During the upgrade process, review the JDBC jar file that is installed to ensure that it is using the latest one available for the Database and JDK being used.
-
Remove the existing JDBC jar file from the ...\Program Files\Apache Software Foundation\Tomcat\lib folder.
-
Locate the correct JDBC jar file and copy the correct database JDBC driver into ...\Program Files\Apache Software Foundation\Tomcat\lib folder.
-
For Microsoft SQL Server, to view the supported versions of Microsoft SQL JDBC Driver, go to https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver16 along with Support Matrix against Java Version and SQL Database version.
-
To download the latest jar file that is compatible with the JDK Version and Database version being used, go to https://learn.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver16#previous-releases and place the jar file in the ...\Program Files\Apache Software Foundation\Tomcat\lib folder.
-
-
For Oracle databases, to view the supported version of the ORACLE JDBC, go to https://www.oracle.com/in/database/technologies/appdev/jdbc-downloads.html
-
Download the latest jar file that is compatible with the JDK Version and Database version being used from the page and the jar file in the ...\Program Files\Apache Software Foundation\Tomcat\lib folder.
-
-