Hello Colleagues,
I have a problem with connections to databases (ORACLE and AS/400/DB2 same behaviour).
I am on TOS 5.6.2. I create a DB Connection for ORACLE with SID as example. Press the check button leads to this error message:
Connection failure, check the database settings or contact your database administrator.
java.lang.RuntimeException: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:164)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1078)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:313)
at org.talend.repository.ui.utils.ManagerConnection.check(ManagerConnection.java:352)
at org.talend.repository.ui.utils.ManagerConnection.check(ManagerConnection.java:301)
at org.talend.repository.ui.wizards.metadata.table.database.SelectorTableForm$8.run(SelectorTableForm.java:1099)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3668)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:353)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:371)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:155)
... 6 more
No the weird thing is going on. Using the connection in a job works. I can connect to DB and request data by SQL. This works.
Technically I have checked everything I could imagine. Connection with same parameters in Squirrel works fine. Connection to IP/Port with telnet works fine.
Any idea what could be the problem and how I can fix this?
Many thanks
Roman
Hi Sir/Madam,
i am also facing the same oracle connection issue using Metadata. by using tOracleConnection under Palette the connection is establishing successfully but only by Repository -> Metadata the oracle is not connecting.
please do the needful.
thank you,
sravan kumar
Hi sravan kumar,
What is your Oracle version ?
In the Database wizard, did you choose the correct version for your oracle database ?
Did you try to connect oracle with sid?
Best regards
Sabrina
Was this ever resolved? It looks like it's still an open issue, which is disappointing because I'm having the same problem. I am able to connect to an Oracle database through the tOracleComponent, but using the same parameters in a DB Connection with either Oracle SID or Oracle service name results in a connection failure. It was the same error as described in the first post.
For the record, I am using Java 1.8 which is required for Talend for Data Integration version 6.1.1.
