Tomcat5.0.28+SQL Server2000连接池配置,在网上的资料是不少,可是怎么写的都不一样啊,我都看晕了,到底应该怎么配置啊,哪位高手给个详细的说明吧,我都弄了大半天了也没能弄好,刚接触这东西实要配置的东西太多了,实在是晕了,请高手们帮帮忙吧,感激不尽!!!

解决方案 »

  1.   

    <Context path="/hyerp" reloadable="true" docBase="D:\tomcat-5.0.28\webapps\hyerp" >
    <Resource name="jdbc/hyerp" scope="Shareable" type="javax.sql.DataSource"/>
              <ResourceParams name="jdbc/hyerp">
                <parameter>
                  <name>url</name>
                  <value>jdbc:microsoft:sqlserver://10.7.4.3:1433;databaseName=hyerp</value>
                </parameter>
                <parameter>
                  <name>password</name>
                  <value>hyerp</value>
                </parameter>
                <parameter>
                  <name>maxActive</name>
                  <value>20</value>
                </parameter>
                <parameter>
                  <name>maxWait</name>
                  <value>5000</value>
                </parameter>
                <parameter>
                  <name>driverClassName</name>
                  <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
                </parameter>
                <parameter>
                  <name>username</name>
                  <value>hyerp</value>
                </parameter>
                <parameter>
                  <name>maxIdle</name>
                  <value>5</value>
                </parameter>
              </ResourceParams>
    </Context>
    这是我项目里面的连接池的配置,错不了的,你照着改改路径和用户名、密码就好了