Talend OS - Oracle Database Connection - Cannot Retrieve Schema

Highlighted
One Star

Talend OS - Oracle Database Connection - Cannot Retrieve Schema

Hi

I'm working on creating an ETL process (I'm a beginner for TOS though). I went through the tutorials and was successful in reading data from a MySQL db and writing back to it. How ever, i actually wanted to read from oracle db and write to mysql. In doing that i set up a oracle DB connection and tried to retrieve the schema, it fails. (Connection test is successful. In addition, Sql developer shows me all the tables inside the schema for the same details)

Oracle DB - 11g (11.2) 64bit

I found following, when i searched through talend forge and blogs.

http://www.talendforge.org/bugs/view.php?id=6323 -> Exact problem i get. It says the issue is fixed in 3.x.x, however, i still get the same problem in TOS-Win32-r50363-V4.1.1 (Running on Windows 64Bit)

Then I found a recent post and a bug fix in the following

http://www.talendforge.org/bugs/view.php?id=15821 -> I tried the same in TOS-Win32-r52549-V4.2.0M1. But it also has the same issue. (Running on Windows 64Bit)

I'm not sure if i'm doing anything wrong.

FYI: Following is the Error shown in the Error Log

java.lang.reflect.InvocationTargetException
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:421)
at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:944)
at org.talend.repository.ui.wizards.metadata.table.database.SelectorTableForm.checkConnection(Unknown Source)
at org.talend.repository.ui.wizards.metadata.table.database.SelectorTableForm.initControlData(Unknown Source)
at org.talend.repository.ui.wizards.metadata.table.database.SelectorTableWizardPage.initControlData(Unknown Source)
at org.talend.repository.ui.wizards.metadata.table.database.DatabaseTableFilterWizardPage.getNextPage(Unknown Source)
at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:823)
at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:369)
at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3880)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3473)
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.AbstractCreateTableAction.handleWizard(Unknown Source)
at org.talend.repository.ui.actions.metadata.AbstractCreateTableAction.access$1(Unknown Source)
at org.talend.repository.ui.actions.metadata.AbstractCreateTableAction$1.runInUIThread(Unknown Source)
at org.eclipse.ui.progress.UIJob$1.run(UIJob.java:95)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3855)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3476)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.talend.rcp.intro.Application.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
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:368)
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:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
Caused by: java.lang.RuntimeException: java.sql.SQLException: Closed Connection: next
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.returnTablesFormConnection(Unknown Source)
at org.talend.repository.ui.wizards.metadata.table.database.SelectorTableForm$6.run(Unknown Source)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: java.sql.SQLException: Closed Connection: next
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:200)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.getTableNamesFromTables(Unknown Source)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.getTableNamesFromTablesForMultiSchema(Unknown Source)
... 3 more


Please help.

Thank you in advance.
Highlighted
One Star

Re: Talend OS - Oracle Database Connection - Cannot Retrieve Schema

Update:

I found another similar issue already fixed

http://www.talendforge.org/bugs/view.php?id=7147

Following the workaround mentioned there, i.e. choosing an older DB Version, worked for me (I chose Oracle 9 as the DB type where the back end database is 11g. Selecting Oracle 10 also didn't work)
Highlighted
One Star

Re: Talend OS - Oracle Database Connection - Cannot Retrieve Schema

Same problem with version 8.
But, it's fine when i change to version 9...
Highlighted
Community Manager

Re: Talend OS - Oracle Database Connection - Cannot Retrieve Schema

Hi
There was a [Bug] 18339 with oracle8 on v411.

Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads