From user-return-35011-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Wed Jul 3 05:05:38 2013 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D4CD5C9F7 for ; Wed, 3 Jul 2013 05:05:38 +0000 (UTC) Received: (qmail 61350 invoked by uid 500); 3 Jul 2013 05:05:36 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 61320 invoked by uid 500); 3 Jul 2013 05:05:36 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 61312 invoked by uid 99); 3 Jul 2013 05:05:35 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Jul 2013 05:05:35 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [98.138.91.151] (HELO nm21-vm3.bullet.mail.ne1.yahoo.com) (98.138.91.151) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Jul 2013 05:05:26 +0000 Received: from [98.138.90.54] by nm21.bullet.mail.ne1.yahoo.com with NNFMP; 03 Jul 2013 05:05:05 -0000 Received: from [98.138.87.8] by tm7.bullet.mail.ne1.yahoo.com with NNFMP; 03 Jul 2013 05:05:05 -0000 Received: from [127.0.0.1] by omp1008.mail.ne1.yahoo.com with NNFMP; 03 Jul 2013 05:05:05 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 138813.36905.bm@omp1008.mail.ne1.yahoo.com Received: (qmail 50753 invoked by uid 60001); 3 Jul 2013 05:05:05 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1372827905; bh=5lvUz4a3PxywpC7W9szvrtPii3IasDRreMklIK6T5zY=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=P30/njrwjq1W/C312v3huHr6zWsa1WBaDrifOU+2FC4wRp/VN0dX53q9Ws3Qmhh+yOFiJ85dAHE09Cf5uPy+xXVcGffqqQvFTn2smfAv7Uup/apPPXYfznaPIvT60KnBi/Ib+jXexgBUwplPGh3s+Ulmziu0rEB/excdU9ns6ME= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=Ej5+IzyoM8MyTasfq/ndXIowvmk8BDa4sr6UdURngoF191yuoBzeZ3ipRt8iriLYzQ6zkmTyIDtPqcVHFlpCvL7/jqbNXbUmJ8R3di6CjhnxTLDBPq/p/wH+FKqM+AVqaCkfi4ZXfb8/wlFy1THhBlOsKJknl8ffIFq3kerKubo= ; X-YMail-OSG: Is7YU6UVM1mLc2RAWTq61cB.lZVL6OK3Ghb0jF7srRsf1bH Sht.3Hd.U1MeWhN4a3UuEuSkjhv6ghGlEjtTEL7iAuzPHZ1q367OjtKX5S4L MJz2Z8KxTCv3HaAQFH2KEl8Sf7U1Xt1ZF7QA5bi.UMq2flwUkRWKgInR.ml6 FcaOxX5ktUk3dOiemMkEZf3UBO3sG50hvFAlmmZu5j0FC7n58wQaKWWaJh9W jAlVuFeUWz3.Ehgbn1PmofRiWChjBh067yA735K22vXI4rGbPr5Jnbp6IhlL cLoKuhqy40twNB_H6ltSr.3Ic8WqsLtMtct0OUlIYD8x1IgCRsRZ4FAg7xnk rj8szBUK4483BPueJ1d2yIJg2aYZoW6UaWrIMy9HxlWuaAODgBZ1fHUyWdNI P_Vy0y.FZm2waeR1UZUpr75nrG.TgQcdM_qOW55qxe_QzrClMvF1lxQLF6nH TVtHxWlhdUqSIXh4SBT8tYtD7zVhZZ34N3UECoTAB2F85imigKgxzINcHMgV n0MxHym6Rb1ZGteozPH9evXYVttBWlSnuyjeSVbJOca64OGFD4k_AlW3bonm W6XWFqLr5SfWlOokhL.81Mh9bUQ-- Received: from [204.228.207.218] by web121804.mail.ne1.yahoo.com via HTTP; Tue, 02 Jul 2013 22:05:04 PDT X-Rocket-MIMEInfo: 002.001,SGkgQWxsLApVc2luZyBKREJDIHByZXBhcmVTdGF0ZW1lbnQgd2hlbiBJIHVzZSBzZWNvbmRhcnkgaW5kZXggYW5kIHVzZSB0aGF0IGluIHByZXBhcmVkU3RhdGVtZW50IEkgZ2V0IG5vIHJvd3MgYmFjay4gSWYgSSByZXBsYWNlIHRoZSA_IHdpdGggYSBpbnRlZ2VyIEkgZ2V0IHRoZSByb3dzIGJhY2sgSSBleHBlY3QuIElmIEkgdXNlIHNldE9iamVjdCgpIGluc3RlYWQgb2Ygc2V0SW50KCkgSSBnZXQgdGhlIGZvbGxvd2luZyBleGNlcHRpb246CsKgZW5jb3VudGVyZWQgb2JqZWN0IG9mIGNsYXNzOiBjbGFzcyABMAEBAQE- X-Mailer: YahooMailWebService/0.8.148.557 Message-ID: <1372827904.50309.YahooMailNeo@web121804.mail.ne1.yahoo.com> Date: Tue, 2 Jul 2013 22:05:04 -0700 (PDT) From: Tony Anecito Reply-To: Tony Anecito Subject: Strange preparedStatment response... To: Users-Cassandra MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1263564687-737540562-1372827904=:50309" X-Virus-Checked: Checked by ClamAV on apache.org ---1263564687-737540562-1372827904=:50309 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi All,=0AUsing JDBC prepareStatement when I use secondary index and use th= at in preparedStatement I get no rows back. If I replace the ? with a integ= er I get the rows back I expect. If I use setObject() instead of setInt() I= get the following exception:=0A=A0encountered object of class: class java.= lang.Integer, but only 'String' is supported to map to the various VARCHAR = types=0A=A0=0AMakes me wonder what I am doing wrong? I use IntegerType for = the column value type but it looks like maybe when you use a sql statement = where you have column_name =3D ? it is comparing maybe the column name rath= er than the Integer values in the column?=0A=A0=0AThanks for the help.=0A-T= ony ---1263564687-737540562-1372827904=:50309 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi All,
Using JDBC prepareStatement when I use secondary= index and use that in preparedStatement I get no rows back. If I replace t= he ? with a integer I get the rows back I expect. If I use setObject() inst= ead of setInt() I get the following exception:
 
encountered object of class: class java.lang.Integer, but only 'String= ' is supported to map to the various VARCHAR types
 
Makes me wonder what I am doing wrong? I use IntegerType for the colum= n value type but it looks like maybe when you use a sql statement where you= have column_name =3D ? it is comparing maybe the column name rather than t= he Integer values in the column?
 
Thanks for the help.
-Tony
---1263564687-737540562-1372827904=:50309--