Edit Question - KnowledgeHub

Title Body

i'am using eclipseLink with jpa. in my persistence.xml, i defined to generate a create.sql file. the file will be generated, but with missing ';'-separators for each sql statement. is there a possibility to define a separator in the persistence.xml or in some other way? Example persistence.xml: <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider> <exclude-unlisted-classes>false</exclude-unlisted-classes> <class>de.company.project.models.User</class> <properties> <property name="eclipselink.ddl-generation" value="drop-and-create-tables" /> <property name="eclipselink.application-location" value="/sql" /> <property name="eclipselink.create-ddl-jdbc-file-name" value="create.sql"/> <property name="eclipselink.drop-ddl-jdbc-file-name" value="drop.sql"/> <property name="eclipselink.ddl-generation.output-mode" value="sql-script"/> </properties> Example generated sql file: CREATE TABLE app_user ( ID INTEGER NOT NULL, last_name VARCHAR(50) NOT NULL, username VARCHAR(15) NOT NULL, user_password VARCHAR(50) NOT NULL, first_name VARCHAR(50) NOT NULL, PRIMARY KEY (ID)) CREATE TABLE SEQUENCE ( SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME)) INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN_TABLE', 0)

Tags (comma-separated) Cancel