Query.SetParameterList

kaisor · **Joined:** Tue Jan 24, 2006 12:04 pm **Posts:** 12

i have a problem about Hibernate List, if the list has over 300 items, then it will throw a "too complicated SQL" exception.

I have to render it myself (divide list to parts), is there any existing way in hibernate to overcome this problem?

CWitherow · **Posted:** Mon May 15, 2006 12:54 pm

Multiple uses of .setParameterList for a query works fine for me (v3.1.3 on DB2/400). We need more information: version, db, mappings, etc.

kaisor · **Joined:** Tue Jan 24, 2006 12:04 pm **Posts:** 12

i put another problem in the first post.

the elder one is solved, that was my fault : an unnecessary ")" in query.

pvradhakrishna · **Joined:** Tue Feb 19, 2008 6:05 pm **Posts:** 82

Code:

from 
table
where table.tableId in (select distinct otherTable.otherTableField where table.tableId = otherTable,tableId
and otherTable.tableColumn in (:tableColumn))
and table.someTableColumn in (:someTableColumn)
.setParameterList(tableColumn, someArray[5])
.setParameterList(someTableColumn, someOtherArray[5])

This is possible to attach two setParameterList of the same length, but is there a way to re-write these queries where in you know that you want to pass a single parameter from the two arrays/list for the two variables. i.e.,

if

Code:

String[] array1 = new String[]{"abc","cde","def"};
String[] array2 = new String[]{"123","234","345"};

I want to pass array1[0]="abc" along with array2[0]="123" at the same time and so on, and get the results.