I'm building a custom processor where i need to execute PL/SQL Procedures with the help of DBCP Connection Pooling Controller Service. The custom processor which executes PL/SQL Procedures needs to connect to different Oracle Databases like 11g and Oracle 8i.
The Problem i'm facing here is that these oracle databases needs different ojdbc jars . For example Oracle 11g needs ojdbc7.jar and Oracle 8i needs ojdbc14.jar . The Custom processor needs ojdbc7.jar as maven dependency to execute complex Oracle jdbc types such as ARRAY ,STRUCT etc. When I load two dbcp controller services which uses different ojdbc.jar's for the same custom processor it is working for one oracle database but not for other. Detail Description. If I connect to Oracle Database 11g where i give diver location as ojdbc7.jar in dbcp controller service then its throwing an error saying " java.sql.Exception : can't wrapped connection to requested interface". To resolve this issue i added ojdbc7.jar in nifi lib folder and the error went. Now, when i connect to Oracle 8i with ojdbc14.jar in dbcp controller service.. It is throwing an error saying " ArrayOutOfBound Exception 7" . I guess it is trying to use incompatible jar which was given in the lib folder (ojdbc7.jar) . If I add ojdbc14.jar in the lib then earlier one is not working giving same error " java.sql.Exception : can't wrapped connection to requested interface". Could you please help me out there.. Not Sure how nifi classloader works .. Thanks in advance.... Regards, Nadeem -- Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/
