Guest User

Untitled

a guest
Sep 18th, 2018
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.85 KB | None | 0 0
  1. Ant, 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.  
  11. create 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.  
  23. create 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
Add Comment
Please, Sign In to add comment