Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to add Firebird JDBC Driver to Oracle Data Integrator 12c

1683943Dec 4 2017 — edited Dec 4 2017

Hello,

we need to access data from Firebird Database (source) to intregrate with Oracle Database 12c (destiny) but the Firebird JDBC driver is not available in Oracle Data Integrator 12.2.1.3.0.

We are using jaybird-3.0.2.jar driver. Could you help us to add the Firebird JDBC driver ?

oracle.odi.runtime.agent.invocation.InvocationException: ODI-1274: Agent Exception Caused by: Could not initialize class org.firebirdsql.gds.ng.jna.FbClientDatabaseFactory$ClientHolder

at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:472)

at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)

at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:1152)

at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:664)

at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$9.doInBackground(SnpsDialogTestConnet.java:622)

at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)

at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)

at java.lang.Thread.run(Thread.java:745)

This post has been answered by Adrian_Popescu-Oracle on Dec 4 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 1 2018

Added on Dec 4 2017

#business-intelligence-applications, #data-integrator, #system-management-and-integration

6 comments

744 views