在项目中通过proxool配置jdbc连接sqlserver。
配置文件如下: proxool.xml <?xml version="1.0" encoding="ISO-8859-1"?>
<something-else-entirely>
<proxool>
<alias>pool</alias>
<driver-url>jdbc:sqlserver://localhost:1433;DatabaseName=xibowork</driver-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<driver-properties>
<property name="user" value="sa"/>
<property name="password" value="密码"/>
</driver-properties>
<maximum-connection-count>1000</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
</proxool>
</something-else-entirely>
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">
<display-name></display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
<init-param>
<param-name>xmlFile</param-name>
<param-value>WEB-INF/proxool.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<!-- zh-cn encoding -->
<filter>
<filter-name>struts-cleanup</filter-name>
<filter-class>org.apache.struts2.dispatcher.ActionContextCleanUp</filter-class>
</filter>
<filter-mapping>
<filter-name>struts-cleanup</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<filter>
<filter-name>struts2</filter-name>
<filter-class>
org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
</filter-class>
</filter>
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>*.do</url-pattern>
</filter-mapping>
</web-app>
最后通过
Class.forName( "org.logicalcobwebs.proxool.ProxoolDriver" );
conn = DriverManager.getConnection("proxool.pool");
获取连接,都是按照常规来配置的,myeclipse不报错。问题就来了。
在运行到conn = DriverManager.getConnection("proxool.pool");即不报错也无法取得conn,就是说类似在这句话上假死了一样,
求大牛解惑,急
配置文件如下: proxool.xml <?xml version="1.0" encoding="ISO-8859-1"?>
<something-else-entirely>
<proxool>
<alias>pool</alias>
<driver-url>jdbc:sqlserver://localhost:1433;DatabaseName=xibowork</driver-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<driver-properties>
<property name="user" value="sa"/>
<property name="password" value="密码"/>
</driver-properties>
<maximum-connection-count>1000</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
</proxool>
</something-else-entirely>
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">
<display-name></display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
<init-param>
<param-name>xmlFile</param-name>
<param-value>WEB-INF/proxool.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<!-- zh-cn encoding -->
<filter>
<filter-name>struts-cleanup</filter-name>
<filter-class>org.apache.struts2.dispatcher.ActionContextCleanUp</filter-class>
</filter>
<filter-mapping>
<filter-name>struts-cleanup</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<filter>
<filter-name>struts2</filter-name>
<filter-class>
org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
</filter-class>
</filter>
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>*.do</url-pattern>
</filter-mapping>
</web-app>
最后通过
Class.forName( "org.logicalcobwebs.proxool.ProxoolDriver" );
conn = DriverManager.getConnection("proxool.pool");
获取连接,都是按照常规来配置的,myeclipse不报错。问题就来了。
在运行到conn = DriverManager.getConnection("proxool.pool");即不报错也无法取得conn,就是说类似在这句话上假死了一样,
求大牛解惑,急
解决方案 »
- Ibatis 查询语句selec count(*),getSqlMapClientTemplate().后面应该接什么
- 求助,jquery不能弹出窗口
- 一张jsp页面里需要多次查询数据库进行显示,应该怎样连接数据库?
- 求助:数据库异常错误[SQLServer 2000 Driver for JDBC]Invalid operation for the current cursor
- JSP调用水晶报表
- 请问Servlet中接受表单的字符并转换为某一字符集应该怎么写
- 求一个JSP文章页面翻页
- HELP!!taglib在weblogic中在线等待!!!!
- 急救!struts模板运用中的叶面导航问题
- 郁闷中.. 用resin做jsp怎样才能使目录结构清晰一些
- 请教 spring 2.5中的jdbctemplate.query的问题。
- JS写的checkbox全选为什么在IE8中有BUG--求助
参数应该是url