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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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. > >
