Very long time for retrieving Oracle Schema with Oracle JDBC driver

One Star

Very long time for retrieving Oracle Schema with Oracle JDBC driver

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?
One Star

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

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
One Star

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

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
One Star

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

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