From dev-return-56346-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Sat May 4 00:18:03 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id B9D6218067E for ; Sat, 4 May 2019 02:18:02 +0200 (CEST) Received: (qmail 17508 invoked by uid 500); 4 May 2019 00:18:01 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 17484 invoked by uid 99); 4 May 2019 00:18:01 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 04 May 2019 00:18:01 +0000 Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 96F90E2B5F for ; Sat, 4 May 2019 00:18:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 28C4225815 for ; Sat, 4 May 2019 00:18:00 +0000 (UTC) Date: Sat, 4 May 2019 00:18:00 +0000 (UTC) From: "Swaroopa Kadam (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Assigned] (PHOENIX-5192) "Parameter value unbound" thrown when use PrepareStatement to getParamMetaData MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/PHOENIX-5192?page=3Dcom.atlass= ian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam reassigned PHOENIX-5192: --------------------------------------- Assignee: Swaroopa Kadam > "Parameter value unbound" thrown when use PrepareStatement to getParamMet= aData > -------------------------------------------------------------------------= ----- > > Key: PHOENIX-5192 > URL: https://issues.apache.org/jira/browse/PHOENIX-5192 > Project: Phoenix > Issue Type: Bug > Affects Versions: 5.0.0 > Reporter: shining > Assignee: Swaroopa Kadam > Priority: Major > Attachments: CreateTable > > > I use QueryServer in phoenix 5.x version, Test code is as follows=EF=BC= =9A > {code:java} > Connection connection =3D DriverManager.getConnection("jdbc:phoenix:thin:= http://localhost:8765;serialization=3DPROTOBUF"); > PreparedStatement ptst =3D connection.prepareStatement("SELECT A.EVIDENCE= _ID, A.APP_ID, A.APP_NAME FROM BIZ_DATA A JOIN EVIDENCE_AUTH_RECORD B ON A.= EVIDENCE_ID=3DB.EVIDENCE_ID WHERE B.APP_ID in (?) AND A.APP_ID in (?)"); > ptst.setString(1, "1111"); > ptst.setString(2, "1234"); > ptst.executeQuery(); > {code} > this will throws Exception: > ~ > {color:red}java.lang.RuntimeException: java.sql.SQLException: ERROR 2004 = (INT05): Parameter value unbound. Parameter at index 1 is unbound > =09at org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:70= 0) > =09at org.apache.calcite.avatica.jdbc.JdbcMeta.prepare(JdbcMeta.java:726) > =09at org.apache.calcite.avatica.jdbc.PhoenixJdbcMeta.prepare(PhoenixJdbc= Meta.java:54) > =09at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.j= ava:195) > =09at org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Ser= vice.java:1215) > =09at org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Ser= vice.java:1186) > =09at org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHan= dler.java:94) > =09at org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHan= dler.java:46) > =09at org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(Ava= ticaProtobufHandler.java:127) > =09at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.jav= a:52) > =09at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapp= er.java:134) > =09at org.eclipse.jetty.server.Server.handle(Server.java:534) > =09at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:320) > =09at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.j= ava:251) > =09at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(Abst= ractConnection.java:283) > =09at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108) > =09at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPo= int.java:93) > =09at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.execut= eProduceConsume(ExecuteProduceConsume.java:303) > =09at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produc= eConsume(ExecuteProduceConsume.java:148) > =09at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(Ex= ecuteProduceConsume.java:136) > =09at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadP= ool.java:671) > =09at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPo= ol.java:589) > =09at java.lang.Thread.run(Thread.java:748) > Caused by: java.sql.SQLException: ERROR 2004 (INT05): Parameter value unb= ound. Parameter at index 1 is unbound > =09at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newExceptio= n(SQLExceptionCode.java:518) > =09at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExc= eptionInfo.java:150) > =09at org.apache.phoenix.jdbc.PhoenixParameterMetaData.getParam(PhoenixPa= rameterMetaData.java:89) > =09at org.apache.phoenix.jdbc.PhoenixParameterMetaData.isSigned(PhoenixPa= rameterMetaData.java:138) > =09at org.apache.calcite.avatica.jdbc.JdbcMeta.parameters(JdbcMeta.java:2= 76) > =09at org.apache.calcite.avatica.jdbc.JdbcMeta.signature(JdbcMeta.java:28= 8) > =09at org.apache.calcite.avatica.jdbc.JdbcMeta.prepare(JdbcMeta.java:721) > =09... 21 more{color} > ~ > create table sql attached! -- This message was sent by Atlassian JIRA (v7.6.3#76005)