in my VDB i have like this <DatabaseBackend name="db" .... url="jdbc:mysql://10.0.0.3:3306/db?zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false" ... >
and when i try to load this config xml for VDB i have the following error ERROR controller.xml.DatabasesParser Next character must be ";" terminating reference to entity "tinyInt1isBit" what is the problem ? in mysql site http://dev.mysql.com/doc/refman/4.1/en/connector-j-reference-configuration-properties.html the syntax for jdbc url is: jdbc:mysql://[host:port],[host:port].../[database] ยป [?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]... so my url from VDB xml config file it is accurate thanks, Mihai On Thu, 2007-04-05 at 19:04 +0300, Simon Csaba wrote: > Salut Mihai, > > > while building Sequoia ResultSet (Value '0000-00-00' can not be > > represented as java.sql.Date))) > > You need the zeroDateTimeBehavior=convertToNull option in the JDBC URL. > For further information see > http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html > > VDB xml file example snippet: > > <DatabaseBackend name="c1b1" ... > url="jdbc:mysql://127.0.0.1:3306/DB1?zeroDateTimeBehavior=convertToNull ..."> > > Regards, > Csaba > > > > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
