Guest User

Untitled

a guest
Apr 29th, 2012
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 KB | None | 0 0
  1. Hibernate - createQuery not fetching timestamp
  2. org.hibernate.Query query = ((HibernateEntityManager) entityManager).getSession().
  3. createSQLQuery(NATIVE_QUERY).setResultTransformer(org.hibernate.transform.Transformers.ALIAS_TO_ENTITY_MAP);
  4.  
  5. query.setString(0, accountNumber);;
  6. query.setTimestamp(1, startDate).setTimestamp(2, endTime);
  7. query.setTimestamp(3, startDate).setTimestamp(4,endTime);
  8. List resultList = query.list();
  9.  
  10. for(Object listItem : resultList){
  11. Map map = (Map) listItem;
  12. Date txnTime = (Date)map.get("txnTime".toUpperCase());
  13. //--------> NOT FETCHING THE TIME. I get the time as 00:00:00
  14. }
  15.  
  16. @Entity
  17. @Table(name="TRANSACTION")
  18. @org.hibernate.annotations.Entity(
  19. dynamicUpdate = true
  20. )
  21. public class Transaction{
  22. @Id
  23. @SequenceGenerator(name="txn_gen", sequenceName="TXN_S")
  24. @GeneratedValue(generator="txn_gen")
  25. @Column(name="TXN_ID")
  26. private Long txnId;
  27.  
  28. @ManyToOne(fetch=FetchType.LAZY)
  29. @JoinColumn(name="USER_ID", nullable=false)
  30. private User user;
  31.  
  32. @Column(name="START_TIME", nullable=false)
  33. @Temporal(TemporalType.TIMESTAMP)
  34. private java.util.Date startTime;
  35.  
  36. @Column(name="CHANGE_TIME")
  37. @Temporal(TemporalType.TIMESTAMP)
  38. private java.util.Date changeTime;
  39. }
  40.  
  41. @Entity
  42. @Table(name="USER")
  43. @org.hibernate.annotations.Entity(
  44. dynamicUpdate = true
  45. )
  46. public class User {
  47. @Id
  48. @SequenceGenerator(name = "user_gen", sequenceName = "USER_S")
  49. @GeneratedValue(generator = "user_gen")
  50. @Column(name="USER_ID")
  51. private Long userId;
  52.  
  53. @Column(length=500, name="FIRST_NAME")
  54. private String firstName;
  55.  
  56. @Column(length=500, name="LAST_NAME")
  57. private String lastName;
  58. }
Advertisement
Add Comment
Please, Sign In to add comment