log.info("Creating test tables ...");
if (log != null) log.info("Creating test tables ...");
    private void createTestTables() throws SQLException    {        log.info("Creating test tables ...");        if (!con.getAutoCommit())            con.setAutoCommit(true);        for (int i = 1; i <= TABLE_COUNT; i++) {            String table = getTableName(i);            StringBuffer sql = new StringBuffer(100);            sql.append("CREATE TABLE ");            sql.append(table);            sql.append(" (\n" +                       "ID INTEGER NOT NULL,\n" +                       "NR INTEGER NOT NULL,\n" +                       "X1 VARCHAR(50),\n" +                       "X2 VARCHAR(50),\n" +                       "X3 VARCHAR(50),\n");            if (i > 1) {                sql.append("ID_");                sql.append(getTableName(i - 1));                sql.append(" INTEGER,\n");            }            sql.append("CONSTRAINT PK_");            sql.append(table);            sql.append(" PRIMARY KEY (ID))");            execute(sql.toString());        }        // add FOREIGN KEY's        for (int i = 2; i <= TABLE_COUNT; i++) {            String thisTable = getTableName(i);            String refTable = getTableName(i - 1);            StringBuffer sql = new StringBuffer(100);            sql.append("ALTER TABLE ");            sql.append(thisTable);            sql.append(" ADD CONSTRAINT FK_");            sql.append(refTable);            sql.append(" FOREIGN KEY (ID_");            sql.append(refTable);            sql.append(") REFERENCES ");            sql.append(refTable);            sql.append(" (ID)");            execute(sql.toString(), true);        }    }