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-

[Sukraj Raikhraj]

I agree with Michael, you need to find the exact version to match the driver or else it won't work.. Had similar issue with Hadoop /Hive.... 

[michaelslabodni]

I think you're correct on the driver version. I ran a test connection with a 3rd party app and noticed it was using a different version. I downloaded the correct one and now I think it's connecting. Man - what a crazy way to get this to work! All in all though, it's not as difficult as I thought it'd be.

[DrewW]

I just loaded the driver and that was it.  Adding all the other stuff seamed to break things.

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

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/import-sets/reference/r_JDBCTypeDataSource.html

I seam to remember there where some options I had to set on the connection URL but it will take me a bit to find it because they dropped the project and the app was removed from the system.

[michaelslabodni]

Got it. I think it came to running the incorrect driver version. Besides that, I followed the same documentation as described and it was pretty straightforward.

[_ChrisHelming]

Can you shed any more light on this? I'm using `com.amazon.redshift.jdbc42.Driver` as my "JDBC driver" in my JDBC Driver Connection and I have the JAR (redshift-jdbc42-2.1.0.7.jar) attached to an ecc_agent_jar record called Redshift but I keep getting a "No suitable driver" error.