log.info("Populating test tables ...");
if (log != null) log.info("Populating test tables ...");
    private void populateTestTables(int rowCount) throws SQLException    {        if (con.getAutoCommit())            con.setAutoCommit(false);        log.info("Populating test tables ...");        Random random = new Random();        for (int i = 1; i <= TABLE_COUNT; i++) {            StringBuffer sql = new StringBuffer(100);            sql.append("INSERT INTO ");            sql.append(getTableName(i));            sql.append(" (ID,NR,X1,X2,X3");            if (i > 1) {                sql.append(",ID_");                sql.append(getTableName(i - 1));            }            sql.append(") VALUES (?,?,?,?,?");            if (i > 1)                sql.append(",?");            sql.append(")");            PreparedStatement stmt = con.prepareStatement(sql.toString());            for (int row = 1; row <= rowCount; row++) {                int rndValue = random.nextInt(1000);                stmt.setInt(1, row);                stmt.setInt(2, rndValue);                stmt.setString(3, "X1." + row + "." + rndValue);                stmt.setString(4, "X2." + row + "." + rndValue);                stmt.setString(5, "X3." + row + "." + rndValue);                if (i > 1)                    stmt.setInt(6, row);                stmt.executeUpdate();            }            stmt.close();            con.commit();        }    }