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
