redshift driver cannot connect: IncorrectTypeException

[BaronWR]

Attempting to make a connection to a redshift instance with the standard redshift driver gives the following error:

SQLException: [Amazon](100021) Error setting default driver property values. GeneralException: [Amazon](100021) Error setting default driver property values. com.amazon.dsi.exceptions.IncorrectTypeException: IncorrectTypeException

Other databases seem to work fine.

[serge-rider]

Please post the error stacktrace (you can get it in Error Log view)

[BaronWR]

I don't see any errors in the error log. This issue occurs when I attempt to connect to redshift.

[serge-rider]

What driver (exact version) do you use?

[WillSidebottom]

@BaronWR did you ever find a solution to this? I'm having the same problem

[urbushey]

@BaronWR @WillSidebottom In case you are still having issues, I think that you may have made the same mistake I initially did when following the Amazon Redshift Getting Started directions step 5.

It says to grab the JDBC URL and copy it into your connection settings. If you just grab the URL, which looks like this:

jdbc:redshift://xxx.xx.us-east-1.redshift.amazonaws.com:5439/dev

it includes the jdbc:redshift:// as well as :5439/dev bit.

You need to take both of those out of your URL because DBeaver connection dialog adds them in. Basically verify that the read-only DBeaver "JDBC URL" matches the Redshift "JDBC URL" at the end of the day because it's easy to mess up.

[maleckicoa]

Thanks Urbushey,
that did the trick!

[FVDDEV]

Thanks Urbushey... worked like a wonder !! :)