From: | Jim Wright <JimWright(at)quick(dot)cz> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Help: ResultSet..insertRow() not coping with explicit oid |
Date: | 2003-09-22 08:06:20 |
Message-ID: | 3F6EAD7C.30901@quick.cz |
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 | Bjørn T Johansen | 2003-09-22 11:38:39 | Begin transaction? |
Previous Message | Jim Wright | 2003-09-22 07:35:50 | Help: ResultSet..insertRow() not coping with explicit oid |