Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 46825 invoked from network); 5 Dec 2005 23:19:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 Dec 2005 23:19:34 -0000 Received: (qmail 95189 invoked by uid 500); 5 Dec 2005 23:19:31 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 95160 invoked by uid 500); 5 Dec 2005 23:19:31 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 95139 invoked by uid 99); 5 Dec 2005 23:19:31 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Dec 2005 15:19:31 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [66.220.6.229] (HELO mail.roomity.com) (66.220.6.229) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Dec 2005 15:19:28 -0800 Received: from slave1.roomity.com (slave1.roomity.com [66.220.6.229]) by mail.roomity.com (Postfix) with ESMTP id 42942A7599 for ; Mon, 5 Dec 2005 15:19:54 -0800 (PST) Message-ID: <9340749.11133824794128.JavaMail.tomcat5@slave1.roomity.com> From: ooper To: user-java@ibatis.apache.org Subject: Problem with to form an IN clause MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1_3703981.1133824794126" Date: Mon, 5 Dec 2005 15:19:54 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_1_3703981.1133824794126 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I can't seem to get this to work in my Oracle database: sg.saved_graph_id IN #paramSavedGraphIdList[]# paramSavedGraphIdList is an ArrayList filled with Integer objects. Here is the error I'm getting: Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the getFoldersOfParentFolderIdPublic-InlineParameterMap. --- Check the parameter mapping for the 'paramSavedGraphIdList[0]' property. --- Cause: java.sql.SQLException: Invalid column type Any ideas on what the problem might be? By the way, it works fine on MS SQL Server. TIA, Brian Barnett Broadband interface (RIA) + mail box saftey = http://iBatis_for_Java_Users_List.roomity.com *Your* clubs, no sign up to read, ad supported; try broadband internet. ------=_Part_1_3703981.1133824794126 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I can't seem to get this to work in my Oracle database:

=
=09sg.sa= ved_graph_id IN
=09
=09=09#paramSavedGraphIdList[]#
=09=


paramSavedGraphIdList is an ArrayList fi= lled with Integer objects. Here is the error I'm getting:

Caused by:= com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error o= ccurred while applying a parameter map.
--- Check the getFoldersOfPare= ntFolderIdPublic-InlineParameterMap.
--- Check the parameter mapping f= or the 'paramSavedGraphIdList[0]' property.
--- Cause: java.sql.SQLExc= eption: Invalid column type

Any ideas on what the problem might be? = By the way, it works fine on MS SQL Server.

TIA,
Brian Barnett

Broadband interface (RIA) + mail box saftey =3D http://iBatis_for_= Java_Users_List.roomity.com
*Your* clubs, no sign up to read, ad support= ed; try broadband internet.
------=_Part_1_3703981.1133824794126--