File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes hibernate convert sql.Timestamp to joda.DateTime format issues Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "hibernate convert sql.Timestamp to joda.DateTime format issues" Watch "hibernate convert sql.Timestamp to joda.DateTime format issues" New topic
Author

hibernate convert sql.Timestamp to joda.DateTime format issues

Grace Russo
Ranch Hand

Joined: Nov 08, 2010
Posts: 64
Is there hibernate annotation to specify a difference in format between what a timestamp field is in the database and what joda.Datetime expects ?

My table has a TIMESTAMP field with format "mm/dd/yyyy HH:mm:ss PM/AM".
My corresponding entity has

@Column(name = "USER_AGREEMENT")
@Type(type = "persistent_date_time")
private DateTime userAgreement;


I get an illegalArgumentException as below, and a different timestamp format is expected.

Caused by: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-
dd hh:mm:ss[.fffffffff]
at java.sql.Timestamp.valueOf(Timestamp.java:202)
at oracle.jdbc.driver.CharCommonAccessor.getTimestamp(CharCommonAccessor
.java:460)
at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetIm
pl.java:796)


Report this post
T Mishra
Ranch Hand

Joined: Apr 04, 2006
Posts: 108

I think this example might be helpful.


Thanks,
Tushar (SCJP 1.5)
 
Consider Paul's rocket mass heater.
 
subject: hibernate convert sql.Timestamp to joda.DateTime format issues