As per section 19.4.2.2 of the Nuxeo Book, you need to set the the correct dialect in sql.properties in your conf directory.
Let me know how you get on after that - I spent the whole w/e trying to get compass to work with MySQL (either with a standard ds or an xa one with no success) :-( Sean > Hi, > > I have found the solution of the problem. > Simple I have not set up the param "schema" in PersistenceManager > configuration. > However now I have another exception. > When I create or update a document from the web application I find in > logs this Exception: > > 12:55:24,735 ERROR [CommentEventListenerBean] failed to process message > com.hp.hpl.jena.db.RDFRDBException: Failed to lock database after 5 attempts. > > Try later or else call DriverRDB.unlockDB() after ensuring > that no other Jena applications are using the database. > at com.hp.hpl.jena.db.impl.DriverRDB.lockDB(DriverRDB.java:930) > at > com.hp.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.java:296) > at > com.hp.hpl.jena.db.DBConnection.containsModel(DBConnection.java:227) > at > org.nuxeo.ecm.platform.relations.jena.JenaGraph.getGraph(JenaGraph.java:181) > at > org.nuxeo.ecm.platform.relations.jena.JenaGraph.getGraph(JenaGraph.java:128) > at > org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:580) > at > org.nuxeo.ecm.platform.relations.services.RelationService.size(RelationService.java:402) > at > org.nuxeo.ecm.platform.comment.ejb.CommentEventListenerBean.onMessage(CommentEventListenerBean.java:140) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112) > at > org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166) > at > org.jboss.seam.intercept.EJBInvocationContext.proceed(EJBInvocationContext.java:37) > at > org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:97) > at > org.jboss.seam.intercept.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:50) > at sun.reflect.GeneratedMethodAccessor171.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118) > at > org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63) > at > org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) > at > org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54) > at > org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) > at > org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) > at > org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) > at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126) > at > org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:201) > at > org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) > at > org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62) > at > org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) > at org.jboss.ejb3.mdb.MDB.localInvoke(MDB.java:865) > at org.jboss.ejb3.mdb.MDB.localInvoke(MDB.java:844) > at > org.jboss.ejb3.mdb.MDB$MessageListenerImpl.onMessage(MDB.java:1074) > at > org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:266) > at > org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:902) > at > org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:170) > at org.jboss.mq.SpySession.run(SpySession.java:323) > at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194) > at > EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743) > at java.lang.Thread.run(Thread.java:595) > > In nxrelations-default-jena-ds.xml and nxcomment-jena-ds.xml the > connection url is jdbc:mysql://localhost/nuxeo?relaxAutoCommit=true like > indicate in the guide. > > Have you any idea about this issue? > > Best Regards, > Denis > > > Il giorno ven, 22/06/2007 alle 17.51 +0200, Denis Tollot ha scritto: > > Hi, > > I have followed the Administration guide to substitute the default > > embedded database with mysql but I have an exception when I start the > > server at point 19.4.1.5 of the guide. > > > > The exception is: > > > > > > 2007-06-22 16:47:58,546 INFO > > [org.apache.jackrabbit.core.fs.local.LocalFileSystem] LocalFileSystem > > initialized at path /usr/java/nuxeo-5.1.0.M3/server/def > > ault/data/NXRuntime/repos/MySqlRepo/version > > 2007-06-22 16:47:59,130 INFO > > [org.nuxeo.ecm.core.jca.JCAManagedConnectionFactory.NXRepository/MySqlRepo] > Failed to create repository > > 2007-06-22 16:47:59,131 INFO > > [org.nuxeo.ecm.core.jca.JCAManagedConnectionFactory.NXRepository/MySqlRepo] > javax.jcr.RepositoryException: Cannot instantiate > > persistence manager > > org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager: You have > > an error in your SQL syntax; check the manual that correspond > > s to your MySQL server version for the right syntax to use near 'not > > null)' at line 1: You have an error in your SQL syntax; check the manual > > that correspo > > nds to your MySQL server version for the right syntax to use near 'not > > null)' at line 1 > > 2007-06-22 16:47:59,134 INFO > > [org.nuxeo.ecm.core.jca.JCAManagedConnectionFactory.NXRepository/MySqlRepo] > at org.apache.jackrabbit.core.RepositoryImp > > l.createPersistenceManager(RepositoryImpl.java:1179) > > 2007-06-22 16:47:59,135 INFO > > [org.nuxeo.ecm.core.jca.JCAManagedConnectionFactory.NXRepository/MySqlRepo] > at org.apache.jackrabbit.core.RepositoryImp > > l.createVersionManager(RepositoryImpl.java:354) > > ..... > > > > > > Many Thanks, > > Denis > > > > _______________________________________________ > > ECM mailing list > > [email protected] > > http://lists.nuxeo.com/mailman/listinfo/ecm > > _______________________________________________ > ECM mailing list > [email protected] > http://lists.nuxeo.com/mailman/listinfo/ecm > > -- Dr. Sean Radford, MBBS MSc http://www.tacola.com _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm
