[ 
https://issues.apache.org/jira/browse/DRILL-6712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16593760#comment-16593760
 ] 

Oleg Zinoviev edited comment on DRILL-6712 at 8/27/18 2:39 PM:
---------------------------------------------------------------

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.


was (Author: le.louch):
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)

Reply via email to