My Oracle Support Banner

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:

  1. Verify that the Cassandra DB is configured for SSL:

    cassandra.yaml
    # enable or disable client/server encryption.
    client_encryption_options:
      enabled: true


  2. Test connection from ODI Studio Topology
  3. 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.