Please see the Hibernate documentation for information about how to query collections. Also
note that you cannot use the [] syntax after a parameter name.
Prasad Iyer wrote:
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
------------------------------------------------------- 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
