Issue installing Postgres on Tomcat 9 with Reportserver

Programming
, ,
1

I’m trying to install Reportserver under Tomcat 9 with PostgreSQL. After running the Tomcat server, I’m encountering the following error:

11:35:51.451 ERROR n.d.r.c.s.i.InternalDbStartup - Error in Internal DB Startup
java.lang.RuntimeException: java.sql.SQLException: No suitable driver

The DB Config and PAM Configuration are as follows:

DB Config:

hibernate.dialect: net.datenwerke.rs.utils.hibernate.PostgreSQLDialect (OK)
hibernate.connection.driver_class: org.postgresql.Driver (OK)
hibernate.connection.url: jdbc:postgresql://localhost:5432/reportserver (OK)
hibernate.connection.username: ****_user
hibernate.connection.password: ********
hibernate.default_schema: 
Connection Test: OK
Schema Version: RS3.0-14

Application Server: Apache Tomcat/9.0.30

PAM Configuration

Static PAM configuration: 
    net.datenwerke.rs.authenticator.service.pam.UserPasswordPAMAuthoritative
Finalized PAM configuration: class 
    net.datenwerke.rs.authenticator.service.pam.UserPasswordPAMAuthoritative

I added the postgresql-42.2.9.jre7.jar to the lib folder on the ROOT folder, but the issue remains. Does anyone have any clues?

2

The error message “java.sql.SQLException: No suitable driver” suggests that the JDBC driver for PostgreSQL is missing or not loaded properly. Make sure that the postgresql-.jar file is located in the correct directory (usually the lib folder under the Tomcat installation directory) and that it is added to the classpath of the application.

If the driver file is already in the correct location, try restarting Tomcat to ensure that it is loaded properly. If the issue persists, you can also try adding the following code before establishing a connection to the database:

Class.forName("org.postgresql.Driver");

This explicitly loads the PostgreSQL JDBC driver class and may help resolve the issue.