Re: Help: ResultSet..insertRow() not coping with explicit

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@micro-automation.net>