Hi Tony,
Can someone explain why these MySQL commands would not be supported in
the following syntaxes? I'm using sequoia 2.10.10 on linux
DELETE FROM testtable;
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Unknown table 'testtable;' in this DELETE statement:
DELETE FROM testtable;')
The ; is not part of the SQL standard and thus it is rejected as
improper syntax (because our parser is not very smart too ;-)).
But if I use no ';' on the end it works. Both SELECT and INSERT work
with or without the ';'
Sequoia is supposed to detect automatically multistatement queries
separated by ; but in the case of a single delete the parser seems to be
lost.
UNLOCK TABLES
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Request UNLOCK TABLES/ failed on backend XXX (Error
while building Sequoia ResultSet (ResultSet is from UPDATE. No Data.)))
This is not SQL either but Sequoia tries to forward it as is. Do you
execute this statement using Statement.execute, Statement.executeQuery
or Statement.executeUpdate? Which case(s) works and which case(s) doesn't?
Thanks for your feedback,
Emmanuel
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [EMAIL PROTECTED]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
