very Thanks. Still one more question. I tried that query but I am still finding trouble. The query is something like this "from MultiplePersonalisedResponse multiple where multiple.singlePersonalisedResponse[0].creationDate=:startDate and multiple.userid=:userid"
The error it gave me is something like this. net.sf.hibernate.QueryException: unindexed collection before []: multiple.singlePersonalisedResponse [from com.webify.eligibility.BenefitResponse.MultiplePersonalisedResponse multiple where multiple.singlePersonalisedResponse[0].creationDate=:startDate and multiple.userid=:userid] The error it gave me is something like this I am not able to figure it out thanks. regards prasad chandrasekaran ----- Original Message ----- From: "Gavin King" <[EMAIL PROTECTED]> To: "Prasad Iyer" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 5:34 PM Subject: Re: [Hibernate] Error "expecting 'elements' or 'indices'" > > 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(PathExpressi o > >nParser.java:469) > > > >at > >net.sf.hibernate.hql.PathExpressionParser.token(PathExpressionParser.java:1 7 > >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:3 5 > >8) > > > >at > >net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:3 3 > >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.g e > >tMultiplePersonalisedResponseFor3Days(MultiplePersonalisedResponseHelper.ja v > >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
