Hi Vincent,
On 21 Mar 2007, at 12:20, Vincent Dutat wrote:
Hi,
I updated Nuxeo sources last monday (rev. 13835). This snapshot has
errors with MySQL databases, errors I did not have with previous
revisions. But it works fine with Hypersonic.
Here are the exceptions :
2007-03-21 11:31:22,331 ERROR
[org.hibernate.tool.hbm2ddl.SchemaUpdate] could not get database
metadata
java.sql.SQLException: Unknown table 'system_sequences' in
information_schema
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
According to the third hit in
http://www.google.com/search?q=system_sequences+mysql
this seems to mean that you have a datasource where you still have
hsqldb statements in a <check-valid-connection-sql> tag.
For MySQL one working syntax is: <check-valid-connection-sql>select
count(*) from dual</check-valid-connection-sql>
(Note that standard Nuxeo 5 datasources don't use <check-valid-
connection-sql> -- they will when we start working on HA configuration.)
Florent
--
Florent Guillaume, Director of R&D, Nuxeo
Open Source Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
