I will do that
What I am doing to seed the database is to change my ant script to point to
sequoia rather then directly at mysql.
> Date: Wed, 2 Jul 2008 21:06:03 +0200> From: [EMAIL PROTECTED]> To:
> [email protected]> Subject: Re: [Sequoia] stored procedure
> creation/DB reseeding> > 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
_________________________________________________________________
Send a smile, make someone laugh, have some fun! Start now!
http://www.freemessengeremoticons.ca/?icid=EMENCA122
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
