Hi List,
I am trying to config nuxeo to use mysql/jetty.
I changed the file JETTY_HOME/config/sql.properties to set
org.nuxeo.ecm.sql.jena.databaseType=MySQL
But when uploading a file to repository, it always failed with following
exception:
Caused by: com.hp.hpl.jena.db.RDFRDBException: Failed to unlock database
after 5 attempts -
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table
'jena_mutex'
at com.hp.hpl.jena.db.impl.DriverRDB.unlockDB(DriverRDB.java:949)
at
com.hp.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.java:307)
at
com.hp.hpl.jena.db.impl.DriverRDB.getDefaultModelProperties(DriverRDB.java:835)
at
com.hp.hpl.jena.db.DBConnection.getDefaultModelProperties(DBConnection.java:195)
at
com.hp.hpl.jena.db.impl.GraphRDBMaker.consGraph(GraphRDBMaker.java:123)
...
I tried the to mysq varialbe
lower_case_table_names = 1
and tried modify the data source for jena in config/jetty.xml
<New id="nxrelations" class="org.mortbay.jetty.plus.naming.Resource">
<Arg>jdbc/nxrelations-default-jena</Arg>
<Arg>
<!--
<New class="org.apache.derby.jdbc.EmbeddedDataSource">
<Set name="databaseName">nxrelations</Set>
<Set name="createDatabase">create</Set>
</New>
-->
<New
class="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource">
<Set name="Url">jdbc:mysql://localhost:3306/nuxeo</Set>
<Set name="User">intalio</Set>
<Set name="Password">intalio</Set>
</New>
</Arg>
</New>
<!-- ======== Nuxeo Comments Data Source ========= -->
<New id="nxcomments" class="org.mortbay.jetty.plus.naming.Resource">
<Arg>jdbc/comment-relations</Arg>
<Arg>
<!--
<New class="org.apache.derby.jdbc.EmbeddedDataSource">
<Set name="databaseName">nxcomments</Set>
<Set name="createDatabase">create</Set>
</New>
-->
<New
class="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource">
<Set name="Url">jdbc:mysql://localhost:3306/nuxeo</Set>
<Set name="Url">jdbc:mysql://localhost:3306/nuxeo</Set>
<Set name="User">intalio</Set>
<Set name="Password">intalio</Set>
</New>
</Arg>
</New>
But no matter I changed or not, it doesn't work.
Does anybody has sovled this problem before ?
--
Best Regards,
Jackie Ju
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
