用tomcat的DBManager或手动如下
<Context path="" docBase="ROOT" debug="0"
                 reloadable="true" crossContext="true">
          <Logger className="org.apache.catalina.logger.FileLogger"
                     prefix="localhost_examples_log." suffix=".txt"
           timestamp="true"/>
          <Ejb   name="ejb/EmplRecord" type="Entity"
                 home="com.wombat.empl.EmployeeRecordHome"
               remote="com.wombat.empl.EmployeeRecord"/>          <Environment name="maxExemptions" type="java.lang.Integer"
                      value="15"/>
          <Parameter name="context.param.name" value="context.param.value"
                     override="false"/>
          <Resource name="jdbc/SqlServerDB" auth="Container"
                    type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/SqlServerDB">
            
            <parameter>
   <name>maxActive</name>
   <value>100</value>
</parameter>
    <parameter>
   <name>maxIdle</name>
   <value>60</value>
</parameter>
            <parameter>
   <name>maxWait</name>
   <value>10000</value>
</parameter>
<!--
    <parameter>
   <name>removeAbandoned</name>
   <value>true</value>
</parameter>
      <parameter>
   <name>removeAbandonedTimeout</name>
   <value>60</value>
</parameter>
    <parameter>
   <name>logAbandoned</name>
   <value>false</value>
</parameter>
-->
    <parameter>
   <name>factory</name>
   <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
    <parameter>
<name>username</name><value>sa</value>
</parameter>
            <parameter>
<name>password</name><value>密码</value>
</parameter>
            <parameter>
<name>driverClassName</name>
              <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
            <parameter>
<name>url</name>
              <value>jdbc:microsoft:sqlserver://IP地址:1433;DatabaseName=数据库名</value>
</parameter>
          </ResourceParams>
          <Resource name="mail/Session" auth="Container"
                    type="javax.mail.Session"/>
          <ResourceParams name="mail/Session">
            <parameter>
              <name>mail.smtp.host</name>
              <value>localhost</value>
            </parameter>
          </ResourceParams>
          <ResourceLink name="linkToGlobalResource" 
                    global="simpleValue"
                    type="java.lang.Integer"/>
        </Context>