We are currently assessing the feasibilty of using Sequoia for load balancing
and failover. We are using Sequoia 2.10.2 and MySQL 4.10 database . Using
MySQL driver, I can run the sql statement "ALTER TABLE MODIFY COLUMN ......",
however same statement fails using Sequoia driver with the following error:
Caused by: org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Malformed Alter Request. No drop or add condition
at
org.continuent.sequoia.driver.Connection.statementExecute(Connection.java:3012)
at org.continuent.sequoia.driver.Statement.execute(Statement.java:424)
at
org.continuent.sequoia.driver.PreparedStatement.execute(PreparedStatement.java:901)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at
com.youdevise.ids.persist.FullAccessPersistenceManager.update(FullAccessPersistenceManager.java:829)
... 17 more
I get similar error when using the sql client that comes with Sequoia
installation:
jdbc:sequoia://ydcluster1.youdevise.com/tradeideasmonitor (tradeideasm) > alter
table TASK_PERFORMANCE MODIFY COLUMN RESPONSE_FORMAT VARCHAR(255) default null
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message of
cause: Malformed Alter Request. No drop or add condition)
Based on the above errors, I am assuming Sequoia does not support the Modify
clause. Are you planning to add support for it in the near future? Both MySQL
and Oracle have support for Modify clasuse. One of the things stated in the
Sequoia documentation is minimum or no code change required to start using
Sequoia, and it would be great if we did not have to make code changes to work
around this limitation.
____________________________________________________________________________________
Need a quick answer? Get one in minutes from people who know.
Ask your question on www.Answers.yahoo.com_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
