Apache calcite / jdbc Oracle

2020-05-14 Thread Thierry Rolland
Hello all, I'm trying calcite avatica v1.16.0 which seems to be a very great tool. I tried with a postgresql database and that works very fine (I used the provided docker standalone server for my tests) Now, I'm trying with an oracle database (v19c) and like for postgresql, I'm using a doc

Re: Apache calcite / jdbc Oracle

2020-05-14 Thread Julian Hyde
That sounds like a bug in Avatica. I was not aware that in 'isWrapperFor(Class iface)', 'iface' had to be an interface, and had assumed the driver would just return 'false'. Can you please log it? A solution would be to create an interface in Avatica for AvaticaPreparedStatement. (It seems that t

Re: Apache calcite / jdbc Oracle

2020-05-14 Thread Laurent Goujon
I checked https://docs.oracle.com/javase/7/docs/api/java/sql/Wrapper.html#isWrapperFor(java.lang.Class), and it mentions interface in multiple places, but it doesn't say explicitly that it should throw if the provided argument is not an interface. And I guess Oracle driver chose to enforce this str

Re: Apache calcite / jdbc Oracle

2020-05-15 Thread Thierry Rolland
Hello, Yes, that was also my analysis and I found source code of an old Oracle jdbc driver there : https://github.com/caot/ojdbc6-11.2.0.2.0.src/blob/master/src/oracle/jdbc/driver/OracleStatementWrapper.java public boolean isWrapperFor(Class paramClass)     throws SQLException   {     if (