From: | Suha Onay <suha(at)liqia(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)archonet(dot)com> |
Cc: | postgres general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: updateString error in PostgreSQL7.4 with JDBC |
Date: | 2004-11-10 12:21:00 |
Message-ID: | 419207AC.4040001@liqia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
It is ok. I fetch the row with no problem.
The error is only in update types like updateString , updateRow,
updateInt...
ps.You are right JDBC list is appropriate.
Richard Huxton wrote:
> Suha Onay wrote:
>
>> Hi,
>> I have a problem with PostgreSQL 7.4. (With the old one 7.3 no
>> probllem.)
>
>
> You might get a better response from the jdbc list.
>
>> I create a connection and a statement :
>> Class.forName("org.postgresql.Driver");
>> conn = DriverManager.getConnection(
>> O_Constants.DB_CONNECTION_URL,
>> O_Constants.DB_CONNECTION_USERNAME,
>> O_Constants.DB_CONNECTION_PASSWORD);
>> st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
>> ResultSet.CONCUR_UPDATABLE);
>> rs = st.executeQuery("select * ...";
>>
>> Then:
>> rs.updateString(20 , ...);
>>
>> The error is:
>> org.postgresql.util.PSQLException: Cannot update the result set
>> because it is either before the start or after the end of the results.
>
>
> What happens if you fetch a row first?
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rolf stvik | 2004-11-10 12:34:39 | Re: I'm about to release the next postgresql RFD. Comments wanted. |
Previous Message | Joel | 2004-11-10 11:45:04 | Re: These Lists Are Being Cut To FOUR |