For point 2 - I don't think it's possible right now, but creating a patch for this should be easy.
Christian -----Original Message----- From: indone [mailto:[EMAIL PROTECTED] Sent: Thursday, 12 July 2007 12:06 To: [email protected] Subject: RE: ORA-01795: maximum number of expressions in a list Hi Praveen, Thanks for your reply. I think using select AND and OR will degrade the performance I Thought of going to temporary table . Before going to thought i have couple of questions 1) I have seen Select and Statement tags always execute as prepared statement. so is there any way we can make query as statement? 2) using iterator is there any way i can index from the collection ? i want to use that index to do some logic.. <iterate property="geos" open="(" close=")" conjunction=","> #geos[]# </iterate> Thanks Venkat Pravin Rane wrote: > > Hi, > > There is no direct work around for this problem because you cannot > pass more than 1000 values in the IN clause. May be you can try one of > the following possible solution. > 1. Replace in clause values with the SELECT query if possible. Even if > select query returns more than 1000 values it will not create any problem. > > 2. Create a data structure like list of lists. Each list will have > maximum of thousand values. This way you can use nested iterate > statement and combine multiple IN statements with OR. > > I hope this will help > > Regards > ~Pravin > > -----Original Message----- > From: indone [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 28, 2007 6:21 AM > To: [email protected] > Subject: ORA-01795: maximum number of expressions in a list > > > Hi Guys, > We are having issue with query exceeding maximum number of expressions > > 1000. we are using ibatis. It looks the issue with oracle that wont > allow list more than 1000 in in parameter. > > i am looking for work around that in my sql i need to pass whole set > of values at once.so for sure i cant go for multiple calls. > second thing is there anyway in ibatis query that i can handle this issue? > > any suggestions would be appreciated > below is the query > -------------------------------- > select to_char(ps_vz_mettrftotal.VZ_ITM_UID) as CATEGORYID, > to_char(sum(PS_VZ_METTRFTOTAL.VZ_IMPRESSION_CNT)) as COUNT from > PS_VZ_METTRFTOTAL, ps_vz_geo_xref where > ps_vz_mettrftotal.VZ_PPC_GEO_ID = > ps_vz_geo_xref.VZ_PPC_GEO_ID > and ps_vz_mettrftotal.VZ_PPC_GEO_ID in > <iterate property="geos" open="(" close=")" conjunction=","> > #geos[]# > </iterate> > group by ps_vz_mettrftotal.VZ_ITM_UID > > > -- > View this message in context: > http://www.nabble.com/ORA-01795%3A-maximum-number-of-expressions-in-a- > list-t > f3991841.html#a11335217 > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > -- View this message in context: http://www.nabble.com/ORA-01795%3A-maximum-number-of-expressions-in-a-li st-tf3991841.html#a11563250 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
