Re: updateString error in PostgreSQL7.4 with JDBC - Mailing list pgsql-general

From Suha Onay
Subject Re: updateString error in PostgreSQL7.4 with JDBC
Date
Msg-id 419207AC.4040001@liqia.com
Whole thread Raw
In response to updateString error in PostgreSQL7.4 with JDBC  (Suha Onay <suha@liqia.com>)
List 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?
>

pgsql-general by date:

Previous
From: Joel
Date:
Subject: Re: These Lists Are Being Cut To FOUR
Next
From: "Mike Cox"
Date:
Subject: I have had enough