Meaningless Drivel is fun!
The moose likes Object Relational Mapping and the fly likes Problem with Parameters in Hibernate query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Problem with Parameters in Hibernate query" Watch "Problem with Parameters in Hibernate query" New topic

Problem with Parameters in Hibernate query

M Aslam

Joined: Jul 12, 2004
Posts: 14
Hi, can someone please assist!:

I have the following query, the problem is in the way I'm setting parameters for the query (eg. queryObject.setParameter), the query otherwise works well with a single parameter.

public Company findPopulatedCompanyByName(final String name, final String name_other) {
HibernateCallback callback = new HibernateCallback(){

public Object doInHibernate(Session session) throws HibernateException, SQLException {
Company Company =null;
String query = "from Company g where IN (?,?)";
Query queryObject = getHibernateTemplate().createQuery(session, query);
queryObject.setParameter(0, name);
queryObject.setParameter(1, name_other);
Company = (Company) queryObject.list().get(0);
return Company;


return (Company) getHibernateTemplate().execute(callback);

Many thanks.
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

Aslam, please click the My Profile link and change your name to follow JavaRanch's naming policy, which states that a real first and last name must be used. Jessica has already asked you to do this.



Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: Problem with Parameters in Hibernate query
jQuery in Action, 3rd edition