Configure Connection Pooling With Apache Tomcat (Doc ID 454425.1)

Last updated on AUGUST 03, 2016

Applies to:

JDBC - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 09-July-2013***


Symptoms

The following errors occur when attempting to make a data source connection in Apache Tomcat using Oracle JDBC drivers:

ERROR :-
HTTP Status 500 -

type Exception report

Message :-
description The server encountered an internal error () that prevented it from fulfilling this
request.

Exception :-
javax.servlet.ServletException: Cannot create JDBC driver of class 'oracle.jdbc.OracleDriver'
for
connect URL 'jdbc:oracle:thin@127.0.0.1:1521:DZINOV8'
DZTest.service(DZTest.java:59)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

Root causes :-
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class
'oracle.jdbc.OracleDriver' for connect URL 'jdbc:oracle:thin@127.0.0.1:1521:DZINOV8'
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
common.DBConnectionMgr.openDBConnectionApache(DBConnectionMgr.java:54)
DZTest.service(DZTest.java:53)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
...
java.sql.SQLException: No suitable driver
java.sql.DriverManager.getDriver(DriverManager.java:243)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
common.DBConnectionMgr.openDBConnectionApache(DBConnectionMgr.java:54)
DZTest.service(DZTest.java:53)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)



Reproducibility :
Click here to see steps that reproduces the above error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms