That directive will instruct OpenJPA to introspect the databases to ensure the tables needed for the table schema defined by your ORM exists, and will create the table structures automatically if they do not exist. Do you have a special need that requires OpenJPA to execute a provided SQL script?
On Fri, Apr 24, 2015 at 10:54 AM, Kay Wrobel <[email protected]> wrote: > Thanks, Jody. How will that let me provide an SQL script containing CREATE > TABLE and INSERT statements? > > Kay > > > On Apr 24, 2015, at 10:51 AM, Jody Grassel <[email protected]> wrote: > > > > Add the following property to your persistence unit: > > > > <property name="openjpa.jdbc.SynchronizeMappings" > > value="buildSchema(ForeignKeys=true)"/> > > > > > > > > On Fri, Apr 24, 2015 at 10:47 AM, Kay Wrobel <[email protected]> wrote: > > > >> Hi everybody. > >> > >> I am having a rough time finding a way to initialize an Embedded > In-Memory > >> Derby database in my web application. I found a reference on Oracle's > web > >> site that states you can initialize a database with DDL and DML > statements > >> using properties like the following: > >> > >>> <properties> > >>> <property > >> name="javax.persistence.schema-generation.database.action" > >> value="drop-and-create"/> > >>> <property > >> name="javax.persistence.schema-generation.create-source" > value="script"/> > >>> <property > >> name="javax.persistence.schema-generation.create-script-source" > >> value="META-INF/sql/create.sql" /> > >>> <property name="javax.persistence.sql-load-script-source" > >> value="META-INF/sql/data.sql" /> > >>> </properties> > >> > >> > >> However, that seems to be a new feature in JPA 2.1 spec as part of JEE > 6. > >> I am working with OpenJPA provided by Apache TomEE, which is > openjpa-2.4.0 > >> non-final, a JPA 2.0 implementation I would imagine. The current > release on > >> OpenJPA web site is openjpa 2.3. > >> > >> Is there a way to accomplish this via JPA 2.0 and/or OpenJPA > properties? > >> I am trying to initialize an in-memory database for a test case I try to > >> provide to someone. > >> > >> Any help would be much appreciated. > >> > >> Kay Wrobel > >
