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!
My results are the same as posted above. Have tried: 10g SID 10g ServiceName General jdbc-with ojdbc14.jar selected and oracle.jdbc.driver.OracleDriver. Also as others, SQL Plus connects as does Eclipse/j2ee. Please let me know when a fix is in. Thanks.
Hi... If I am not wrong. TOS 3.0.2 is having some problem in connective database. I was unable to connect to datbase (Oracle 10g). I downloaded TOS 3.0.3. Its working. Hope its helpful. - sangi
Hello, I used TOS 3.0.4 and TOS 3.0.5 but I have similar problem. I can connect to my database (Oracle 10 with service name) with TOAD or other software, but with TOS often I get this message: Exception in component tOracleConnection_3 java.sql.SQLException: Eccezione IO: The Network Adapter could not establish the connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:441) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) I say OFTEN because sometimes the connection works! But I really don't know why. Is there any way to setup the connection timeout? I tried from Preferences->Talend->Sql Builder but it seems that it doesn't work.
Thanks for your quick reaction.
I tried to download 3.1.4, but with branch 3.1.x (we tried also with 3.1.1) we have a problem with component tContextLoad, that is unfortunately used in all our jobs.
For this db, unfortunately we must connect with service name.
There are two instances of this db (in 2 different servers) because it is a load balanced one. But with a generic oracle client we can connect with both instances without problems.
The strange thing is that sometimes it works. I think it could be a connection timeout problem. Where can I modifiy (if possible) the connection timeout?
Regards.
