Alex Bryant
10/27/2023, 4:08 AMjava.sql.SQLException: No suitable driver found for jdbc:<postgresql://dev-api-tru.deeprec.local:5432/postgres>
at java.sql.DriverManager.getConnection(Unknown Source) ~[java.sql:?]
at java.sql.DriverManager.getConnection(Unknown Source) ~[java.sql:?]
In Maven I have:
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.6.0</version>
</dependency>
I'm setting up the connection to the database in my Flink job as such:
Properties properties = getDbProperties();
// Establish the connection
setConnection(
driverManagerWrapper.getConnection(
"jdbc:postgresql://"
+ properties.get("serverName")
+ ":"
+ properties.get("port")
+ "/"
+ properties.get("databaseName"),
properties.get("user").toString(),
properties.get("password").toString()));
Java version: 11
Postgres version: 15
Flink version: 1.17.1
Postgres driver version: 42.6.0
It's unlikely directly related to Flink. Any help would be appreciated.Alex Bryant
10/27/2023, 5:59 AMwget -P /opt/flink/lib/ <https://jdbc.postgresql.org/download/postgresql-42.6.0.jar>