Be careful when upgrading Tomcat on a Web system using Oracle

Disclaimer

Even if I googled, only English was a hit, so it is a memo writing level record.

Premise

--Database is Oracle --The server you are currently using is Tomcat 7 or lower --The JDBC driver you are using now is ojdbc6.jar

Thing you want to do

I want to upgrade Tomcat from 7 to 8.5 or 9.0

Error message

java.lang.AbstractMethodError: oracle.jdbc.driver.T4CConnection.getSchema()Ljava/lang/String; 

Cause

--Java 7 or higher is required from Tomcat 8. --In Java 7, the getSchema () method has been added to the Connection class, and it is used by Tomcat's connection pool (dbcp2). --The jdbc driver for Java 7 is ojdbc7.jar

Correspondence

Throw ojdbc7.jar (or the latest jdbc driver) into the tomcat lib folder

Recommended Posts

Be careful when upgrading Tomcat on a Web system using Oracle
Be careful when using multiple articles
Be careful when using rails_semantic_logger with unicorn
Be careful of initialization timing when using MessageEncryptor with Rails 5.2 / 6.0
Things to think about when deciding on a new system architecture
[Spring Boot] Precautions when developing a web application with Spring Boot and placing war on an independent Tomcat server
Create a tomcat project using Eclipse
Using a local network on iOS 14
Clone your own web app on GitLab when building a Docker image
A memorandum when IME cannot be turned on with VS Code (Ubuntu 20.04)