Ben qu created DRILL-7743:
-----------------------------
Summary: Prepared-statement dynamic parameters are not supported.
Key: DRILL-7743
URL: https://issues.apache.org/jira/browse/DRILL-7743
Project: Apache Drill
Issue Type: Improvement
Components: Client - JDBC
Affects Versions: 1.17.0, 1.15.0
Reporter: Ben qu
As described in title， jdbc driver PreparedStatement does not support dynamic
parameters。 e.g: setString API of PreparedStatement would trigger the following
exception.
All threads started!All threads
started!java.sql.SQLFeatureNotSupportedException: Prepared-statement dynamic
parameters are not supported. at
org.apache.drill.jdbc.impl.DrillPreparedStatementImpl.getParameter(DrillPreparedStatementImpl.java:88)
at
oadd.org.apache.calcite.avatica.AvaticaPreparedStatement.getSite(AvaticaPreparedStatement.java:434)
at
oadd.org.apache.calcite.avatica.AvaticaPreparedStatement.setString(AvaticaPreparedStatement.java:195)
at InsertBatchesThread.execInsert(TsqlInsertClient.java:160) at
InsertBatchesThread.run(TsqlInsertClient.java:192)java.sql.SQLFeatureNotSupportedException:
Prepared-statement dynamic parameters are not supported. at
org.apache.drill.jdbc.impl.DrillPreparedStatementImpl.getParameter(DrillPreparedStatementImpl.java:88)
at
oadd.org.apache.calcite.avatica.AvaticaPreparedStatement.getSite(AvaticaPreparedStatement.java:434)
at
oadd.org.apache.calcite.avatica.AvaticaPreparedStatement.setString(AvaticaPreparedStatement.java:195)
at InsertBatchesThread.execInsert(TsqlInsertClient.java:160) at
InsertBatchesThread.run(TsqlInsertClient.java:192)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
