· 10 years ago · Nov 29, 2015, 03:30 PM
1--- inmemdb-maven-plugin:1.4.3:run (start-db) @ dsas-uncy-reader ---
2Configured database name: xploder;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3
3Configured database password: test
4Configured database port: 53033
5Configured database attributes: {}
6Configured database username: test
7Starting embedded H2 database
8Embedded H2 database has started
9Server has been started
10Waiting for command from client
11
12--- maven-failsafe-plugin:2.19:integration-test (default) @ dsas-uncy-reader ---
13
14-------------------------------------------------------
15 T E S T S
16-------------------------------------------------------
1711-29 09:24:04 jdbc[3]:
18/*SQL */SET TRACE_LEVEL_FILE 2;
192015-11-29 09:24:04 jdbc:
20/**/Connection conn0 = DriverManager.getConnection("jdbc:h2:tcp://localhost:53033/mem:xploder;create=false;TRACE_LEVEL_FILE=2;TRACE_LEVEL_SYSTEM_OUT=2", "TEST", "");
2111-29 09:24:05 jdbc[3]:
22/*SQL #:1 t:1*/CALL DATABASE();
2311-29 09:24:05 jdbc[3]:
24/*SQL */ROLLBACK;
252015-11-29 09:24:05 jdbc: exception
2611-29 09:24:05 jdbc[3]:
27/*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));
2811-29 09:24:05 jdbc[3]:
29/*SQL */COMMIT;
3011-29 09:24:05 jdbc[3]:
31/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
3211-29 09:24:05 jdbc[3]:
33/*SQL t:1*/DELETE FROM PUBLIC.DATABASECHANGELOGLOCK;
3411-29 09:24:05 jdbc[3]:
35/*SQL #:1 t:1*/INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
3611-29 09:24:05 jdbc[3]:
37/*SQL */COMMIT;
3811-29 09:24:05 jdbc[3]:
39/*SQL #:1 t:1*/SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1;
4011-29 09:24:05 jdbc[3]:
41/*SQL #:1*/UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '192.168.99.1 (192.168.99.1)', LOCKGRANTED = '2015-11-29 09:24:05.371' WHERE ID = 1 AND LOCKED = FALSE;
4211-29 09:24:05 jdbc[3]:
43/*SQL */COMMIT;
44INFO 11/29/15 9:24 AM: liquibase: Successfully acquired change log lock
4511-29 09:24:05 jdbc[3]:
46/*SQL */ROLLBACK;
47INFO 11/29/15 9:24 AM: liquibase: Dropping Database Objects in schema: XPLODER.PUBLIC
4811-29 09:24:05 jdbc[3]:
49/*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: 'DATABASECHANGELOG', 6: '\\', 7: 'TABLE'};
50INFO 11/29/15 9:24 AM: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
5111-29 09:24:05 jdbc[3]:
52/*SQL t:1*/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));
5311-29 09:24:05 jdbc[3]:
54/*SQL */COMMIT;
5511-29 09:24:05 jdbc[3]:
56/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
5711-29 09:24:05 jdbc[3]:
58/*SQL #:1*/SELECT CATALOG_NAME TABLE_CAT FROM INFORMATION_SCHEMA.CATALOGS;
5911-29 09:24:05 jdbc[3]:
60/*SQL #:2*/SELECT SCHEMA_NAME TABLE_SCHEM, CATALOG_NAME TABLE_CATALOG, IS_DEFAULT FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
6111-29 09:24:05 jdbc[3]:
62/*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'};
6311-29 09:24:05 jdbc[3]:
64/*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'};
6511-29 09:24:05 jdbc[3]:
66/*SQL */SELECT SEQUENCE_NAME FROM INFORMATION_SCHEMA.SEQUENCES WHERE SEQUENCE_SCHEMA = 'PUBLIC' AND IS_GENERATED=FALSE;
6711-29 09:24:05 jdbc[3]:
68/*SQL l:410 #:1 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: 'DATABASECHANGELOG', 6: '\\', 7: 'TABLE'};
6911-29 09:24:05 jdbc[3]:
70/*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'};
7111-29 09:24:05 jdbc[3]:
72/*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: '\\'};
7311-29 09:24:05 jdbc[3]:
74/*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'};
7511-29 09:24:05 jdbc[3]:
76/*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'};
7711-29 09:24:05 jdbc[3]:
78/*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: '\\'};
7911-29 09:24:05 jdbc[3]:
80/*SQL */COMMIT;
8111-29 09:24:05 jdbc[3]:
82/*SQL #:1*/select count(*) from \"PUBLIC\".\"DATABASECHANGELOG\";
8311-29 09:24:05 jdbc[3]:
84/*SQL t:2*/DROP TABLE \"PUBLIC\".\"DATABASECHANGELOG\";
8511-29 09:24:05 jdbc[3]:
86/*SQL #:1*/select count(*) from \"PUBLIC\".\"DATABASECHANGELOGLOCK\";
8711-29 09:24:05 jdbc[3]:
88/*SQL */DROP TABLE \"PUBLIC\".\"DATABASECHANGELOGLOCK\";
8911-29 09:24:05 jdbc[3]:
90/*SQL */COMMIT;
912015-11-29 09:24:05 jdbc: exception
9211-29 09:24:05 jdbc[3]:
93/*SQL */ROLLBACK;
942015-11-29 09:24:05 jdbc: exception
9511-29 09:24:05 jdbc[3]:
96/*SQL */COMMIT;
972015-11-29 09:24:05 jdbc: exception
9811-29 09:24:05 jdbc[3]:
99/*SQL */COMMIT;
10011-29 09:24:05 jdbc[3]:
101/*SQL */COMMIT;
102INFO 11/29/15 9:24 AM: liquibase: Successfully acquired change log lock
10311-29 09:24:05 jdbc[3]:
104/*SQL */ROLLBACK;
10511-29 09:24:06 jdbc[3]:
106/*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'};
107INFO 11/29/15 9:24 AM: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
10811-29 09:24:06 jdbc[3]:
109/*SQL */COMMIT;
1102015-11-29 09:24:06 jdbc: exception
11111-29 09:24:06 jdbc[3]:
112/*SQL */COMMIT;
1132015-11-29 09:24:06 jdbc: exception
11411-29 09:24:06 jdbc[3]:
115/*SQL */ROLLBACK;
11611-29 09:24:06 jdbc[3]:
117/*SQL */ROLLBACK;
118INFO 11/29/15 9:24 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
11911-29 09:24:06 jdbc[3]:
120/*SQL */COMMIT;
121INFO 11/29/15 9:24 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
1222015-11-29 09:24:06 jdbc: exception
12311-29 09:24:06 jdbc[3]:
124/*SQL */COMMIT;
12511-29 09:24:06 jdbc[3]:
126/*SQL */COMMIT;
12711-29 09:24:06 jdbc[3]:
128/*SQL */ROLLBACK;
129INFO 11/29/15 9:24 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
130INFO 11/29/15 9:24 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): Custom SQL executed
131INFO 11/29/15 9:24 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
13211-29 09:24:06 jdbc[3]:
133/*SQL */COMMIT;
134INFO 11/29/15 9:24 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 3ms
13511-29 09:24:06 jdbc[3]:
136/*SQL */COMMIT;
13711-29 09:24:06 jdbc[3]:
138/*SQL */COMMIT;
13911-29 09:24:06 jdbc[3]:
140/*SQL */ROLLBACK;
141INFO 11/29/15 9:24 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
14211-29 09:24:06 jdbc[3]:
143/*SQL */COMMIT;
144INFO 11/29/15 9:24 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
14511-29 09:24:06 jdbc[3]:
146/*SQL */COMMIT;
14711-29 09:24:06 jdbc[3]:
148/*SQL */COMMIT;
14911-29 09:24:06 jdbc[3]:
150/*SQL t:1*/ROLLBACK;
15111-29 09:24:06 jdbc[3]:
152/*SQL */COMMIT;
153INFO 11/29/15 9:24 AM: liquibase: Successfully released change log lock
15411-29 09:24:06 jdbc[3]:
155/*SQL */ROLLBACK;
156-- *********************************************************************
157-- Update Database Script
158-- *********************************************************************
159-- Change Log: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml
160-- Ran at: 11/29/15 9:24 AM
161-- Against: TEST@jdbc:h2:tcp://localhost:53033/mem:xploder
162-- Liquibase version: 3.4.2
163-- *********************************************************************
164
165-- Create Database Lock Table
166CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
167
168-- Initialize Database Lock Table
169DELETE FROM PUBLIC.DATABASECHANGELOGLOCK;
170
171INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
172
173-- Lock Database
174UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '192.168.99.1 (192.168.99.1)', LOCKGRANTED = '2015-11-29 09:24:05.458' WHERE ID = 1 AND LOCKED = FALSE;
175
176-- Create Database Change Log Table
177CREATE 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));
178
179-- Changeset src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin
180INSERT 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');
181
182-- Changeset src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov)
183CREATE TABLE PUBLIC.POINTS (ID BIGINT AUTO_INCREMENT NOT NULL, SHORELINE_ID BIGINT NOT NULL, SEGMENT_ID BIGINT NOT NULL, UNCY DOUBLE NOT NULL, CONSTRAINT pk_ID PRIMARY KEY (ID));
184
185ALTER TABLE POINTS ADD COLUMN GEOM GEOMETRY COMMENT 'POINT' BEFORE ID;
186
187CREATE UNIQUE INDEX PUBLIC.idx_ID ON PUBLIC.POINTS(id);
188
189INSERT 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:c4d56e127240e45e4e1bf0923fe58e9f', 'createTable, sql, createIndex', '', 'EXECUTED', 'update,integration-test', NULL, '3.4.2');
190
191-- Changeset src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin
192INSERT 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');
193
194-- Release Database Lock
195UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
196
19711-29 09:24:06 jdbc[3]:
198/*SQL */ROLLBACK;
199Running gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest
2002015-11-29 09:24:06 jdbc: exception
20111-29 09:24:06 jdbc[3]:
202/*SQL */CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
20311-29 09:24:06 jdbc[3]:
204/*SQL */COMMIT;
20511-29 09:24:06 jdbc[3]:
206/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
20711-29 09:24:06 jdbc[3]:
208/*SQL */DELETE FROM PUBLIC.DATABASECHANGELOGLOCK;
20911-29 09:24:06 jdbc[3]:
210/*SQL #:1*/INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
21111-29 09:24:06 jdbc[3]:
212/*SQL */COMMIT;
21311-29 09:24:06 jdbc[3]:
214/*SQL #:1*/SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1;
21511-29 09:24:06 jdbc[3]:
216/*SQL #:1*/UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '192.168.99.1 (192.168.99.1)', LOCKGRANTED = '2015-11-29 09:24:06.194' WHERE ID = 1 AND LOCKED = FALSE;
21711-29 09:24:06 jdbc[3]:
218/*SQL */COMMIT;
219INFO 11/29/15 9:24 AM: liquibase: Successfully acquired change log lock
22011-29 09:24:06 jdbc[3]:
221/*SQL */ROLLBACK;
22211-29 09:24:06 jdbc[3]:
223/*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'};
224INFO 11/29/15 9:24 AM: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
22511-29 09:24:06 jdbc[3]:
226/*SQL t:1*/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));
22711-29 09:24:06 jdbc[3]:
228/*SQL */COMMIT;
22911-29 09:24:06 jdbc[3]:
230/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOG;
231INFO 11/29/15 9:24 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
23211-29 09:24:06 jdbc[3]:
233/*SQL */SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
23411-29 09:24:06 jdbc[3]:
235/*SQL */COMMIT;
23611-29 09:24:06 jdbc[3]:
237/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
23811-29 09:24:06 jdbc[3]:
239/*SQL */ROLLBACK;
24011-29 09:24:06 jdbc[3]:
241/*SQL */ROLLBACK;
242INFO 11/29/15 9:24 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
24311-29 09:24:06 jdbc[3]:
244/*SQL */COMMIT;
245INFO 11/29/15 9:24 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
24611-29 09:24:06 jdbc[3]:
247/*SQL #:1 t:2*/SELECT MAX(ORDEREXECUTED) FROM PUBLIC.DATABASECHANGELOG;
24811-29 09:24:06 jdbc[3]:
249/*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-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');
25011-29 09:24:06 jdbc[3]:
251/*SQL */COMMIT;
25211-29 09:24:06 jdbc[3]:
253/*SQL */COMMIT;
25411-29 09:24:06 jdbc[3]:
255/*SQL */ROLLBACK;
25611-29 09:24:06 jdbc[3]:
257/*SQL t:3*/CREATE TABLE PUBLIC.POINTS (ID BIGINT AUTO_INCREMENT NOT NULL, SHORELINE_ID BIGINT NOT NULL, SEGMENT_ID BIGINT NOT NULL, UNCY DOUBLE NOT NULL, CONSTRAINT pk_ID PRIMARY KEY (ID));
258INFO 11/29/15 9:24 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
25911-29 09:24:06 jdbc[3]:
260/*SQL t:5*/ALTER TABLE POINTS ADD COLUMN GEOM GEOMETRY COMMENT 'POINT' BEFORE ID;
261INFO 11/29/15 9:24 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): Custom SQL executed
26211-29 09:24:06 jdbc[3]:
263/*SQL t:2*/CREATE UNIQUE INDEX PUBLIC.idx_ID ON PUBLIC.POINTS(id);
264INFO 11/29/15 9:24 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
26511-29 09:24:06 jdbc[3]:
266/*SQL */COMMIT;
267INFO 11/29/15 9:24 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 14ms
26811-29 09:24:06 jdbc[3]:
269/*SQL #: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:c4d56e127240e45e4e1bf0923fe58e9f', 'createTable, sql, createIndex', '', 'EXECUTED', 'update,integration-test', NULL, '3.4.2');
27011-29 09:24:06 jdbc[3]:
271/*SQL */COMMIT;
27211-29 09:24:06 jdbc[3]:
273/*SQL */COMMIT;
27411-29 09:24:06 jdbc[3]:
275/*SQL */ROLLBACK;
27611-29 09:24:06 jdbc[3]:
277/*SQL */COMMIT;
278INFO 11/29/15 9:24 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
279INFO 11/29/15 9:24 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 1ms
28011-29 09:24:06 jdbc[3]:
281/*SQL #: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');
28211-29 09:24:06 jdbc[3]:
283/*SQL */COMMIT;
28411-29 09:24:06 jdbc[3]:
285/*SQL */COMMIT;
28611-29 09:24:06 jdbc[3]:
287/*SQL */ROLLBACK;
28811-29 09:24:06 jdbc[3]:
289/*SQL #:1*/UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
29011-29 09:24:06 jdbc[3]:
291/*SQL */COMMIT;
292INFO 11/29/15 9:24 AM: liquibase: Successfully released change log lock
29311-29 09:24:06 jdbc[3]:
294/*SQL */ROLLBACK;
29509:24:06.306 [main] INFO g.u.c.d.u.H2DBOutputExploderIntegrationTest - testCreateXploder()
29609:24:07.088 [main] DEBUG gov.usgs.cida.dsas.uncy.Xploder - Reading source schema from /var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.shp
29709:24:07.266 [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)
29811-29 09:24:07 database: connecting session #4 to mem:xploder
29911-29 09:24:07 jdbc[4]:
300/*SQL */ROLLBACK;
30111-29 09:24:07 database: disconnecting session #4
30211-29 09:24:07 database: disconnected session #4
30311-29 09:24:07 database: connecting session #5 to mem:xploder
30411-29 09:24:07 jdbc[5]:
305/*SQL */CREATE DOMAIN POINT AS BLOB;
30611-29 09:24:07 jdbc[5]:
307/*SQL */CREATE DOMAIN LINESTRING AS BLOB;
30811-29 09:24:07 jdbc[5]:
309/*SQL */CREATE DOMAIN POLYGON AS BLOB;
31011-29 09:24:07 jdbc[5]:
311/*SQL */CREATE DOMAIN MULTIPOINT AS BLOB;
31211-29 09:24:07 jdbc[5]:
313/*SQL */CREATE DOMAIN MULTILINESTRING AS BLOB;
31411-29 09:24:07 jdbc[5]:
315/*SQL */CREATE DOMAIN MULTIPOLYGON AS BLOB;
31611-29 09:24:07 jdbc[5]:
317/*SQL */CREATE DOMAIN GEOMETRYCOLLECTION AS BLOB;
31811-29 09:24:07 jdbc[5]:
319/*SQL */CREATE TABLE IF NOT EXISTS _GEODB (checksum VARCHAR);
32011-29 09:24:07 jdbc[5]:
321/*SQL */DELETE FROM _GEODB;
32211-29 09:24:07 jdbc[5]:
323/*SQL #:1*/INSERT INTO _GEODB VALUES (9);
32411-29 09:24:07 jdbc[5]:
325/*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));
32611-29 09:24:07 jdbc[5]:
327/*SQL #:4*/SELECT TYPE TABLE_TYPE FROM INFORMATION_SCHEMA.TABLE_TYPES ORDER BY TABLE_TYPE;
32811-29 09:24:07 jdbc[5]:
329/*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'};
33011-29 09:24:07 jdbc[5]:
331/*SQL #:1*/SELECT checksum FROM _GEODB;
33211-29 09:24:07 jdbc[5]:
333/*SQL l:316 #:1 t:1*/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'};
33411-29 09:24:07 jdbc[5]:
335/*SQL l:959 #:1 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: '%', 4: '\\', 5: '%', 6: '\\', 7: 'POINTS', 8: '\\', 9: 'ID', 10: '\\'};
33611-29 09:24:07 jdbc[5]:
337/*SQL */SELECT \"ID\" FROM \"POINTS\" WHERE 0=1;
33811-29 09:24:07 jdbc[5]:
339/*SQL #:1*/CALL DATABASE();
34011-29 09:24:07 jdbc[5]:
341/*SQL #:1*/SELECT checksum FROM _GEODB;
34211-29 09:24:07 jdbc[5]:
343/*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: '\\'};
34411-29 09:24:07 jdbc[5]:
345/*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: '%', 2: '\\', 3: '%', 4: '\\', 5: 'POINTS_HATBOX', 6: '\\', 7: 'TABLE'};
3462015-11-29T09:24:07.386-0600 WARNING Error occured determing srid for POINTS.GEOM
347org.h2.jdbc.JdbcSQLException: Function "ST_SRID" not found; SQL statement:
348SELECT ST_SRID("GEOM") FROM "POINTS" WHERE "GEOM" is not null LIMIT 1 [90022-178]
349 at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
350 at org.h2.message.DbException.get(DbException.java:178)
351 at org.h2.message.DbException.get(DbException.java:154)
352 at org.h2.command.Parser.readJavaFunction(Parser.java:2326)
353 at org.h2.command.Parser.readFunction(Parser.java:2378)
354 at org.h2.command.Parser.readTerm(Parser.java:2712)
355 at org.h2.command.Parser.readFactor(Parser.java:2244)
356 at org.h2.command.Parser.readSum(Parser.java:2231)
357 at org.h2.command.Parser.readConcat(Parser.java:2201)
358 at org.h2.command.Parser.readCondition(Parser.java:2051)
359 at org.h2.command.Parser.readAnd(Parser.java:2023)
360 at org.h2.command.Parser.readExpression(Parser.java:2015)
361 at org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:1927)
362 at org.h2.command.Parser.parseSelectSimple(Parser.java:1959)
363 at org.h2.command.Parser.parseSelectSub(Parser.java:1853)
364 at org.h2.command.Parser.parseSelectUnion(Parser.java:1674)
365 at org.h2.command.Parser.parseSelect(Parser.java:1662)
366 at org.h2.command.Parser.parsePrepared(Parser.java:434)
367 at org.h2.command.Parser.parse(Parser.java:306)
368 at org.h2.command.Parser.parse(Parser.java:278)
369 at org.h2.command.Parser.prepareCommand(Parser.java:243)
370 at org.h2.engine.Session.prepareLocal(Session.java:442)
371 at org.h2.server.TcpServerThread.process(TcpServerThread.java:265)
372 at org.h2.server.TcpServerThread.run(TcpServerThread.java:160)
373 at java.lang.Thread.run(Thread.java:745)
374
375 at org.h2.engine.SessionRemote.done(SessionRemote.java:624)
376 at org.h2.command.CommandRemote.prepare(CommandRemote.java:68)
377 at org.h2.command.CommandRemote.<init>(CommandRemote.java:45)
378 at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:494)
379 at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
380 at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:73)
381 at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
382 at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
383 at org.geotools.data.h2.H2Dialect.getGeometrySRID(H2Dialect.java:368)
384 at org.geotools.data.h2.H2DialectBasic.getGeometrySRID(H2DialectBasic.java:131)
385 at org.geotools.jdbc.JDBCFeatureSource.buildFeatureType(JDBCFeatureSource.java:313)
386 at org.geotools.jdbc.JDBCDataStore.createFeatureSource(JDBCDataStore.java:912)
387 at org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:395)
388 at org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:376)
389 at org.geotools.data.store.ContentDataStore.ensureFeatureStore(ContentDataStore.java:457)
390 at org.geotools.data.store.ContentDataStore.getFeatureWriterAppend(ContentDataStore.java:489)
391 at gov.usgs.cida.dsas.uncy.H2DBOutputXploder.createFeatureWriter(H2DBOutputXploder.java:63)
392 at gov.usgs.cida.dsas.uncy.Xploder.explode(Xploder.java:270)
393 at gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest.testCreateXploder(H2DBOutputExploderIntegrationTest.java:127)
394 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
395 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
396 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
397 at java.lang.reflect.Method.invoke(Method.java:497)
398 at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
399 at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
400 at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
401 at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
402 at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
403 at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
404 at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
405 at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
406 at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
407 at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
408 at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
409 at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
410 at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
411 at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
412 at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
413 at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
414 at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
415 at org.junit.runners.Suite.runChild(Suite.java:128)
416 at org.junit.runners.Suite.runChild(Suite.java:27)
417 at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
418 at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
419 at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
420 at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
421 at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
422 at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
423 at org.apache.maven.surefire.junitcore.JUnitCore.run(JUnitCore.java:55)
424 at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.createRequestAndRun(JUnitCoreWrapper.java:130)
425 at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.executeEager(JUnitCoreWrapper.java:101)
426 at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.execute(JUnitCoreWrapper.java:77)
427 at org.apache.maven.surefire.junitcore.JUnitCoreProvider.invoke(JUnitCoreProvider.java:177)
428 at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:286)
429 at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:240)
430 at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:121)
431
43211-29 09:24:07 jdbc[5]:
433/*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: '%', 2: '\\', 3: '%', 4: '\\', 5: 'POINTS\\_HATBOX', 6: '\\', 7: 'TABLE'};
43411-29 09:24:07 jdbc[5]:
435/*SQL #:1*/SELECT checksum FROM _GEODB;
43611-29 09:24:07 jdbc[5]:
437/*SQL */SELECT \"ID\",\"GEOM\" as \"GEOM\",\"SHORELINE_ID\",\"SEGMENT_ID\",\"UNCY\" FROM \"POINTS\" WHERE 0 = 1;
43809:24:07.446 [main] DEBUG gov.usgs.cida.dsas.uncy.Xploder - Input files from /var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines
439PRJ file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.prj
440SHP_XML file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.shp.xml
441DBF file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.dbf
442SHX file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.shx
443FIX file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.fix
444QIX file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.qix
445SHP file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.shp
446
44709:24:07.446 [main] DEBUG gov.usgs.cida.dsas.uncy.Xploder - -1
44811-29 09:24:07 jdbc[5]:
449/*SQL #:1*/CALL READONLY();
45011-29 09:24:07 jdbc[5]:
451/*SQL */ROLLBACK;
45211-29 09:24:07 jdbc[5]:
453/*SQL */COMMIT;
45411-29 09:24:07 jdbc[3]:
455/*SQL */ROLLBACK;
45611-29 09:24:07 jdbc[3]:
457/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
45811-29 09:24:07 jdbc[3]:
459/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
46011-29 09:24:07 jdbc[3]:
461/*SQL */COMMIT;
46211-29 09:24:07 jdbc[3]:
463/*SQL */ROLLBACK;INFO 11/29/15 9:24 AM: liquibase: Successfully acquired change log lock
464
46511-29 09:24:07 jdbc[3]:
466/*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'};
46711-29 09:24:07 jdbc[3]:
468/*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: '\\'};
46911-29 09:24:07 jdbc[3]:
470/*SQL #:3*/SELECT MD5SUM FROM PUBLIC.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL;
47111-29 09:24:07 jdbc[3]:
472/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOG;
473INFO 11/29/15 9:24 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
47411-29 09:24:07 jdbc[3]:
475/*SQL #:3*/SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
47611-29 09:24:07 jdbc[3]:
477/*SQL */ROLLBACK;
478INFO 11/29/15 9:24 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
47911-29 09:24:07 jdbc[3]:
480/*SQL */COMMIT;
48111-29 09:24:07 jdbc[3]:
482/*SQL */COMMIT;
48311-29 09:24:07 jdbc[3]:
484/*SQL */COMMIT;
485INFO 11/29/15 9:24 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)
48611-29 09:24:07 jdbc[3]:
487/*SQL */COMMIT;
48811-29 09:24:07 jdbc[3]:
489/*SQL */COMMIT;
49011-29 09:24:07 jdbc[3]:
491/*SQL */COMMIT;
49211-29 09:24:07 jdbc[3]:
493/*SQL */ROLLBACK;
49411-29 09:24:07 jdbc[3]:
495/*SQL */COMMIT;
496INFO 11/29/15 9:24 AM: liquibase: Successfully released change log lock
49711-29 09:24:07 jdbc[3]:
498/*SQL */ROLLBACK;
499-- *********************************************************************
500-- Rollback to 'pre-points-table-created' Script
501-- *********************************************************************
502-- Change Log: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml
503-- Ran at: 11/29/15 9:24 AM
504-- Against: TEST@jdbc:h2:tcp://localhost:53033/mem:xploder
505-- Liquibase version: 3.4.2
506-- *********************************************************************
507
508-- Lock Database
509UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = '192.168.99.1 (192.168.99.1)', LOCKGRANTED = '2015-11-29 09:24:07.450' WHERE ID = 1 AND LOCKED = FALSE;
510
511-- Rolling Back ChangeSet: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin
512DELETE 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';
513
514-- Rolling Back ChangeSet: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov)
515DELETE FROM PUBLIC.POINTS;
516
517DELETE 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';
518
519-- Release Database Lock
520UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
521
52211-29 09:24:07 jdbc[3]:
523/*SQL */ROLLBACK;
52411-29 09:24:07 database: disconnecting session #3
52511-29 09:24:07 database: disconnected session #3
526Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 1.302 sec <<< FAILURE! - in gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest
527testCreateXploder(gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest) Time elapsed: 1.299 sec <<< ERROR!
528java.lang.RuntimeException: This program only supports input that has the geometry as attribute 0
529 at gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest.testCreateXploder(H2DBOutputExploderIntegrationTest.java:127)
530
53111-29 09:24:07 jdbc[5]:
532/*SQL */ROLLBACK;
53311-29 09:24:07 database: disconnecting session #5
53411-29 09:24:07 database: closing mem:xploder
53511-29 09:24:07 database: closed
53611-29 09:24:07 database: disconnected session #5
537
538Results :
539
540Tests in error:
541 H2DBOutputExploderIntegrationTest.testCreateXploder:127 » Runtime This program...
542
543Tests run: 1, Failures: 0, Errors: 1, Skipped: 0