From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
---|---|
To: | Jim Wright <JimWright(at)quick(dot)cz> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Help: ResultSet..insertRow() not coping with explicit |
Date: | 2003-09-22 14:21:59 |
Message-ID: | 1064240518.4287.336.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Jim,
can you send me a test case which demonstrates this?
Dave
On Mon, 2003-09-22 at 04:06, Jim Wright wrote:
> 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
--
Dave Cramer <Dave(at)micro-automation(dot)net>
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2003-09-22 15:46:44 | Re: java.net.SocketException: Broken pipe |
Previous Message | Paul Thomas | 2003-09-22 14:18:01 | Re: Begin transaction? |