thanks for your reply but it don't work
i was able to load xml config file for VDB i was able to initialize the backend but when i was try to enable the backend ... surprize ... don't work ... the following error 20:28:57,002 WARN sequoia.controller.connection Unable to initialize connections for this backend 20:28:57,002 ERROR sequoia.controller.connection Pool is empty, no connection available for this backend 20:28:57,006 WARN sequoia.controller.connection Unable to initialize connections for this backend 20:28:57,007 ERROR sequoia.controller.connection Pool is empty, no connection available for this backend 20:28:57,007 ERROR 0.0.2 Connection test failed (java.sql.SQLException: The connection property 'zeroDateTimeBehavior' only accepts values of the form: 'exception', 'round' or 'convertToNull'. The value 'convertToNull?amp;tinyInt1isBit=false' is not in this set.) 20:28:57,008 WARN controller.virtualdatabase.epayment Error while initalizing database backend 10.0.0.2 (java.sql.SQLException: Unable to connect to backend.) java.sql.SQLException: Unable to connect to backend my xml file lokks lik that <DatabaseBackend name="10.0.0.2" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://10.0.0.2:3306/backupDB?zeroDateTimeBehavior=convertToNull?amp;tinyInt1isBit=false" connectionTestStatement="select 1"> On Thu, 2007-04-05 at 19:24 +0200, Gilles Rayrat wrote: > Hi Mihai, > You have to put "&" instead of & in the url to separate options: > jdbc:mysql://10.0.0.3:3306/db?zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false > Cheers, > Gilles. > > Mihai Costache wrote: > > > > > 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 > > > > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
