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
