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(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CConnection.logon(
at oracle.jdbc.driver.PhysicalConnection.<init>(
at oracle.jdbc.driver.T4CConnection.<init>(
at oracle.jdbc.driver.T4CDriverExtension.getConnection(
at oracle.jdbc.driver.OracleDriver.connect(
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 Source)
at Source)
at Source)
at$2(Unknown Source)
at$ Source)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(
at org.eclipse.swt.widgets.Display.runAsyncMessages(
at org.eclipse.swt.widgets.Display.readAndDispatch(
at org.eclipse.ui.internal.Workbench.runEventLoop(
at org.eclipse.ui.internal.Workbench.runUI(
at org.eclipse.ui.internal.Workbench.access$4(
at org.eclipse.ui.internal.Workbench$
at org.eclipse.core.databinding.observable.Realm.runWithDefault(
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(
at org.talend.rcp.intro.Application.start(Unknown Source)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(
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(
at org.eclipse.equinox.launcher.Main.basicRun(
Any ideas?
Community Manager

Re: Oracle connection problem via vpn

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

Talend | Data Agility for Modern Business
Four Stars

Re: Oracle connection problem via vpn

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
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 - 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!