Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes HOW TO USE ResultSet.insertRow() ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "HOW TO USE ResultSet.insertRow() ?" Watch "HOW TO USE ResultSet.insertRow() ?" New topic
Author

HOW TO USE ResultSet.insertRow() ?

fengzixuan zheng
Ranch Hand

Joined: Aug 02, 2001
Posts: 31
I got a problem.
I successfully connect to a MS Access database. (Using JDBC:ODBC bridge)
Also I can roll the records, I can delete the records. But once I use the insertRow() method, a SQLException will occur:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Dirver] mistakes in rows(Just the meaning).
and followed by a lot of at......
Please Help

With regards
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

what is the exact error message? What is the offending code? have you looked at http://java.sun.com/docs/books/tutorial/jdbc/jdbc2dot0/inserting.html ?
Jamie
fengzixuan zheng
Ranch Hand

Joined: Aug 02, 2001
Posts: 31
Originally posted by Jamie Robertson:
what is the exact error message? What is the offending code? have you looked at http://java.sun.com/docs/books/tutorial/jdbc/jdbc2dot0/inserting.html ?
Jamie

Jamie , thanks for you replay.
I have searched the web page you given above, but I find it doesn't help.
I post a new paste, enclosed my codes, I wish you have time to have a look.
Thank you again.

Fengzixuan
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: HOW TO USE ResultSet.insertRow() ?
 
Similar Threads
java database connectivity
how can java connect to Access?
Database Access
Access driver on linux/unix?
Getting the date