Hi, I have already added the dialect in sql.properties and I had the exception after this operation. In my config folder there wasn't a file named "sql.properties" and I have created it.
The content of sql.properties is: org.nuxeo.ecm.sql.jena.databaseType=MySQL Any ideas? Many Thanks, Denis Il giorno lun, 25/06/2007 alle 14.43 +0100, Sean Radford ha scritto: > 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
