Meaningless Drivel is fun!*
The moose likes Object Relational Mapping and the fly likes Passing Date as parameter in SQL (Hibernate) where clause 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 » Object Relational Mapping
Bookmark "Passing Date as parameter in SQL (Hibernate) where clause" Watch "Passing Date as parameter in SQL (Hibernate) where clause" New topic
Author

Passing Date as parameter in SQL (Hibernate) where clause

Jehan Jaleel
Ranch Hand

Joined: Apr 30, 2002
Posts: 196
Hi,

I have the code below where I am querying my database based on some parameters and one of them is a date field where I am passing in a java util Date...



In the debug console I can see this come out as follows...



In the DB the value of the Settlement Date field is just "2013-01-27" but as you can see I am passing "Sun Jan 27 00:00:00 EST 2013". Could this be the reason why it is not finding the record? And if so how do I make it to pick it up? All the other fields of my query are present in the DB record.

Thanks in advance for any help.
Jehan Jaleel
Ranch Hand

Joined: Apr 30, 2002
Posts: 196
Hi,

I was able to resolve this by casting java util Date to java sql Date.

Thanks.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Passing Date as parameter in SQL (Hibernate) where clause
 
Similar Threads
Hibernate & Date
Http Status 404 Error
Problem with date
Hibernate date in criteria
Error While deploying EAR application