I am loading an SQL file using javax.persistence.sql-load-script-source; it seems that blank lines cause
"unexpected end of statement" Is this to be expected? Longer description: 0. greeter war is adapted from Wildfly/hibernate: https://github.com/wildfly/quickstart/tree/master/greeter 1. Loaded the greeter war into TomEE plus 8.0.4 (OpenJPA 3.1.0, H2 mem) - did not switch to hibernate 2. persistence.xml from the repo is modified to be OpenJPA-friendly <properties> <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/> <property name="javax.persistence.sql-load-script-source" value="import.sql"/> 3. import.sql contains blank lines -- comments lines like this -- blank line below this INSERT INTO USERS (ID, USERNAME, FIRSTNAME, LASTNAME) VALUES (-1, 'jdoe', 'John', 'Doe'); INSERT INTO USERS (ID, USERNAME, FIRSTNAME, LASTNAME) VALUES (-2, 'emuster', 'Erika', 'Mustermann'); I am getting this error org.apache.openjpa.lib.jdbc.ReportingSQLException: unexpected end of statement {stmnt 640838984 } [code=-5590, state=42590] 4. This SQL files works on Wildfly/hibernate; it also works on TomEE/OpenJPA if I remove all blank lines
