JDBC-ODBC and sql.Date

[Verbetex]

I'm trying to use a ResultSet to manipulate data, and update my table in Microsoft Access 2000.

It works fine for updateInt(int x) etc.. and will accept my sql.Date into the ResultSet.

However, when I call the update or insertRow methods on the resultSet when the date has been changed, Access returns an error in row!

Any Ideas?

 

[rsfoley]

You may want to check your JDBC drivers. If you are using just a plan ODBC driver this could be your problem. You should be using one that is specificy for MS Access 2k.

You can search for some at:

http://industry.java.sun.com/products/jdbc/drivers

Although there are several drivers out there for Access, however, there currently are no TYPE 4 or Sun certified.

I hope this helps in some way.

Rodney

http://www.javathis.com