hi list, after some search on mysql jdbc documentation i found that i can use "zeroDateTimeBehavior=convertToNull"
thanks, Mihai On Thu, 2007-04-05 at 18:47 +0300, Mihai Costache wrote: > > hi list, > i have an test env whit one sequoia controller and two mysql (4.1.22) > backends .... i use mysql jdbc 5.0.5 > > after some test with an simple DBs i switch my test on a restore of > real DB .... on this DB i have a few tables with some datetime column > with some "0000-00-00" or "0000-00-00 00:00:00" values > > when i try to do some select query from sequoia console ... like this: > jdbc:sequoia://127.0.0.1:25322/backup (testuser) > > SELECT * FROM backup.`products` LIMIT 0 , 5; > or when i try to browse this tables (with 00... values) from > phpmyadmin > i have the following errors: > > 18:36:24,655 WARN virtualdatabase.VirtualDatabaseWorkerThread.backup > Error during command execution (Request SELECT * FROM > `accounting_invoices` LIMIT 0, 30 failed on backend 10.0.0.2 (Error > while building Sequoia ResultSet (Value '0000-00-00' can not be > represented as java.sql.Date))) > > 18:38:02,128 WARN virtualdatabase.VirtualDatabaseWorkerThread.backup > Error during command execution (Request SELECT * FROM `products` > LIMIT 0, 30 failed on backend 10.0.0.2 (Error while building Sequoia > ResultSet (Cannot convert value '0000-00-00 00:00:00' from column 16 > to TIMESTAMP.))) > > > it is a limitation from jdbc driver ? > can you help me ? > > thanks, > Mihai > > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
