RE: [appfuse-user] Passing set of User objects as Argument in HQL

[Bandula]

Thank you Ron, I will try this.

Bandula

 

From: Ron Anderson [mailto:[EMAIL PROTECTED] 
Sent: Saturday, January 19, 2008 11:29 PM
To: users@appfuse.dev.java.net
Subject: Re: [appfuse-user] Passing set of User objects as Argument in HQL

 

I use the following to pass in a collection as a parameter list but do it in
a hibernate callback.
hth,
Ron

    public List getIpdrsToRate(final Collection listOfStatusToRate, final
String subscriberToRate) throws DataAccessException {
        
        return getHibernateTemplate().executeFind(new HibernateCallback() {
            public Object doInHibernate(Session session) throws
HibernateException {
                Query query = session.createQuery(
                        "from Ipdr ipdr where ipdr.ratingStatus IN
(:ratingStatusList) " +
                " AND ipdr.subscriberID = :subscriberId ");
                query.setParameterList("ratingStatusList",
listOfStatusToRate);
                query.setString("subscriberId", subscriberToRate);
                query.setMaxResults(MAX_BATCH_SIZE.intValue());
                return query.list();
            }
        });
    }

----- Original Message ----
From: Bandula <[EMAIL PROTECTED]>
To: users@appfuse.dev.java.net; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, January 19, 2008 9:47:21 AM
Subject: [appfuse-user] Passing set of User objects as Argument in HQL

  

Dear All;  

 

I get exception "java.lang.reflect.InvocationTargetException" when I call
following method in CommentDaoHibernate.java class. I want to pass set of
User objects to field assignedParty in following HQL. Can someone please
suggest a way to pass User object list. 

        

 

 

 

public List<Comment> findCommentByChangeRequestForRole(ChangeRequest
changeRequest, List<User> userList){

          

        Object[] params = new Object[2];

        params[0] = userList;

        params[1] = changeRequest;

        

        return getHibernateTemplate().find(("from Comment c 

where c.assignedParty in (?) AND c.changeRequest = ? ORDER BY c.sid",
params);

      

}

 

 

Thanks 

Bandula