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?
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
