topic Re: How to connect with SSL enabled Oracle database in Talend Studio

How to connect with SSL enabled Oracle database

Anonymous — Sat, 16 Nov 2024 05:18:34 GMT

Can some help me how to get connect with SSL enabled Oracle database. I have trust store and keystore both with me. Please suggest

Re: How to connect with SSL enabled Oracle database

Anonymous — Thu, 11 Jul 2019 21:40:26 GMT

I already tried tSetkeytore and provide keyStore there and on Ok trigger making "useSSL=true" in Additional JDBC parameter in Toracleconnection. Its not working

Re: How to connect with SSL enabled Oracle database

Anonymous — Fri, 12 Jul 2019 20:42:26 GMT

Hi,

Can you make a screenshoot?

You can try to add in Additional JDBC parameter

"serverTimezone=UTC" and "requireSSL=false/true"

I hope it will help you

Re: How to connect with SSL enabled Oracle database

Anonymous — Fri, 12 Jul 2019 21:18:32 GMT

This is the error i am getting:

[statistics] connecting to socket on port 3760
[statistics] connected
Exception in component tOracleConnection_1 (abc)
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:266)
at

Re: How to connect with SSL enabled Oracle database

Anonymous — Fri, 12 Jul 2019 21:19:19 GMT

Its not working with even with this