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