Passing Date as parameter in SQL (Hibernate) where clause

[Jehan Jaleel]

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...

advDetail = (AdviceDetail) this.as400Em
					.createQuery(
							"select a from AdviceDetail a where a.adviceHeaderId= ?1 AND a.settlementEntityId= ?2 AND a.dateSettlement= ?3 ")
					.setParameter(1, adviceHeaderId)
					.setParameter(2, settlementDetail.getSettlementEntity().trim())
					.setParameter(3, settlementDetail.getDateSettlement().getSingleResult());

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

Hibernate: select advicedeta0_.ADVICE_DETAIL_ID as ADVICE1_4_ from SETTLEMENT.ADVICE_DETAIL advicedeta0_ where advicedeta0_.ADVICE_HEADER_ID=? and advicedeta0_.SETTLEMENT_ENTITY_ID=? and advicedeta0_.DATE_SETTLEMENT=? and advicedeta0_.SETTLEMENT_CURRENCY_CODE=? and advicedeta0_.DIRECTION_OF_ADVICE_COMPONENT=? and advicedeta0_.ADVICE_COMPONENT_CODE=? and advicedeta0_.ENTITY_PRODUCT_GROUP_ID=? fetch first 2 rows only 
17:17:04,788 TRACE main sql.BasicBinder:83 - binding parameter [1] as [BIGINT] - 15
17:17:04,789 TRACE main sql.BasicBinder:83 - binding parameter [2] as [VARCHAR] - BY185
17:17:04,789 TRACE main sql.BasicBinder:83 - binding parameter [3] as [DATE] - Sun Jan 27 00:00:00 EST 2013

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]

Hi,

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

Thanks.