JdbcConnection conn = (JdbcConnection) database.getConnection();
try {
Statement stmt = conn.createStatement();
PreparedStatement insertStmt =
conn.prepareStatement("insert into HCredentials "
+ "(account_id, type, user, email, creationDate, lastChanged, versionNum) values"
+ "(?, ?, ?, ?, ?, ?, ?)");
ResultSet rset =
stmt.executeQuery("select acc.id, acc.username, p.email, acc.creationDate, acc.lastChanged "
+ " from HAccount acc, HPerson p"