• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Devaka Cooray
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Martijn Verburg
  • Frits Walraven
  • Himai Minh

Using Timestamp in Database Application

 
Ranch Hand
Posts: 2155
2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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"
 
Ranch Hand
Posts: 147
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 2155
2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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:

 
I need a new interior decorator. This tiny ad just painted every room in my house purple.
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic