数据源的配置

其实各个数据库的数据源配置类似， 通过driverClassName, url来进行设置。

数据源的配置：

context:

<Context reloadable="true">
  <Resource
           name="jdbc/oracle"
           type="javax.sql.DataSource"
           password="train"
           driverClassName="oracle.jdbc.driver.OracleDriver"
           maxIdle="10"
           maxWait="50"
           username="train"
           url="jdbc:oracle:thin:@192.168.212.42:1521:test"
           maxActive="10"/>
</Context>

 

调用数据源来配置DBPool：

try {

env = (Context) new InitialContext().lookup("java:comp/env");

pool = (DataSource) env.lookup("jdbc/oracle");

System.err.println("'DBPool' is an known DataSource");

if (pool == null)

System.err.println("'DBPool' is an unknown DataSource");

} catch (NamingException ne){

ne.printStackTrace();

}