You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ode.apache.org by "Stelianos G. Sfakianakis" <sg...@gmail.com> on 2007/11/26 12:03:14 UTC
Alternative databases
Hi,
It seems that I am having some problems with the derby embedded database of
ODE. For example I have a lot of test workflows that I want to remove
(undeploy) and I don't know how to do it (there's of course the management
api but I haven't delved into it yet)
Anyway is there any possibility for using a "normal" database (e.g. mysql)
for ODE? There's a FAQ entry in <http://ode.apache.org/faq.html> that there
exist schemas for mysql but I failed to find one and a guide on how to do
it...
Thank you in advance for your answers (BTW I have found this mailing list to
be very responsive and friendly; Thank you again!)
Best regards
Stelios
Re: Alternative databases
Posted by Matthieu Riou <ma...@offthelip.org>.
Configuration with the WAR is pretty much the same thing wrt database
configuration, just replace 'jbi' with 'axis2' everywhere :) So your
ode-axis2.properties configuration file should contain the following
properties:
ode-axis2.db.mode=EXTERNAL
ode-axis2.db.ext.dataSource=java:comp/env/jdbc/MyDS
Cheers,
Matthieu
On Nov 26, 2007 5:43 AM, Kristian Köhler <Kr...@dmc.de> wrote:
> Hi
> I'm running ODE within ServiceMix and adjusted the ode.properties (within
> the JBI package) file to a mysql connection pool. I never tried to
> reconfigure the database within the WAR distribution.. ;-)
>
> Kristian
>
>
> -----Ursprüngliche Nachricht-----
> Von: Stelianos G. Sfakianakis [mailto:sgsfak@gmail.com]
> Gesendet: Montag, 26. November 2007 13:14
> An: user@ode.apache.org
> Cc: Kristian Köhler
> Betreff: Re: Alternative databases
>
>
> On Nov 26, 2007 2:08 PM, Kristian Köhler <Kr...@dmc.de> wrote:
>
> hi
>
> I have a schema for mysql db. It is available here:
>
>
> https://gaswerk.svn.sourceforge.net/svnroot/gaswerk/assemblies/soa-stack/trunk/gaswerk-database/gaswerk-soa-stack-db/src/main/sql/complete-db-mysql.sql
>
> It works with ODE 1.1 for me. ;-)
>
>
> Thank you Kristian! What additional configuration parameters should be set
> in order for this to work?
>
> Stelios
>
>
> --
> http://gaswerk.sourceforge.net
>
AW: Alternative databases
Posted by Kristian Köhler <Kr...@dmc.de>.
Hi
I'm running ODE within ServiceMix and adjusted the ode.properties (within the JBI package) file to a mysql connection pool. I never tried to reconfigure the database within the WAR distribution.. ;-)
Kristian
-----Ursprüngliche Nachricht-----
Von: Stelianos G. Sfakianakis [mailto:sgsfak@gmail.com]
Gesendet: Montag, 26. November 2007 13:14
An: user@ode.apache.org
Cc: Kristian Köhler
Betreff: Re: Alternative databases
On Nov 26, 2007 2:08 PM, Kristian Köhler <Kr...@dmc.de> wrote:
hi
I have a schema for mysql db. It is available here:
https://gaswerk.svn.sourceforge.net/svnroot/gaswerk/assemblies/soa-stack/trunk/gaswerk-database/gaswerk-soa-stack-db/src/main/sql/complete-db-mysql.sql
It works with ODE 1.1 for me. ;-)
Thank you Kristian! What additional configuration parameters should be set in order for this to work?
Stelios
--
http://gaswerk.sourceforge.net
Re: Alternative databases
Posted by "Stelianos G. Sfakianakis" <sg...@gmail.com>.
On Nov 26, 2007 2:08 PM, Kristian Köhler <Kr...@dmc.de> wrote:
> hi
>
> I have a schema for mysql db. It is available here:
>
>
> https://gaswerk.svn.sourceforge.net/svnroot/gaswerk/assemblies/soa-stack/trunk/gaswerk-database/gaswerk-soa-stack-db/src/main/sql/complete-db-mysql.sql
>
> It works with ODE 1.1 for me. ;-)
>
Thank you Kristian! What additional configuration parameters should be set
in order for this to work?
Stelios
AW: Alternative databases
Posted by Kristian Köhler <Kr...@dmc.de>.
hi
I have a schema for mysql db. It is available here:
https://gaswerk.svn.sourceforge.net/svnroot/gaswerk/assemblies/soa-stack/trunk/gaswerk-database/gaswerk-soa-stack-db/src/main/sql/complete-db-mysql.sql
It works with ODE 1.1 for me. ;-)
Kristian
> -----Ursprüngliche Nachricht-----
> Von: Stelianos G. Sfakianakis [mailto:sgsfak@gmail.com]
> Gesendet: Montag, 26. November 2007 12:03
> An: user@ode.apache.org
> Betreff: Alternative databases
>
>
> Hi,
>
> It seems that I am having some problems with the derby
> embedded database of
> ODE. For example I have a lot of test workflows that I want to remove
> (undeploy) and I don't know how to do it (there's of course
> the management
> api but I haven't delved into it yet)
>
> Anyway is there any possibility for using a "normal" database
> (e.g. mysql)
> for ODE? There's a FAQ entry in
> <http://ode.apache.org/faq.html> that there
> exist schemas for mysql but I failed to find one and a guide
> on how to do
> it...
>
> Thank you in advance for your answers (BTW I have found this
> mailing list to
> be very responsive and friendly; Thank you again!)
>
> Best regards
> Stelios
>
--
http://gaswerk.sourceforge.net