updatable resultset doesn't work
i try to get an updatable resultset in this way:
Statement upstmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet uprs=upstmt.executeQuery("select * from COFFEES");
the resultset uprs, that i get back, is in fact not updatable!
uprs.isUpdatable=false,
and when i try to invoke the method uprs.moveToInsertRow(), i get the SQLException:com.mysql.jdbc.NotUpdatable: Result Set not updatable
uprs is a valid resultset and i can get all the rows.
i am using mysql-standard-4.1.12-apple-darwin7.9.0-powerpc with mysql-connector-java-3.1.8.
does the connector/J not support updatable resultsets?
please help!
Subject
Written By
Posted
updatable resultset doesn't work
June 13, 2005 09:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.