Hi - I am new to TOS and am hoping someone can point out what I have missed in the documentation and forums. I have been unable to create a database connection in TOS v3.0.2 to any of our Oracle databases (both v8.1.7 and v10.0.2). I can connect and explore schemas from TOP and standard Oracle tools but TOS consistently fails with "Io exception: Socket is not connected". I have reinstalled TOS but the problem persists. I have used both the FQDN and IP address for the host along with double quotes around the text values. The typical entry in the error log is: !ENTRY org.talend.libraries 4 0 2008-12-23 09:24:03.359 !MESSAGE 2008-12-23 09:24:03,359 ERROR org.talend.commons.exception.ExceptionHandler - Io exception: Socket is not connected !STACK 0 java.sql.SQLException: Io exception: Socket is not connected 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.(PhysicalConnection.java:344) at oracle.jdbc.driver.T4CConnection.(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) I would appreciate any help that can be offered. Thanks!
Hi,
You have to remove the double quotes character in the Wizard.
For Login, Password, Server, Database, etc...
Double quotes are importants in components properties; but it occurs troubles if you use with our Metadata Database wizard.
Best regards;
Hi Cantoine,
I tried originally to define the database connection without using the double quotes. When doing so I immediately get a slightly different error:
"Io exception: The Network Adapter could not estblish the connection"
I remain baffled by this as I can make a connection to this same database using the same properties using the Talend Open Profiler product.
I would appreciate any suggestions as to how I should proceed.
Thanks!
Hi, I have tried to connect to both an Oracle 8.1.7 instance using the Oracle 8 driver in the wizard, and a version 10.2 instance using the Oracle 10 driver in the wizard. The error is the same. Thank you for your continued interest.
Hi,
Have you tried with 'SID' and 'Service name' connection method?
Do you have no trouble to connect to your Oracle with your Oracle client?
Are you sure that your Oracle machine allow remote connection ? multiple simultaneous connections ?
Best regards.
Hi,
Yes, I have tried both methods. I can connect to the databases using TOAD and the Talend Open Profiler. The Oracle servers in questions already allow multiple, remote connections.
Thanks!
I am having the same exact problem as kpjim. I can connect with sql developer, sql plus etc but not with TOS. I have tried different things and get the same messages. Is there a solution for this issue? Thanks, SY
Can someone with knowledge of both Talend Open Profiler (TOP) and Talend Open Studio (TOS) explain the difference between their Oracle access methods? The fact that I can connect to multiple Oracle databases with TOP but not TOS suggests that the two products use different libraries/methods and that the solution to this problem is in those differences. Thanks!
When I try a straight oracle connection with either SID or service name nothing works. I tried removing the domain name and I got a socket error message instead of the
"Io exception: The Network Adapter could not estblish the connection". I too can connect with TOP and sqldeveloper etc but not with TOS. I am hoping for a solution soon...
