aspose file tools
The moose likes JDBC and the fly likes HOW TO USE ResultSet.insertRow() ? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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
posted
0
Quote
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

I like...
MySQL Database Suse
posted private message
0
Quote
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
posted
0
Quote
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
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: HOW TO USE ResultSet.insertRow() ?
 
Similar Threads
Database Access
Getting the date
Access driver on linux/unix?
how can java connect to Access?
java database connectivity