Hi, Jackie Ju.
Have you setted the "lower_case_table_name" property of MySQL?
Take a look at the following entry of the FAQ:
http://doc.nuxeo.org/xwiki/bin/view/FAQ/Nuxeo53VcsMySQL
Regards.
Jackie Ju escribió:
Hi List,
I am working on configure nuxeo to use mysql.
I did all things
according http://doc.nuxeo.org/5.3/books/nuxeo-book/html-single/index-admin.html
and nuxeo-core/nuxeo-core-storage-sql/README.TXT
But failed with following error:
09:54:40,117 WARN [DriverRDB] Problem formatting database
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'nuxeo.jena_prefix' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
...
...
09:54:40,164 ERROR [RelationService] Error while initializing graph
publication
java.lang.RuntimeException: com.hp.hpl.jena.shared.JenaException: The
database appears to be unformatted or corrupted and
an attempt to automatically format the database has failed
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.wrapException(JenaGraph.java:172)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:825)
at
org.nuxeo.ecm.platform.relations.services.RelationService.frameworkEvent(RelationService.java:476)
...
Caused by: com.hp.hpl.jena.shared.JenaException: The database appears
to be unformatted or corrupted and
an attempt to automatically format the database has failed
at
com.hp.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.java:311)
at
com.hp.hpl.jena.db.impl.DriverRDB.getDefaultModelProperties(DriverRDB.java:835)
...
Caused by: com.hp.hpl.jena.db.RDFRDBException:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'nuxeo.jena_prefix' doesn't exist
at
com.hp.hpl.jena.db.impl.DriverRDB.formatAndConstructSystemSpecializedGraph(DriverRDB.java:477)
at
com.hp.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.java:305)
... 26 more
Attached is the configure files.
Many thanks if anyone can help !
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
--
Enrique Pérez Olivares.
Dpto I+D.
Yerbabuena Software.
[email protected]
http://www.yerbabuena.es
Tlf/Fax: 902 995 246
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
