Thanks Matthieu - I am running ODE under ServiceMix, but will certainly
write it all down once I have it up and running. May take a few days though
......

Thanks again

Mike

On 6/12/07, Matthieu Riou <[EMAIL PROTECTED]> wrote:

Hi Michael,

I've just cleaned that up a bit, there were a couple of issues there. So
to build the MySQL schema you just need to go into the dao-jpa-ojpa-derby
module and run 'rake build'. This should produce a schema for MySQL in the
target directory. Alternatively I've attached the result to this e-mail if
it's easier for you.

Once MySQL is setup, you just need to configure ODE to use the datasource
you've configured in your application server. Just edit
ode-axis2.properties and set the 2 following properties:

ode-axis2.db.mode=EXTERNAL
ode-axis2.db.ext.dataSource=java:comp/env/jdbc/MYDS

That should be it. If you can write down the different steps you followed
to make this work with your application server, we'd be more than happy to
publish it as a small "how to" so others can reuse it :)

Thanks,
Matthieu

On 6/12/07, Michael Horwitz <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> There are various cryptic hints around the site that Ode can be run
> against
> an external database. I have been experiencing a few problems with the
> Quartz scheduler not being able to get a connection to the embedded
> database
> when running asynchronous processes and would like to try running
> against
> MySql to see if it will solve my problems. Are there any scripts
> available
> to create the database?
>
> Thanks
>
> Mike Horwitz
>



Reply via email to