java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/testdb

Question

Actually we are not using any DB pool in certain fucntionalities and we using JDBC to connect the postgres db,Currently the system in production and it was working without any issues but all of sudden we encountered following error.

Our configurations are fine because this error we got yesterday only.

java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/testdb
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)

Can anyone guess what is going on our production server?

Check to see if the file is still there on the application classpath, as Thilo suggested, something might have changed, server maintenance, accidental deletion, anything. Assuming this is a production server error, resolving the error takes priority I presume :) — Gyan
You have done mistake in db name and db URL . So please give the complete code — Ketan G

Jens Jens · Accepted Answer · 2015-03-20T10:58:39

0

votes

You have to download the postgresql driver and add it to your classpath.

java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/testdb

1 Answers