*
The moose likes Java in General and the fly likes Using Timestamp in Database Application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Using Timestamp in Database Application" Watch "Using Timestamp in Database Application" New topic
Author

Using Timestamp in Database Application

Steve Dyke
Ranch Hand

Joined: Nov 16, 2004
Posts: 1393
My application records inspection records. When the user types in an inspection record document number and the app attempts to validate it I store a timestamp to a servlet attribute as follows:



Then when the record is submitted I send this value to my connection class as follows:



In my connection class I have:



I get this error in the console

SamplingInspectionConnection1:PE: java.text.ParseException: Unparseable date: "2010-11-12 05:52:35.038"
Ed Ward
Ranch Hand

Joined: Jan 30, 2006
Posts: 147
You didn't give much info but I can say that

works just fine for me on 1.6.0_22.
Are you sure about the value and format being passed in?
What line number does the stacktrace report the Exception on?
Is it where you call Timestamp.valueOf(String); ?
Steve Dyke
Ranch Hand

Joined: Nov 16, 2004
Posts: 1393
After looking at this again I realized I did not need to use the:



So I use the string parameter sent to the class directly in the:

 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Using Timestamp in Database Application
 
Similar Threads
After deleting 14 records, application hanging
I can't get my query cache to work...
lock/unlock
My locking approach...comments please
Design question