Re: [Ecm] Mysql configuaration problem

Mon, 25 Jun 2007 08:18:59 -0700

It work for me with mysql 5.024 with MyIsam for the default engine and the following datasource configuration : 

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>nxrelations-default-jena</jndi-name> <connection-url>jdbc:mysql://${fr.toutatice.nuxeo.db.host}/nx_relations_default_jena?relaxAutoCommit=true&amp;autoReconnect=true</connection-url> 
  <driver-class>${fr.toutatice.nuxeo.db.driver}</driver-class>
  <user-name>${fr.toutatice.nuxeo.db.login}</user-name>
  <password>${fr.toutatice.nuxeo.db.pwd}</password>
</local-tx-datasource>
</datasources>
I'm using the "autoReconnect" parameter to force reconnexion after a broken network session between JBOSS and Mysql. 
The jena configuration is setting like that :

<?xml version="1.0"?>
<component name="org.nuxeo.ecm.platform.relations.services.DefaultJenaGraph">
<require>org.nuxeo.ecm.platform.relations.services.RelationService</require> 
 <require>org.nuxeo.ecm.platform.relations.jena</require>
<extension target="org.nuxeo.ecm.platform.relations.services.RelationService" 
   point="resourceadapters">
   <adapter namespace="http://www.nuxeo.org/document/uid/";
class="org.nuxeo.ecm.platform.relations.web.adapter.DocumentModelResourceAdapter" /> 
 </extension>
<extension target="org.nuxeo.ecm.platform.relations.services.RelationService" 
   point="graphs">
   <documentation>see http://jena.sourceforge.net/DB/</documentation>
   <graph name="default" type="jena">
     <option name="backend">sql</option>
     <option name="databaseType">MySQL</option>
     <option name="datasource">java:/nxrelations-default-jena</option>
     <option name="databaseDoCompressUri">false</option>
     <option name="databaseTransactionEnabled">false</option>
     <namespaces>
       <namespace name="rdf">
         http://www.w3.org/1999/02/22-rdf-syntax-ns#
       </namespace>
       <namespace name="dcterms">http://purl.org/dc/terms/</namespace>
<namespace name="nuxeo">http://www.nuxeo.org/document/uid/</namespace> 
     </namespaces>
   </graph>
 </extension>

</component>



A+, Olivier



Denis Tollot a écrit :

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



begin:vcard
fn:Olivier Adam
n:Adam;Olivier
org;quoted-printable:Rectorat de Rennes;SERvice Informatique Acad=C3=A9mique (SERIA)
email;internet:[EMAIL PROTECTED]
title;quoted-printable:SERIA-T : D=C3=A9partement "D=C3=A9veloppements des TIC en =C3=A9tablisse=
	ments et services"
tel;work:02 23 21 75 84
version:2.1
end:vcard


_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm

Reply via email to