yZtDL6xJ

1Ant, execute-sql-script and errors with PostgreSQL
2<execute-sql-script
3    driver=org.postgresql.Driver
4    url=jdbc:postgresql://127.0.0.1:5432/lakshmi_testapp?searchpath=lakshmi_stdcmp
5    user=lakshmi_stdcmp
6    password=********
7    classpathid=execute-sql.classpath
8    sqlfile=/var/lib/jenkins/jobs/Lakshmi-Testapp-PostgreSQL/workspace/target/lakshmi-std-cmp-opu.sql
9/>
10	
11create table PersistentOrder (
12    dbId int8 not null,
13    orderActionsBinary oid,
14    orderActionsText text,
15    orderIssuerId varchar(255),
16    orderIssuerName varchar(255),
17    orderType varchar(255),
18    returnType int4,
19    uuid varchar(255),
20    primary key (dbId)
21);
22
23create table REVINFO (
24    REV int4 not null,
25    REVTSTMP int8,
26    primary key (REV)
27);
28	
29[sql] Executing resource: /var/lib/jenkins/jobs/Lakshmi-Testapp-PostgreSQL/workspace/target/lakshmi-std-cmp-opu.sql
30[sql] Failed to execute:   create table if not exists PersistentOrder ( dbId int8 not null, orderActionsBinary oid, orderActionsText text, orderIssuerId varchar(255), orderIssuerName varchar(255), orderType varchar(255), returnType int4, uuid varchar(255), primary key (dbId) )
31[sql] org.postgresql.util.PSQLException: ERROR: syntax error at or near "not"
32[sql]   Position: 19
33[sql] Failed to execute:   create table if not exists REVINFO ( REV int4 not null, REVTSTMP int8, primary key (REV) )
34[sql] org.postgresql.util.PSQLException: ERROR: syntax error at or near "not"
35[sql]   Position: 19
36[sql] Failed to execute:   drop sequence if exists hibernate_sequence
37[sql] org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
38[sql] Failed to execute:  create sequence hibernate_sequence;
39[sql] org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
40[sql] 0 of 4 SQL statements executed successfully