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?
3 REPLIES
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