oracle

File : context.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/PROJ">
    <Resource name="jdbc/myOracle" auth="Container"
              type="javax.sql.DataSource"
              driverClassName="oracle.jdbc.driver.OracleDriver"
              url="jdbc:oracle:thin:@localhost:ABCDEF"
              username="incpkg" password="incpkg"
              maxActive="50"
              maxIdle="5"
              minIdle="0"
              maxWait="-1"
              testWhileIdle="true"
              poolPreparedStatements="true"
              maxOpenPreparedStatements="100"
              validationQuery="SELECT SYSDATE FROM DUAL"
              rollbackOnReturn="true"
              timeBetweenEvictionRunsMillis="30000"
              minEvictableIdleTimeMillis="55000"
              removeAbandoned="true"
              removeAbandonedTimeout="55"
              factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
    />
</Context>

--------------------------------------------------------------------------------------
file : tnsnames.ora

ABCDEF =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.4.2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ABCDEF)
    )
  )
-------------------------------------------------------------