Announcement Announcement Module
Collapse
No announcement yet.
hibernateTemplate with arraylist as parameter Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • hibernateTemplate with arraylist as parameter

    Hi,

    i'm trying to execute this query :
    Code:
    this.getHibernateTemplate()
          find("select distinct ci.customer " +
                 "from CustomerInvoice ci " +
                  "where ci.id in (?) " , ids);
    with ids as a List<Long>, id is of type Long

    when executing i get exception

    Code:
    java.lang.ClassCastException: java.util.ArrayList cannot be cast to java.lang.Long
    	at org.hibernate.type.LongType.set(LongType.java:42)
    	at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136)
    	at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:116)
    	at org.hibernate.param.PositionalParameterSpecification.bind(PositionalParameterSpecification.java:39)
    	at org.hibernate.loader.hql.QueryLoader.bindParameterValues(QueryLoader.java:491)
    	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1563)
    	at org.hibernate.loader.Loader.doQuery(Loader.java:673)
    	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    	at org.hibernate.loader.Loader.doList(Loader.java:2220)
    	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    	at org.hibernate.loader.Loader.list(Loader.java:2099)
    	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
    	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
    	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
    	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
    	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
    	at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:849)
    	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
    	at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:840)
    	at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:836)
    	at
Working...
X