openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anthony Alba <ascanio.al...@gmail.com>
Subject Blank lines in SQL/H2 mem: unexpected end of statement error
Date Sun, 15 Nov 2020 04:42:06 GMT
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

Mime
View raw message