Re: [Sequoia] hi ... some query errors

Gilles Rayrat Thu, 05 Apr 2007 10:26:48 -0700

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="" ... >

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="">

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

Re: [Sequoia] hi ... some query errors

Reply via email to