Try to avoid registering more than one connector, the issue was obviously
caused by the duplicate connections which by default oracle will reuse the
existing registered connector.
Register the driver at runtime will solve the issue.
Ex:
// Oracle 7 connection
File chia = new File("/path/to/oracle7.jar");
URL[] cp = new URL[1];
cp[0] = chia.toURI().toURL();
URLClassLoader ora8loader = new URLClassLoader(cp,
ClassLoader.getSystemClassLoader());
Class drvClass = ora8loader.loadClass("oracle.jdbc.driver.OracleDriver");
Driver ora8driver = (Driver)drvClass.newInstance();
Properties props = new Properties();
props.setProperty("user", "chiablahblah");
props.setProperty("password", "mybankaccountpwd");
Connection ora8conn =
ora8driver.connect("jdbc:oracle:thin:@host:port:sid",props);
****/
Repeat the same blah above for 11g and you should be good.
/chia
--
Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/
