Hi,
It took me some time to find the right configuration for the unified
datasource (NuxeoDS) using MySQL.
In
|$JBOSS_HOME/server/default/deploy/nuxeo.ear/datasources/unified-nuxeo-ds.xml,
there is a |commented out PostgresSQL configuration.
To use MySQL, apart from the driver, I changed this line:
<check-valid-connection-sql>;</check-valid-connection-sql>
to <check-valid-connection-sql>select count(*) from
dual</check-valid-connection-sql>
Without this, I had recurring
"com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Query was empty."
Hope this helps.
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
