File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes storing dates using prepared statements Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "storing dates using prepared statements" Watch "storing dates using prepared statements" New topic

storing dates using prepared statements

prav ba

Joined: Jun 17, 2007
Posts: 12
hi all,
have got a method which converts java.util.Date to java.sql.Date and stores it to oracle 11g db.

the problem is that when i look into the db the value stored is 05-05-0005 which is not correct since i would have thought the value stored would be 05-05-2005.

can anyone explain why this is happening ??

Paul Clapham

Joined: Oct 14, 2005
Posts: 18141

This is nothing to do with JDBC at all. You simply have misunderstood SimpleDateFormat. Direct quote from its API documentation:
For parsing, if the number of pattern letters is more than 2, the year is interpreted literally, regardless of the number of digits. So using the pattern "MM/dd/yyyy", "01/11/12" parses to Jan 11, 12 A.D.
prav ba

Joined: Jun 17, 2007
Posts: 12
aha !! thanks Paul.
I agree. Here's the link:
subject: storing dates using prepared statements
Similar Threads
date problem
problem insering date value in database
Question on ParseException
date format problem
SQLException caught: ORA-17041: (no message for error) 1