jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Mueller" <thomas.tom.muel...@gmail.com>
Subject Re: Jack Rabbit with DB2
Date Wed, 07 Nov 2007 10:50:40 GMT
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 <kranti.infy@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 <kranti.infy@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.
>
>

Mime
View raw message