jdk7+tomcat7,使用的tomcat连接池,配置如下:<?xml version="1.0" encoding="UTF-8"?>
<Context
docBase="D:/webroot"
reloadable="true">
<Resource
name="abcd/jdbcmssql"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
password="1111"
maxIdle="100"
maxWait="10000"
username="sa"
url="jdbc:sqlserver://localhost:1433;DatabaseName=shop;SelectMethod=cursor"
maxActive="5000"/> <Resource
name="bbbb/jdbcmssql"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
password="111111"
maxIdle="100"
maxWait="10000"
username="sa"
url="jdbc:sqlserver://localhost:1433;DatabaseName=BaiduMap;SelectMethod=cursor"
maxActive="5000"/> <WatchedResource>D:\tomcat\conf\context.xml</WatchedResource>
</Context>
<Context
docBase="D:/webroot"
reloadable="true">
<Resource
name="abcd/jdbcmssql"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
password="1111"
maxIdle="100"
maxWait="10000"
username="sa"
url="jdbc:sqlserver://localhost:1433;DatabaseName=shop;SelectMethod=cursor"
maxActive="5000"/> <Resource
name="bbbb/jdbcmssql"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
password="111111"
maxIdle="100"
maxWait="10000"
username="sa"
url="jdbc:sqlserver://localhost:1433;DatabaseName=BaiduMap;SelectMethod=cursor"
maxActive="5000"/> <WatchedResource>D:\tomcat\conf\context.xml</WatchedResource>
</Context>
解决方案 »
- javascript 或者 Jsp 如何实现弹出保存文件对话框呢
- json-rpc-java是用来处理什么逻辑的?
- jsp分页问题
- JSP+ORACLE求表格状数据集增删改实例,分可以另开贴再给
- 高分送啊!!!!!!高手好!我是学JSP的新手?请问在JSP中怎样装JDBC驱动
- 在jsp中连接数据库要安装什么软件?这样设置?请教教小弟!分数很少请笑纳!!`
- jsp身份验证的问题
- SOS!,大家吃饱了喝足了,请给我一个绝对可以调用ejb的Jsp!!!
- (妲姬) 帮个忙吧 乱码问题 谢谢啦先!!
- 使用resin的错误
- 大神,问下,我在删除时,出了这个500错,怎么回事
- 关于将生日()插入到数据库中出错
服务器阻塞了,和应用有关。
先检查下是否和数据库的操作有关系(特别检查下资源使用完或者出错时有无释放)?再检查是否用了多线程?
GO
/****** Object: StoredProcedure [dbo].[search_page_count] Script Date: 05/16/2014 09:24:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOALTER proc [dbo].[search_page_count]
@QueryStr nvarchar(4000)='' /*查询语句*/
as
SET NOCOUNT ON/*-----这一句很重要哦:)),不然它只会认 insert #change......这个数据集:))*/
declare @sql nvarchar(1000), --声明动态sql执行语句
@Obj_ID int --对象ID
--处理查询语句
select @Obj_ID=object_id(@QueryStr)
,@QueryStr=case when @Obj_ID is not null then ' '+@QueryStr else ' ('+@QueryStr+') a' end
--取得当前数据库的记录总数
begin
set @sql=N'select count(*) as rownum from '+@QueryStr
exec sp_executesql @sql
end在sql2008中这个存储过程有问题吗?统计记录条数的
try{
if(this.conn != null && this.conn.isClosed() == false)
this.conn.close();
}catch(SQLException e){
e.printStackTrace();
}
if(this.rsmd != null)
this.rsmd = null;
if(this.rs != null)
this.rs = null;
if(this.psmt != null)
this.psmt = null;
if(this.conn != null)
this.conn = null;
}