Hi, I am trying to execute a query on the two tables which has one-to-many relationship between them I get this error. I don't understand this error I tried everything using ArrayList and Array. But don't get it right can anyone help. Please MultiplePersonalisedResponse has a list that contains the collection of singlePersonalisedResponse and I want to get the data for singlePersonalisedResponse between two days.
net.sf.hibernate.QueryException: expecting 'elements' or 'indices' after: multiple.singlePersonalisedResponse.creationDate [from com.webify.eligibility.BenefitResponse.MultiplePersonalisedResponse multiple where multiple.singlePersonalisedResponse.creationDate=:startDate[0] and multiple.userid=:userid] at net.sf.hibernate.hql.PathExpressionParser.doCollectionProperty(PathExpressio nParser.java:469) at net.sf.hibernate.hql.PathExpressionParser.token(PathExpressionParser.java:17 2) at net.sf.hibernate.hql.WhereParser.doPathExpression(WhereParser.java:362) at net.sf.hibernate.hql.WhereParser.doToken(WhereParser.java:391) at net.sf.hibernate.hql.WhereParser.token(WhereParser.java:277) at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:73) at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:120) at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29) at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:132) at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:119) at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:35 8) at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:33 6) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1354) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1318) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:68) at com.webify.eligibility.BenefitResponse.MultiplePersonalisedResponseHelper.ge tMultiplePersonalisedResponseFor3Days(MultiplePersonalisedResponseHelper.jav a:185) at com.webify.eligibility.db.HibernateTest.getMultiple3Days(HibernateTest.java: 107) at com.webify.eligibility.db.HibernateTest.main(HibernateTest.java:850) java.lang.NullPointerException at com.webify.eligibility.db.HibernateTest.getMultiple3Days(HibernateTest.java: 108) at com.webify.eligibility.db.HibernateTest.main(HibernateTest.java:850) Thanks in advance regards prasad chandrasekaran ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
