Thanks for that, Lew. I'm snowed under this week, but will try to dig
into this some more given the information you provided.
On 4/20/18 4:26 PM, Lew Jackman wrote:
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
