OCI Oracle Custom Connection Error

Anonymous — Wed, 15 Jan 2014 09:23:01 GMT

Hello.
I use Talend for DI ver. 5.4.1.
When I try to make an Orracle OCI connection with a DB Type "Oracle OCI", I can connect correctly to my DB in Talend.
These are the parameters (Additional Parameters is empty):
DB Version : Oracle 11
Connection String : jdbc racle ci8:TESTDB
Login : tstLogin
Password : tstPassword
Local Service Name : TESTDB
Schema : JTLA
But if i try to connect using a DB Type "Oracle Custom" and putting the same parameters of the previously OCI connection I get an error
Parameters...
DB Version : Oracle 11
Login : tstLogin
Password : tstPassword
Connection String : jdbc racle ci8:TESTDB
Schema : JTLA
Error.... :

Connessione fallita. Devi cambiare le impostazioni del database
  java.lang.RuntimeException: java.lang.UnsatisfiedLinkError: Native Library C:\oracle\32bit\11.2.0\bin\ocijdbc11.dll already loaded in another classloader
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:179)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1034)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:300)
      at org.talend.repository.ui.utils.ManagerConnection.check(ManagerConnection.java:293)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm.checkConnection(DatabaseForm.java:2008)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm.access$39(DatabaseForm.java:1933)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$23.widgetSelected(DatabaseForm.java:2261)
      at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)
      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)
      at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
      at org.eclipse.jface.window.Window.open(Window.java:801)
      at org.talend.repository.ui.actions.metadata.CreateConnectionAction.doRun(CreateConnectionAction.java:207)
      at org.talend.repository.ui.actions.AContextualAction$2.run(AContextualAction.java:608)
      at org.talend.repository.RepositoryWorkUnit.executeRun(RepositoryWorkUnit.java:93)
      at org.talend.core.repository.model.AbstractRepositoryFactory.executeRepositoryWorkUnit(AbstractRepositoryFactory.java:237)
      at org.talend.repository.localprovider.model.LocalRepositoryFactory.executeRepositoryWorkUnit(LocalRepositoryFactory.java:3197)
      at org.talend.core.repository.model.ProxyRepositoryFactory.executeRepositoryWorkUnit(ProxyRepositoryFactory.java:1979)
      at org.talend.repository.ui.actions.AContextualAction.run(AContextualAction.java:617)
      at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
      at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
      at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
      at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)
      at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)
      at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
      at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
      at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
      at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)
      at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
      at org.talend.rcp.intro.Application.start(Application.java:145)
      at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:619)
      at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
      at org.eclipse.equinox.launcher.Main.run(Main.java:1407)
  Caused by: java.lang.UnsatisfiedLinkError: Native Library C:\oracle\32bit\11.2.0\bin\ocijdbc11.dll already loaded in another classloader
      at java.lang.ClassLoader.loadLibrary0(Unknown Source)
      at java.lang.ClassLoader.loadLibrary(Unknown Source)
      at java.lang.Runtime.loadLibrary0(Unknown Source)
      at java.lang.System.loadLibrary(Unknown Source)
      at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3506)
      at java.security.AccessController.doPrivileged(Native Method)
      at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3502)
      at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:252)
      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
      at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:148)
      at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
      at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:170)
      ... 48 more

Can you help me to solve the problem?
Is this a bug?
Thank you, Daniele

Re: OCI Oracle Custom Connection Error

Anonymous — Wed, 15 Jan 2014 22:45:55 GMT

It looks like a bug but why do you choose a connection type like this. Actually I would not use the OCI connector at all. Oracle provides with its JDBC driver a very fast type-4 driver with does not depend on any local Oracle client at all.
This makes the jobs much more flexible and easier to deploy to any server.

topic OCI Oracle Custom Connection Error in Talend Studio

OCI Oracle Custom Connection Error

Re: OCI Oracle Custom Connection Error