I think Alex didn't mean it's there already, just pointed out a way to add this :)
We already have something similar in bpel-store [1]. You can configure OpenJPA to create the schema for you if it can't find it. So what you would do is basically: 1. Create a derby instance. 2. Point OpenJPA to it with the right option (just add it as a property in [2]). 3. Instantiate the store asking it to create its schema as well. 4. There's no 4. Given that Tuscany already has its own IL, you have all the freedom to do this when assembling the pieces. The only missing one is the property in 2. Cheers, Matthieu [1] http://svn.apache.org/repos/asf/ode/trunk/bpel-store/src/main/java/org/apache/ode/store/jpa/DbConfStoreConnectionFactory.java [2] http://svn.apache.org/repos/asf/ode/trunk/dao-jpa/src/main/java/org/apache/ode/dao/jpa/BPELDAOConnectionFactoryImpl.java On Tue, May 13, 2008 at 12:04 PM, Luciano Resende <[EMAIL PROTECTED]> wrote: > Good to know we already have the code to create a new Derby dabase > instance with a fresh Ode Schema. I guess I have missed this when > creating the Tuscany Embedded Ode Server. Could you please point me to > where this is available ? > > On Tue, May 13, 2008 at 11:56 AM, Alex Boisvert <[EMAIL PROTECTED]> > wrote: > > Perhaps by defining a new database mode "SAMPLE" (we already have > EMBEDDED, > > INTERNAL, EXTERNAL), that creates a new Derby database instance with a > fresh > > Ode schema everytime the server is started? > > > > alex > > > > > > On Tue, May 13, 2008 at 11:50 AM, Luciano Resende <[EMAIL PROTECTED]> > > wrote: > > > >> In Apache Tuscany, we have a embedded ODE Server that has a dependency > >> on the ODE database (ode-dao-jpa-ojpa-derby-1.1.zip) that get's unzip > >> by the build process when the app is run. I see two issues with this > >> approach : The build infrastructure to unzip the db needs to be copied > >> on every sample app and when running from an IDE, this code might not > >> have been executed, and will require the application developer to go > >> outside of the ide, to run some build command to create the db and > >> make it available on the classpath. > >> > >> I was wondering if there is some kind of script that could be used to > >> generate the db structure and any initial content. If so, I was > >> thinking to integrate this script into the Embedded ODE Server > >> initialization code, and create the proper db dependencies if not > >> found. > >> > >> Thoughts ? > >> > >> -- > >> Luciano Resende > >> Apache Tuscany Committer > >> http://people.apache.org/~lresende<http://people.apache.org/%7Elresende>< > http://people.apache.org/%7Elresende> > >> http://lresende.blogspot.com/ > >> > > > > > > -- > Luciano Resende > Apache Tuscany Committer > http://people.apache.org/~lresende <http://people.apache.org/%7Elresende> > http://lresende.blogspot.com/ >
