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 <[email protected]> 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 >
