Eclipse Community Forums: EclipseLink » Schema generation script in JPA 2.1

Home » Eclipse Projects » EclipseLink » Schema generation script in JPA 2.1(Schema not generated with javax.persistence.schema-generation.create-script-source)

Schema generation script in JPA 2.1 [message #1075936]

Tue, 30 July 2013 07:05

Eclipse User

I am trying to use the new JPA 2.1 schema features to have my database schema loaded from a script. I have set "javax.persistence.schema-generation.create-script-source" to the location of my schema DDL but the script does not get run and there are no errors thrown. If I supply a "javax.persistence.sql-load-script-source" to load some initial data this does run but fails as the database tables have not been created.

Maybe I have misunderstood things but I would expect the "..create-script-source" script to be run first to create the database tables etc. then "...sql-load-script-source" to load the data.

persistence.xml below, any suggestions much appreciated.

<persistence version="2.1" xmlns="http ://xmlns.jcp.org/xml/ns/persistence"
             xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http ://xmlns.jcp.org/xml/ns/persistence
             http ://www.oracle.com/webfolder/technetwork/jsc/xml/ns/persistence/persistence_2_1.xsd">

    <persistence-unit name="myapppu" transaction-type="JTA">
        <jta-data-source>jdbc/myapp</jta-data-source>
        <properties>
            <property name="eclipselink.target-database" value="org.eclipse.persistence.platform.database.H2Platform"/>
            <property name="javax.persistence.schema-generation.database.action" value="create"/>
            <property name="javax.persistence.schema-generation.scripts.action" value="none"/>
            <property name="javax.persistence.schema-generation.create-source" value="script"/>
            <property name="javax.persistence.schema-generation.create-script-source" value="file:etc/schema/schema-1.0.sql"/>
			<!--<property name="javax.persistence.sql-load-script-source" value="file:etc/data/test-data.sql"/>-->
            <property name="eclipselink.deploy-on-startup" value="true"/>
            <property name="eclipselink.logging.level" value="fine"/>
        </properties>
    </persistence-unit>

</persistence>

PS. I'm using embedded Glassfish 4 which reports the EclipseLink version as - Eclipse Persistence Services - 2.5.0.v20130507-3faac2b

Re: Schema generation script in JPA 2.1 [message #1076061 is a reply to message #1075936]

Tue, 30 July 2013 12:22

Eclipse User

What is in the script? EclipseLink should throw an exception if it cannot load the script file, so I would suggest turning EclipseLink logging to Finest and check the logs to see if the script you have specified is being executed or if there are some issues when running the script that might be preventing the tables from being fully created.

Best Regards,
Chris

Re: Schema generation script in JPA 2.1 [message #1076128 is a reply to message #1076061]

Tue, 30 July 2013 15:15

Eclipse User

Thanks I've got the errors now and it seems it doesn't like the line breaks in my SQL file.

My schema is generated by a data modelling tool with table definitions like below. I let JPA generate the DDL script and I see it has each table definition on a single line. Is there any way around this or does each statement have to be on a single line?

CREATE TABLE "language" (
"language_code" char(2) NOT NULL,
"language_description" varchar(50) NOT NULL,
CONSTRAINT "language_pkey" PRIMARY KEY ("language_code") 
);

Previous Topic:	Sequences in SQL Server 2012 + JPA + Eclipselink
Next Topic:	AdditionalCriteria in ServerSession

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 06 23:48:46 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter