This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft 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 | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
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
 
wood burning stoves
 
subject: Updating Date
 
Similar Threads
Passing java.sql.date to constructors
Converting From String to java.sql.Date
preparedStatement.setDate and java.util.Date
Save date to the database
util.Date to sql.Date