Using Timestamp in Database Application

[Steve Dyke]

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:

GetCurrentDate cDate = new GetCurrentDate();
cDate.setcDate();
		
request.getSession().setAttribute("currentSIDocTimeStamp", cDate.getTimeStamp());
		

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

String timestamp = request.getSession().getAttribute("currentSIDocTimeStamp").toString();

SamplingInspectionConnection siConn = new SamplingInspectionConnection();
siConn.setSubmitInitialSamplingInspectionRecord(gConn.getAs400Conn(), inspectionType, docNumber, partNumber, shipsetID, dwgRevision, vendorCode, faiIndex, lotQty, sampleType, sampleQty, acceptedQty, rejectedQty, userName, SubsourceFlag, defectCodes, userNotes, systemEmailAddress, localserverflag, currentYear, partDescription, badgeNo, stampNumber, docktostockflag, siNewComments, timestamp);
		

In my connection class I have:

Timestamp timeStampDate = Timestamp.valueOf(timeStamp);

...
"','" + stampNumber +
"'," + docktostockLot +
",'" + buyerNo + "',TIMESTAMP('" + timeStampDate +
"'))";

I get this error in the console

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

[Ed Ward]

You didn't give much info but I can say that

Timestamp timeStampDate = Timestamp.valueOf("2010-11-12 05:52:35.038"); 

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]

After looking at this again I realized I did not need to use the:

Timestamp timeStampDate = Timestamp.valueOf(timeStamp);   

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

...   
"','" + stampNumber +   
"'," + docktostockLot +   
",'" + buyerNo + "',TIMESTAMP('" + timeStamp +   
"'))";