Hi Shai,
Maybe a stupied question, maybe wrong definitions..
but how do I load a mysqldump file ? i get some errors:
[21:27:22] ERROR
[org.continuent.myosotis.protocol.mysql.MySQLProtocolHandler] - Error
processing query: DROP TABLE IF EXISTS `acting_users`
org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Unknown table 'if' in this DROP statement 'DROP
TABLE IF EXISTS `acting_users`'
Unfortunately DROP TABLE IF EXISTS is not SQL standard, it is MySQL
specific. You can alter the regular expression for DROP statements if
you want to support it or just go for the regular DROP TABLE statement
and ignore any failure.
and from sequoia
21:20:54,943 INFO virtualdatabase.VirtualDatabaseWorkerThread.myDB
Error during command execution (Request /*!40101 SET
@[EMAIL PROTECTED] failed on backend one (Error while
building Sequoia ResultSet (ResultSet is from UPDATE. No Data.)))
This one looks like the SET command is executed as a SELECT instead of
an update. Therefore the controller cannot build a ResultSet since there
is no result for it. I don't know if this is a Myosotis problem or a
Sequoia parser issue.
Could you try to execute the same request in a simple Java client using
Statement.execute(). If the test passes then this is a Myosotis problem
otherwise this is a Sequoia parser issue.
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
