Very long time for retrieving Oracle Schema with Oracle JDBC driver

Anonymous — Sat, 16 Nov 2024 13:10:01 GMT

Hi everybody,
I'm using Talend Studio 4.1 and I have a pb with the retrieving schema function on my oracle connection.
I'm using Oracle 8 and when I want to retrieve the schema it's very very very long.
I see in the workspace log this message :
!SESSION 2010-12-29 08:55:15.516 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_21
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=fr_FR
Command-line arguments: -os win32 -ws win32 -arch x86_64
!ENTRY org.talend.libraries 1 0 2010-12-29 08:55:49.819
!MESSAGE 2010-12-29 08:55:49,809 INFO org.talend.repository.model.ProxyRepositoryFactory - mybets@laposte.net logged on DECISIONNEL_B4

!ENTRY org.talend.libraries 4 0 2010-12-29 08:58:51.080
!MESSAGE 2010-12-29 08:58:51,070 ERROR org.talend.commons.exception.ExceptionHandler - ORA-00942: Table ou vue inexistante

!STACK 0
java.sql.SQLException: ORA-00942: Table ou vue inexistante
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1819)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2004)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:571)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.extractTablesFromDB(Unknown Source)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.returnTablesFormConnection(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(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
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)
!ENTRY org.talend.libraries 4 0 2010-12-29 09:06:59.677
!MESSAGE 2010-12-29 09:06:59,677 ERROR org.talend.commons.exception.ExceptionHandler - ORA-00942: Table ou vue inexistante

!STACK 0
java.sql.SQLException: ORA-00942: Table ou vue inexistante
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1819)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2004)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:571)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.extractTablesFromDB(Unknown Source)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.returnMetadataColumnsFormTable(Unknown Source)
at org.talend.repository.ui.wizards.metadata.table.database.SelectorTableForm$RetrieveColumnRunnable.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Any idea?

Re: Very long time for retrieving Oracle Schema with Oracle JDBC driver

_AnonymousUser — Wed, 29 Dec 2010 09:05:51 GMT

Hi,
if ORA-00942 error comes in Oracle thaen it means the Table name which you have specified does not exist in database

Regards,
Vijay.M

Re: Very long time for retrieving Oracle Schema with Oracle JDBC driver

Anonymous — Wed, 29 Dec 2010 09:54:19 GMT

Tks for your reply, but I don't specify any table name, I try to retrieve the list of all table of my Oracle schema.
I just click on the "retrieve schema" choice on the contextual menu of my metadata dbconnection.
After a very long time, the list of my tables in my schema is present.
If I select one of these tables to retrieve the list of columns, Talend takes 20 minutes to recover (even on a table with 2 columns of 5 records)
Maybe it is my Oracle schema that is rotten

Re: Very long time for retrieving Oracle Schema with Oracle JDBC driver

_AnonymousUser — Wed, 22 Jun 2011 10:16:50 GMT

Empty the recycle bin and try retrieving schema...it'll work fine

topic Very long time for retrieving Oracle Schema with Oracle JDBC driver in Talend Studio

Very long time for retrieving Oracle Schema with Oracle JDBC driver

Re: Very long time for retrieving Oracle Schema with Oracle JDBC driver

Re: Very long time for retrieving Oracle Schema with Oracle JDBC driver

Re: Very long time for retrieving Oracle Schema with Oracle JDBC driver