Runtime Parameter replacement failing

ikettle · **Joined:** Tue Jan 17, 2006 3:07 pm **Posts:** 1

I'm using Hibernate 3 and am having a strange issue with querying one of my persistant objects. The problem is that when I use parameter replacement the query returns no results

"select prod from ProductImpl as prod where prod.myfield=?", productId

If I replace this with the following I get the expected results

"select prod from ProductImpl as prod where prod.myfield='"+productId+"'"

I have other queries using parameter replacement that work fine.

Does anyone have any ideas what would be causing this? The queries are actually performed using the find method in the HibernateTemplate in Spring.

/I

LaLiLuna · **Posted:** Tue Jan 17, 2006 4:23 pm

may be it is a type issue. Please post the complete query and the mapping.

Regards Sebastian