Unable To Connect To an SSL-Enabled Cassandra Database From ODI
(Doc ID 2425692.1)
Last updated on MARCH 11, 2021
Applies to:
Oracle Data Integrator - Version 12.2.1.2.6 to 12.2.1.3.0 [Release 12c]Information in this document applies to any platform.
Symptoms
On Oracle Data Integrator (ODI) 12.2.1.2.6 or 12.2.1.3.0, when trying to connect to a Cassandra DB configured with SSL, the test connection from ODI Studio hangs with the following error:
java.sql.SQLException: [FMWGEN][Cassandra JDBC Driver][Cassandra]Error establishing socket to host and port: <HOSTNAME>:<PORT>. Reason: null
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1258)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:204)
...
Caused by: java.sql.SQLException: [FMWGEN][Cassandra JDBC Driver][Cassandra]Error establishing socket to host and port: <HOSTNAME>:<PORT>. Reason: null
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:228)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
...
Caused by: java.sql.SQLNonTransientConnectionException: [FMWGEN][Cassandra JDBC Driver][Cassandra]Error establishing socket to host and port: <HOSTNAME>:<PORT>. Reason: null
at weblogic.jdbc.cassandrabase.ddce.a(Unknown Source)
at weblogic.jdbc.cassandrabase.ddce.a(Unknown Source)
at weblogic.jdbc.cassandrabase.ddce.a(Unknown Source)
at weblogic.jdbc.cassandracloud.ddq.a(Unknown Source)
at weblogic.jdbc.cassandracloud.ddq.a(Unknown Source)
at weblogic.jdbc.cassandra.CassandraImplConnection.a(Unknown Source)
at weblogic.jdbc.cassandrabase.BaseConnection.b(Unknown Source)
at weblogic.jdbc.cassandrabase.BaseConnection.m(Unknown Source)
at weblogic.jdbc.cassandrabase.BaseConnection.f(Unknown Source)
at weblogic.jdbc.cassandrabase.BaseConnection.a(Unknown Source)
at weblogic.jdbc.cassandrabase.BaseDriver.connect(Unknown Source)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:412)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:385)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:352)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:331)
... 6 more
Caused by: weblogic.cassandracloud.sql.ddai: Error establishing socket to host and port: <HOSTNAME>:<PORT>. Reason: null
at weblogic.cassandracloud.sql.ddbm.<init>(Unknown Source)
at weblogic.cassandracloud.sql.ddbm.a(Unknown Source)
... 17 more
The issue can be reproduced at will with the following steps:
- Verify that the Cassandra DB is configured for SSL:
cassandra.yaml
# enable or disable client/server encryption.
client_encryption_options:
enabled: true - Test connection from ODI Studio Topology
- View that without a timeout value, the connection hangs.
Changes
The Cassandra DB is configured for SSL.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |