[TRAFODION-1780] [MTDCS]jPrepareStatement execute twice, second ResultSet is empty

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: connectivity-dcs
• Assignee: Kevin Xu
• Reporter: Kevin Xu
• Created: 26/Jan/16 03:03
• Updated: 15/Sep/18 07:31
• Resolved: 28/Jan/16 03:18

Description

//there is 1 row in table t1.
String query = "SELECT * FROM t1 WHERE id=? AND name=?";
conn.setAutoCommit(true);
try {
PreparedStatement statement = conn.prepareStatement(query);
statement.setString(1, "1");
statement.setString(2, "1");
ResultSet rs = statement.executeQuery();
assertTrue(rs.next());
assertFalse(rs.next());
rs.close();
// Run another query through same connection and make sure
// you can't find the new row
rs = statement.executeQuery();
assertTrue(rs.next());//Error here
} finally {
}