Tomcat connection pool Configuration

MYySQL: ResourceauthContainernamejdbcnametypejavax. SQL. DataSourcedriverClassNamecom. mysql. jdbc. DrivermaxIdle50maxWait5000usernamerootpasswordurljdbc: mysql: 127.0.0.1: 3306 dbnameremo

MYySQL:

1. <Resource Auth="Container" Name="Jdbc/name" Type="Javax. SQL. DataSource"
2. DriverClassName="Com. mysql. jdbc. Driver" MaxIdle="50" MaxWait="5000"
3. Username="Root" Password=""
4. Url="Jdbc: mysql: // 127.0.0.1: 3306/dbname"
5. RemoveAbandonEd="TrUe" RemoveAbandonedTimeout="60" MaxActive="100" />

MSSQLSERVER:

1. <Resource Auth="Container" Name="Jdbc/name" Type="Javax. SQL. DataSource"
2. DriverClassName="Net. sourceforge. jtds. jdbc. Driver" MaxIdle="50" MaxWait="5000"
3. Username="Sa" Password=""
4. Url="Jdbc: jtds: sqLsErver: // 127.0.0.1: 1433/dbname; tds = 8.0; lastupDateCount = true"
5. RemoveAbandoned="True" RemoveAbandonedTimeout="60" MaxActive="100" />

Oracle:

1. <Resource Name="Jdbc/name" Auth="Container" Type="Javax. SQL. DataSource"
2. DriverClassName="Oracle. jdbc. driver. OracleDriver" MaxIdle="50" MaxWait="5000"
3. Username="User" Password=""
4. Url="Jdbc: oracle: thin: @ 127.0.0.1: 1521: Gname"
5. RemoveAbandoned="True" RemoveAbandonedTimeout="60" MaxActive="100"/>