HPCCPreparedStatement not accepting Long/Integer as params

[apohl]

Hi,

Trying to run the following example code...

Code: Select all

String myprepsql = "select k,s from ajp::temp::ds persons where k >= ? and k <= ?";
HPCCPreparedStatement prepstmt = (HPCCPreparedStatement)connection.prepareStatement(myprepsql);
prepstmt.setLong(1, (long)1);
prepstmt.setLong(2, (long)5);
HPCCResultSet qrs = (HPCCResultSet) ((HPCCPreparedStatement) prepstmt).executeQuery();
while(qrs.next()) {
   System.out.println(qrs.getInt("k"));
}

I get the following error message...
java.sql.SQLException: java.lang.Long cannot be cast to java.lang.String
at org.hpccsystems.jdbcdriver.HPCCPreparedStatement.executeQuery(HPCCPreparedStatement.java:108)

When looking at the HPCCPreparedStatement code it looks like any parameter passed in is type cast to a String. I'm wondering if this is something that could be changed in a future update?

Thanks,
Aaron

[rodrigo.pastrana]

Aaron, I'm glad to see you got your project building.
Thanks for bringing up this issue, I'm currently working on the primitive type binding and will have a solution very soon. In the meantime you can add yourself as a watcher to this Jira so you can follow the progress. Thanks

https://track.hpccsystems.com/browse/JDBC-49

Update, just noticed you were the original reporter of the issue... the fix has been submitted and will the reviewed shortly. If you're in a hurry you can pull the commit from my repo: https://github.com/rpastrana/hpcc-jdbc/ ... ypeBinding