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!
Hello
About tContextLoad component, please read the user documentation, there is a demo.
About connection timeout, you can go to Window--.Preference--.talend-->Performance and set the connectin timeout time or uncheck this option.
If it is still no use, download the latest version or update the JDBC jar.
Best regards
Hello, Finally, we tried changing connection configuration as you suggested (using SID instead of Service Name) and it worked well!!! Before, we tried changing jdbc driver and upgrading to 3.1.4 but without success (however now we can appreciate your latest version 3.1.4.... we found a simple workaround for the different behaviour of tContextLoad component in 3.1.x branch). many thanks for your precious help! Best Regards.
Beginner user of Talend OpenStudio here with similar / the same problem as above: Oracle service connection successful with other clients (for example SQL Developer from Oracle) but not w/Talend tOracleConnect component. We have made multiple Oracle SID connections to other databases via tOracleConnect.
We need to be able to connect to this Oracle instance as a *service*, and to connect to Oracle services generally. This particular source is a large scale enterprise DB. Getting it made available as a SID is non-trivial. We are also pursuing multiple (dozens) of integrations with Oracle sources or destinations while the organization is moving over time to make all Oracle resources available as Services, so the inability to connect to Services will hurt us badly.
I'm pretty sure I'm missing something basic here.
Tech Environment:
- Talend 3.2.0 (I see not changes to the Oracle connect component associated with 3.2.1)
- JDK 1.6.0_16 (from Sun.)
- All "thin" drivers (No OCI).
- Oracle InstantClient also installed on client machine.
- Client is Windows XP, current patch level.
- Going after the "spare" in a hot-standby configuration of an 10.x or 11.x Oracle DB - we're getting that last bit defined
Component Configurations:
We are configuring the connection component directly, *not* using a metadata item. Some of the things I've tried within OpenStudio ...
- Accept entries from existing "tsnames.ora" file. This works with SQL Developer and fails with the Talend component.
- Configuring the componenet by hand (no tnsnames.ora) the job won't build without quotes around the configuration items- reports symbols that won't resolve.
- Configuring the component by hand, (no tnsnames.ora) the job with quotes around the configuration items will build. ("With quotes" configuration in third screen shot.)
- Jobs that build report at run time a "service not available" initial error:
" connecting to socket on port 3577
connected Exception in component tOracleConnection_1
java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress ..."
The service is there. I think this is a more general "failure to register" thing, misreported. Looking for guidance on what to investigate first. I can't post screen shots of the actual credentials here.
OpenStudio Investigations:
- Can I make OpenStudio dump the JDBC driver it's binding the component to? Or where to find that? There are multiples installed on this client machine.
- Can I make OpenStudio or the component dump the connect string it is outputting?
- Can I back into determining which one it is using, if necessary by removing drivers until the job fails differently.
Brodder Investigations:
- Logging from the JDBC driver to see the *exact* connect string being presented from the OpenStudio generated job?
- Ditto to see the client apps using the driver. Possibly load information from the JVM will do this. Theory is maybe SQL Developer and Talend are using different drivers & there's a problem with one.
- There are some reports in the wild of version-dependent errors in theoretically compatible Oracle JDBC drivers & Oracle server versions in the 10x / 11x generations.)
I can't be the only person who's having this issue. Any help appreciated.
shong explained what to do in order to get Oracle connections to work
About connection timeout, you can go to Window / Preferences ... / Talend / Performance and set the connection timeout time or uncheck this option.
Running TOS 3.2.2 and trying to connect to Oracle 10g, I unchecked the "Activate the Timeout for the Database Connection" preference option, and then my Oracle connections worked fine, either as a SID or a service.
Before I unchecked that option, I consistently got immediate connection failures as follows:
"Connection Failure. You must change the Database Settings."
The details said:
"Io exception: The Network Adapter could not establish the connection."
So, if you can't connect to oracle, uncheck "Activate the Timeout for the Database Connection"
Still no luck even if I unchecked it. By the way, I was able to connect locally in my XE. Although I can connect to external DB using SQL developer/TOAD. this is one is really tough.. any help from you guys is much appreciated. Thanks... God Bless...
I have error to connect with database
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:275)
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!
