3个驱动我都拷贝到WEB-INF/lib里面去了
==========下面是struts-config.xml代码==================================
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.1//EN" "http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd"><struts-config>
<data-sources >
<data-source key="sql" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="password" value="sa" />
<set-property property="minCount" value="" />
<set-property property="maxCount" value="" />
<set-property property="user" value="sa" />
<set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<set-property property="description" value="" />
<set-property property="url" value="jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=Prod" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
<set-property property="loginTimeout" value="" />
</data-source> </data-sources> <form-beans >
<form-bean name="loginForm" type="com.user.struts.form.LoginForm" /> </form-beans> <global-exceptions />
<global-forwards />
<action-mappings >
<action
attribute="loginForm"
input="/login.jsp"
name="loginForm"
path="/login"
type="com.user.struts.action.LoginAction">
<forward name="error" path="/error.jsp" />
<forward name="success" path="/success.jsp" />
</action> </action-mappings> <message-resources parameter="com.user.struts.ApplicationResources" />
</struts-config>
===================================
==========下面是struts-config.xml代码==================================
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.1//EN" "http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd"><struts-config>
<data-sources >
<data-source key="sql" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="password" value="sa" />
<set-property property="minCount" value="" />
<set-property property="maxCount" value="" />
<set-property property="user" value="sa" />
<set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<set-property property="description" value="" />
<set-property property="url" value="jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=Prod" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
<set-property property="loginTimeout" value="" />
</data-source> </data-sources> <form-beans >
<form-bean name="loginForm" type="com.user.struts.form.LoginForm" /> </form-beans> <global-exceptions />
<global-forwards />
<action-mappings >
<action
attribute="loginForm"
input="/login.jsp"
name="loginForm"
path="/login"
type="com.user.struts.action.LoginAction">
<forward name="error" path="/error.jsp" />
<forward name="success" path="/success.jsp" />
</action> </action-mappings> <message-resources parameter="com.user.struts.ApplicationResources" />
</struts-config>
===================================
<data-source key="sql" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="password" value="sa" />
<set-property property="minCount" value="" />
<set-property property="maxCount" value="" />
<set-property property="user" value="sa" />
<set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<set-property property="description" value="" />
<set-property property="url" value="jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=Prod" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
<set-property property="loginTimeout" value="" />
</data-source>
</data-sources>
============================
這一塊好像配置的不對。
改成這樣試試:
<data-sources >
<data-source key="sql" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="url" value="jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=Prod" />
<set-property property="username" value="sa" />
<set-property property="password" value="sa" />
<set-property property="maxActive" value="10" />
<set-property property="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<set-property property="defaultReadOnly" value="false" />
<set-property property="defaultAutoCommit" value="false" />
</data-source>
</data-sources>
还有个什么...pool...的
早不这样配了.
和
commons-pool-1.2.1.jar
两个包导入就去就一切ok了
明天我会具体说明
还是自己实现一个数据库连接池,或者在tomcat 上配置数据源
你的sqlserver 没打补丁,去吧补丁打了 就可以了。现在好像是到sp4了。