Hello all. Please can someone give me some assista...
# troubleshooting
a
Hello all. Please can someone give me some assistance resolving this issue seen in my Flink logs?
Copy code
java.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:
Copy code
<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:
Copy code
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.
Fixed by including the driver jar in the flink container at runtime:
wget -P /opt/flink/lib/ <https://jdbc.postgresql.org/download/postgresql-42.6.0.jar>