Tomcat利用JNDI配置DataSource

• conf/server.xml配置如下

<GlobalNamingResources>
  <!-- Editable user database that can also be used by
       UserDatabaseRealm to authenticate users
  -->
  <Resource name="UserDatabase" auth="Container"
            type="org.apache.catalina.UserDatabase"
            description="User database that can be updated and saved"
            factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
            pathname="conf/tomcat-users.xml" />

  <!-- 添加以下配置-->
  <Resource name="jdbc/Test"
          auth="Container"
          type="javax.sql.DataSource"
          username="xxxxxx"
          password="xxxxxx"
          driverClassName="oracle.jdbc.driver.OracleDriver"
          url="jdbc:oracle:thin:@127.0.0.1:1521:orcl"
          maxActive="8"
          maxIdle="4"/>
</GlobalNamingResources>

<!-- 添加以下配置-->
<Context path="/xxx" docBase="D:\projects\xxx\WebContent" reloadable="true">
    <ResourceLink 
           name="jdbc/Test"
           global="jdbc/Test"
           type="javax.sql.DataSource"/>
</Context>

• 在Java中通过以下代码得到DataSource对象

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;

Context initCtx;
DataSource ds = null;
try {
    initCtx = new InitialContext();
    ds = (BasicDataSource) initCtx.lookup("java:/comp/env/jdbc/Test");
} catch (NamingException e) {
    e.printStackTrace();
}