求助：SSH连接SQL Server2005问题

Question

数据库连接池配置<?xml version="1.0" encoding="utf-8"?> 
<something-else-entirely> 
<proxool>
<alias>ceshi</alias> 
<driver-url>jdbc:sqlserver://localhost:1433;DatabaseName=sspa</driver-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> 
<driver-properties> 
<property name="user" value="ceshi"/> 
<property name="password" value="ceshi"/> 
</driver-properties>
<house-keeping-sleep-time>90000</house-keeping-sleep-time> 
<maximum-active-time>60000</maximum-active-time>
<maximum-new-connections>20</maximum-new-connections> 
<prototype-count>5</prototype-count> 
<maximum-connection-count>100</maximum-connection-count> 
<minimum-connection-count>10</minimum-connection-count> 
</proxool> 
</something-else-entirely> 

Answer 1

数据库连接池配置<?xml version="1.0" encoding="utf-8"?> 
<something-else-entirely> 
<proxool>
<alias>ceshi</alias> 
<driver-url>jdbc:sqlserver://localhost:1433;DatabaseName=sspa</driver-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> 
<driver-properties> 
<property name="user" value="ceshi"/> 
<property name="password" value="ceshi"/> 
</driver-properties>
<house-keeping-sleep-time>90000</house-keeping-sleep-time> 
<maximum-active-time>60000</maximum-active-time>
<maximum-new-connections>20</maximum-new-connections> 
<prototype-count>5</prototype-count> 
<maximum-connection-count>100</maximum-connection-count> 
<minimum-connection-count>10</minimum-connection-count> 
</proxool> 
</something-else-entirely> 

Answer 2

数据库连接池配置proxool.xml文件<?xml version="1.0" encoding="utf-8"?> 
<something-else-entirely> 
<proxool>
<alias>ceshi</alias> 
<driver-url>jdbc:sqlserver://localhost:1433;DatabaseName=ceshi</driver-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> 
<driver-properties> 
<property name="user" value="ceshi"/> 
<property name="password" value="ceshi"/> 
</driver-properties>
<!--proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁 默认30秒--> 
<house-keeping-sleep-time>90000</house-keeping-sleep-time> 
<maximum-active-time>60000</maximum-active-time>
<!--没有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受-->  
<maximum-new-connections>20</maximum-new-connections> 
<!--最少保持的空闲连接数(默认2个)-->  
<prototype-count>5</prototype-count>
<!--最大连接数(默认5个),超过了这个连接数,再有请求时,
就排在队列中等候,最大的等待请求数由maximum-new-connections决定 -->  
<maximum-connection-count>100</maximum-connection-count> 
<!--最小连接数(默认2个)--> 
<minimum-connection-count>10</minimum-connection-count> 
</proxool> 
</something-else-entirely> 

Answer 3

web.xml配置文件内容<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
  <!-- mmm -->
<filter>
<filter-name>hibernateFilter</filter-name>
<filter-class>
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter
</filter-class>
</filter>
<filter-mapping>
<filter-name>hibernateFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping> <filter>
        <filter-name>SetCharacterEncodingFilter</filter-name>
        <filter-class>com.monkey.filter.SetCharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
    </filter>
    <filter-mapping>
<filter-name>SetCharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>


<filter>
<filter-name>popedomFilter</filter-name>
<filter-class>com.monkey.filter.PopedomFilter</filter-class>
 <init-param>
            <param-name>redirectURL</param-name>
            <param-value>/nologin.jsp</param-value>
            </init-param>
            <init-param>
            <param-name>checkSessionKey</param-name>
            <param-value>userId</param-value>
            </init-param>
            <init-param>
             <param-name>notCheckURLList</param-name>
            <param-value>/sspa/main/index.jsp,/nologin.jsp,/sspa/main/code.jsp</param-value>
        </init-param>
</filter>
<filter-mapping>
<filter-name>popedomFilter</filter-name>
<url-pattern>*.jsp</url-pattern>
</filter-mapping>
<filter> <filter-name>struts2</filter-name>
<filter-class>
org.apache.struts2.dispatcher.FilterDispatcher
</filter-class>
</filter>
<!-- 
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
 -->
<filter-mapping>
       <filter-name>struts2</filter-name>
       <url-pattern>*.action</url-pattern>
    </filter-mapping>
    <filter-mapping>
       <filter-name>struts2</filter-name>
       <url-pattern>*.jsp</url-pattern>
    </filter-mapping>
 <!--  -->
<!-- 配置spring的监听器  -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:applicationContext*.xml</param-value>
</context-param>
<listener>
<listener-class>
org.springframework.web.context.request.RequestContextListener
</listener-class>
</listener>
<listener>
<listener-class>
org.springframework.web.context.ContextLoaderListener
</listener-class>
</listener>
<listener>
<listener-class>
com.monkey.listener.InitOptionsContextListener
</listener-class>
</listener>
<jsp-config>
<taglib>
<taglib-uri>/key</taglib-uri>
<taglib-location>/WEB-INF/tags/key.tld</taglib-location>
</taglib>
</jsp-config> <welcome-file-list>
<welcome-file>/index.jsp</welcome-file>
</welcome-file-list>
</web-app>

Answer 4

web.xml配置文件内容<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
  <!-- mmm -->
<filter>
<filter-name>hibernateFilter</filter-name>
<filter-class>
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter
</filter-class>
</filter>
<filter-mapping>
<filter-name>hibernateFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping> <filter>
        <filter-name>SetCharacterEncodingFilter</filter-name>
        <filter-class>com.monkey.filter.SetCharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
    </filter>
    <filter-mapping>
<filter-name>SetCharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>


<filter>
<filter-name>popedomFilter</filter-name>
<filter-class>com.monkey.filter.PopedomFilter</filter-class>
 <init-param>
            <param-name>redirectURL</param-name>
            <param-value>/nologin.jsp</param-value>
            </init-param>
            <init-param>
            <param-name>checkSessionKey</param-name>
            <param-value>userId</param-value>
            </init-param>
            <init-param>
             <param-name>notCheckURLList</param-name>
            <param-value>/sspa/main/index.jsp,/nologin.jsp,/sspa/main/code.jsp</param-value>
        </init-param>
</filter>
<filter-mapping>
<filter-name>popedomFilter</filter-name>
<url-pattern>*.jsp</url-pattern>
</filter-mapping>
<filter> <filter-name>struts2</filter-name>
<filter-class>
org.apache.struts2.dispatcher.FilterDispatcher
</filter-class>
</filter>
<!-- 
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
 -->
<filter-mapping>
       <filter-name>struts2</filter-name>
       <url-pattern>*.action</url-pattern>
    </filter-mapping>
    <filter-mapping>
       <filter-name>struts2</filter-name>
       <url-pattern>*.jsp</url-pattern>
    </filter-mapping>
 <!--  -->
<!-- 配置spring的监听器  -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:applicationContext*.xml</param-value>
</context-param>
<listener>
<listener-class>
org.springframework.web.context.request.RequestContextListener
</listener-class>
</listener>
<listener>
<listener-class>
org.springframework.web.context.ContextLoaderListener
</listener-class>
</listener>
<listener>
<listener-class>
com.monkey.listener.InitOptionsContextListener
</listener-class>
</listener>
<jsp-config>
<taglib>
<taglib-uri>/key</taglib-uri>
<taglib-location>/WEB-INF/tags/key.tld</taglib-location>
</taglib>
</jsp-config> <welcome-file-list>
<welcome-file>/index.jsp</welcome-file>
</welcome-file-list>
</web-app>

Answer 5

web.xml配置文件内容<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
  <!-- mmm -->
<filter>
<filter-name>hibernateFilter</filter-name>
<filter-class>
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter
</filter-class>
</filter>
<filter-mapping>
<filter-name>hibernateFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping> <filter>
        <filter-name>SetCharacterEncodingFilter</filter-name>
        <filter-class>com.monkey.filter.SetCharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
    </filter>
    <filter-mapping>
<filter-name>SetCharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>


<filter>
<filter-name>popedomFilter</filter-name>
<filter-class>com.monkey.filter.PopedomFilter</filter-class>
 <init-param>
            <param-name>redirectURL</param-name>
            <param-value>/nologin.jsp</param-value>
            </init-param>
            <init-param>
            <param-name>checkSessionKey</param-name>
            <param-value>userId</param-value>
            </init-param>
            <init-param>
             <param-name>notCheckURLList</param-name>
            <param-value>/sspa/main/index.jsp,/nologin.jsp,/sspa/main/code.jsp</param-value>
        </init-param>
</filter>
<filter-mapping>
<filter-name>popedomFilter</filter-name>
<url-pattern>*.jsp</url-pattern>
</filter-mapping>
<filter> <filter-name>struts2</filter-name>
<filter-class>
org.apache.struts2.dispatcher.FilterDispatcher
</filter-class>
</filter>
<!-- 
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
 -->
<filter-mapping>
       <filter-name>struts2</filter-name>
       <url-pattern>*.action</url-pattern>
    </filter-mapping>
    <filter-mapping>
       <filter-name>struts2</filter-name>
       <url-pattern>*.jsp</url-pattern>
    </filter-mapping>
 <!--  -->
<!-- 配置spring的监听器  -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:applicationContext*.xml</param-value>
</context-param>
<listener>
<listener-class>
org.springframework.web.context.request.RequestContextListener
</listener-class>
</listener>
<listener>
<listener-class>
org.springframework.web.context.ContextLoaderListener
</listener-class>
</listener>
<listener>
<listener-class>
com.monkey.listener.InitOptionsContextListener
</listener-class>
</listener>
<jsp-config>
<taglib>
<taglib-uri>/key</taglib-uri>
<taglib-location>/WEB-INF/tags/key.tld</taglib-location>
</taglib>
</jsp-config> <welcome-file-list>
<welcome-file>/index.jsp</welcome-file>
</welcome-file-list>
</web-app>