driverClassName --- >com.microsoft.jdbc.sqlserver.SQLServerDriver
解决方案 »
- request.getRequestDispatcher转发页面出错。
- 关于DWR刷新List的问题
- 登录流程问题
- 每天都core dump 请高手帮忙
- 请问一下webwork2.2中怎样禁止在控制台不断输出的freemark的Debug信息?
- 请教一下...用jsp+java如何把文件传送到服务器中去....
- 求助,cannot create poolableconnectionfactory错误,各位帮帮忙
- EJB是否有数量限制?
- 在XPath中如何比较字符串?
- 为什么IE6不能正确的显示我的XML文件?
- java servlet的字节码文件究竟要放在Tomcat的哪里才能检测得到?
- fileload如何上传excel文件到一个服务器?
<Context path="/test" docBase="G:\test" debug="5" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_DBTest_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/SqlServerDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/SqlServerDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit.-->
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<!-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit.-->
<parameter>
<name>maxIdle</name>
<value>20</value>
</parameter>
<!-- Maximum time to wait for a dB connection to become available in ms, in this example 0.5 seconds. An Exception is thrown if this timeout is exceeded. Set to -1 to wait indefinitely. -->
<parameter>
<name>maxWait</name>
<value>500</value>
</parameter>
<!-- msSQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>sa</value>
</parameter>
<!-- Class name for SQLServer2000 JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<!-- The JDBC connection url for connecting to your MS SQL Server dB.The autoReconnect=true argument to the url makes sure that the mm.Sql Server JDBC Driver will automatically reconnect if mysqld closed the connection. mysqld by default closes idle connections after 8 hours.-->
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://ipAddress:1433;databaseName=test</value>
<!--must use & not use & -->
</parameter>
</ResourceParams>
</Context>