Hello,
calling moveToInsertRow on a ResultSet returned by a prepared statement leads
to a NullPointerException:
Example code:
PreparedStatement p = c.prepareStatement(
"SELECT * FROM sampletable WHERE myid=?",
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_UPDATABLE);
p.setInt(1,1);
ResultSet r = p.executeQuery();
r.moveToInsertRow();
Result:
Exception in thread "main" java.lang.NullPointerException
at org.postgresql.core.v3.SimpleQuery.toString(SimpleQuery.java:40)
at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.parseQuery(AbstractJdbc2ResultSet.java:1656)
at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.isUpdateable(AbstractJdbc2ResultSet.java:1516)
at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkUpdateable(AbstractJdbc2ResultSet.java:2427)
at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.moveToInsertRow(AbstractJdbc2ResultSet.java:868)
Driver Version: 8.0.309 JDBC3
PostgreSQL Version: 7.4.6
Best regards
Martin Keller