moveToInsertRow doesn't work when using prepared statements
От | Martin Keller |
---|---|
Тема | moveToInsertRow doesn't work when using prepared statements |
Дата | |
Msg-id | 200501271500.46617.martin.keller@unitedplanet.de обсуждение исходный текст |
Ответы |
Re: moveToInsertRow doesn't work when using prepared statements
|
Список | pgsql-jdbc |
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
В списке pgsql-jdbc по дате отправления: