ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Boisvert <boisv...@intalio.com>
Subject Re: Generate Database Schema for Ode with MySQL
Date Sat, 25 Jul 2009 00:17:56 GMT
The fact that .sql files were not included in the distribution was a build
failure.

I've fixed this now (and reenabled the build test that should ensure it
doesn't happen in future builds).

alex


On Thu, Jul 23, 2009 at 12:48 AM, Alex Hepp <heppa@web.de> wrote:

> Hi List,
>
> we have just started to evaluate ODE for our needs in an EJB Web Service
> orchestration context. What we are looking for is high performance with a
> large number of active processes (>150.000 at a time). This can not really
> be handled by HSQLDB, so we would like to use an external DB (mysql for
> testing and later oracle).  We were able to configure external database
> (with the help of your online doc AND some external resources), but, we
> would now need the up to date database schema.
>
> Your online documentation says at 3.) "Make sure that MySQL is started and
> the ODE schema has been loaded in a /ode/ database.". Very funny, indeed ;)
>
> We found several resources presenting a schema, but most of them are for
> ODE 1.2, which is not compatible to 1.3.2 anymore. I know, that we could
> take the sources, build the whole project with Buildr, and we would also get
> a sql file for DDL schema generation.
>
> The question is: Is this really intended? Should a "normal" Oder User
> really have to download sources and set up a whole building environment to
> be able to use an external database instead of builtin? Is it somehow
> possible to generate / create the schema in a different way?
>
> We also read about using hibernate and setting a special property for
> generation. First problem: We don't seem to get Ode to using hibernate
> (though setting
> ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl)
> and trying ode.persistence = hibernate. Then we tried to stick with OpenJPA
> and using openjpa.jdbc.SynchronizeMappings = buildSchema (we set all the
> properties in ode-axis2.properties). I set the logging to debug, and
> recognized that openjpa.jdbc.synchronizeMapping is always still set to
> false. Are there any property files that override ode-axis2.properties
> values again? I thought it would make sense, to read this one last.
>
> I really don't see, how we would be able to have a schema generated without
> setting up a Buildr environment. Perhaps you can give me some advice? How
> would we really enable hibernate instead of openJPA, or how would we be able
> to create the schema with openJPA?
>
> Thank you very much in advance!
> Best regards
>
> Alex  Hepp
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message