From: | Jim Wright <jimw(at)paneris(dot)org> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Help: ResultSet..insertRow() not coping with explicit oid |
Date: | 2003-09-22 07:35:50 |
Message-ID: | 3F6EA656.4080303@paneris.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Wright | 2003-09-22 08:06:20 | Help: ResultSet..insertRow() not coping with explicit oid |
Previous Message | Barry Lind | 2003-09-22 04:06:24 | Re: JDBC with SSL |