wood burning stoves*
The moose likes JDBC 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
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
 
Similar Threads
Reading from XML file
JDBC bridge on MS-Access
moveToInsertRow()
Please help with the 3 Hardest Javascript problems in the world
move row in table