database driver that allows scrollable result set
I attempted to create a scrollable result set with the following create statement.
s = c.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
I received the following error at runtime.
java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]Driver not capable
Anyone know of a Foxpro driver that supports scrollable result sets or another solution to this problem.
Thanks,
Brian
[457 byte] By [
BrianB24] at [2007-9-26 1:34:28]
Rather than trying to find a driver to do this, get the Rowset API from the JDC (Java Developer Connection).
Get it here:
http://developer.java.sun.com/developer/earlyAccess/crs
The JavaDocs are well detailed; essentially you populate a CachedRowSet which acts as a wrapper around your ResultSet. The CRS gives you the power to scroll, update, serialize, etc.
Enjoy
Justoon
I don't know if you just mistyped your original question, but to create a scrollable resultset you have to give it a the statement constructor a ResultSet.TYPE_SCROLL_INSENSITIVE parameter:
s = c.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
maybe your driver does not support ResultSet.CONCUR_UPDATABLE?
Jamie
