[sqlitejdbc] Re-setting single values in PreparedStatement

[MAILER-DAEMON]

I get unexpected behaviour, possibly a bug, of the PreparedStatement
when using it in a loop and modifying single values, but not all, in
each iteration. The unmodified values are lost. Example:

PreparedStatement prep = conn.prepareStatement("SELECT ?,?");
prep.setInt(1, 4);

for (int i = 1; i < 3; i++) {
    prep.setInt(2, i);
    ResultSet rs = prep.executeQuery();
    while (rs.next()) {
        System.out.println(rs.getInt(1) + " " + rs.getInt(2));
    }
}

Output:
4 1
0 2

Expected result (and what MySQL does) is:
4 1
4 2

--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---