PostgreSQL: "java.sql.SQLException: No suitable driver found"
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
JIRA setup wizard in browser throws "No suitable driver found" error when attempting to connect to PostgreSQL database
Cause
There are two possible causes for this error.
- JDBC driver is not loaded:
Ensure that the PostgreSQL driver is located in the correct directory which should be in "JIRA Install/lib".Usually this is not an issue as the driver is bundled along with JIRA. - JDBC URL is in wrong syntax:
Entering the wrong JDBC URL syntax will also throw the same error, as illustrated in this example below where http:// protocol is accidentally specified when copy & pasting the hostname.