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 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 JavaScript Promises Essentials this week in the JavaScript 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Passing Date as parameter in SQL (Hibernate) where clause