[Amazon](600000) Error setting/closing connection. General SSLEngine problem

Product: StreamSets Data Collector pipelines

Issue

When trying to connect to an Amazon RDS database with a JDBC producer or consumer stage, the stage throws the following error

[Amazon](600000) Error setting/closing connection. General SSLEngine problem

Solution

When multiple JDBC drivers are installed to a Data Collector, JDBC will attempt to load the correct driver class based on the connection string. In cases where JDBC finds more than one driver that is compatible with a connection string, it will choose the driver based on the sorting-order of the SDC ClassLoader.

You can specify to the JDBC stage precisely which JDBC driver to use:

1. In the JDBC stage configuration select "Advanced Options"
2. Switch to the "Legacy Drivers" tab
3. Enter the correct JDBC driver class into the "JDBC Driver Class Name"

Example

If you are connecting to your RDS PostgreSQL database, you can force JDBC to use the PostgreSQL driver by specifying org.postgresql.Driver in the JDBC Driver Class field.