Configure the connection pool (Oracle Database) under Tomcat)

Step 1: Open the context. xml file in the Apache Tomcat 6.0.35 \ conf directory and configure it under the context node as follows:

<Resource
Name = "JDBC/connection pool name"
Type = "javax. SQL. datasource"
Driverclassname = "oracle. JDBC. Driver. oracledriver"
Url = "JDBC: oracle: thin: @ localhost: 1521: orcl"
Username = "Scott" // User Name
Password = "Scott" Password
Maxidle= "2000"
Maxwait = "5000"
Maxactive = "1000"/>

Step 2: Open Server. XML in the directory of Apache Tomcat 6.0.35 \ conf. The configuration under the host node is as follows:

<Context Path = "/Module-customercare" reloadable = "true" crosscontext = "true"> </context> <! -- Path = "your project name" -->