API tools faq
paste
Advertisement
isuftin

Untitled

isuftin
Nov 29th, 2015
144
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 36.07 KB | None | 0 0
raw download clone embed print report
  1. --- maven-failsafe-plugin:2.19:integration-test (default) @ dsas-uncy-reader ---
  2.  
  3. -------------------------------------------------------
  4. T E S T S
  5. -------------------------------------------------------
  6. 11-29 09:38:16 jdbc[3]:
  7. /*SQL */SET TRACE_LEVEL_FILE 2;
  8. 2015-11-29 09:38:16 jdbc:
  9. /**/Connection conn0 = DriverManager.getConnection("jdbc:h2:tcp://localhost:53344/mem:xploder;create=false;TRACE_LEVEL_FILE=2;TRACE_LEVEL_SYSTEM_OUT=2", "TEST", "");
  10. 11-29 09:38:17 jdbc[3]:
  11. /*SQL #:1 t:2*/CALL DATABASE();
  12. 11-29 09:38:17 jdbc[3]:
  13. /*SQL */ROLLBACK;
  14. 2015-11-29 09:38:21 jdbc: exception
  15. 11-29 09:38:21 jdbc[3]:
  16. /*SQL t:1*/CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
  17. 11-29 09:38:21 jdbc[3]:
  18. /*SQL */COMMIT;
  19. 11-29 09:38:21 jdbc[3]:
  20. /*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
  21. 11-29 09:38:21 jdbc[3]:
  22. /*SQL */DELETE FROM PUBLIC.DATABASECHANGELOGLOCK;
  23. 11-29 09:38:21 jdbc[3]:
  24. /*SQL #:1*/INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
  25. 11-29 09:38:21 jdbc[3]:
  26. /*SQL */COMMIT;
  27. 11-29 09:38:21 jdbc[3]:
  28. /*SQL #:1 t:1*/SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1;
  29. 11-29 09:38:21 jdbc[3]:
  30. /*SQL #:1 t:1*/UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '192.168.99.1 (192.168.99.1)', LOCKGRANTED = '2015-11-29 09:38:21.600' WHERE ID = 1 AND LOCKED = FALSE;
  31. 11-29 09:38:21 jdbc[3]:
  32. /*SQL */COMMIT;
  33. INFO 11/29/15 9:38 AM: liquibase: Successfully acquired change log lock
  34. 11-29 09:38:21 jdbc[3]:
  35. /*SQL */ROLLBACK;
  36. INFO 11/29/15 9:38 AM: liquibase: Dropping Database Objects in schema: XPLODER.PUBLIC
  37. 11-29 09:38:21 jdbc[3]:
  38. /*SQL l:410*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOG', 6: '\\', 7: 'TABLE'};
  39. INFO 11/29/15 9:38 AM: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
  40. 11-29 09:38:21 jdbc[3]:
  41. /*SQL */CREATE TABLE PUBLIC.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255));
  42. 11-29 09:38:21 jdbc[3]:
  43. /*SQL */COMMIT;
  44. 11-29 09:38:21 jdbc[3]:
  45. /*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
  46. 11-29 09:38:21 jdbc[3]:
  47. /*SQL #:1*/SELECT CATALOG_NAME TABLE_CAT FROM INFORMATION_SCHEMA.CATALOGS;
  48. 11-29 09:38:21 jdbc[3]:
  49. /*SQL #:2 t:1*/SELECT SCHEMA_NAME TABLE_SCHEM, CATALOG_NAME TABLE_CATALOG, IS_DEFAULT FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
  50. 11-29 09:38:21 jdbc[3]:
  51. /*SQL l:410 t:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: '%', 6: '\\', 7: 'VIEW'};
  52. 11-29 09:38:21 jdbc[3]:
  53. /*SQL l:410 #:2 t:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: '%', 6: '\\', 7: 'TABLE'};
  54. 11-29 09:38:21 jdbc[3]:
  55. /*SQL */SELECT SEQUENCE_NAME FROM INFORMATION_SCHEMA.SEQUENCES WHERE SEQUENCE_SCHEMA = 'PUBLIC' AND IS_GENERATED=FALSE;
  56. 11-29 09:38:21 jdbc[3]:
  57. /*SQL l:410 #:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOG', 6: '\\', 7: 'TABLE'};
  58. 11-29 09:38:21 jdbc[3]:
  59. /*SQL l:482*/SELECT PKTABLE_CATALOG PKTABLE_CAT, PKTABLE_SCHEMA PKTABLE_SCHEM, PKTABLE_NAME PKTABLE_NAME, PKCOLUMN_NAME, FKTABLE_CATALOG FKTABLE_CAT, FKTABLE_SCHEMA FKTABLE_SCHEM, FKTABLE_NAME, FKCOLUMN_NAME, ORDINAL_POSITION KEY_SEQ, UPDATE_RULE, DELETE_RULE, FK_NAME, PK_NAME, DEFERRABILITY FROM INFORMATION_SCHEMA.CROSS_REFERENCES WHERE FKTABLE_CATALOG LIKE ? ESCAPE ? AND FKTABLE_SCHEMA LIKE ? ESCAPE ? AND FKTABLE_NAME = ? ORDER BY PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, FK_NAME, KEY_SEQ {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOG'};
  60. 11-29 09:38:21 jdbc[3]:
  61. /*SQL l:959 #:13 t:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATALOG, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_SCHEMA, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_TABLE, SOURCE_DATA_TYPE, CASE WHEN SEQUENCE_NAME IS NULL THEN CAST(? AS VARCHAR) ELSE CAST(? AS VARCHAR) END IS_AUTOINCREMENT, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATLOG FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND COLUMN_NAME LIKE ? ESCAPE ? ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION {1: 'NO', 2: 'YES', 3: 'XPLODER', 4: '\\', 5: 'PUBLIC', 6: '\\', 7: 'DATABASECHANGELOG', 8: '\\', 9: '%', 10: '\\'};
  62. 11-29 09:38:21 jdbc[3]:
  63. /*SQL l:410 #:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOGLOCK', 6: '\\', 7: 'TABLE'};
  64. 11-29 09:38:21 jdbc[3]:
  65. /*SQL l:482*/SELECT PKTABLE_CATALOG PKTABLE_CAT, PKTABLE_SCHEMA PKTABLE_SCHEM, PKTABLE_NAME PKTABLE_NAME, PKCOLUMN_NAME, FKTABLE_CATALOG FKTABLE_CAT, FKTABLE_SCHEMA FKTABLE_SCHEM, FKTABLE_NAME, FKCOLUMN_NAME, ORDINAL_POSITION KEY_SEQ, UPDATE_RULE, DELETE_RULE, FK_NAME, PK_NAME, DEFERRABILITY FROM INFORMATION_SCHEMA.CROSS_REFERENCES WHERE FKTABLE_CATALOG LIKE ? ESCAPE ? AND FKTABLE_SCHEMA LIKE ? ESCAPE ? AND FKTABLE_NAME = ? ORDER BY PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, FK_NAME, KEY_SEQ {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOGLOCK'};
  66. 11-29 09:38:21 jdbc[3]:
  67. /*SQL l:959 #:4*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATALOG, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_SCHEMA, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_TABLE, SOURCE_DATA_TYPE, CASE WHEN SEQUENCE_NAME IS NULL THEN CAST(? AS VARCHAR) ELSE CAST(? AS VARCHAR) END IS_AUTOINCREMENT, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATLOG FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND COLUMN_NAME LIKE ? ESCAPE ? ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION {1: 'NO', 2: 'YES', 3: 'XPLODER', 4: '\\', 5: 'PUBLIC', 6: '\\', 7: 'DATABASECHANGELOGLOCK', 8: '\\', 9: '%', 10: '\\'};
  68. 11-29 09:38:21 jdbc[3]:
  69. /*SQL */COMMIT;
  70. 11-29 09:38:21 jdbc[3]:
  71. /*SQL #:1*/select count(*) from \"PUBLIC\".\"DATABASECHANGELOG\";
  72. 11-29 09:38:21 jdbc[3]:
  73. /*SQL t:1*/DROP TABLE \"PUBLIC\".\"DATABASECHANGELOG\";
  74. 11-29 09:38:21 jdbc[3]:
  75. /*SQL #:1*/select count(*) from \"PUBLIC\".\"DATABASECHANGELOGLOCK\";
  76. 11-29 09:38:21 jdbc[3]:
  77. /*SQL */DROP TABLE \"PUBLIC\".\"DATABASECHANGELOGLOCK\";
  78. 11-29 09:38:21 jdbc[3]:
  79. /*SQL */COMMIT;
  80. 2015-11-29 09:38:21 jdbc: exception
  81. 11-29 09:38:21 jdbc[3]:
  82. /*SQL */ROLLBACK;
  83. 2015-11-29 09:38:21 jdbc: exception
  84. 11-29 09:38:21 jdbc[3]:
  85. /*SQL */COMMIT;
  86. 2015-11-29 09:38:21 jdbc: exception
  87. 11-29 09:38:21 jdbc[3]:
  88. /*SQL */COMMIT;
  89. 11-29 09:38:21 jdbc[3]:
  90. /*SQL t:1*/COMMIT;
  91. INFO 11/29/15 9:38 AM: liquibase: Successfully acquired change log lock
  92. 11-29 09:38:21 jdbc[3]:
  93. /*SQL */ROLLBACK;
  94. 11-29 09:38:22 jdbc[3]:
  95. /*SQL l:410*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOG', 6: '\\', 7: 'TABLE'};
  96. INFO 11/29/15 9:38 AM: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
  97. 11-29 09:38:22 jdbc[3]:
  98. /*SQL */COMMIT;
  99. 2015-11-29 09:38:22 jdbc: exception
  100. 11-29 09:38:22 jdbc[3]:
  101. /*SQL */COMMIT;
  102. 2015-11-29 09:38:22 jdbc: exception
  103. 11-29 09:38:22 jdbc[3]:
  104. /*SQL */ROLLBACK;
  105. 11-29 09:38:22 jdbc[3]:
  106. /*SQL */ROLLBACK;
  107. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin: Tag 'pre-points-table-created' applied to database
  108. 11-29 09:38:22 jdbc[3]:
  109. /*SQL t:1*/COMMIT;
  110. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin: ChangeSet src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin ran successfully in 1ms
  111. 2015-11-29 09:38:22 jdbc: exception
  112. 11-29 09:38:22 jdbc[3]:
  113. /*SQL */COMMIT;
  114. 11-29 09:38:22 jdbc[3]:
  115. /*SQL */COMMIT;
  116. 11-29 09:38:22 jdbc[3]:
  117. /*SQL */ROLLBACK;
  118. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): Table POINTS created
  119. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): Index idx_ID created
  120. 11-29 09:38:22 jdbc[3]:
  121. /*SQL */COMMIT;
  122. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): ChangeSet src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov) ran successfully in 2ms
  123. 11-29 09:38:22 jdbc[3]:
  124. /*SQL */COMMIT;
  125. 11-29 09:38:22 jdbc[3]:
  126. /*SQL */COMMIT;
  127. 11-29 09:38:22 jdbc[3]:
  128. /*SQL */ROLLBACK;
  129. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin: Tag 'post-points-table-created' applied to database
  130. 11-29 09:38:22 jdbc[3]:
  131. /*SQL */COMMIT;
  132. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin: ChangeSet src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin ran successfully in 0ms
  133. 11-29 09:38:22 jdbc[3]:
  134. /*SQL */COMMIT;
  135. 11-29 09:38:22 jdbc[3]:
  136. /*SQL */COMMIT;
  137. 11-29 09:38:22 jdbc[3]:
  138. /*SQL */ROLLBACK;
  139. 11-29 09:38:22 jdbc[3]:
  140. /*SQL */COMMIT;
  141. INFO 11/29/15 9:38 AM: liquibase: Successfully released change log lock
  142. 11-29 09:38:22 jdbc[3]:
  143. /*SQL */ROLLBACK;
  144. -- *********************************************************************
  145. -- Update Database Script
  146. -- *********************************************************************
  147. -- Change Log: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml
  148. -- Ran at: 11/29/15 9:38 AM
  149. -- Against: TEST@jdbc:h2:tcp://localhost:53344/mem:xploder
  150. -- Liquibase version: 3.4.2
  151. -- *********************************************************************
  152.  
  153. -- Create Database Lock Table
  154. CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
  155.  
  156. -- Initialize Database Lock Table
  157. DELETE FROM PUBLIC.DATABASECHANGELOGLOCK;
  158.  
  159. INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
  160.  
  161. -- Lock Database
  162. UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '192.168.99.1 (192.168.99.1)', LOCKGRANTED = '2015-11-29 09:38:21.674' WHERE ID = 1 AND LOCKED = FALSE;
  163.  
  164. -- Create Database Change Log Table
  165. CREATE TABLE PUBLIC.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255));
  166.  
  167. -- Changeset src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin
  168. INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, TAG) VALUES ('tag-integration-test-database-before-creation', 'Ivan Suftin', 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml', NOW(), 1, '7:895e9d9e7c30a2094c0e607ef02b8de1', 'tagDatabase', '', 'EXECUTED', 'integration-test', NULL, '3.4.2', 'pre-points-table-created');
  169.  
  170. -- Changeset src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov)
  171. CREATE TABLE PUBLIC.POINTS (ID BIGINT AUTO_INCREMENT NOT NULL, SHORELINE_ID BIGINT NOT NULL, SEGMENT_ID BIGINT NOT NULL, GEOM GEOMETRY NOT NULL, UNCY DOUBLE NOT NULL, CONSTRAINT pk_ID PRIMARY KEY (ID));
  172.  
  173. CREATE UNIQUE INDEX PUBLIC.idx_ID ON PUBLIC.POINTS(id);
  174.  
  175. INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('create-shoreline-points-table', 'Ivan Suftin (isuftin@usgs.gov)', 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml', NOW(), 2, '7:b0f510d94f8729fc5891a3604357fb3d', 'createTable, createIndex', '', 'EXECUTED', 'update,integration-test', NULL, '3.4.2');
  176.  
  177. -- Changeset src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin
  178. INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, TAG) VALUES ('tag-integration-test-database-after-creation', 'Ivan Suftin', 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml', NOW(), 3, '7:3eed4ea632e44959f747908dce40aed8', 'tagDatabase', '', 'EXECUTED', 'integration-test', NULL, '3.4.2', 'post-points-table-created');
  179.  
  180. -- Release Database Lock
  181. UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
  182.  
  183. 11-29 09:38:22 jdbc[3]:
  184. /*SQL */ROLLBACK;
  185. Running gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest
  186. 2015-11-29 09:38:22 jdbc: exception
  187. 11-29 09:38:22 jdbc[3]:
  188. /*SQL t:1*/CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
  189. 11-29 09:38:22 jdbc[3]:
  190. /*SQL */COMMIT;
  191. 11-29 09:38:22 jdbc[3]:
  192. /*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
  193. 11-29 09:38:22 jdbc[3]:
  194. /*SQL */DELETE FROM PUBLIC.DATABASECHANGELOGLOCK;
  195. 11-29 09:38:22 jdbc[3]:
  196. /*SQL #:1*/INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
  197. 11-29 09:38:22 jdbc[3]:
  198. /*SQL */COMMIT;
  199. 11-29 09:38:22 jdbc[3]:
  200. /*SQL #:1*/SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1;
  201. 11-29 09:38:22 jdbc[3]:
  202. /*SQL #:1*/UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '192.168.99.1 (192.168.99.1)', LOCKGRANTED = '2015-11-29 09:38:22.270' WHERE ID = 1 AND LOCKED = FALSE;
  203. 11-29 09:38:22 jdbc[3]:
  204. /*SQL */COMMIT;
  205. INFO 11/29/15 9:38 AM: liquibase: Successfully acquired change log lock
  206. 11-29 09:38:22 jdbc[3]:
  207. /*SQL */ROLLBACK;
  208. 11-29 09:38:22 jdbc[3]:
  209. /*SQL l:410*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOG', 6: '\\', 7: 'TABLE'};
  210. INFO 11/29/15 9:38 AM: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
  211. 11-29 09:38:22 jdbc[3]:
  212. /*SQL */CREATE TABLE PUBLIC.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255));
  213. 11-29 09:38:22 jdbc[3]:
  214. /*SQL */COMMIT;
  215. 11-29 09:38:22 jdbc[3]:
  216. /*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOG;
  217. INFO 11/29/15 9:38 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
  218. 11-29 09:38:22 jdbc[3]:
  219. /*SQL */SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
  220. 11-29 09:38:22 jdbc[3]:
  221. /*SQL */COMMIT;
  222. 11-29 09:38:22 jdbc[3]:
  223. /*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
  224. 11-29 09:38:22 jdbc[3]:
  225. /*SQL */ROLLBACK;
  226. 11-29 09:38:22 jdbc[3]:
  227. /*SQL */ROLLBACK;
  228. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin: Tag 'pre-points-table-created' applied to database
  229. 11-29 09:38:22 jdbc[3]:
  230. /*SQL */COMMIT;
  231. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin: ChangeSet src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin ran successfully in 0ms
  232. 11-29 09:38:22 jdbc[3]:
  233. /*SQL #:1 t:1*/SELECT MAX(ORDEREXECUTED) FROM PUBLIC.DATABASECHANGELOG;
  234. 11-29 09:38:22 jdbc[3]:
  235. /*SQL #:1*/INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, TAG) VALUES ('tag-integration-test-database-before-creation', 'Ivan Suftin', 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml', NOW(), 1, '7:895e9d9e7c30a2094c0e607ef02b8de1', 'tagDatabase', '', 'EXECUTED', 'integration-test', NULL, '3.4.2', 'pre-points-table-created');
  236. 11-29 09:38:22 jdbc[3]:
  237. /*SQL */COMMIT;
  238. 11-29 09:38:22 jdbc[3]:
  239. /*SQL */COMMIT;
  240. 11-29 09:38:22 jdbc[3]:
  241. /*SQL */ROLLBACK;
  242. 11-29 09:38:22 jdbc[3]:
  243. /*SQL t:3*/CREATE TABLE PUBLIC.POINTS (ID BIGINT AUTO_INCREMENT NOT NULL, SHORELINE_ID BIGINT NOT NULL, SEGMENT_ID BIGINT NOT NULL, GEOM GEOMETRY NOT NULL, UNCY DOUBLE NOT NULL, CONSTRAINT pk_ID PRIMARY KEY (ID));
  244. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): Table POINTS created
  245. 11-29 09:38:22 jdbc[3]:
  246. /*SQL t:2*/CREATE UNIQUE INDEX PUBLIC.idx_ID ON PUBLIC.POINTS(id);
  247. 11-29 09:38:22 jdbc[3]:
  248. /*SQL */COMMIT;INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): Index idx_ID created
  249.  
  250. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): ChangeSet src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov) ran successfully in 8ms
  251. 11-29 09:38:22 jdbc[3]:
  252. /*SQL #:1 t:1*/INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('create-shoreline-points-table', 'Ivan Suftin (isuftin@usgs.gov)', 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml', NOW(), 2, '7:b0f510d94f8729fc5891a3604357fb3d', 'createTable, createIndex', '', 'EXECUTED', 'update,integration-test', NULL, '3.4.2');
  253. 11-29 09:38:22 jdbc[3]:
  254. /*SQL */COMMIT;
  255. 11-29 09:38:22 jdbc[3]:
  256. /*SQL */COMMIT;
  257. 11-29 09:38:22 jdbc[3]:
  258. /*SQL */ROLLBACK;
  259. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin: Tag 'post-points-table-created' applied to database
  260. 11-29 09:38:22 jdbc[3]:
  261. /*SQL */COMMIT;
  262. INFO 11/29/15 9:38 AM: liquibase: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin: ChangeSet src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin ran successfully in 0ms
  263. 11-29 09:38:22 jdbc[3]:
  264. /*SQL #:1 t:1*/INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, TAG) VALUES ('tag-integration-test-database-after-creation', 'Ivan Suftin', 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml', NOW(), 3, '7:3eed4ea632e44959f747908dce40aed8', 'tagDatabase', '', 'EXECUTED', 'integration-test', NULL, '3.4.2', 'post-points-table-created');
  265. 11-29 09:38:22 jdbc[3]:
  266. /*SQL */COMMIT;
  267. 11-29 09:38:22 jdbc[3]:
  268. /*SQL */COMMIT;
  269. 11-29 09:38:22 jdbc[3]:
  270. /*SQL */ROLLBACK;
  271. 11-29 09:38:22 jdbc[3]:
  272. /*SQL #:1*/UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
  273. 11-29 09:38:22 jdbc[3]:
  274. /*SQL */COMMIT;
  275. INFO 11/29/15 9:38 AM: liquibase: Successfully released change log lock
  276. 11-29 09:38:22 jdbc[3]:
  277. /*SQL */ROLLBACK;
  278. 09:38:22.362 [main] INFO g.u.c.d.u.H2DBOutputExploderIntegrationTest - testCreateXploder()
  279. 09:38:23.114 [main] DEBUG gov.usgs.cida.dsas.uncy.Xploder - Reading source schema from /var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448811502260/test_shorelines.shp
  280. 09:38:23.290 [main] DEBUG gov.usgs.cida.dsas.uncy.Xploder - Source schema is SimpleFeatureTypeImpl test_shorelines identified extends lineFeature(the_geom:MultiLineString,descriptio:descriptio,name:name,DATE_:DATE_,ACCURACY:ACCURACY)
  281. 11-29 09:38:23 database: connecting session #4 to mem:xploder
  282. 11-29 09:38:23 jdbc[4]:
  283. /*SQL t:1*/ROLLBACK;
  284. 11-29 09:38:23 database: disconnecting session #4
  285. 11-29 09:38:23 database: disconnected session #4
  286. 11-29 09:38:23 database: connecting session #5 to mem:xploder
  287. 11-29 09:38:23 jdbc[5]:
  288. /*SQL t:1*/CREATE DOMAIN POINT AS BLOB;
  289. 11-29 09:38:23 jdbc[5]:
  290. /*SQL t:1*/CREATE DOMAIN LINESTRING AS BLOB;
  291. 11-29 09:38:23 jdbc[5]:
  292. /*SQL */CREATE DOMAIN POLYGON AS BLOB;
  293. 11-29 09:38:23 jdbc[5]:
  294. /*SQL */CREATE DOMAIN MULTIPOINT AS BLOB;
  295. 11-29 09:38:23 jdbc[5]:
  296. /*SQL */CREATE DOMAIN MULTILINESTRING AS BLOB;
  297. 11-29 09:38:23 jdbc[5]:
  298. /*SQL */CREATE DOMAIN MULTIPOLYGON AS BLOB;
  299. 11-29 09:38:23 jdbc[5]:
  300. /*SQL */CREATE DOMAIN GEOMETRYCOLLECTION AS BLOB;
  301. 11-29 09:38:23 jdbc[5]:
  302. /*SQL */CREATE TABLE IF NOT EXISTS _GEODB (checksum VARCHAR);
  303. 11-29 09:38:23 jdbc[5]:
  304. /*SQL */DELETE FROM _GEODB;
  305. 11-29 09:38:23 jdbc[5]:
  306. /*SQL #:1*/INSERT INTO _GEODB VALUES (9);
  307. 11-29 09:38:23 jdbc[5]:
  308. /*SQL */CREATE TABLE IF NOT EXISTS geometry_columns (f_table_schema VARCHAR, f_table_name VARCHAR, f_geometry_column VARCHAR, coord_dimension INT, srid INT, type VARCHAR(30));
  309. 11-29 09:38:23 jdbc[5]:
  310. /*SQL #:4*/SELECT TYPE TABLE_TYPE FROM INFORMATION_SCHEMA.TABLE_TYPES ORDER BY TABLE_TYPE;
  311. 11-29 09:38:23 jdbc[5]:
  312. /*SQL l:413 #:5 t:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?, ?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: '%', 2: '\\', 3: '%', 4: '\\', 5: '%', 6: '\\', 7: 'TABLE', 8: 'VIEW'};
  313. 11-29 09:38:23 jdbc[5]:
  314. /*SQL #:1 t:1*/SELECT checksum FROM _GEODB;
  315. 11-29 09:38:23 jdbc[5]:
  316. /*SQL l:316 #:1 t:2*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION KEY_SEQ, IFNULL(CONSTRAINT_NAME, INDEX_NAME) PK_NAME FROM INFORMATION_SCHEMA.INDEXES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME = ? AND PRIMARY_KEY = TRUE ORDER BY COLUMN_NAME {1: '%', 2: '\\', 3: '%', 4: '\\', 5: 'POINTS'};
  317. 11-29 09:38:23 jdbc[5]:
  318. /*SQL l:959 #:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATALOG, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_SCHEMA, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_TABLE, SOURCE_DATA_TYPE, CASE WHEN SEQUENCE_NAME IS NULL THEN CAST(? AS VARCHAR) ELSE CAST(? AS VARCHAR) END IS_AUTOINCREMENT, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATLOG FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND COLUMN_NAME LIKE ? ESCAPE ? ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION {1: 'NO', 2: 'YES', 3: '%', 4: '\\', 5: '%', 6: '\\', 7: 'POINTS', 8: '\\', 9: 'ID', 10: '\\'};
  319. 11-29 09:38:23 jdbc[5]:
  320. /*SQL */SELECT \"ID\" FROM \"POINTS\" WHERE 0=1;
  321. 11-29 09:38:23 jdbc[5]:
  322. /*SQL #:1*/CALL DATABASE();
  323. 11-29 09:38:23 jdbc[5]:
  324. /*SQL #:1*/SELECT checksum FROM _GEODB;
  325. 11-29 09:38:23 jdbc[5]:
  326. /*SQL l:959 #:5*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATALOG, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_SCHEMA, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_TABLE, SOURCE_DATA_TYPE, CASE WHEN SEQUENCE_NAME IS NULL THEN CAST(? AS VARCHAR) ELSE CAST(? AS VARCHAR) END IS_AUTOINCREMENT, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATLOG FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND COLUMN_NAME LIKE ? ESCAPE ? ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION {1: 'NO', 2: 'YES', 3: 'XPLODER', 4: '\\', 5: '%', 6: '\\', 7: 'POINTS', 8: '\\', 9: '%', 10: '\\'};
  327. 2015-11-29T09:38:23.401-0600 WARNING Could not find mapping for 'GEOM', ignoring the column and setting the feature type read only
  328. 11-29 09:38:23 jdbc[3]:
  329. /*SQL */ROLLBACK;
  330. 11-29 09:38:23 jdbc[3]:
  331. /*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
  332. 11-29 09:38:23 jdbc[3]:
  333. /*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
  334. 11-29 09:38:23 jdbc[3]:
  335. /*SQL */COMMIT;
  336. INFO 11/29/15 9:38 AM: liquibase: Successfully acquired change log lock
  337. 11-29 09:38:23 jdbc[3]:
  338. /*SQL */ROLLBACK;
  339. 11-29 09:38:23 jdbc[3]:
  340. /*SQL l:410 #:1*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?)) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME {1: 'XPLODER', 2: '\\', 3: 'PUBLIC', 4: '\\', 5: 'DATABASECHANGELOG', 6: '\\', 7: 'TABLE'};
  341. 11-29 09:38:23 jdbc[3]:
  342. /*SQL l:959 #:13*/SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATALOG, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_SCHEMA, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_TABLE, SOURCE_DATA_TYPE, CASE WHEN SEQUENCE_NAME IS NULL THEN CAST(? AS VARCHAR) ELSE CAST(? AS VARCHAR) END IS_AUTOINCREMENT, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATLOG FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND COLUMN_NAME LIKE ? ESCAPE ? ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION {1: 'NO', 2: 'YES', 3: 'XPLODER', 4: '\\', 5: 'PUBLIC', 6: '\\', 7: 'DATABASECHANGELOG', 8: '\\', 9: '%', 10: '\\'};
  343. 11-29 09:38:23 jdbc[3]:
  344. /*SQL #:3*/SELECT MD5SUM FROM PUBLIC.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL;
  345. 11-29 09:38:23 jdbc[3]:
  346. /*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOG;
  347. INFO 11/29/15 9:38 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
  348. 11-29 09:38:23 jdbc[3]:
  349. /*SQL #:3*/SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
  350. 11-29 09:38:23 jdbc[3]:
  351. /*SQL */ROLLBACK;
  352. INFO 11/29/15 9:38 AM: liquibase: null: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin: Rolling Back Changeset:src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin
  353. 11-29 09:38:23 jdbc[3]:
  354. /*SQL */COMMIT;
  355. 11-29 09:38:23 jdbc[3]:
  356. /*SQL */COMMIT;
  357. 11-29 09:38:23 jdbc[3]:
  358. /*SQL */COMMIT;
  359. INFO 11/29/15 9:38 AM: liquibase: null: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov): Rolling Back Changeset:src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov)
  360. 11-29 09:38:23 jdbc[3]:
  361. /*SQL */COMMIT;
  362. 11-29 09:38:23 jdbc[3]:
  363. /*SQL */COMMIT;
  364. 11-29 09:38:23 jdbc[3]:
  365. /*SQL */COMMIT;
  366. 11-29 09:38:23 jdbc[3]:
  367. /*SQL */ROLLBACK;
  368. 11-29 09:38:23 jdbc[3]:
  369. /*SQL */COMMIT;
  370. INFO 11/29/15 9:38 AM: liquibase: Successfully released change log lock
  371. 11-29 09:38:23 jdbc[3]:
  372. /*SQL */ROLLBACK;
  373. -- *********************************************************************
  374. -- Rollback to 'pre-points-table-created' Script
  375. -- *********************************************************************
  376. -- Change Log: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml
  377. -- Ran at: 11/29/15 9:38 AM
  378. -- Against: TEST@jdbc:h2:tcp://localhost:53344/mem:xploder
  379. -- Liquibase version: 3.4.2
  380. -- *********************************************************************
  381.  
  382. -- Lock Database
  383. UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '192.168.99.1 (192.168.99.1)', LOCKGRANTED = '2015-11-29 09:38:23.404' WHERE ID = 1 AND LOCKED = FALSE;
  384.  
  385. -- Rolling Back ChangeSet: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin
  386. DELETE FROM PUBLIC.DATABASECHANGELOG WHERE ID = 'tag-integration-test-database-after-creation' AND AUTHOR = 'Ivan Suftin' AND FILENAME = 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml';
  387.  
  388. -- Rolling Back ChangeSet: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov)
  389. DELETE FROM PUBLIC.POINTS;
  390.  
  391. DELETE FROM PUBLIC.DATABASECHANGELOG WHERE ID = 'create-shoreline-points-table' AND AUTHOR = 'Ivan Suftin (isuftin@usgs.gov)' AND FILENAME = 'src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml';
  392.  
  393. -- Release Database Lock
  394. UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
  395.  
  396. 11-29 09:38:23 jdbc[3]:
  397. /*SQL */ROLLBACK;
  398. 11-29 09:38:23 database: disconnecting session #3
  399. 11-29 09:38:23 database: disconnected session #3
  400. Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 1.229 sec <<< FAILURE! - in gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest
  401. testCreateXploder(gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest) Time elapsed: 1.227 sec <<< ERROR!
  402. java.io.IOException: POINTS is read only
  403. at gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest.testCreateXploder(H2DBOutputExploderIntegrationTest.java:127)
  404.  
  405. 11-29 09:38:23 jdbc[5]:
  406. /*SQL */ROLLBACK;
  407. 11-29 09:38:23 database: disconnecting session #5
  408. 11-29 09:38:23 database: closing mem:xploder
  409. 11-29 09:38:23 database: closed
  410. 11-29 09:38:23 database: disconnected session #5
  411.  
  412. Results :
  413.  
  414. Tests in error:
  415. H2DBOutputExploderIntegrationTest.testCreateXploder:127 » IO POINTS is read on...
  416.  
  417. Tests run: 1, Failures: 0, Errors: 1, Skipped: 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!