which verson of mysql support server side cursors
Posted by: shifeng zhao
Date: June 04, 2005 11:53PM

hi, i was following the tutorial of using scrollable result set as defined in
jdbc 2.0 api. unfortunately, i get the following error

mySQL 4.1.0-alpha-max-debug
mysql-connector-java-3.0.9-stable-bin.jar

throw Exception:
[java] com.mysql.jdbc.NotUpdatable: Result Set not updatable.This result
se
t must come from a statement that was created with a result set type of
ResultSe
t.CONCUR_UPDATABLE, the query must select only one table, and must select all
pr
imary keys from that table. See the JDBC 2.1 API Specification, section 5.6 for
more details.

Options: ReplyQuote


Subject
Written By
Posted
which verson of mysql support server side cursors
June 04, 2005 11:53PM


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.