--- inmemdb-maven-plugin:1.4.3:run (start-db) @ dsas-uncy-reader ---
Configured database name: xploder;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3
Configured database password: test
Configured database port: 53033
Configured database attributes: {}
Configured database username: test
Starting embedded H2 database
Embedded H2 database has started
Server has been started
Waiting for command from client

--- maven-failsafe-plugin:2.19:integration-test (default) @ dsas-uncy-reader ---

-------------------------------------------------------
 T E S T S
-------------------------------------------------------
11-29 09:24:04 jdbc[3]:
/*SQL */SET TRACE_LEVEL_FILE 2;
2015-11-29 09:24:04 jdbc:
/**/Connection conn0 = DriverManager.getConnection("jdbc:h2:tcp://localhost:53033/mem:xploder;create=false;TRACE_LEVEL_FILE=2;TRACE_LEVEL_SYSTEM_OUT=2", "TEST", "");
11-29 09:24:05 jdbc[3]:
/*SQL #:1 t:1*/CALL DATABASE();
11-29 09:24:05 jdbc[3]:
/*SQL */ROLLBACK;
2015-11-29 09:24:05 jdbc: exception
11-29 09:24:05 jdbc[3]:
/*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));
11-29 09:24:05 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:05 jdbc[3]:
/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
11-29 09:24:05 jdbc[3]:
/*SQL t:1*/DELETE FROM PUBLIC.DATABASECHANGELOGLOCK;
11-29 09:24:05 jdbc[3]:
/*SQL #:1 t:1*/INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
11-29 09:24:05 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:05 jdbc[3]:
/*SQL #:1 t:1*/SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1;
11-29 09:24:05 jdbc[3]:
/*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;
11-29 09:24:05 jdbc[3]:
/*SQL */COMMIT;
INFO 11/29/15 9:24 AM: liquibase: Successfully acquired change log lock
11-29 09:24:05 jdbc[3]:
/*SQL */ROLLBACK;
INFO 11/29/15 9:24 AM: liquibase: Dropping Database Objects in schema: XPLODER.PUBLIC
11-29 09:24:05 jdbc[3]:
/*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'};
INFO 11/29/15 9:24 AM: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
11-29 09:24:05 jdbc[3]:
/*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));
11-29 09:24:05 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:05 jdbc[3]:
/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
11-29 09:24:05 jdbc[3]:
/*SQL #:1*/SELECT CATALOG_NAME TABLE_CAT FROM INFORMATION_SCHEMA.CATALOGS;
11-29 09:24:05 jdbc[3]:
/*SQL #:2*/SELECT SCHEMA_NAME TABLE_SCHEM, CATALOG_NAME TABLE_CATALOG,  IS_DEFAULT FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
11-29 09:24:05 jdbc[3]:
/*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'};
11-29 09:24:05 jdbc[3]:
/*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'};
11-29 09:24:05 jdbc[3]:
/*SQL */SELECT SEQUENCE_NAME FROM INFORMATION_SCHEMA.SEQUENCES WHERE SEQUENCE_SCHEMA = 'PUBLIC' AND IS_GENERATED=FALSE;
11-29 09:24:05 jdbc[3]:
/*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'};
11-29 09:24:05 jdbc[3]:
/*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'};
11-29 09:24:05 jdbc[3]:
/*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: '\\'};
11-29 09:24:05 jdbc[3]:
/*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'};
11-29 09:24:05 jdbc[3]:
/*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'};
11-29 09:24:05 jdbc[3]:
/*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: '\\'};
11-29 09:24:05 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:05 jdbc[3]:
/*SQL #:1*/select count(*) from \"PUBLIC\".\"DATABASECHANGELOG\";
11-29 09:24:05 jdbc[3]:
/*SQL t:2*/DROP TABLE \"PUBLIC\".\"DATABASECHANGELOG\";
11-29 09:24:05 jdbc[3]:
/*SQL #:1*/select count(*) from \"PUBLIC\".\"DATABASECHANGELOGLOCK\";
11-29 09:24:05 jdbc[3]:
/*SQL */DROP TABLE \"PUBLIC\".\"DATABASECHANGELOGLOCK\";
11-29 09:24:05 jdbc[3]:
/*SQL */COMMIT;
2015-11-29 09:24:05 jdbc: exception
11-29 09:24:05 jdbc[3]:
/*SQL */ROLLBACK;
2015-11-29 09:24:05 jdbc: exception
11-29 09:24:05 jdbc[3]:
/*SQL */COMMIT;
2015-11-29 09:24:05 jdbc: exception
11-29 09:24:05 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:05 jdbc[3]:
/*SQL */COMMIT;
INFO 11/29/15 9:24 AM: liquibase: Successfully acquired change log lock
11-29 09:24:05 jdbc[3]:
/*SQL */ROLLBACK;
11-29 09:24:06 jdbc[3]:
/*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'};
INFO 11/29/15 9:24 AM: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
2015-11-29 09:24:06 jdbc: exception
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
2015-11-29 09:24:06 jdbc: exception
11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
INFO 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
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
INFO 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
2015-11-29 09:24:06 jdbc: exception
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
INFO 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
INFO 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
INFO 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
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
INFO 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
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
INFO 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
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
INFO 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
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL t:1*/ROLLBACK;
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
INFO 11/29/15 9:24 AM: liquibase: Successfully released change log lock
11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
-- *********************************************************************
-- Update Database Script
-- *********************************************************************
-- Change Log: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml
-- Ran at: 11/29/15 9:24 AM
-- Against: TEST@jdbc:h2:tcp://localhost:53033/mem:xploder
-- Liquibase version: 3.4.2
-- *********************************************************************

-- Create Database Lock Table
CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));

-- Initialize Database Lock Table
DELETE FROM PUBLIC.DATABASECHANGELOGLOCK;

INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);

-- Lock Database
UPDATE 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;

-- Create Database Change Log Table
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));

-- Changeset src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-before-creation::Ivan Suftin
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');

-- Changeset src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov)
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));

ALTER TABLE POINTS ADD COLUMN GEOM GEOMETRY COMMENT 'POINT' BEFORE ID;

CREATE UNIQUE INDEX PUBLIC.idx_ID ON PUBLIC.POINTS(id);

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');

-- Changeset src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin
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');

-- Release Database Lock
UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
Running gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest
2015-11-29 09:24:06 jdbc: exception
11-29 09:24:06 jdbc[3]:
/*SQL */CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
11-29 09:24:06 jdbc[3]:
/*SQL */DELETE FROM PUBLIC.DATABASECHANGELOGLOCK;
11-29 09:24:06 jdbc[3]:
/*SQL #:1*/INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL #:1*/SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1;
11-29 09:24:06 jdbc[3]:
/*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;
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
INFO 11/29/15 9:24 AM: liquibase: Successfully acquired change log lock
11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
11-29 09:24:06 jdbc[3]:
/*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'};
INFO 11/29/15 9:24 AM: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
11-29 09:24:06 jdbc[3]:
/*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));
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOG;
INFO 11/29/15 9:24 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
11-29 09:24:06 jdbc[3]:
/*SQL */SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
INFO 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
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
INFO 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
11-29 09:24:06 jdbc[3]:
/*SQL #:1 t:2*/SELECT MAX(ORDEREXECUTED) FROM PUBLIC.DATABASECHANGELOG;
11-29 09:24:06 jdbc[3]:
/*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');
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
11-29 09:24:06 jdbc[3]:
/*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));
INFO 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
11-29 09:24:06 jdbc[3]:
/*SQL t:5*/ALTER TABLE POINTS ADD COLUMN GEOM GEOMETRY COMMENT 'POINT' BEFORE ID;
INFO 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
11-29 09:24:06 jdbc[3]:
/*SQL t:2*/CREATE UNIQUE INDEX PUBLIC.idx_ID ON PUBLIC.POINTS(id);
INFO 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
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
INFO 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
11-29 09:24:06 jdbc[3]:
/*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');
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
INFO 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
INFO 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
11-29 09:24:06 jdbc[3]:
/*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');
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
11-29 09:24:06 jdbc[3]:
/*SQL #:1*/UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
11-29 09:24:06 jdbc[3]:
/*SQL */COMMIT;
INFO 11/29/15 9:24 AM: liquibase: Successfully released change log lock
11-29 09:24:06 jdbc[3]:
/*SQL */ROLLBACK;
09:24:06.306 [main] INFO  g.u.c.d.u.H2DBOutputExploderIntegrationTest - testCreateXploder()
09:24:07.088 [main] DEBUG gov.usgs.cida.dsas.uncy.Xploder - Reading source schema from /var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.shp
09: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)
11-29 09:24:07 database: connecting session #4 to mem:xploder
11-29 09:24:07 jdbc[4]:
/*SQL */ROLLBACK;
11-29 09:24:07 database: disconnecting session #4
11-29 09:24:07 database: disconnected session #4
11-29 09:24:07 database: connecting session #5 to mem:xploder
11-29 09:24:07 jdbc[5]:
/*SQL */CREATE DOMAIN POINT AS BLOB;
11-29 09:24:07 jdbc[5]:
/*SQL */CREATE DOMAIN LINESTRING AS BLOB;
11-29 09:24:07 jdbc[5]:
/*SQL */CREATE DOMAIN POLYGON AS BLOB;
11-29 09:24:07 jdbc[5]:
/*SQL */CREATE DOMAIN MULTIPOINT AS BLOB;
11-29 09:24:07 jdbc[5]:
/*SQL */CREATE DOMAIN MULTILINESTRING AS BLOB;
11-29 09:24:07 jdbc[5]:
/*SQL */CREATE DOMAIN MULTIPOLYGON AS BLOB;
11-29 09:24:07 jdbc[5]:
/*SQL */CREATE DOMAIN GEOMETRYCOLLECTION AS BLOB;
11-29 09:24:07 jdbc[5]:
/*SQL */CREATE TABLE IF NOT EXISTS _GEODB (checksum VARCHAR);
11-29 09:24:07 jdbc[5]:
/*SQL */DELETE FROM _GEODB;
11-29 09:24:07 jdbc[5]:
/*SQL #:1*/INSERT INTO _GEODB VALUES (9);
11-29 09:24:07 jdbc[5]:
/*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));
11-29 09:24:07 jdbc[5]:
/*SQL #:4*/SELECT TYPE TABLE_TYPE FROM INFORMATION_SCHEMA.TABLE_TYPES ORDER BY TABLE_TYPE;
11-29 09:24:07 jdbc[5]:
/*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'};
11-29 09:24:07 jdbc[5]:
/*SQL #:1*/SELECT checksum FROM _GEODB;
11-29 09:24:07 jdbc[5]:
/*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'};
11-29 09:24:07 jdbc[5]:
/*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: '\\'};
11-29 09:24:07 jdbc[5]:
/*SQL */SELECT \"ID\" FROM \"POINTS\" WHERE 0=1;
11-29 09:24:07 jdbc[5]:
/*SQL #:1*/CALL DATABASE();
11-29 09:24:07 jdbc[5]:
/*SQL #:1*/SELECT checksum FROM _GEODB;
11-29 09:24:07 jdbc[5]:
/*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: '\\'};
11-29 09:24:07 jdbc[5]:
/*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'};
2015-11-29T09:24:07.386-0600  WARNING  Error occured determing srid for POINTS.GEOM
org.h2.jdbc.JdbcSQLException: Function "ST_SRID" not found; SQL statement:
SELECT ST_SRID("GEOM") FROM "POINTS" WHERE "GEOM" is not null LIMIT 1 [90022-178]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
	at org.h2.message.DbException.get(DbException.java:178)
	at org.h2.message.DbException.get(DbException.java:154)
	at org.h2.command.Parser.readJavaFunction(Parser.java:2326)
	at org.h2.command.Parser.readFunction(Parser.java:2378)
	at org.h2.command.Parser.readTerm(Parser.java:2712)
	at org.h2.command.Parser.readFactor(Parser.java:2244)
	at org.h2.command.Parser.readSum(Parser.java:2231)
	at org.h2.command.Parser.readConcat(Parser.java:2201)
	at org.h2.command.Parser.readCondition(Parser.java:2051)
	at org.h2.command.Parser.readAnd(Parser.java:2023)
	at org.h2.command.Parser.readExpression(Parser.java:2015)
	at org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:1927)
	at org.h2.command.Parser.parseSelectSimple(Parser.java:1959)
	at org.h2.command.Parser.parseSelectSub(Parser.java:1853)
	at org.h2.command.Parser.parseSelectUnion(Parser.java:1674)
	at org.h2.command.Parser.parseSelect(Parser.java:1662)
	at org.h2.command.Parser.parsePrepared(Parser.java:434)
	at org.h2.command.Parser.parse(Parser.java:306)
	at org.h2.command.Parser.parse(Parser.java:278)
	at org.h2.command.Parser.prepareCommand(Parser.java:243)
	at org.h2.engine.Session.prepareLocal(Session.java:442)
	at org.h2.server.TcpServerThread.process(TcpServerThread.java:265)
	at org.h2.server.TcpServerThread.run(TcpServerThread.java:160)
	at java.lang.Thread.run(Thread.java:745)

	at org.h2.engine.SessionRemote.done(SessionRemote.java:624)
	at org.h2.command.CommandRemote.prepare(CommandRemote.java:68)
	at org.h2.command.CommandRemote.<init>(CommandRemote.java:45)
	at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:494)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:73)
	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
	at org.geotools.data.h2.H2Dialect.getGeometrySRID(H2Dialect.java:368)
	at org.geotools.data.h2.H2DialectBasic.getGeometrySRID(H2DialectBasic.java:131)
	at org.geotools.jdbc.JDBCFeatureSource.buildFeatureType(JDBCFeatureSource.java:313)
	at org.geotools.jdbc.JDBCDataStore.createFeatureSource(JDBCDataStore.java:912)
	at org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:395)
	at org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:376)
	at org.geotools.data.store.ContentDataStore.ensureFeatureStore(ContentDataStore.java:457)
	at org.geotools.data.store.ContentDataStore.getFeatureWriterAppend(ContentDataStore.java:489)
	at gov.usgs.cida.dsas.uncy.H2DBOutputXploder.createFeatureWriter(H2DBOutputXploder.java:63)
	at gov.usgs.cida.dsas.uncy.Xploder.explode(Xploder.java:270)
	at gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest.testCreateXploder(H2DBOutputExploderIntegrationTest.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runners.Suite.runChild(Suite.java:128)
	at org.junit.runners.Suite.runChild(Suite.java:27)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.apache.maven.surefire.junitcore.JUnitCore.run(JUnitCore.java:55)
	at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.createRequestAndRun(JUnitCoreWrapper.java:130)
	at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.executeEager(JUnitCoreWrapper.java:101)
	at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.execute(JUnitCoreWrapper.java:77)
	at org.apache.maven.surefire.junitcore.JUnitCoreProvider.invoke(JUnitCoreProvider.java:177)
	at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:286)
	at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:240)
	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:121)

11-29 09:24:07 jdbc[5]:
/*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'};
11-29 09:24:07 jdbc[5]:
/*SQL #:1*/SELECT checksum FROM _GEODB;
11-29 09:24:07 jdbc[5]:
/*SQL */SELECT \"ID\",\"GEOM\" as \"GEOM\",\"SHORELINE_ID\",\"SEGMENT_ID\",\"UNCY\" FROM \"POINTS\" WHERE  0 = 1;
09:24:07.446 [main] DEBUG gov.usgs.cida.dsas.uncy.Xploder - Input files from /var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines
PRJ	file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.prj
SHP_XML	file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.shp.xml
DBF	file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.dbf
SHX	file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.shx
FIX	file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.fix
QIX	file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.qix
SHP	file:/var/folders/qw/v35cljyx1d9gxsyrxrt3m08m0000gn/T/1448810646183/test_shorelines.shp

09:24:07.446 [main] DEBUG gov.usgs.cida.dsas.uncy.Xploder - -1
11-29 09:24:07 jdbc[5]:
/*SQL #:1*/CALL READONLY();
11-29 09:24:07 jdbc[5]:
/*SQL */ROLLBACK;
11-29 09:24:07 jdbc[5]:
/*SQL */COMMIT;
11-29 09:24:07 jdbc[3]:
/*SQL */ROLLBACK;
11-29 09:24:07 jdbc[3]:
/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
11-29 09:24:07 jdbc[3]:
/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOGLOCK;
11-29 09:24:07 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:07 jdbc[3]:
/*SQL */ROLLBACK;INFO 11/29/15 9:24 AM: liquibase: Successfully acquired change log lock

11-29 09:24:07 jdbc[3]:
/*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'};
11-29 09:24:07 jdbc[3]:
/*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: '\\'};
11-29 09:24:07 jdbc[3]:
/*SQL #:3*/SELECT MD5SUM FROM PUBLIC.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL;
11-29 09:24:07 jdbc[3]:
/*SQL #:1*/select count(*) from PUBLIC.DATABASECHANGELOG;
INFO 11/29/15 9:24 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
11-29 09:24:07 jdbc[3]:
/*SQL #:3*/SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC;
11-29 09:24:07 jdbc[3]:
/*SQL */ROLLBACK;
INFO 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
11-29 09:24:07 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:07 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:07 jdbc[3]:
/*SQL */COMMIT;
INFO 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)
11-29 09:24:07 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:07 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:07 jdbc[3]:
/*SQL */COMMIT;
11-29 09:24:07 jdbc[3]:
/*SQL */ROLLBACK;
11-29 09:24:07 jdbc[3]:
/*SQL */COMMIT;
INFO 11/29/15 9:24 AM: liquibase: Successfully released change log lock
11-29 09:24:07 jdbc[3]:
/*SQL */ROLLBACK;
-- *********************************************************************
-- Rollback to 'pre-points-table-created' Script
-- *********************************************************************
-- Change Log: src/test/resources/liquibase/changelogs/create-table-parent-changeLog.xml
-- Ran at: 11/29/15 9:24 AM
-- Against: TEST@jdbc:h2:tcp://localhost:53033/mem:xploder
-- Liquibase version: 3.4.2
-- *********************************************************************

-- Lock Database
UPDATE 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;

-- Rolling Back ChangeSet: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::tag-integration-test-database-after-creation::Ivan Suftin
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';

-- Rolling Back ChangeSet: src/test/resources/liquibase/changelogs/create-shoreline-points-table.xml::create-shoreline-points-table::Ivan Suftin (isuftin@usgs.gov)
DELETE FROM PUBLIC.POINTS;

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';

-- Release Database Lock
UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

11-29 09:24:07 jdbc[3]:
/*SQL */ROLLBACK;
11-29 09:24:07 database: disconnecting session #3
11-29 09:24:07 database: disconnected session #3
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 1.302 sec <<< FAILURE! - in gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest
testCreateXploder(gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest)  Time elapsed: 1.299 sec  <<< ERROR!
java.lang.RuntimeException: This program only supports input that has the geometry as attribute 0
	at gov.usgs.cida.dsas.uncy.H2DBOutputExploderIntegrationTest.testCreateXploder(H2DBOutputExploderIntegrationTest.java:127)

11-29 09:24:07 jdbc[5]:
/*SQL */ROLLBACK;
11-29 09:24:07 database: disconnecting session #5
11-29 09:24:07 database: closing mem:xploder
11-29 09:24:07 database: closed
11-29 09:24:07 database: disconnected session #5

Results :

Tests in error:
  H2DBOutputExploderIntegrationTest.testCreateXploder:127 » Runtime This program...

Tests run: 1, Failures: 0, Errors: 1, Skipped: 0