Hi Adam,
I have managed to get sequoia to work with our existing mysql
databases including it calls made to stored procedures which is great.
I have yet to try it on something other then my local box with more
then one db but that is a challenge for another day. Right now I am
attempting to rework our seed scripts to work through sequoia so when
we redeploy and want to wipe the database we can. I have taken out
things like IF Exists calls (though it would be nice if sequoia
supported that) so I can recreate the tables fine. However when I
start on the stored procedures which change delimiter to $$ I get the
following error:
_org.continuent.sequoia.common.exceptions.driver.DriverSQLException_:
Message of cause: Failed to execute request CREATE PROCEDURE XXX(IN...
because of (org.continuent.sequoia.controller.requests.StoredProcedure
cannot be cast to
org.continuent.sequoia.controller.requests.AbstractWriteRequest)
The issue for IF EXIST calls is due to the parser. Please post a new
JIRA issue with the exact commands you are using so that I can add
support for it in Sequoia 4.
Regarding the CREATE PROCEDURE issue, are you executing it from a
console that just do Statement.execute() or are you calling this from a
Java program using CallableStatement.execute() ?
Once again this is a parsing problem to route the query to the proper
path within the controller.
Thanks for the 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
