You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Jean-Claude Cote <jc...@gmail.com> on 2016/01/16 21:31:05 UTC

support for parameter binding in JDBC driver

Currently the drill JDBC driver throws an SQLFeatureNotSupportedException
when you attempt to

prepStatement = conn.prepareStatement("SELECT int_col AS INTCOL FROM
dfs.jdbctesting.fewtypes_txt_view where int_col > ?");
    prepStatement.setInt(1, 20);


I understand that the Drill server does not support prepared statement with
bind variables however some tools such as Hibernate entity mapping require
the use of bind variables.

Are there plans to support this in the future by having the Driver insert
the parameters into the SQL before sending it off to the drill server.

This would permit the use of bind variables without modifying the drill
server itself.

Thanks
Jean-Claude