Hi
Can the DBAdmin update/insert data . I can only read tables, but get the following error when trying to insert;
Exception in thread "main" java.sql.SQLException: Timeout Interrupted Exception: beyond 50000 msecs to get result for a remote request, but that request should have been executed by remote server.
at com.hxtt.global.SQLState.SQLException(Unknown Source)
code:
Class.forName("com.hxtt.sql.dbf.DBFDriver").newInstance();
String jdbcConnection = "jdbc:dbf://localhost:3099/d:/dms2000/data/dhs";
Connection con = DriverManager.getConnection(jdbcConnection,properties);
PreparedStatement stmt = con.prepareStatement(
"select * from incident",
ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet rs = stmt.executeQuery();
while (rs.next()){ ;
rs.updateString("PUNIT", "test");
rs.updateRow();
}
|
|
Checked. It's resulted by a bug in remote ResultSet.updateRow method. Fixed. The latest package will be availabel after about 3 hours.
|
Main
webmaster@hxtt.com