Yes, or you could use instead: <valid-connection-checker-class- name >org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</ valid-connection-checker-class-name> See the JBoss docs about datasources.
Florent On 29 Oct 2008, at 14:53, Xavier Pétard wrote: > 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 -- Florent Guillaume, Head of R&D, Nuxeo Open Source, Java EE based, 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
