From: | Elie Nacache <elie_nacache(at)yahoo(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Resultset problem or BUG ! |
Date: | 2004-08-11 12:59:35 |
Message-ID: | 20040811125935.94879.qmail@web54106.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Richard,
Some informations:
==============
OS: RedHat
DB: PostgreSQL 7.4.3
Driver: PostgreSQL 7.4.2 JDBC3 with SSL (build 213)
Here some code:
============
INFO >> sqlDatas is of type ResultSet
INFO >> Step first insert new row
this.sqlDatas.moveToInsertRow();
this.updateColumns();
this.sqlDatas.insertRow();
this.sqlLineNumber = this.sqlDatas.getRow(); // INFO >> return 0
INFO >> At this step there is no commit
INFO >> Second step update the row after collecting updated info
this.sqlDatas.absolute(this.sqlLineNumber); // INFO >> throw the exception
this.updateColumns();
this.sqlDatas.updateRow();
INFO >> If I fix the sqlLineNumber to 1 and force the absolute(1) then no Execption is thrown but the modification is not seen in the table.
Elie Nacache
RentaSoft Ltd.
Richard Huxton <dev(at)archonet(dot)com> wrote:
Elie Nacache wrote:
> Hi All,
Hi Elie, I'm afraid we'll need more details before we can help.
> A data writed in a table but not commited is not accessible in
> modification by the resultset. The error returned is "Cannot move to
> index of 0".
Is this an ODBC or JDBC error? There are specific lists for both of those.
> BTW in SQL a sequence of INSERT, UPDATE and then COMMIT work fine.
> I'm using the same code with oracle and it's working well.
What code?
> Is it a BUG !?
Can't say.
> I'm using psql 7.4.3 on Linux 9.0
psql is the command-line tool, so I'm guessing you mean PostgreSQL (or
pgsql) 7.4.3. Likewise, there is no Linux 9.0 - I'm assuming you mean
RedHat, SuSE or Mandrake.
If you can provide details on how you are accessing the database and a
short example of your code, I'm sure someone will be able to help.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
---------------------------------
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Mascari | 2004-08-11 13:00:50 | Re: How to write soundex query in postgresql?? |
Previous Message | Vinay Jain | 2004-08-11 12:37:00 | How to write soundex query in postgresql?? |