You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by "kranti.infy" <kr...@gmail.com> on 2007/11/07 10:55:28 UTC
Jack Rabbit with DB2
Hi,
I am trying to hook JackRabbit with DB2,
I am getting the following error.
org.apache.jasper.JasperException: Cannot instantiate persistence manager
org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager: DB2 SQL
error: SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null: DB2 SQL error:
SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
http://www.nabble.com/file/p13624184/repository.xml repository.xml
I have attached the config file. Ithink there is nothing wrong in this file.
Can any one suggest me what might be the problem.............
Thanks,
Kranti.
--
View this message in context: http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13624184
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
Re: Jack Rabbit with DB2
Posted by "kranti.infy" <kr...@gmail.com>.
Thank you Thomas.
its working......
Kranti.
Thomas Mueller-6 wrote:
>
> Hi,
>
> Did you delete the workspace.xml files before trying again? The
> problem is, when the repository is created first, the contents of the
> repository.xml are copied to workspace.xml files (one for each
> workspace) and so the changed setting is repository.xml is not used.
>
> What I do usually is: delete all files except repository.xml and
> jaas.config (if you have that): folders version, repository,
> workspaces.
>
> Thomas
>
>
> On Nov 7, 2007 12:43 PM, kranti.infy <kr...@gmail.com> wrote:
>>
>> Hi Thomas,
>>
>> I have attahced the modified cofig file.
>> http://www.nabble.com/file/p13625593/repository.xml repository.xml
>> here i have added the schema param as follows:
>> param name="schema" value="db2"
>>
>> Still it is giving the same error.....
>>
>> Thanks,
>> Kranti
>>
>>
>> Thomas Mueller-6 wrote:
>> >
>> > Hi,
>> >
>> > In the repository.xml, you have commented out the 'schema' item:
>> >
>> > <PersistenceManager
>> > class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
>> >
>> >
>> >
>> >
>> > <!-- -->
>> >
>> >
>> > </PersistenceManager>
>> >
>> > The term 'schema' is misleading, it doesn't refer to the database
>> > schema but to the .ddl file that Jackrabbit uses. For DB2, you need to
>> > use
>> >
>> >
>>
>> > (this will use the file org/apache/jackrabbit/core/fs/db/db2.ddl)
>> > So you don't need to create a database schema called 'db2'.
>> >
>> > See also http://issues.apache.org/jira/browse/JCR-1180
>> >
>> > I hope this helps,
>> > Thomas
>> >
>> >
>> > On Nov 7, 2007 11:11 AM, kranti.infy <kr...@gmail.com> wrote:
>> >>
>> >> please find attached the logged data..... in jackLog.loog file:
>> >> http://www.nabble.com/file/p13624318/jackLog.log jackLog.log
>> >>
>> >>
>> >>
>> >> Thomas Mueller-6 wrote:
>> >> >
>> >> > Hi,
>> >> >
>> >> > Could you send the complete stack trace please?
>> >> >
>> >> > Thanks,
>> >> > Thomas
>> >> >
>> >> > On Nov 7, 2007 10:55 AM, kranti.infy <kr...@gmail.com> wrote:
>> >> >>
>> >> >> Hi,
>> >> >> I am trying to hook JackRabbit with DB2,
>> >> >> I am getting the following error.
>> >> >>
>> >> >> org.apache.jasper.JasperException: Cannot instantiate persistence
>> >> manager
>> >> >> org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager: DB2
>> >> SQL
>> >> >> error: SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null: DB2 SQL
>> error:
>> >> >> SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null
>> >> >>
>> >> >>
>> >>
>> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
>> >> >>
>> >> >>
>> >>
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
>> >> >>
>> >> >>
>> >>
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
>> >> >>
>> >> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
>> >> >>
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>> >> >>
>> >> >>
>> >>
>> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
>> >> >> http://www.nabble.com/file/p13624184/repository.xml repository.xml
>> >> >> I have attached the config file. Ithink there is nothing wrong in
>> this
>> >> >> file.
>> >> >> Can any one suggest me what might be the problem.............
>> >> >>
>> >> >> Thanks,
>> >> >> Kranti.
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >> http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13624184
>> >> >> Sent from the Jackrabbit - Users mailing list archive at
>> Nabble.com.
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >> http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13624318
>> >>
>> >> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13625593
>>
>> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13641373
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
Re: Jack Rabbit with DB2
Posted by Thomas Mueller <th...@gmail.com>.
Hi,
Did you delete the workspace.xml files before trying again? The
problem is, when the repository is created first, the contents of the
repository.xml are copied to workspace.xml files (one for each
workspace) and so the changed setting is repository.xml is not used.
What I do usually is: delete all files except repository.xml and
jaas.config (if you have that): folders version, repository,
workspaces.
Thomas
On Nov 7, 2007 12:43 PM, kranti.infy <kr...@gmail.com> wrote:
>
> Hi Thomas,
>
> I have attahced the modified cofig file.
> http://www.nabble.com/file/p13625593/repository.xml repository.xml
> here i have added the schema param as follows:
> param name="schema" value="db2"
>
> Still it is giving the same error.....
>
> Thanks,
> Kranti
>
>
> Thomas Mueller-6 wrote:
> >
> > Hi,
> >
> > In the repository.xml, you have commented out the 'schema' item:
> >
> > <PersistenceManager
> > class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
> >
> >
> >
> >
> > <!-- -->
> >
> >
> > </PersistenceManager>
> >
> > The term 'schema' is misleading, it doesn't refer to the database
> > schema but to the .ddl file that Jackrabbit uses. For DB2, you need to
> > use
> >
> >
>
> > (this will use the file org/apache/jackrabbit/core/fs/db/db2.ddl)
> > So you don't need to create a database schema called 'db2'.
> >
> > See also http://issues.apache.org/jira/browse/JCR-1180
> >
> > I hope this helps,
> > Thomas
> >
> >
> > On Nov 7, 2007 11:11 AM, kranti.infy <kr...@gmail.com> wrote:
> >>
> >> please find attached the logged data..... in jackLog.loog file:
> >> http://www.nabble.com/file/p13624318/jackLog.log jackLog.log
> >>
> >>
> >>
> >> Thomas Mueller-6 wrote:
> >> >
> >> > Hi,
> >> >
> >> > Could you send the complete stack trace please?
> >> >
> >> > Thanks,
> >> > Thomas
> >> >
> >> > On Nov 7, 2007 10:55 AM, kranti.infy <kr...@gmail.com> wrote:
> >> >>
> >> >> Hi,
> >> >> I am trying to hook JackRabbit with DB2,
> >> >> I am getting the following error.
> >> >>
> >> >> org.apache.jasper.JasperException: Cannot instantiate persistence
> >> manager
> >> >> org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager: DB2
> >> SQL
> >> >> error: SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null: DB2 SQL error:
> >> >> SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null
> >> >>
> >> >>
> >> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
> >> >>
> >> >>
> >> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
> >> >>
> >> >>
> >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
> >> >>
> >> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
> >> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> >> >>
> >> >>
> >> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> >> >> http://www.nabble.com/file/p13624184/repository.xml repository.xml
> >> >> I have attached the config file. Ithink there is nothing wrong in this
> >> >> file.
> >> >> Can any one suggest me what might be the problem.............
> >> >>
> >> >> Thanks,
> >> >> Kranti.
> >> >>
> >> >> --
> >> >> View this message in context:
> >> >> http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13624184
> >> >> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >
> >> >
> >>
> >> --
> >> View this message in context:
> >> http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13624318
> >>
> >> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
> >>
> >>
> >
> >
>
> --
> View this message in context: http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13625593
>
> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>
>
Re: Jack Rabbit with DB2
Posted by "kranti.infy" <kr...@gmail.com>.
Hi Thomas,
I have attahced the modified cofig file.
http://www.nabble.com/file/p13625593/repository.xml repository.xml
here i have added the schema param as follows:
param name="schema" value="db2"
Still it is giving the same error.....
Thanks,
Kranti
Thomas Mueller-6 wrote:
>
> Hi,
>
> In the repository.xml, you have commented out the 'schema' item:
>
> <PersistenceManager
> class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
>
>
>
>
> <!-- -->
>
>
> </PersistenceManager>
>
> The term 'schema' is misleading, it doesn't refer to the database
> schema but to the .ddl file that Jackrabbit uses. For DB2, you need to
> use
>
>
> (this will use the file org/apache/jackrabbit/core/fs/db/db2.ddl)
> So you don't need to create a database schema called 'db2'.
>
> See also http://issues.apache.org/jira/browse/JCR-1180
>
> I hope this helps,
> Thomas
>
>
> On Nov 7, 2007 11:11 AM, kranti.infy <kr...@gmail.com> wrote:
>>
>> please find attached the logged data..... in jackLog.loog file:
>> http://www.nabble.com/file/p13624318/jackLog.log jackLog.log
>>
>>
>>
>> Thomas Mueller-6 wrote:
>> >
>> > Hi,
>> >
>> > Could you send the complete stack trace please?
>> >
>> > Thanks,
>> > Thomas
>> >
>> > On Nov 7, 2007 10:55 AM, kranti.infy <kr...@gmail.com> wrote:
>> >>
>> >> Hi,
>> >> I am trying to hook JackRabbit with DB2,
>> >> I am getting the following error.
>> >>
>> >> org.apache.jasper.JasperException: Cannot instantiate persistence
>> manager
>> >> org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager: DB2
>> SQL
>> >> error: SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null: DB2 SQL error:
>> >> SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null
>> >>
>> >>
>> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
>> >>
>> >>
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
>> >>
>> >>
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
>> >>
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
>> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>> >>
>> >>
>> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
>> >> http://www.nabble.com/file/p13624184/repository.xml repository.xml
>> >> I have attached the config file. Ithink there is nothing wrong in this
>> >> file.
>> >> Can any one suggest me what might be the problem.............
>> >>
>> >> Thanks,
>> >> Kranti.
>> >>
>> >> --
>> >> View this message in context:
>> >> http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13624184
>> >> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13624318
>>
>> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13625593
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
Re: Jack Rabbit with DB2
Posted by Thomas Mueller <th...@gmail.com>.
Hi,
In the repository.xml, you have commented out the 'schema' item:
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
<param name="driver" value="com.ibm.db2.jcc.DB2Driver"/>
<param name="url" value="jdbc:db2://blrkec88518d:50000/GENERAL"/>
<param name="user" value="cataloguser"/>
<param name="password" value="Infybang2007"/>
<!-- <param name="schema" value="GENERAL"/> -->
<param name="schemaObjectPrefix" value="Jackrabbit Core_"/>
<param name="externalBLOBs" value="false"/>
</PersistenceManager>
The term 'schema' is misleading, it doesn't refer to the database
schema but to the .ddl file that Jackrabbit uses. For DB2, you need to
use
<param name="schema" value="db2"/>
(this will use the file org/apache/jackrabbit/core/fs/db/db2.ddl)
So you don't need to create a database schema called 'db2'.
See also http://issues.apache.org/jira/browse/JCR-1180
I hope this helps,
Thomas
On Nov 7, 2007 11:11 AM, kranti.infy <kr...@gmail.com> wrote:
>
> please find attached the logged data..... in jackLog.loog file:
> http://www.nabble.com/file/p13624318/jackLog.log jackLog.log
>
>
>
> Thomas Mueller-6 wrote:
> >
> > Hi,
> >
> > Could you send the complete stack trace please?
> >
> > Thanks,
> > Thomas
> >
> > On Nov 7, 2007 10:55 AM, kranti.infy <kr...@gmail.com> wrote:
> >>
> >> Hi,
> >> I am trying to hook JackRabbit with DB2,
> >> I am getting the following error.
> >>
> >> org.apache.jasper.JasperException: Cannot instantiate persistence manager
> >> org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager: DB2 SQL
> >> error: SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null: DB2 SQL error:
> >> SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null
> >>
> >> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
> >>
> >> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
> >>
> >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
> >> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> >>
> >> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> >> http://www.nabble.com/file/p13624184/repository.xml repository.xml
> >> I have attached the config file. Ithink there is nothing wrong in this
> >> file.
> >> Can any one suggest me what might be the problem.............
> >>
> >> Thanks,
> >> Kranti.
> >>
> >> --
> >> View this message in context:
> >> http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13624184
> >> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
> >>
> >>
> >
> >
>
> --
> View this message in context: http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13624318
>
> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>
>
Re: Jack Rabbit with DB2
Posted by "kranti.infy" <kr...@gmail.com>.
please find attached the logged data..... in jackLog.loog file:
http://www.nabble.com/file/p13624318/jackLog.log jackLog.log
Thomas Mueller-6 wrote:
>
> Hi,
>
> Could you send the complete stack trace please?
>
> Thanks,
> Thomas
>
> On Nov 7, 2007 10:55 AM, kranti.infy <kr...@gmail.com> wrote:
>>
>> Hi,
>> I am trying to hook JackRabbit with DB2,
>> I am getting the following error.
>>
>> org.apache.jasper.JasperException: Cannot instantiate persistence manager
>> org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager: DB2 SQL
>> error: SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null: DB2 SQL error:
>> SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null
>>
>> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
>>
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
>>
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>>
>> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
>> http://www.nabble.com/file/p13624184/repository.xml repository.xml
>> I have attached the config file. Ithink there is nothing wrong in this
>> file.
>> Can any one suggest me what might be the problem.............
>>
>> Thanks,
>> Kranti.
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13624184
>> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13624318
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
Re: Jack Rabbit with DB2
Posted by Thomas Mueller <th...@gmail.com>.
Hi,
Could you send the complete stack trace please?
Thanks,
Thomas
On Nov 7, 2007 10:55 AM, kranti.infy <kr...@gmail.com> wrote:
>
> Hi,
> I am trying to hook JackRabbit with DB2,
> I am getting the following error.
>
> org.apache.jasper.JasperException: Cannot instantiate persistence manager
> org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager: DB2 SQL
> error: SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null: DB2 SQL error:
> SQLCODE: -486, SQLSTATE: 42991, SQLERRMC: null
>
> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
>
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> http://www.nabble.com/file/p13624184/repository.xml repository.xml
> I have attached the config file. Ithink there is nothing wrong in this file.
> Can any one suggest me what might be the problem.............
>
> Thanks,
> Kranti.
>
> --
> View this message in context: http://www.nabble.com/Jack-Rabbit-with-DB2-tf4763645.html#a13624184
> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>
>