Return-Path: 
 <user-java-return-17023-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 23507 invoked from network); 19 Jun 2009 16:39:17 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 19 Jun 2009 16:39:17 -0000
Received: (qmail 47110 invoked by uid 500); 19 Jun 2009 16:39:27 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 47090 invoked by uid 500); 19 Jun 2009 16:39:27 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 47055 invoked by uid 99); 19 Jun 2009 16:39:27 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 19 Jun 2009 16:39:27 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 19 Jun 2009 16:39:07 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1MHh71-0008P6-9L
	for user-java@ibatis.apache.org; Fri, 19 Jun 2009 09:38:47 -0700
Message-ID: <24114956.post@talk.nabble.com>
Date: Fri, 19 Jun 2009 09:38:47 -0700 (PDT)
From: BruceKKK <sibyl0726@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: issue of ibatis sqlmap list of list
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: sibyl0726@gmail.com
X-Virus-Checked: Checked by ClamAV on apache.org


hi kai,

i have read the src of ibatis, it did not support multi loop. so i consider
use temp table.

thx

k.

---------------------------------------------------------------------------------- 

Kai Grabfelder-3 wrote:
> 
> consider using a tmp table if you encounter this error (a) insert into tmp
> table, b) join your select with the
> tmp table). Most of the time ist should be faster than doing than
> combining OR and IN statements.
> 
> cheers
> 
> Kai
> 
> --- Original Nachricht ---
> Absender: BruceKKK
> Datum: 19.06.2009 05:34
>> i met ora-01795 error, so i need separate list to several size limited
>> lists,
>> I am trying use nested iterators to iterate over a List of List  using
>> following code:
>> 
>> <select id="getList" parameterClass="map" resultClass="com.ResultObject">	 
>>  select *****	from ****** where 
>>   <isNotEmpty property="outLists" >
>>    <iterate property="outLists" open="(" close=")" conjunction="OR">
>>     data in
>>      <iterate property="outLists[]" open="(" close=")" conjunction=",">
>>       #outLists[].[]#
>>      </iterate>
>>     </iterate>
>>    </isNotEmpty>
>> </select>
>> 
>> but i got exception:
>> com.ibatis.common.beans.ProbeException: Error getting ordinal list from
>> JavaBean. Cause java.lang.NumberFormatException: For input string: "" 
>> 
>> how to make it run?
>> 
>> by the way: the version of ibatis i used is 2.1.7
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/issue-of-ibatis-sqlmap-list-of-list-tp24105006p24114956.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.