Help: ResultSet..insertRow() not coping with explicit oid - Mailing list pgsql-jdbc

Hi,

I have some code which I think effectively does this:

statement = connection.createStatement(
                  ResultSet.TYPE_SCROLL_SENSITIVE,
                  ResultSet.CONCUR_UPDATABLE));
resultSet = statement.executeQuery(
         "SELECT oid, * FROM " + table.ID);
resultSet.moveToInsertRow();
resultSet.updateXXX(...);
...
resultSet.insertRow();

At which point I get the SQLException:

ERROR:  Relation "character" has no column "oid"

(Sorry about the confusing table name)

I have tried both with and without updateLong()
for the oid.

This looks like a bug. If I believe the manual
then result sets are readonly but I assume the
code is ahead of the docs.

I have postgresql-7.3.1-6.src.rpm under Red Hat
8.0 and pg73jdbc3.jar.

So what is the story. Am I doing it wrong? Is this
fixed in a later release?

Help much appreciated,

Jim Wright

--
Recently completed - Child Brain Injury Trust
Admin System
http://cbitdemo.paneris.org/

Urgently seeking paid work
Java, Linux, XML and much more.
http://be.webz.cz/