Return-Path: Delivered-To: apmail-commons-user-archive@www.apache.org Received: (qmail 82932 invoked from network); 25 Aug 2008 21:14:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 25 Aug 2008 21:14:13 -0000 Received: (qmail 35478 invoked by uid 500); 25 Aug 2008 21:14:07 -0000 Delivered-To: apmail-commons-user-archive@commons.apache.org Received: (qmail 35422 invoked by uid 500); 25 Aug 2008 21:14:07 -0000 Mailing-List: contact user-help@commons.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Commons Users List" Delivered-To: mailing list user@commons.apache.org Received: (qmail 35411 invoked by uid 500); 25 Aug 2008 21:14:07 -0000 Delivered-To: apmail-jakarta-commons-user@jakarta.apache.org Received: (qmail 35408 invoked by uid 99); 25 Aug 2008 21:14:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 25 Aug 2008 14:14:07 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [85.33.2.25] (HELO smtp-out25.alice.it) (85.33.2.25) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 25 Aug 2008 21:13:09 +0000 Received: from FBCMMO02.fbc.local ([192.168.68.196]) by smtp-out25.alice.it with Microsoft SMTPSVC(6.0.3790.1830); Mon, 25 Aug 2008 23:13:35 +0200 Received: from FBCMCL01B01.fbc.local ([192.168.69.82]) by FBCMMO02.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Mon, 25 Aug 2008 23:13:34 +0200 Received: from [127.0.0.1] ([87.17.138.59]) by FBCMCL01B01.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Mon, 25 Aug 2008 23:13:34 +0200 Message-ID: <48B32025.9010605@inwind.it> Date: Mon, 25 Aug 2008 23:12:05 +0200 From: Pietro Santurelli User-Agent: Thunderbird 2.0.0.16 (Windows/20080708) MIME-Version: 1.0 To: commons-user@jakarta.apache.org Subject: Common DbUtils Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 080825-0, 25/08/2008), Outbound message X-Antivirus-Status: Clean X-OriginalArrivalTime: 25 Aug 2008 21:13:34.0915 (UTC) FILETIME=[6F343130:01C906F7] X-Virus-Checked: Checked by ClamAV on apache.org Hi all, I'm using common DbUtils 1.1 to execute this query: SELECT column1 FROM table WHERE id_table IN (?). Java fragment code is: String params = "1,2"; String query = "SELECT column1 FROM table WHERE id_table IN (?)"; QueryRunner qRunner = new QueryRunner(); ArrayList stores = (ArrayList)qRunner.query(connection,query, params, new BeanListHandler(Store.class)); The ArrayList obtained is populated only with stores with id = 1. In other words, the stores with id = 2 aren't retrieved. The semicolon seems to be the problem. Is this a bug of common DbUtils? Thanks in advance, Pietro --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@commons.apache.org For additional commands, e-mail: user-help@commons.apache.org