connecting to redshift with amazon driver

[Alan Nichol]

if I try and connect as follows: 

(I'm coding in Scala)



 

    val dataSource: DataSource = { 

      val ds = new HikariDataSource() 

      ds.setDataSourceClassName("com.amazon.redshift.jdbc41.Driver") 

      ds.addDataSourceProperty("url", url) 

      ds.addDataSourceProperty("user", user) 

      ds.addDataSourceProperty("password", pw) 

      ds 

    }

I get the error:

cannot cast com.amazon.redshift.jdbc41.Driver to javax.sql.DataSource







Do I need to switch to a vanilla postgres driver?







[Nitin Chauhan]

you are passing 'driver' name for method that expects 'datasource'.

try:

HikariDataSource ds = new HikariDataSource();
ds.setJdbcUrl("jdbc:redshift://server:port/database");
ds.setUsername(username);
ds.setPassword(password);

[Brett Wooldridge]

Nitin is correct.  I can also tell you that Redshift is known to be working with HikariCP, so whatever issues you might encounter are likely to be configuration related rather than a problem with HikariCP.