You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Ben qu (Jira)" <ji...@apache.org> on 2020/05/22 11:55:00 UTC

[jira] [Created] (DRILL-7743) Prepared-statement dynamic parameters are not supported.

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)