One Star

Oracle connection problem via vpn

When I click Guess Schema on a tOracleInput component I get a The Network Adapter could not establish the connection. The weird thing is I can create a connection with the same exact properties in the DBConnections in the Metadata section. I can also connect with TOAD, EntMan, and Sql Plus. I looked in the log and it has the following error:
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(Unknown Source)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(Unknown Source)
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController.checkConnection(Unknown Source)
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController.useMockJob(Unknown Source)
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController.openParamemerDialog(Unknown Source)
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController.access$2(Unknown Source)
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController$5.run(Unknown Source)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:133)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3800)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3425)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2382)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2346)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2198)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:493)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:288)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:488)
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:193)
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:382)
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:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
Any ideas?
3 REPLIES
Community Manager

Re: Oracle connection problem via vpn

Hello
Please report a bug with detailed info on our bugtracker.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: Oracle connection problem via vpn

Hello,
Can you specify your version of TOS please? And version of Oracle?
We have a similar issue on our bugtracker, fixed in version 3.1.1
http://www.talendforge.org/bugs/view.php?id=7147
Regards
One Star

Re: Oracle connection problem via vpn

I am seeing this exact same issue with Talend Open Studio version 3.2.1 build id r31371-20091020-0242 against:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
I can connect to the database outside of Talend from this host, I can create a connection under metadata and it works. I can even use sql builder from the component mode for the component I have created for this connection/schema/table space and the query returns data from the table, but I cannot "Guess schema" in order to get a clean, error free listing of the columns to use in my tMap interface. I don't see in this thread how this user got past the issue. Can someone point me to the answer please? Many thanks!