[
https://issues.apache.org/jira/browse/DRILL-6712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16593760#comment-16593760
]
Oleg Zinoviev commented on DRILL-6712:
--------------------------------------
I just try to create a new jdbc storage plugin:
{
"type": "jdbc",
"driver": "oracle.jdbc.OracleDriver",
"url": "jdbc:oracle:thin:@***",
"username": "***",
"password": "***",
"enabled": true
}
Drill response was "Please retry: Error while creating/ updating storage :
org.apache.commons.pool2.impl.GenericObjectPool.setTestOnCreate(Z)V"
All unit tests pass, so I am wondering how it slipped through.
Test classpath differs from bundled jars. Calcite 1.17.0 has it's own
commons-pool2 dependency (2.5.0 version:
https://mvnrepository.com/artifact/org.apache.calcite/calcite-core/1.17.0), but
drill java-exec has a commons-pool2:2.1 dependency.
> Creation of jdbc storage plugin fails with NoSuchMethod
> -------------------------------------------------------
>
> Key: DRILL-6712
> URL: https://issues.apache.org/jira/browse/DRILL-6712
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - JDBC
> Affects Versions: 1.15.0
> Reporter: Oleg Zinoviev
> Priority: Major
>
> Creation of jdbc-storage-plugin falis with:
> Caused by: java.lang.NoSuchMethodError:
> org.apache.commons.pool2.impl.GenericObjectPool.setTestOnCreate(Z)V
> at
> org.apache.commons.dbcp2.BasicDataSource.createConnectionPool(BasicDataSource.java:2224)
> ~[commons-dbcp2-2.4.0.jar:2.4.0]
> at
> org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2085)
> ~[commons-dbcp2-2.4.0.jar:2.4.0]
> at
> org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1525)
> ~[commons-dbcp2-2.4.0.jar:2.4.0]
> at
> org.apache.calcite.adapter.jdbc.JdbcUtils$DialectPool.get(JdbcUtils.java:78)
> ~[calcite-core-1.17.0-drill-r0.jar:1.17.0-drill-r0]
> at
> org.apache.calcite.adapter.jdbc.JdbcSchema.createDialect(JdbcSchema.java:184)
> ~[calcite-core-1.17.0-drill-r0.jar:1.17.0-drill-r0]
> at
> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin.<init>(JdbcStoragePlugin.java:101)
> ~[drill-jdbc-storage-1.15.0-SNAPSHOT.jar:1.15.0-SNAPSHOT]
> Reason:
> bundled dependency commons-pool2:2.1
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
