Talend OS - Oracle Database Connection - Cannot Retrieve Schema

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.
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)
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...
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 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads