struts1.1+sqlserver2000连接池问题

Question

PRB: Error Establishing Socket with JDBC Driver
http://support.microsoft.com/?scid=kb;zh-cn;313178&spid=2852&sid=332

Answer 1

<?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 type="org.apache.commons.dbcp.BasicDataSource">
      <set-property property="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
      <set-property property="url" value="jdbc:microsoft:sqlserver://10.241.50.149:1433;DatabaseName=NECDB" />
      <set-property property="username" value="test" />
      <set-property property="password" value="test" />
      <set-property property="maxActive" value="10" />
      <set-property property="maxWait" value="5000" />
      <set-property property="defaultAutoCommit" value="false" />
      <set-property property="defaultReadOnly" value="false" />
    </data-source>
 </data-sources>
 
 <form-beans>
    <form-bean name="userInfoForm" type="entity.UserInfoForm" />
 </form-beans> <action-mappings>
    <action input="/logon.jsp" name="userInfoForm" path="/logonAction" scope="session" 
type="action.LogonAction" validate="false">
      <forward name="success" path="/main.jsp" />      
    </action>
 </action-mappings> <message-resources parameter="ApplicationResources" />
 
</struts-config>這個是我用著的,只能給你參考一下

Answer 2

使用的時候就是這樣DataSource dataSource;
    Connection con=null;
.......
dataSource=getDataSource(request);
        con=dataSource.getConnection();

Answer 3

1、下载Microsoft SQL Server 2000 Service Pack 3a并安装，SQL请选用混和安装模式！！！
http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=zh-cn2、下载SQL Server 2000 Driver for JDBC Service Pack 3
http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en3、运行时关闭防火墙