We have a bit more of a stack trace for our bind parameter exception, not sure if this is very revealing but we have: java.lang.RuntimeException: java.sql.SQLException: ERROR 2004 (INT05): Parameter value unbound. Parameter at index 1 is unbound org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:681) org.apache.calcite.avatica.jdbc.JdbcMeta.prepare(JdbcMeta.java:707) org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:208) org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Service.java:1195) org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Service.java:1166) org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:95) org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:46) org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:124)org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.Server.handle(Server.java:499) org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HttpChannel.handle(HttpChannel.java:311) org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HttpConnection.onFillable(HttpConnection.java:257) org.apache.phoenix.shaded.org.eclipse.jetty.server.io.AbstractConnection$2.run(AbstractConnection.java:544) org.apache.phoenix.shaded.org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) org.apache.phoenix.shaded.org.eclipse.jetty.util.thread.io.QueuedThreadPool$3.run(QueuedThreadPool.java:555)java.lang.Thread.run(Thread.java:745)
---------- Original Message ---------- From: "Lew Jackman" <lew9...@netzero.net> To: user@phoenix.apache.org Subject: Re: Bind Params with Union throw AvaticaSqlException Date: Fri, 13 Apr 2018 01:30:43 GMT This is Phoenix 4.9, we are upgrading to 4.11 very shortly but are on 4.9 this week. I'll try to get a better stack trace, thanks much ____________________________________________________________ World War 2 Discovery Kept Secret For Over 70 Years?! pro.naturalhealthresponse.com http://thirdpartyoffers.netzero.net/TGL3231/5ad0085f8ab2385f473fst03vuc
