The moose likes JDBC and Relational Databases and the fly likes ResultSet move OK, updateRow and InsertRow don't work on MS-Acess Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "ResultSet move OK, updateRow and InsertRow don Watch "ResultSet move OK, updateRow and InsertRow don New topic
Author

ResultSet move OK, updateRow and InsertRow don't work on MS-Acess

Xuening Ma
Greenhorn

Joined: Jul 25, 2002
Posts: 6
I am working on web pages design with JSP, I'd like to use the scrolable result set in my appliation, it is OK for cursor move, but when I excute updateRow(), it update with some garbage to my table, when I excute insertRow, it throw with exception, "Error in row", I just use a simple table with a column, type number or text, doesn't work.
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
I don't tehink the JDBC-ODBC driver supports that method.
You can check this link for some known problems/limitations of that driver.
http://java.sun.com/products/jdbc/faq.html
[ July 26, 2002: Message edited by: Bosun Bello ]

Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Jessica Sant
Sheriff

Joined: Oct 17, 2001
Posts: 4313

"Ning"-
Welcome to the JavaRanch! Please adjust your displayed name to match the JavaRanch Naming Policy.
You can change it here.
Thanks! and again welcome to the JavaRanch!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ResultSet move OK, updateRow and InsertRow don't work on MS-Acess
 
It's not a secret anymore!