JDBC Adaptor: Support Prepared Statement with Bind Variable.

[Jiunn Jye Ng]

Hi,

When testing Calcite Jdbc Adaptor on prepared statement with bind variable,

    sql = "select * from EMPS where EMPNO > ?"
    val ps = connection.prepareStatement(sql);
    ps.setInt(1, 1)
    rs = ps.executeQuery()

Calcite fail the execution with error

     Caused by: java.lang.ClassCastException:
org.apache.calcite.rex.RexDynamicParam incompatible with
org.apache.calcite.rex.RexCall
at
org.apache.calcite.adapter.jdbc.JdbcImplementor$Context.toSql(JdbcImplementor.java:216)

This is due to DYNAMIC_PARAM which are not implemented in
JdbcImplementor$Context.toSql method.

After quickly mocking up the support for DYNAMIC_PARAM, the execution is
now failing with parameter not set from the external database.

     Caused by: org.h2.jdbc.JdbcSQLException: Parameter "#1" is not set;
SQL statement:

So I discovered it take much more than a few line of code changes to
support bind variable.

Does Calcite plan to support bind variable in JdbcAdaptor ?


Thank you.

Rgds,
jay