<ResourceParams name="jdbc/SqlDB">
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10</value>
</parameter>
<parameter>
<name>user</name>
<value>sa</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:microsoft:sqlserver://william:1433;databaseName=bluesite</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://william:1433;databaseName=bluesite</value>
</parameter>
<parameter>
<name>password</name>
<value/>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
</ResourceParams>
ResourceParams部分如是写就可以了。Tomcat的不同版本参数好像有点不同。web.xml中需要添加:
<resource-ref>
<description>Resource reference to a factory for java.sql.Connection instances that may be used for talking to a particular database that is configured in the server.xml file. </description>
<res-ref-name>jdbc/SqlDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10</value>
</parameter>
<parameter>
<name>user</name>
<value>sa</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:microsoft:sqlserver://william:1433;databaseName=bluesite</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://william:1433;databaseName=bluesite</value>
</parameter>
<parameter>
<name>password</name>
<value/>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
</ResourceParams>
ResourceParams部分如是写就可以了。Tomcat的不同版本参数好像有点不同。web.xml中需要添加:
<resource-ref>
<description>Resource reference to a factory for java.sql.Connection instances that may be used for talking to a particular database that is configured in the server.xml file. </description>
<res-ref-name>jdbc/SqlDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<description>Resource reference to a factory for java.sql.Connection instances that may be used for talking to a particular database that is configured in the server.xml file. </description>
<res-ref-name>jdbc/SqlDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
这段内容我也加了,还是说Cannot load JDBC driver class 'null'