Hi Nadeem, Did you try specifying a external directory instead of an exact jar location, then put multiple versions of Jar there? This way DBCPConnectionPool can utilize multiple jars. This would provide the similar effect with putting one in NiFi lib dir.
If that doesn't work, an alternative approach would be setup different DBCPConnectionPool instance per required JDBC driver version then switching those by some condition. I haven't tested above myself, so no guarantee, but just wanted to share my thoughts. Thanks, Koji On Thu, Dec 28, 2017 at 12:14 AM, Mohammed Nadeem <[email protected]> wrote: > Thanks Mark that really helps. But I'm facing below issue > > As you said i loaded drivers externally and it was successful for oracle8i > where i executed simple stored procedure and it is working fine but when i > try to execute stored procedure which has array type for Oracle 11g then im > getting this error ( can't wrap connection to oracle connection ) > > java.lang.AbstractMethodError: null > at > org.apache.commons.dbcp.DelegatingConnection.unwrap(DelegatingConnection.java:553) > ~[na:na] > at > org.apache.commons.dbcp.DelegatingConnection.unwrap(DelegatingConnection.java:553) > ~[na:na] > at > ExecuteProcedure.executeStoredProcedure(GE_Scon_ExecuteProcedure.java:584) > ~[na:na] > at ExecuteProcedure.onTrigger(GE_Scon_ExecuteProcedure.java:382) > ~[na:na] > > It can't unwrap the connection to oracle connection . Earlier i had resolved > this issue by placing ojdbc7.jar in my nifi-lib folder then it started to > work.. But as you said we should not place any jars in the nifi lib folder > .. > So now its giving this error. Please help here > > Thanks, > Nadeem > Software Engineering Specialist > > > > -- > Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/
