Hi Nadeem, I think you can do very similar to Kafka implementation. For different version NIFI have two different processor for Kafka 10 and 11 “PublishKafka_0_10” and “PublishKafka_0_11”
Regards, Milan Das Sr. System Architect email: [email protected] <https://www.linkedin.com/in/milandas/> www.interset.com <http://www.interset.com/> On 12/27/17, 7:08 AM, "Mohammed Nadeem" <[email protected]> wrote: 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/
