JDBC Driver not supported Exception on VertX

1

Hello,

And error that i encounter when i try to use jdbc driver through an VertX architecture. On dremio the querry is received and played successfully, but the response failed.

Blockquote
16:15:08.586 [C3P0PooledConnectionPoolManager[identityToken->z8kfsx9t15b5mb8x6wd0n|604e946b]-HelperThread-#2] DEBUG oadd.com.dremio.exec.client.DremioClient - Connecting to server dremio.data.ovh.net:31010
16:15:08.598 [Client-1] DEBUG oadd.com.dremio.sabot.rpc.user.QueryResultHandler - batchArrived: queryId = 257bad83-5b18-e269-6240-3df830d03c00
16:15:08.614 [Client-1] DEBUG com.dremio.jdbc.impl.DremioCursor$ResultsListener - [#2] Received query data batch #1: QueryResultBatch [header=query_id {
part1: 2700943181219422825
part2: 7079726750406556672
}
row_count: 1
def {
record_count: 1
field {
major_type {
minor_type: FLOAT8
mode: OPTIONAL
}
name_part {
name: “revenue_sum”
}
child {
major_type {
minor_type: BIT
mode: REQUIRED
}
name_part {
name: “$bits$”
}
value_count: 1
buffer_length: 1
}
child {
major_type {
minor_type: FLOAT8
mode: REQUIRED
}
name_part {
name: “$values$”
}
value_count: 1
buffer_length: 8
}
value_count: 1
buffer_length: 9
}
carries_two_byte_selection_vector: false
}
, data=ArrowBuf[28], udle: [11 0…16]].
16:15:08.615 [vert.x-worker-thread-8] DEBUG com.dremio.jdbc.impl.DremioCursor$ResultsListener - [#2] Dequeued query data batch #1: QueryResultBatch [header=query_id {
part1: 2700943181219422825
part2: 7079726750406556672
}
row_count: 1
def {
record_count: 1
field {
major_type {
minor_type: FLOAT8
mode: OPTIONAL
}
name_part {
name: “revenue_sum”
}
child {
major_type {
minor_type: BIT
mode: REQUIRED
}
name_part {
name: “$bits$”
}
value_count: 1
buffer_length: 1
}
child {
major_type {
minor_type: FLOAT8
mode: REQUIRED
}
name_part {
name: “$values$”
}
value_count: 1
buffer_length: 8
}
value_count: 1
buffer_length: 9
}
carries_two_byte_selection_vector: false
}
, data=ArrowBuf[28], udle: [11 0…16]].
16:15:08.804 [vert.x-worker-thread-8] DEBUG com.mchange.v2.c3p0.impl.NewPooledConnection - com.mchange.v2.c3p0.impl.NewPooledConnection@260981cc handling a throwable.
java.sql.SQLFeatureNotSupportedException: null
at oadd.org.apache.calcite.avatica.Helper.unsupported(Helper.java:68) ~[dremio-jdbc-driver-1.0.8.jar:1.0.8-201707190805180330-27f36e1]
at oadd.org.apache.calcite.avatica.AvaticaStatement.getMoreResults(AvaticaStatement.java:369) ~[dremio-jdbc-driver-1.0.8.jar:1.0.8-201707190805180330-27f36e1]
at com.dremio.jdbc.impl.DremioStatementImpl.getMoreResults(DremioStatementImpl.java:286) ~[dremio-jdbc-driver-1.0.8.jar:1.0.8-201707190805180330-27f36e1]
at com.mchange.v2.c3p0.impl.NewProxyStatement.getMoreResults(NewProxyStatement.java:779) ~[c3p0-0.9.5.2.jar:0.9.5.2]
at io.vertx.ext.jdbc.impl.actions.JDBCExecute.execute(JDBCExecute.java:54) ~[vertx-jdbc-client-3.4.2.jar:?]
at io.vertx.ext.jdbc.impl.actions.JDBCExecute.execute(JDBCExecute.java:32) ~[vertx-jdbc-client-3.4.2.jar:?]
at io.vertx.ext.jdbc.impl.actions.AbstractJDBCAction.handle(AbstractJDBCAction.java:58) ~[vertx-jdbc-client-3.4.2.jar:?]
at io.vertx.core.impl.ContextImpl.lambda$executeBlocking$1(ContextImpl.java:271) ~[vertx-core-3.4.2.jar:?]
at io.vertx.core.impl.TaskQueue.lambda$new$0(TaskQueue.java:60) ~[vertx-core-3.4.2.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_151]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_151]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_151]
16:15:08.810 [vert.x-worker-thread-8] DEBUG com.mchange.v2.sql.SqlUtils - Attempted to convert SQLException to SQLException. Leaving it alone. [SQLState: null; errorCode: 0]
java.sql.SQLFeatureNotSupportedException: null
at oadd.org.apache.calcite.avatica.Helper.unsupported(Helper.java:68) ~[dremio-jdbc-driver-1.0.8.jar:1.0.8-201707190805180330-27f36e1]
at oadd.org.apache.calcite.avatica.AvaticaStatement.getMoreResults(AvaticaStatement.java:369) ~[dremio-jdbc-driver-1.0.8.jar:1.0.8-201707190805180330-27f36e1]
at com.dremio.jdbc.impl.DremioStatementImpl.getMoreResults(DremioStatementImpl.java:286) ~[dremio-jdbc-driver-1.0.8.jar:1.0.8-201707190805180330-27f36e1]
at com.mchange.v2.c3p0.impl.NewProxyStatement.getMoreResults(NewProxyStatement.java:779) ~[c3p0-0.9.5.2.jar:0.9.5.2]
at io.vertx.ext.jdbc.impl.actions.JDBCExecute.execute(JDBCExecute.java:54) ~[vertx-jdbc-client-3.4.2.jar:?]
at io.vertx.ext.jdbc.impl.actions.JDBCExecute.execute(JDBCExecute.java:32) ~[vertx-jdbc-client-3.4.2.jar:?]
at io.vertx.ext.jdbc.impl.actions.AbstractJDBCAction.handle(AbstractJDBCAction.java:58) ~[vertx-jdbc-client-3.4.2.jar:?]
at io.vertx.core.impl.ContextImpl.lambda$executeBlocking$1(ContextImpl.java:271) ~[vertx-core-3.4.2.jar:?]
at io.vertx.core.impl.TaskQueue.lambda$new$0(TaskQueue.java:60) ~[vertx-core-3.4.2.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_151]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_151]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_151]
16:15:08.811 [vert.x-worker-thread-8] DEBUG com.mchange.v2.c3p0.impl.DefaultConnectionTester - Testing a Connection in response to an Exception:
java.sql.SQLFeatureNotSupportedException: null
at oadd.org.apache.calcite.avatica.Helper.unsupported(Helper.java:68) ~[dremio-jdbc-driver-1.0.8.jar:1.0.8-201707190805180330-27f36e1]
at oadd.org.apache.calcite.avatica.AvaticaStatement.getMoreResults(AvaticaStatement.java:369) ~[dremio-jdbc-driver-1.0.8.jar:1.0.8-201707190805180330-27f36e1]
at com.dremio.jdbc.impl.DremioStatementImpl.getMoreResults(DremioStatementImpl.java:286) ~[dremio-jdbc-driver-1.0.8.jar:1.0.8-201707190805180330-27f36e1]
at com.mchange.v2.c3p0.impl.NewProxyStatement.getMoreResults(NewProxyStatement.java:779) ~[c3p0-0.9.5.2.jar:0.9.5.2]
at io.vertx.ext.jdbc.impl.actions.JDBCExecute.execute(JDBCExecute.java:54) ~[vertx-jdbc-client-3.4.2.jar:?]
at io.vertx.ext.jdbc.impl.actions.JDBCExecute.execute(JDBCExecute.java:32) ~[vertx-jdbc-client-3.4.2.jar:?]
at io.vertx.ext.jdbc.impl.actions.AbstractJDBCAction.handle(AbstractJDBCAction.java:58) ~[vertx-jdbc-client-3.4.2.jar:?]
at io.vertx.core.impl.ContextImpl.lambda$executeBlocking$1(ContextImpl.java:271) ~[vertx-core-3.4.2.jar:?]
at io.vertx.core.impl.TaskQueue.lambda$new$0(TaskQueue.java:60) ~[vertx-core-3.4.2.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_151]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_151]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_151]
16:15:08.812 [vert.x-worker-thread-8] DEBUG com.mchange.v2.c3p0.impl.NewPooledConnection - com.mchange.v2.c3p0.impl.NewPooledConnection@260981cc invalidated by Exception.
java.sql.SQLFeatureNotSupportedException: null
at oadd.org.apache.calcite.avatica.Helper.unsupported(Helper.java:68) ~[dremio-jdbc-driver-1.0.8.jar:1.0.8-201707190805180330-27f36e1]
at oadd.org.apache.calcite.avatica.AvaticaStatement.getMoreResults(AvaticaStatement.java:369) ~[dremio-jdbc-driver-1.0.8.jar:1.0.8-201707190805180330-27f36e1]
at com.dremio.jdbc.impl.DremioStatementImpl.getMoreResults(DremioStatementImpl.java:286) ~[dremio-jdbc-driver-1.0.8.jar:1.0.8-201707190805180330-27f36e1]
at com.mchange.v2.c3p0.impl.NewProxyStatement.getMoreResults(NewProxyStatement.java:779) ~[c3p0-0.9.5.2.jar:0.9.5.2]
at io.vertx.ext.jdbc.impl.actions.JDBCExecute.execute(JDBCExecute.java:54) ~[vertx-jdbc-client-3.4.2.jar:?]
at io.vertx.ext.jdbc.impl.actions.JDBCExecute.execute(JDBCExecute.java:32) ~[vertx-jdbc-client-3.4.2.jar:?]
at io.vertx.ext.jdbc.impl.actions.AbstractJDBCAction.handle(AbstractJDBCAction.java:58) ~[vertx-jdbc-client-3.4.2.jar:?]
at io.vertx.core.impl.ContextImpl.lambda$executeBlocking$1(ContextImpl.java:271) ~[vertx-core-3.4.2.jar:?]
at io.vertx.core.impl.TaskQueue.lambda$new$0(TaskQueue.java:60) ~[vertx-core-3.4.2.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_151]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_151]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_151]
16:15:08.813 [vert.x-worker-thread-8] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - CONNECTION ERROR OCCURRED!
16:15:08.814 [vert.x-worker-thread-8] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Resource com.mchange.v2.c3p0.impl.NewPooledConnection@260981cc marked broken by pool (com.mchange.v2.resourcepool.BasicResourcePool@23a8a9e4).
16:15:08.815 [vert.x-worker-thread-8] DEBUG oadd.com.dremio.exec.client.DremioClient - Cancelling query 257bad83-5b18-e269-6240-3df830d03c00
16:15:08.816 [C3P0PooledConnectionPoolManager[identityToken->z8kfsx9t15b5mb8x6wd0n|604e946b]-HelperThread-#1] DEBUG oadd.com.dremio.common.scanner.ClassPathScanner - Scanning classpath for resources with pathname “sabot-module.conf”.
16:15:08.817 [vert.x-worker-thread-8] DEBUG com.dremio.jdbc.impl.DremioCursor$ResultsListener - [#2] Query listener closing.
16:15:08.818 [C3P0PooledConnectionPoolManager[identityToken->z8kfsx9t15b5mb8x6wd0n|604e946b]-HelperThread-#1] DEBUG oadd.com.dremio.common.scanner.ClassPathScanner - - collected resource URL jar:file:/home/fgimenez/IdeaProjects/etourneau-micro-services4/microservice-dremio/src/lib/dremio-jdbc-driver-1.0.8.jar!/sabot-module.conf.
16:15:08.818 [vert.x-worker-thread-8] DEBUG com.dremio.jdbc.impl.DremioStatementRegistry - Removing from open-statements registry: com.dremio.jdbc.impl.DremioStatementImpl@324dc057
févr. 14, 2018 4:15:08 PM com.ovh.dc.etourneau.dremio.service.impl.DremioServiceImpl
INFOS: dremio failed querry dfeefded java.sql.SQLFeatureNotSupportedException
Blockquote

2

We do not support yet the Statement.getMoreResults() API, which causes your software to use. This is something we have on our radar (it also causes issues with DataGrip), but we don’t have an ETA for it yet.

If you are an enterprise-edition customer, I would encourage you to contact Dremio through your dedicated support portal to report and work with you on a possible timeline.

1 Like