JDBC Driver not loaded - Amazon Redshift Database

[Gideon van Zyl1]

Hi,

I have a Redbase database in which a customer is keeping data that we want to import on a regular basis for their Change process.

The JDBC Driver is not supported by default, so I uploaded the Redshift JAR file for the MID server, and created a datasource with the specific Database type added (with the correct Driver Class correctly defined). 

I am however getting an error when I test the database and try to import the data from the Database:

MID Server reported error: java.sql.SQLException: com.snc.automation_common.integration.exceptions.InvalidConnectionParameterException: Unable to load JDBC driver: 

I have searched through the Community and docs server, and from all I can see my configuration is correct. 

Has anybody created a JDBC connection for Redshift, and if so, are there any gotchas you encountered? If so, How have you resolved them?

-Gideon-

[DrewW]

I kept getting this error until I used an older version of the RedShift driver.  I fairly sure the dropdown value you should use is based on the class the driver makes available.  So I think if you can figure that out you can just update it.

[_ChrisHelming]

Do you know what version you're currently using (it might save me some time going through all the point releases looking for one that works)?

[DrewW]

See one of my comments above

"The file I included was "RedshiftJDBC42-no-awssdk-1.2.50.1077.jar", then I just followed the steps here"