Hikaricp: support for redshift explicitly

[sharaf31]

Environment

HikariCP version: x.x.x
JDK version     : 1.8.0_111
Database        : Redshift
Driver version  : x.x.x

^{⚠️ Please verify that your issue still occurs on the latest version of HikariCP before reporting.}

Provide support for redshift

Have you searched the CLOSED issues already? How about checking stackoverflow?

[brettwooldridge]

@sharaf31 I don't know what this means. We have a lot of users who are using HikariCP with Redshift without issue.

[sharaf31]

I have been trying to use HikariCP with Spring boot 2. when i try to run the project i get below error
`*********
APPLICATION FAILED TO START

---

Description:

Failed to bind properties under '' to com.zaxxer.hikari.HikariDataSource:

Property: driverclassname
Value: com.amazon.redshift.jdbc41.Driver
Origin: "driverClassName" from property source "source"
Reason: Unable to set value for property driver-class-name

Action:

Update your application's configuration`

Here is my property file for spring boot
spring.datasource.driver-class-name=com.amazon.redshift.jdbc41.Driver spring.datasource.url=jdbc:redshift://xxxxx.redshift.amazonaws.com:5439/xxx spring.datasource.username=xxx spring.datasource.password=xxxx

[Danilo-Araujo-Silva]

@brettwooldridge , do you know where I can find a working code using Redshift with Hikari to perform insert on the database? I can retrieve results from the database but I had no success on inserts yet. Thanks in advance.

[brettwooldridge]

@Danilo-Araujo-Silva Redshift is just PostgreSQL, so it shouldn't be hard to find working configurations out on the internet.

Even though this old issue was related to failure recovery, the bug report includes a debug log that reveals the pool configuration. 👉 Note: that configuration contains a connectionTestQuery, it should no longer be needed with the latest PostgreSQL drivers.

You might also read this issue and verify that your driver versions are correct.

[Kyeongrok]

i have same issue too.

[brettwooldridge]

Try using the PostgreSQL 8.4 dialect. I also see that someone made a custom dialect — 2yrs old, may no longer apply.

Either way, this is a Hibernate/Redshift issue, not a HikariCP issue.

[Kyeongrok]

thank you brettwooldridge. i'll try that.