wood burning stoves 2.0*
The moose likes JDBC and the fly likes Date/Timestamp 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 » Databases » JDBC
Bookmark "Date/Timestamp" Watch "Date/Timestamp" New topic
Author

Date/Timestamp

Kunal Sathe
Ranch Hand

Joined: Apr 08, 2005
Posts: 49
I have a java program which reads data from an Oracle Database and inserts it into DB2. The reading part is working perfectly fine. However, while inserting the data into DB2, it gives me the following error:

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008

After doing some research, I have come to the conclusion that the error might be due to the fact the I am trying to insert values of the type Timestamp into the DB2 table which expects values of the type Date.

Please correct me if I am wrong.

However, if the above is true, could someone suggest a way in which I can convert the Timestamp values into Date values.

I would really appreciate if someone could point me into the right direction.

Thanks,
Kunal
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

I always have to look in the API documentation for things like that too. But there aren't many constructors available for Date so it's pretty easy:
Kunal Sathe
Ranch Hand

Joined: Apr 08, 2005
Posts: 49
Thanks Paul.

I shall try it out.
 
Consider Paul's rocket mass heater.
 
subject: Date/Timestamp
 
Similar Threads
2 phase commit
Unsuccessful execution of db2 query - Unavailable resource
please help urgently ...strange error
Error Help
db2 year 2000 invalid date