tomcat configuration

Configuring a MySQL Datasource on Tomcat  Pre-requisite . Download MySQL JDBC Driver from: https://dev.mysql.com/downloads/connector/j/ In order to configure a Datasource on Tomcat for MySQL Database you need to follow these three simple steps: 1) Define the Datasource in server.xml Include a Datasource configuration in your Tomcat's server.xml file within the Context section, containing information about the JDBC URL, username and password and the maximum number of active connections allowed in the pool: < Resource name= " jdbc/MySQLDS " auth= " Container " type= " javax.sql.DataSource " username= " root " password= " admin " driverClassName= " com.mysql.jdbc.Driver " url= " jdbc:mysql://localhost:3306/schema " maxActive= " 15 " maxIdle= " 7 " defaultTransactionIsolation= " READ_COMMITTED " ...

Pre-requisite. Download Oracle JDBC Driver from: Oracle JDBC Drivers are available at Oracle Site: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html In order to configure a Datasource on Tomcat for Oracle Database you need to follow these three simple steps: 1) Define the Datasource in server.xml Include a Datasource configuration in your Tomcat's server.xml file within the Context section, containing information about the JDBC URL, username and password and the maximum number of active connections allowed in the pool: < Resource name= " jdbc/OracleDS " auth= " Container " type= " javax.sql.DataSource " username= " scott " password= " tiger " driverClassName= " com.mysql.jdbc.Driver " url= " jdbc:oracle:thin:@localhost:1521:test " maxActive= " 15 " maxIdle= " 7 " defaultTrans...