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
|