Menu ▾ ▴

#1642 java.sql.SQLSyntaxErrorException: user lacks privilege or object not found

version 2.5.x
open-works-for-me
Fred Toussi
SQLSyntaxErrorException (1)
5
2022-01-29
2021-12-16
Walter Weinmann
No

HSQLDB Version 2.61

Dropping a unique key gives an error of type SQLSyntaxErrorException - this error occurs only with the embedded version - no problem with the client version.

2021-12-16 13:22:06,564 [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10115'
2021-12-16 13:22:06,564 [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10117'
2021-12-16 13:22:06,564 [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10133'
2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10145'
2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10093'
2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10102'
2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10113'
2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10132'
2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10143'
2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_26_10100'
2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_28_10111'
2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_27_10130'
2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_25_10157'
2021-12-16 13:22:06,566 [AbstractJdbcSeeder.java] DEBUG Start
2021-12-16 13:22:06,566 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_FK_10115
2021-12-16 13:22:06,567 [AbstractJdbcSeeder.java] DEBUG End
2021-12-16 13:22:06,567 [AbstractJdbcSeeder.java] DEBUG Start
2021-12-16 13:22:06,567 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_FK_10117
2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG End
2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG Start
2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP CONSTRAINT SYS_FK_10133
2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG End
2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG Start
2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP CONSTRAINT SYS_FK_10145
2021-12-16 13:22:06,570 [AbstractJdbcSeeder.java] DEBUG End
2021-12-16 13:22:06,570 [AbstractJdbcSeeder.java] DEBUG Start
2021-12-16 13:22:06,570 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY DROP CONSTRAINT SYS_PK_10093
2021-12-16 13:22:06,570 [AbstractJdbcSeeder.java] DEBUG End
2021-12-16 13:22:06,571 [AbstractJdbcSeeder.java] DEBUG Start
2021-12-16 13:22:06,571 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE TIMEZONE DROP CONSTRAINT SYS_PK_10102
2021-12-16 13:22:06,571 [AbstractJdbcSeeder.java] DEBUG End
2021-12-16 13:22:06,571 [AbstractJdbcSeeder.java] DEBUG Start
2021-12-16 13:22:06,572 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_PK_10113
2021-12-16 13:22:06,572 [AbstractJdbcSeeder.java] DEBUG End
2021-12-16 13:22:06,572 [AbstractJdbcSeeder.java] DEBUG Start
2021-12-16 13:22:06,572 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP CONSTRAINT SYS_PK_10132
2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG End
2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG Start
2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP CONSTRAINT SYS_PK_10143
2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG End
2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG Start
2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY DROP CONSTRAINT SYS_IDX_KXN_26_10100
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: SYS_IDX_KXN_26_10100
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
        at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
        at ch.konnexions.db_seeder.jdbc.AbstractJdbcSeeder.executeSQLStmnts(AbstractJdbcSeeder.java:1362)
        at ch.konnexions.db_seeder.jdbc.AbstractJdbcSeeder.dropTableConstraints(AbstractJdbcSeeder.java:1231)
        at ch.konnexions.db_seeder.jdbc.AbstractJdbcSeeder.createData(AbstractJdbcSeeder.java:427)
        at ch.konnexions.db_seeder.DatabaseSeeder.main(DatabaseSeeder.java:160)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: SYS_IDX_KXN_26_10100
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.SchemaManager.getSchemaObject(Unknown Source)
        at org.hsqldb.ParserDQL.readSchemaObjectName(Unknown Source)
        at org.hsqldb.ParserDDL.compileAlterTableDropConstraint(Unknown Source)
        at org.hsqldb.ParserDDL.compileAlterTable(Unknown Source)
        at org.hsqldb.ParserDDL.compileAlter(Unknown Source)
        at org.hsqldb.ParserCommand.compilePart(Unknown Source)
        at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
        at org.hsqldb.Session.executeDirectStatement(Unknown Source)
        at org.hsqldb.Session.execute(Unknown Source)
        ... 6 more

Related

Bugs: #1642

Discussion

  • Fred Toussi

    Fred Toussi - 2021-12-16

    Those names, such as SYS_IDX_KXN_26_10100 are names of backing indexes for unique constraints. You need to use the name of the constraint to drop it.

     

    • Walter Weinmann

      Walter Weinmann - 2021-12-16

      We use the database metadata interface to determine the constraints.

      This works fine with the client version of HSQLDB - here is the debug log
      for it:

      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,COUNTRY)
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,TIMEZONE)
      [AbstractJdbcSeeder.java] DEBUG
      getImportedKeys(null,KXN_SCHEMA,COUNTRY_STATE)
      [AbstractJdbcSeeder.java] DEBUG
      getImportedKeys(null,KXN_SCHEMA,COUNTRY_STATE)
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME =COUNTRY
      [AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME =PK_COUNTRY_ID
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME =FK_COUNTRY_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG UPDATE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG DELETE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG FK_NAME =SYS_FK_10504
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10486
      [AbstractJdbcSeeder.java] DEBUG DEFERRABILITY =7
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getImportedKeys(null,KXN_SCHEMA,COUNTRY_STATE)
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME =TIMEZONE
      [AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME =PK_TIMEZONE_ID
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME =FK_TIMEZONE_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG UPDATE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG DELETE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG FK_NAME =SYS_FK_10506
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10493
      [AbstractJdbcSeeder.java] DEBUG DEFERRABILITY =7
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,CITY)
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,CITY)
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME =PK_COUNTRY_STATE_ID
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME =CITY
      [AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME =FK_COUNTRY_STATE_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG UPDATE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG DELETE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG FK_NAME =SYS_FK_10518
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10502
      [AbstractJdbcSeeder.java] DEBUG DEFERRABILITY =7
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,COMPANY)
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,COMPANY)
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME =CITY
      [AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME =PK_CITY_ID
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME =COMPANY
      [AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME =FK_CITY_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG UPDATE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG DELETE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG FK_NAME =SYS_FK_10528
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10517
      [AbstractJdbcSeeder.java] DEBUG DEFERRABILITY =7
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,COUNTRY)
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,COUNTRY)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_COUNTRY_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10486
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,TIMEZONE)
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,TIMEZONE)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =TIMEZONE
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_TIMEZONE_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10493
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getPrimaryKeys(null,KXN_SCHEMA,COUNTRY_STATE)
      [AbstractJdbcSeeder.java] DEBUG
      getPrimaryKeys(null,KXN_SCHEMA,COUNTRY_STATE)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_COUNTRY_STATE_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10502
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,CITY)
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,CITY)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =CITY
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_CITY_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10517
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,COMPANY)
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,COMPANY)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COMPANY
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_COMPANY_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10526
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COUNTRY,false,true)
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COUNTRY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_PK_10486
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_COUNTRY_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COUNTRY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =KXN_26
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =NAME
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,TIMEZONE,false,true)
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,TIMEZONE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =TIMEZONE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_PK_10493
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_TIMEZONE_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,TIMEZONE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =TIMEZONE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =KXN_28
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =NAME
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COUNTRY_STATE,false,true)
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COUNTRY_STATE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_PK_10502
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_COUNTRY_STATE_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COUNTRY_STATE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =KXN_27
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =FK_COUNTRY_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COUNTRY_STATE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =KXN_27
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=2
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =NAME
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COUNTRY_STATE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =true
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_FK_10504
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =FK_COUNTRY_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COUNTRY_STATE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =true
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_FK_10506
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =FK_TIMEZONE_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,CITY,false,true)
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,CITY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =CITY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_PK_10517
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_CITY_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,CITY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =CITY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =true
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_FK_10518
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =FK_COUNTRY_STATE_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COMPANY,false,true)
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COMPANY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COMPANY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_PK_10526
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_COMPANY_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COMPANY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COMPANY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =KXN_25
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =NAME
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,KXN_SCHEMA,COMPANY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =KXN_SCHEMA
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COMPANY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =true
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_FK_10528
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =FK_CITY_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10504'
      [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10506'
      [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10518'
      [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10528'
      [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10486'
      [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10493'
      [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10502'
      [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10517'
      [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10526'
      [AbstractJdbcSeeder.java] DEBUG constraint type=U name='KXN_26'
      [AbstractJdbcSeeder.java] DEBUG constraint type=U name='KXN_28'
      [AbstractJdbcSeeder.java] DEBUG constraint type=U name='KXN_27'
      [AbstractJdbcSeeder.java] DEBUG constraint type=U name='KXN_25'
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE
      COUNTRY_STATE DROP CONSTRAINT SYS_FK_10504
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE
      COUNTRY_STATE DROP CONSTRAINT SYS_FK_10506
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP
      CONSTRAINT SYS_FK_10518
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP
      CONSTRAINT SYS_FK_10528
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY DROP
      CONSTRAINT SYS_PK_10486
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE TIMEZONE
      DROP CONSTRAINT SYS_PK_10493
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE
      COUNTRY_STATE DROP CONSTRAINT SYS_PK_10502
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP
      CONSTRAINT SYS_PK_10517
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP
      CONSTRAINT SYS_PK_10526
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY
      DROP CONSTRAINT KXN_26
      [AbstractJdbcSeeder.java] DEBUG End

      But unfortunately there are problems with the embedded version of HSQLDB -
      same debug protocol:

      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,COUNTRY)
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,TIMEZONE)
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,COUNTRY_STATE)
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,COUNTRY_STATE)
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME =COUNTRY
      [AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME =PK_COUNTRY_ID
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME =FK_COUNTRY_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG UPDATE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG DELETE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG FK_NAME =SYS_FK_10115
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10093
      [AbstractJdbcSeeder.java] DEBUG DEFERRABILITY =7
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,COUNTRY_STATE)
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME =TIMEZONE
      [AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME =PK_TIMEZONE_ID
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME =FK_TIMEZONE_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG UPDATE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG DELETE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG FK_NAME =SYS_FK_10117
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10102
      [AbstractJdbcSeeder.java] DEBUG DEFERRABILITY =7
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,CITY)
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,CITY)
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME =PK_COUNTRY_STATE_ID
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME =CITY
      [AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME =FK_COUNTRY_STATE_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG UPDATE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG DELETE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG FK_NAME =SYS_FK_10133
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10113
      [AbstractJdbcSeeder.java] DEBUG DEFERRABILITY =7
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,COMPANY)
      [AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,COMPANY)
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME =CITY
      [AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME =PK_CITY_ID
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME =COMPANY
      [AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME =FK_CITY_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG UPDATE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG DELETE_RULE =3
      [AbstractJdbcSeeder.java] DEBUG FK_NAME =SYS_FK_10145
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10132
      [AbstractJdbcSeeder.java] DEBUG DEFERRABILITY =7
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,COUNTRY)
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,COUNTRY)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_COUNTRY_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10093
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,TIMEZONE)
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,TIMEZONE)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =TIMEZONE
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_TIMEZONE_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10102
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,COUNTRY_STATE)
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,COUNTRY_STATE)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_COUNTRY_STATE_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10113
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,CITY)
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,CITY)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =CITY
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_CITY_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10132
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,COMPANY)
      [AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,COMPANY)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COMPANY
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_COMPANY_ID
      [AbstractJdbcSeeder.java] DEBUG KEY_SEQ =1
      [AbstractJdbcSeeder.java] DEBUG PK_NAME =SYS_PK_10143
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COUNTRY,false,true)
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COUNTRY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_SYS_PK_10093_10096
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_COUNTRY_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COUNTRY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_KXN_26_10100
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =NAME
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,TIMEZONE,false,true)
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,TIMEZONE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =TIMEZONE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_SYS_PK_10102_10106
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_TIMEZONE_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,TIMEZONE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =TIMEZONE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_KXN_28_10111
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =NAME
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,null,COUNTRY_STATE,false,true)
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,null,COUNTRY_STATE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_SYS_PK_10113_10120
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_COUNTRY_STATE_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,null,COUNTRY_STATE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_KXN_27_10130
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =FK_COUNTRY_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,null,COUNTRY_STATE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_KXN_27_10130
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=2
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =NAME
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,null,COUNTRY_STATE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =true
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_SYS_FK_10115_10123
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =FK_COUNTRY_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG
      getIndexInfo(null,null,COUNTRY_STATE,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COUNTRY_STATE
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =true
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_SYS_FK_10117_10126
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =FK_TIMEZONE_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,CITY,false,true)
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,CITY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =CITY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_SYS_PK_10132_10136
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_CITY_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,CITY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =CITY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =true
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_SYS_FK_10133_10138
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =FK_COUNTRY_STATE_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COMPANY,false,true)
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COMPANY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COMPANY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_SYS_PK_10143_10149
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =PK_COMPANY_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COMPANY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COMPANY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =false
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_KXN_25_10157
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =NAME
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COMPANY,false,true)
      [AbstractJdbcSeeder.java] DEBUG TABLE_CAT =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG TABLE_NAME =COMPANY
      [AbstractJdbcSeeder.java] DEBUG NON_UNIQUE =true
      [AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
      [AbstractJdbcSeeder.java] DEBUG INDEX_NAME =SYS_IDX_SYS_FK_10145_10152
      [AbstractJdbcSeeder.java] DEBUG TYPE =3
      [AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
      [AbstractJdbcSeeder.java] DEBUG COLUMN_NAME =FK_CITY_ID
      [AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC =A
      [AbstractJdbcSeeder.java] DEBUG CARDINALITY =0
      [AbstractJdbcSeeder.java] DEBUG PAGES =0
      [AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
      [AbstractJdbcSeeder.java] DEBUG
      [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10115'
      [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10117'
      [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10133'
      [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10145'
      [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10093'
      [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10102'
      [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10113'
      [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10132'
      [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10143'
      [AbstractJdbcSeeder.java] DEBUG constraint type=U
      name='SYS_IDX_KXN_26_10100'
      [AbstractJdbcSeeder.java] DEBUG constraint type=U
      name='SYS_IDX_KXN_28_10111'
      [AbstractJdbcSeeder.java] DEBUG constraint type=U
      name='SYS_IDX_KXN_27_10130'
      [AbstractJdbcSeeder.java] DEBUG constraint type=U
      name='SYS_IDX_KXN_25_10157'
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE
      COUNTRY_STATE DROP CONSTRAINT SYS_FK_10115
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE
      COUNTRY_STATE DROP CONSTRAINT SYS_FK_10117
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP
      CONSTRAINT SYS_FK_10133
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP
      CONSTRAINT SYS_FK_10145
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY DROP
      CONSTRAINT SYS_PK_10093
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE TIMEZONE
      DROP CONSTRAINT SYS_PK_10102
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE
      COUNTRY_STATE DROP CONSTRAINT SYS_PK_10113
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP
      CONSTRAINT SYS_PK_10132
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP
      CONSTRAINT SYS_PK_10143
      [AbstractJdbcSeeder.java] DEBUG End
      [AbstractJdbcSeeder.java] DEBUG Start
      [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY
      DROP CONSTRAINT SYS_IDX_KXN_26_10100

      Problems only occur with constraints of type unique key - is there a way to
      determine the correct constraint name?

      On Thu, 16 Dec 2021 at 13:40, Fred Toussi fredt@users.sourceforge.net
      wrote:

      Those names, such as SYS_IDX_KXN_26_10100 are names of backing indexes for
      unique constraints. You need to use the name of the constraint to drop it.

      Status: open
      Group: version 2.5.x
      Labels: SQLSyntaxErrorException
      Created: Thu Dec 16, 2021 12:26 PM UTC by Walter Weinmann
      Last Updated: Thu Dec 16, 2021 12:26 PM UTC
      Owner: nobody

      HSQLDB Version 2.61

      Dropping a unique key gives an error of type SQLSyntaxErrorException -
      this error occurs only with the embedded version - no problem with the
      client version.

      2021-12-16 13:22:06,564 [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10115'2021-12-16 13:22:06,564 [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10117'2021-12-16 13:22:06,564 [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10133'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10145'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10093'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10102'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10113'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10132'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10143'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_26_10100'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_28_10111'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_27_10130'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_25_10157'2021-12-16 13:22:06,566 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,566 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_FK_101152021-12-16 13:22:06,567 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,567 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,567 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_FK_101172021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP CONSTRAINT SYS_FK_101332021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP CONSTRAINT SYS_FK_101452021-12-16 13:22:06,570 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,570 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,570 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY DROP CONSTRAINT SYS_PK_100932021-12-16 13:22:06,570 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,571 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,571 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE TIMEZONE DROP CONSTRAINT SYS_PK_101022021-12-16 13:22:06,571 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,571 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,572 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_PK_101132021-12-16 13:22:06,572 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,572 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,572 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP CONSTRAINT SYS_PK_101322021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP CONSTRAINT SYS_PK_101432021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY DROP CONSTRAINT SYS_IDX_KXN_26_10100java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: SYS_IDX_KXN_26_10100
      at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
      at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
      at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
      at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
      at ch.konnexions.db_seeder.jdbc.AbstractJdbcSeeder.executeSQLStmnts(AbstractJdbcSeeder.java:1362)
      at ch.konnexions.db_seeder.jdbc.AbstractJdbcSeeder.dropTableConstraints(AbstractJdbcSeeder.java:1231)
      at ch.konnexions.db_seeder.jdbc.AbstractJdbcSeeder.createData(AbstractJdbcSeeder.java:427)
      at ch.konnexions.db_seeder.DatabaseSeeder.main(DatabaseSeeder.java:160)Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: SYS_IDX_KXN_26_10100
      at org.hsqldb.error.Error.error(Unknown Source)
      at org.hsqldb.error.Error.error(Unknown Source)
      at org.hsqldb.SchemaManager.getSchemaObject(Unknown Source)
      at org.hsqldb.ParserDQL.readSchemaObjectName(Unknown Source)
      at org.hsqldb.ParserDDL.compileAlterTableDropConstraint(Unknown Source)
      at org.hsqldb.ParserDDL.compileAlterTable(Unknown Source)
      at org.hsqldb.ParserDDL.compileAlter(Unknown Source)
      at org.hsqldb.ParserCommand.compilePart(Unknown Source)
      at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
      at org.hsqldb.Session.executeDirectStatement(Unknown Source)
      at org.hsqldb.Session.execute(Unknown Source)
      ... 6 more

      Sent from sourceforge.net because you indicated interest in
      https://sourceforge.net/p/hsqldb/bugs/1642/

      To unsubscribe from further messages, please visit
      https://sourceforge.net/auth/subscriptions/

       

      Related

      Bugs: #1642

      alternate

  • Walter Weinmann

    Walter Weinmann - 2021-12-16

    We use the database metadata interface to determine the constraints.

    This works fine with the client version of HSQLDB - here is the debug log for it:

    [AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,COUNTRY)
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,TIMEZONE)
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,COUNTRY_STATE)
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,COUNTRY_STATE)
[AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM   =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME    =COUNTRY
[AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME   =PK_COUNTRY_ID
[AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM   =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME    =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME   =FK_COUNTRY_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG UPDATE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG DELETE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG FK_NAME         =SYS_FK_10504
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10486
[AbstractJdbcSeeder.java] DEBUG DEFERRABILITY   =7
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,COUNTRY_STATE)
[AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM   =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME    =TIMEZONE
[AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME   =PK_TIMEZONE_ID
[AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM   =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME    =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME   =FK_TIMEZONE_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG UPDATE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG DELETE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG FK_NAME         =SYS_FK_10506
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10493
[AbstractJdbcSeeder.java] DEBUG DEFERRABILITY   =7
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,CITY)
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,CITY)
[AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM   =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME    =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME   =PK_COUNTRY_STATE_ID
[AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM   =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME    =CITY
[AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME   =FK_COUNTRY_STATE_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG UPDATE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG DELETE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG FK_NAME         =SYS_FK_10518
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10502
[AbstractJdbcSeeder.java] DEBUG DEFERRABILITY   =7
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,COMPANY)
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,KXN_SCHEMA,COMPANY)
[AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM   =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME    =CITY
[AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME   =PK_CITY_ID
[AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM   =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME    =COMPANY
[AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME   =FK_CITY_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG UPDATE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG DELETE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG FK_NAME         =SYS_FK_10528
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10517
[AbstractJdbcSeeder.java] DEBUG DEFERRABILITY   =7
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,COUNTRY)
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,COUNTRY)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_COUNTRY_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10486
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,TIMEZONE)
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,TIMEZONE)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =TIMEZONE
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_TIMEZONE_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10493
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,COUNTRY_STATE)
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,COUNTRY_STATE)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_COUNTRY_STATE_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10502
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,CITY)
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,CITY)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =CITY
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_CITY_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10517
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,COMPANY)
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,KXN_SCHEMA,COMPANY)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COMPANY
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_COMPANY_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10526
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COUNTRY,false,true)
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COUNTRY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_PK_10486
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_COUNTRY_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COUNTRY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =KXN_26
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =NAME
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,TIMEZONE,false,true)
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,TIMEZONE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =TIMEZONE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_PK_10493
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_TIMEZONE_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,TIMEZONE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =TIMEZONE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =KXN_28
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =NAME
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COUNTRY_STATE,false,true)
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COUNTRY_STATE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_PK_10502
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_COUNTRY_STATE_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COUNTRY_STATE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =KXN_27
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =FK_COUNTRY_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COUNTRY_STATE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =KXN_27
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=2
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =NAME
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COUNTRY_STATE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =true
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_FK_10504
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =FK_COUNTRY_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COUNTRY_STATE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =true
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_FK_10506
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =FK_TIMEZONE_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,CITY,false,true)
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,CITY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =CITY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_PK_10517
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_CITY_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,CITY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =CITY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =true
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_FK_10518
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =FK_COUNTRY_STATE_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COMPANY,false,true)
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COMPANY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COMPANY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_PK_10526
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_COMPANY_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COMPANY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COMPANY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =KXN_25
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =NAME
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,KXN_SCHEMA,COMPANY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =KXN_SCHEMA
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COMPANY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =true
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_FK_10528
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =FK_CITY_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10504'
[AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10506'
[AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10518'
[AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10528'
[AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10486'
[AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10493'
[AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10502'
[AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10517'
[AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10526'
[AbstractJdbcSeeder.java] DEBUG constraint type=U name='KXN_26'
[AbstractJdbcSeeder.java] DEBUG constraint type=U name='KXN_28'
[AbstractJdbcSeeder.java] DEBUG constraint type=U name='KXN_27'
[AbstractJdbcSeeder.java] DEBUG constraint type=U name='KXN_25'
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_FK_10504
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_FK_10506
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP CONSTRAINT SYS_FK_10518
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP CONSTRAINT SYS_FK_10528
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY DROP CONSTRAINT SYS_PK_10486
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE TIMEZONE DROP CONSTRAINT SYS_PK_10493
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_PK_10502
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP CONSTRAINT SYS_PK_10517
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP CONSTRAINT SYS_PK_10526
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY DROP CONSTRAINT KXN_26
[AbstractJdbcSeeder.java] DEBUG End

    But unfortunately there are problems with the embedded version of HSQLDB - same debug protocol:

    [AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,COUNTRY)
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,TIMEZONE)
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,COUNTRY_STATE)
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,COUNTRY_STATE)
[AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM   =PUBLIC
[AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME    =COUNTRY
[AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME   =PK_COUNTRY_ID
[AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM   =PUBLIC
[AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME    =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME   =FK_COUNTRY_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG UPDATE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG DELETE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG FK_NAME         =SYS_FK_10115
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10093
[AbstractJdbcSeeder.java] DEBUG DEFERRABILITY   =7
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,COUNTRY_STATE)
[AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM   =PUBLIC
[AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME    =TIMEZONE
[AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME   =PK_TIMEZONE_ID
[AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM   =PUBLIC
[AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME    =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME   =FK_TIMEZONE_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG UPDATE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG DELETE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG FK_NAME         =SYS_FK_10117
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10102
[AbstractJdbcSeeder.java] DEBUG DEFERRABILITY   =7
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,CITY)
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,CITY)
[AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM   =PUBLIC
[AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME    =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME   =PK_COUNTRY_STATE_ID
[AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM   =PUBLIC
[AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME    =CITY
[AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME   =FK_COUNTRY_STATE_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG UPDATE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG DELETE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG FK_NAME         =SYS_FK_10133
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10113
[AbstractJdbcSeeder.java] DEBUG DEFERRABILITY   =7
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,COMPANY)
[AbstractJdbcSeeder.java] DEBUG getImportedKeys(null,null,COMPANY)
[AbstractJdbcSeeder.java] DEBUG PKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG PKTABLE_SCHEM   =PUBLIC
[AbstractJdbcSeeder.java] DEBUG PKTABLE_NAME    =CITY
[AbstractJdbcSeeder.java] DEBUG PKCOLUMN_NAME   =PK_CITY_ID
[AbstractJdbcSeeder.java] DEBUG FKTABLE_CAT     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG FKTABLE_SCHEM   =PUBLIC
[AbstractJdbcSeeder.java] DEBUG FKTABLE_NAME    =COMPANY
[AbstractJdbcSeeder.java] DEBUG FKCOLUMN_NAME   =FK_CITY_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG UPDATE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG DELETE_RULE     =3
[AbstractJdbcSeeder.java] DEBUG FK_NAME         =SYS_FK_10145
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10132
[AbstractJdbcSeeder.java] DEBUG DEFERRABILITY   =7
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,COUNTRY)
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,COUNTRY)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_COUNTRY_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10093
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,TIMEZONE)
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,TIMEZONE)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =TIMEZONE
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_TIMEZONE_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10102
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,COUNTRY_STATE)
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,COUNTRY_STATE)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_COUNTRY_STATE_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10113
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,CITY)
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,CITY)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =CITY
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_CITY_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10132
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,COMPANY)
[AbstractJdbcSeeder.java] DEBUG getPrimaryKeys(null,null,COMPANY)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COMPANY
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_COMPANY_ID
[AbstractJdbcSeeder.java] DEBUG KEY_SEQ         =1
[AbstractJdbcSeeder.java] DEBUG PK_NAME         =SYS_PK_10143
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COUNTRY,false,true)
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COUNTRY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_SYS_PK_10093_10096
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_COUNTRY_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COUNTRY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_KXN_26_10100
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =NAME
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,TIMEZONE,false,true)
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,TIMEZONE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =TIMEZONE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_SYS_PK_10102_10106
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_TIMEZONE_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,TIMEZONE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =TIMEZONE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_KXN_28_10111
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =NAME
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COUNTRY_STATE,false,true)
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COUNTRY_STATE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_SYS_PK_10113_10120
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_COUNTRY_STATE_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COUNTRY_STATE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_KXN_27_10130
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =FK_COUNTRY_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COUNTRY_STATE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_KXN_27_10130
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=2
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =NAME
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COUNTRY_STATE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =true
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_SYS_FK_10115_10123
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =FK_COUNTRY_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COUNTRY_STATE,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COUNTRY_STATE
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =true
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_SYS_FK_10117_10126
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =FK_TIMEZONE_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,CITY,false,true)
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,CITY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =CITY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_SYS_PK_10132_10136
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_CITY_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,CITY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =CITY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =true
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_SYS_FK_10133_10138
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =FK_COUNTRY_STATE_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COMPANY,false,true)
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COMPANY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COMPANY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_SYS_PK_10143_10149
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =PK_COMPANY_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COMPANY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COMPANY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =false
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_KXN_25_10157
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =NAME
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG getIndexInfo(null,null,COMPANY,false,true)
[AbstractJdbcSeeder.java] DEBUG TABLE_CAT       =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_SCHEM     =PUBLIC
[AbstractJdbcSeeder.java] DEBUG TABLE_NAME      =COMPANY
[AbstractJdbcSeeder.java] DEBUG NON_UNIQUE      =true
[AbstractJdbcSeeder.java] DEBUG INDEX_QUALIFIER =PUBLIC
[AbstractJdbcSeeder.java] DEBUG INDEX_NAME      =SYS_IDX_SYS_FK_10145_10152
[AbstractJdbcSeeder.java] DEBUG TYPE            =3
[AbstractJdbcSeeder.java] DEBUG ORDINAL_POSITION=1
[AbstractJdbcSeeder.java] DEBUG COLUMN_NAME     =FK_CITY_ID
[AbstractJdbcSeeder.java] DEBUG ASC_OR_DESC     =A
[AbstractJdbcSeeder.java] DEBUG CARDINALITY     =0
[AbstractJdbcSeeder.java] DEBUG PAGES           =0
[AbstractJdbcSeeder.java] DEBUG FILTER_CONDITION=null
[AbstractJdbcSeeder.java] DEBUG 
[AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10115'
[AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10117'
[AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10133'
[AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10145'
[AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10093'
[AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10102'
[AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10113'
[AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10132'
[AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10143'
[AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_26_10100'
[AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_28_10111'
[AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_27_10130'
[AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_25_10157'
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_FK_10115
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_FK_10117
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP CONSTRAINT SYS_FK_10133
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP CONSTRAINT SYS_FK_10145
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY DROP CONSTRAINT SYS_PK_10093
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE TIMEZONE DROP CONSTRAINT SYS_PK_10102
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_PK_10113
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP CONSTRAINT SYS_PK_10132
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP CONSTRAINT SYS_PK_10143
[AbstractJdbcSeeder.java] DEBUG End
[AbstractJdbcSeeder.java] DEBUG Start
[AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY DROP CONSTRAINT SYS_IDX_KXN_26_10100

    Problems only occur with constraints of type unique key - is there a way to determine the correct constraint name?

     

  • Fred Toussi

    Fred Toussi - 2021-12-16

    I think your setup for embedded and client/server may be different. You obviously used SET DATABASE SQL SYS INDEX NAMES TRUE in the setup that returns KXN_25 as the name, but you have not used the command for the other setup. Note the command must be used before creating any tables.

     

    • Walter Weinmann

      Walter Weinmann - 2021-12-18

      This - SET DATABASE SQL SYS INDEX NAMES TRUE - did the trick - thank you
      very much.

      On Thu, 16 Dec 2021 at 17:51, Fred Toussi fredt@users.sourceforge.net
      wrote:

      I think your setup for embedded and client/server may be different. You
      obviously used SET DATABASE SQL SYS INDEX NAMES TRUE in the setup that
      returns KXN_25 as the name, but you have not used the command for the other
      setup. Note the command must be used before creating any tables.

      Status: open
      Group: version 2.5.x
      Labels: SQLSyntaxErrorException
      Created: Thu Dec 16, 2021 12:26 PM UTC by Walter Weinmann
      Last Updated: Thu Dec 16, 2021 03:37 PM UTC
      Owner: nobody

      HSQLDB Version 2.61

      Dropping a unique key gives an error of type SQLSyntaxErrorException -
      this error occurs only with the embedded version - no problem with the
      client version.

      2021-12-16 13:22:06,564 [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10115'2021-12-16 13:22:06,564 [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10117'2021-12-16 13:22:06,564 [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10133'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=R name='SYS_FK_10145'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10093'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10102'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10113'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10132'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=P name='SYS_PK_10143'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_26_10100'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_28_10111'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_27_10130'2021-12-16 13:22:06,565 [AbstractJdbcSeeder.java] DEBUG constraint type=U name='SYS_IDX_KXN_25_10157'2021-12-16 13:22:06,566 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,566 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_FK_101152021-12-16 13:22:06,567 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,567 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,567 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_FK_101172021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP CONSTRAINT SYS_FK_101332021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,569 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP CONSTRAINT SYS_FK_101452021-12-16 13:22:06,570 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,570 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,570 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY DROP CONSTRAINT SYS_PK_100932021-12-16 13:22:06,570 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,571 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,571 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE TIMEZONE DROP CONSTRAINT SYS_PK_101022021-12-16 13:22:06,571 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,571 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,572 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY_STATE DROP CONSTRAINT SYS_PK_101132021-12-16 13:22:06,572 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,572 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,572 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE CITY DROP CONSTRAINT SYS_PK_101322021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COMPANY DROP CONSTRAINT SYS_PK_101432021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG End2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG Start2021-12-16 13:22:06,573 [AbstractJdbcSeeder.java] DEBUG next SQL statement=ALTER TABLE COUNTRY DROP CONSTRAINT SYS_IDX_KXN_26_10100java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: SYS_IDX_KXN_26_10100
      at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
      at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
      at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
      at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
      at ch.konnexions.db_seeder.jdbc.AbstractJdbcSeeder.executeSQLStmnts(AbstractJdbcSeeder.java:1362)
      at ch.konnexions.db_seeder.jdbc.AbstractJdbcSeeder.dropTableConstraints(AbstractJdbcSeeder.java:1231)
      at ch.konnexions.db_seeder.jdbc.AbstractJdbcSeeder.createData(AbstractJdbcSeeder.java:427)
      at ch.konnexions.db_seeder.DatabaseSeeder.main(DatabaseSeeder.java:160)Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: SYS_IDX_KXN_26_10100
      at org.hsqldb.error.Error.error(Unknown Source)
      at org.hsqldb.error.Error.error(Unknown Source)
      at org.hsqldb.SchemaManager.getSchemaObject(Unknown Source)
      at org.hsqldb.ParserDQL.readSchemaObjectName(Unknown Source)
      at org.hsqldb.ParserDDL.compileAlterTableDropConstraint(Unknown Source)
      at org.hsqldb.ParserDDL.compileAlterTable(Unknown Source)
      at org.hsqldb.ParserDDL.compileAlter(Unknown Source)
      at org.hsqldb.ParserCommand.compilePart(Unknown Source)
      at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
      at org.hsqldb.Session.executeDirectStatement(Unknown Source)
      at org.hsqldb.Session.execute(Unknown Source)
      ... 6 more

      Sent from sourceforge.net because you indicated interest in
      https://sourceforge.net/p/hsqldb/bugs/1642/

      To unsubscribe from further messages, please visit
      https://sourceforge.net/auth/subscriptions/

       

      Related

      Bugs: #1642

      alternate

  • Fred Toussi

    Fred Toussi - 2022-01-29
    • status: open --> open-works-for-me
    • assigned_to: Fred Toussi
     

Log in to post a comment.

MongoDB Logo MongoDB