Hi,
I'm trying to perform a SELECT .. FOR UPDATE and get an SQLException saying my connection is in readonly mode - please can you tell me what I am doing wrong?
I've included the testcase code and Exception below.
Thanks
Nick.
My example testcase:
public class TestSelectForUpdate {
public static void main(String[] args) throws Exception {
Class.forName("com.hxtt.sql.dbf.DBFDriver");
String url = "jdbc:dbf:/c:\\data\\SHSUB";
Properties info = new Properties();
Connection conn = DriverManager.getConnection(url, info);
Statement stmt=conn.createStatement();
stmt.executeQuery("select * from demo where id = 4700 for update");
conn.close();
}
}
When I run the above code, I get the following Exception:
java.sql.SQLException: FOR UPDATE has been used but your connection is in readonly mode.
|
>Statement stmt=conn.createStatement();
According to JDBC API, the defaulte value is ResultSet.CONCUR_READ_ONLY, you should use:
conn.createStatementResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
|