<?xml version="1.0" encoding="UTF-8"?>
<Context path="/wmj_blog" privileged="true">
<!--access-->
  <Resource 
        name="jdbc/blog" 
        type="javax.sql.DataSource" 
        driverClassName="sun.jdbc.odbc.JdbcOdbcDriver" 
        url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=e:/wmj_blog.mdb"/>
<!--oracle-->
  <Resource 
        name="jdbc/comm" 
        type="javax.sql.DataSource" 
        driverClassName="oracle.jdbc.driver.OracleDriver" 
        url="jdbc:oracle:thin:dangdang/dangdang@192.168.201.153:1521:TESTDB"/>
<!--sqlserver-->
  <Resource 
        name="jdbc/wengmj" 
        type="javax.sql.DataSource"
        auth="Container"
        driverClassName="net.sourceforge.jtds.jdbc.Driver" 
        url="jdbc:jtds:sqlserver://192.168.200.48:1433/wengmj_dev"
        username="wengmj"
        password="123456"
        maxIdle="2"
        maxWait="5000"
        maxActive="4"/>
<!--mysql-->
  <Resource 
        name="jdbc/wengmj" 
        type="javax.sql.DataSource"
        auth="Container"
        driverClassName="com.mysql.jdbc.Driver" 
        url="jdbc:mysql://localhost:3306/wengmj_development"
        username="root"
        password=""
        maxIdle="2"
        maxWait="5000"
        maxActive="4"/>
</Context>

driver jar : sqlserver mysql