Perhaps. But knowing that may be a key to solving the problem.
It'd be weird if a syntax error was reported on a PreparedStatement data mismatch, but then again, the ODBC-JDBC driver isn't the smartest kid on the block. [ October 18, 2004: Message edited by: Bear Bibeault ]
Joined: Oct 18, 2004
Hi, thanks for the help.
I did indeed comment out the setTime (and made appropriate changes to the values and setxxx code) and it worked great. 3000 log entries inserted just dandy.
The lg.getDate() returns a java.util.Date. I then get the time using getTime() and pass to the java.sql.Date constructor.
I have checked the output of the lg.getDate() and lg.getTime() methods and they look fine.
The LogEntry.Date database object is an Access Date/Time column.
So I am wondering if there is an issue with the Access/JDBC/ODBC combination. Has anyone seem some code that successfully inserts into an Access DB using the setTime() method?