This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
The moose likes JDBC and the fly likes Updating Date Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Updating Date " Watch "Updating Date " New topic
Author

Updating Date

mujtaba habib
Greenhorn

Joined: Feb 26, 2001
Posts: 12
i want to update a date/time field in MS Access Database. here is the code but its not working
java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());

result.updateDate("op_pw_change_date",sqlDate);
result.updateRow();
Error Message is: Error in row
its works fine when i comment updateDate row
any idea ??
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1506
I don't think the JDBC-ODBC driver supports that method.


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
mujtaba habib
Greenhorn

Joined: Feb 26, 2001
Posts: 12
hmm.. but other updateXXX() methods r working fine
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Updating Date
 
Similar Threads
Converting From String to java.sql.Date
Passing java.sql.date to constructors
Save date to the database
util.Date to sql.Date
preparedStatement.setDate and java.util.Date