Thanks Koji. But giving a directory of multiple drivers is throwing an error
"can't load database driver " and i verified that with dbcp code and it
specifically checks for ".jar extension".
final ClassLoader classLoader =
ClassLoaderUtils.getCustomClassLoader(
locationString,
this.getClass().getClassLoader(),
(dir, name) -> name != null && name.endsWith(".jar")
);
Your alternative approach is what the problem i wrote earlier creating
multiple instances of dbcp service and making each point to different
version of drivers. The issue was below error for ojdbc7.jar ( oracle 11g)..
*java.sql.SQLException: Object does not wrap anything with requested
interface*
at oracle.jdbc.driver.OracleConnection.unwrap(OracleConnection.java:268)
at
org.apache.commons.dbcp.DelegatingConnection.unwrap(DelegatingConnection.java:553)
at
org.apache.commons.dbcp.DelegatingConnection.unwrap(DelegatingConnection.java:553)
It is not able to unwrap this connection to oracle.jdbc.OracleConnection (
*because im using createOracleArray method of this OracleConnection.class*
). For this i added dependent ojdbc7.jar into my maven build pom.xml . Still
I'm facing this issue....
Though it was working with junit testcases where i used dbcp as connection
service.
What could be the reason.. Please help
--
Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/
