关于Proxool使用介绍及在使用中发现的问题

发布时间:2016-12-11 4:46:48 编辑:www.fx114.net 分享查询网我要评论
本篇文章主要介绍了"关于Proxool使用介绍及在使用中发现的问题",主要涉及到关于Proxool使用介绍及在使用中发现的问题方面的内容,对于关于Proxool使用介绍及在使用中发现的问题感兴趣的同学可以参考一下。

Proxool.xml文件配置如下:<?xml version="1.0" encoding="ISO-8859-1" ?> - <!-- the proxool configuration can be embedded within your own application's. Anything outside the "proxool" tag is ignored. --> - <something-else-entirely> - <proxool> <alias>victa</alias> <driver-url>jdbc:mysql://localhost:3306/victa</driver-url> <driver-class>com.mysql.jdbc.Driver</driver-class> - <driver-properties> <property name="user" value="user" /> <property name="password" value="password" /> </driver-properties> <maximum-connection-count>30</maximum-connection-count> <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql> </proxool> </something-else-entirely> 这个是没有什么好说的, 在以前的使用中都是直接获取Connection,好像是没有什么问题,后来为了方便,单独提取出来,没有想到出现了问题。代码如下: ----------------SqlTool.java----------package cn.victa; import java.sql.*; import java.util.ArrayList; import org.logicalcobwebs.proxool.ProxoolException; import org.logicalcobwebs.proxool.configuration.JAXPConfigurator; import org.logicalcobwebs.proxool.ProxoolFacade; public final class SqlTool{ /*创建这个私有静态变量是为了调用它的私有构造函数,由于在运行时静态变量只初始化一次, *因而节约了时间,保证在调用getConnection()方法之前已经注册了proxool.victa这个驱动程序*/ //private static SqlTool instance=new SqlTool(); //私有化构造函数,防止生成实例 private SqlTool(){ //init(); } private static void init(){ try { JAXPConfigurator.configure("proxool.xml",false); } catch (Exception ex) { //ex.printStackTrace(); } } /** * 获得Connection对象 */ public static Connection getConnection(){ Connection conn=null; try{ init(); conn=DriverManager.getConnection("proxool.victa"); } catch(Exception e){ conn=null; } return conn; } /** * 关闭Connection对象 */ public static void closeConnection(Connection conn){ try{ if((conn!=null)&&(!conn.isClosed())){ conn.close(); } } catch(SQLException e){ System.out.println("关闭数据库连接发生异常!"); } } /** * 关闭PreparedStatement对象 */ public static void closePreparedStatement(PreparedStatement pstmt){ try{ if(pstmt!=null){ pstmt.close(); } } catch(SQLException e){ System.out.println("关闭PreparedStatement发生异常!"); } } /** * 关闭ResultSet对象 */ public static void closeResultSet(ResultSet rs){ try { if(rs!=null){ rs.close(); } } catch (Exception ex) { System.out.println("关闭ResultSet发生异常!"); } } /** * 测试函数 */ public static void main(String[] args)throws Exception{ java.sql.Connection conn=SqlTool.getConnection(); System.out.println (conn==null?"NULL":"NOT NULL"); } } ---------------------------------------UserTool.java-------------------------------------------- package cn.victa; import java.sql.*; import java.util.ArrayList; import java.util.Random; public class UserTool{ private static UserTool instance; //禁止构造新的实例 private UserTool(){ } public static UserTool getInstance(){ if(instance==null){ instance=new UserTool(); } return instance; } public int addUser(String username,String password,String headImg,String sex,String email,String pwdQuestion,String pwdAnswer){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; conn=SqlTool.getConnection(); int res=0; if(conn==null){ return res; } else{ try { pstmt=conn.prepareStatement("insert into userinfo(username,password,face,sex,email,pwdQuestion,pwdAnswer,regDate,lastLogin) values(?,?,?,?,?,?,?,?,?)"); Timestamp current=new Timestamp(System.currentTimeMillis()); pstmt.setString(1,username); pstmt.setString(2,MD5Encode.encode(password)); pstmt.setString(3,headImg); pstmt.setString(4,sex); pstmt.setString(5,email); pstmt.setString(6,pwdQuestion); pstmt.setString(7,pwdAnswer); pstmt.setTimestamp(8,current); pstmt.setTimestamp(9,current); res=pstmt.executeUpdate(); } catch (Exception ex) { System.out.println(ex.toString()); res=0; } finally { SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return res; } } } /** *删除一个用户(其实并没有真正删除,只是将isActive设置为0)。 *任何能正常登录的用户的isActive为1。 *这样用户就不能登录了,但有关该用户以前的数据都保存了。 [email protected] uid 要删除的用户的编号 [email protected] 是否成功删除 */ public boolean deleteUser(int uid){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; boolean delete=false; conn=SqlTool.getConnection(); if(conn==null){ return delete; } else{ try { pstmt=conn.prepareStatement("update userinfo set isActive=0 where uid=?"); pstmt.setInt(1,uid); pstmt.executeUpdate(); delete=true; } catch (Exception ex) { delete=false; } finally { SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return delete; } } } public UserInfo getUserInfo(String username){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; conn=SqlTool.getConnection(); if(conn==null){ return null; } else{ UserInfo user=new UserInfo(); try { pstmt=conn.prepareStatement("select * from userinfo where username=?"); pstmt.setString(1,username); rs=pstmt.executeQuery(); if(rs.next()){ user.setUserId(rs.getInt("uid")); user.setUsername(rs.getString("username")); user.setPassword(rs.getString("password")); user.setFace(rs.getString("face")); user.setSex(rs.getString("sex")); user.setEmail(rs.getString("email")); user.setPwdQuestion(rs.getString("pwdQuestion")); user.setPwdAnswer(rs.getString("pwdAnswer")); user.setRegDate(rs.getTimestamp("regDate")); user.setLoginCount(rs.getInt("loginCount")); user.setLastLogin(rs.getTimestamp("lastLogin")); user.setIsActive(rs.getByte("isActive")); user.setPrimeCount(rs.getInt("primeCount")); user.setArticleCount(rs.getInt("articleCount")); } else{ user=null; } } catch (Exception ex) { ex.printStackTrace(); user=null; } finally { SqlTool.closeResultSet(rs); SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return user; } } } /** *根据名字中的一部分来查找所有符合条件的用户 [email protected] partName-用户名中的部分 [email protected] 以ArrayList为容器的UserInfo类 */ public ArrayList getUserInfoList(String partName){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; ArrayList userList=null; conn=SqlTool.getConnection(); if(conn==null){ return null; } else{ try { userList=new ArrayList(); pstmt=conn.prepareStatement("select * from userinfo where username like '%"+partName+"%'"); rs=pstmt.executeQuery(); while(rs.next()){ UserInfo user=new UserInfo(); user.setUserId(rs.getInt("uid")); user.setUsername(rs.getString("username")); user.setPassword(rs.getString("password")); user.setFace(rs.getString("face")); user.setSex(rs.getString("sex")); user.setEmail(rs.getString("email")); user.setPwdQuestion(rs.getString("pwdQuestion")); user.setPwdAnswer(rs.getString("pwdAnswer")); user.setRegDate(rs.getTimestamp("regDate")); user.setLoginCount(rs.getInt("loginCount")); user.setLastLogin(rs.getTimestamp("lastLogin")); user.setIsActive(rs.getByte("isActive")); userList.add(user); } } catch (Exception ex) { userList=null; } finally { SqlTool.closeResultSet(rs); SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return userList; } } } public UserInfo getUserInfo(int id){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; conn=SqlTool.getConnection(); if(conn==null){ return null; } else{ UserInfo user=new UserInfo(); try { pstmt=conn.prepareStatement("select * from userinfo where uid=?"); pstmt.setInt(1,id); rs=pstmt.executeQuery(); if(rs.next()){ user.setUserId(rs.getInt("uid")); user.setUsername(rs.getString("username")); user.setPassword(rs.getString("password")); user.setFace(rs.getString("face")); user.setSex(rs.getString("sex")); user.setEmail(rs.getString("email")); user.setPwdQuestion(rs.getString("pwdQuestion")); user.setPwdAnswer(rs.getString("pwdAnswer")); user.setRegDate(rs.getTimestamp("regDate")); user.setLoginCount(rs.getInt("loginCount")); user.setLastLogin(rs.getTimestamp("lastLogin")); user.setIsActive(rs.getByte("isActive")); user.setPrimeCount(rs.getInt("primeCount")); user.setArticleCount(rs.getInt("articleCount")); } else{ user=null; } } catch (Exception ex) { user=null; } finally { SqlTool.closeResultSet(rs); SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return user; } } } public boolean login(String username,String password){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; boolean; conn=SqlTool.getConnection(); if(conn==null){ return checked; } else{ try { pstmt=conn.prepareStatement("select username,password from userinfo where username=? and password=? and isActive=1"); pstmt.setString(1,username); pstmt.setString(2,MD5Encode.encode(password)); rs=pstmt.executeQuery(); while(rs.next()){ checked=true; } if(checked==true){ pstmt=conn.prepareStatement("update userinfo set loginCount=loginCount+1,lastLogin=? where username=?"); Timestamp current=new Timestamp(System.currentTimeMillis()); pstmt.setTimestamp(1,current); pstmt.setString(2,username); pstmt.executeUpdate(); } } catch (Exception ex) {; } finally { SqlTool.closeResultSet(rs); SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return checked; } } } public boolean updateUserInfo(int uid,String password,String face,String sex,String email,String pwdQuestion,String pwdAnswer){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; boolean updated=false; conn=SqlTool.getConnection(); if(conn==null){ return false; } else{ try { pstmt=conn.prepareStatement("update userinfo set password=?,face=?,sex=?,email=?,pwdQuestion=?,pwdAnswer=? where uid=?"); pstmt.setString(1,MD5Encode.encode(password)); pstmt.setString(2,face); pstmt.setString(3,sex); pstmt.setString(4,email); pstmt.setString(5,pwdQuestion); pstmt.setString(6,pwdAnswer); pstmt.setInt(7,uid); pstmt.executeUpdate(); updated=true; } catch (Exception ex) { updated=false; } finally { SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return updated; } } } public boolean updateUserInfo(String username,String password,String face,String sex,String email,String pwdQuestion,String pwdAnswer){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; boolean updated=false; conn=SqlTool.getConnection(); if(conn==null){ return false; } else{ try { pstmt=conn.prepareStatement("update userinfo set password=?,face=?,sex=?,email=?,pwdQuestion=?,pwdAnswer=? where username=?"); pstmt.setString(1,MD5Encode.encode(password)); pstmt.setString(2,face); pstmt.setString(3,sex); pstmt.setString(4,email); pstmt.setString(5,pwdQuestion); pstmt.setString(6,pwdAnswer); pstmt.setString(7,username); pstmt.executeUpdate(); updated=true; } catch (Exception ex) { updated=false; } finally { SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return updated; } } } public boolean updateUserInfo(UserInfo userInfo,int uid){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; boolean updated=false; conn=SqlTool.getConnection(); if(conn==null){ return false; } else{ try { pstmt=conn.prepareStatement("update userinfo set face=?,sex=?,email=?,pwdQuestion=?,pwdAnswer=? where uid=?"); pstmt.setString(1,userInfo.getFace()); pstmt.setString(2,userInfo.getSex()); pstmt.setString(3,userInfo.getEmail()); pstmt.setString(4,userInfo.getPwdQuestion()); pstmt.setString(5,userInfo.getPwdAswer()); pstmt.setInt(6,uid); pstmt.executeUpdate(); updated=true; } catch (Exception ex) { updated=false; } finally { SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return updated; } } } public boolean existsUsername(String username){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; boolean exists=false; conn=SqlTool.getConnection(); if(conn==null){ return true; } else{ try { pstmt=conn.prepareStatement("select username from userinfo where username=?"); pstmt.setString(1,username); rs=pstmt.executeQuery(); while(rs.next()){ exists=true; } } catch (Exception ex) { System.out.println(ex.getMessage()); exists=true; } finally { SqlTool.closeResultSet(rs); SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return exists; } } } public boolean checkRole(String username,String roleName){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; boolean hasRole=false; conn=SqlTool.getConnection(); if(username.equals("admin")){ return true; } else if(conn==null){ return false; } else{ try { pstmt=conn.prepareStatement("select role.uid,role.rolename from userinfo,role where username=? and rolename=? and userinfo.uid=role.uid"); pstmt.setString(1,username); pstmt.setString(2,roleName); rs=pstmt.executeQuery(); while(rs.next()){ hasRole=true; } pstmt=conn.prepareStatement("select role.uid,role.rolename from userinfo,role where username=? and rolename=? and userinfo.uid=role.uid"); pstmt.setString(1,username); pstmt.setString(2,"administrator"); rs=pstmt.executeQuery(); while(rs.next()){ hasRole=true; } } catch (Exception ex) { hasRole=false; } finally { SqlTool.closeResultSet(rs); SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return hasRole; } } } public ArrayList getUserList(int startIndex,int size){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; conn=SqlTool.getConnection(); ArrayList userList=new ArrayList(size); if(conn==null){ return null; } else{ try { pstmt=conn.prepareStatement("select * from userinfo where isActive=1 order by uid"); rs=pstmt.executeQuery(); if(startIndex==0){ rs.beforeFirst(); } else{ rs.absolute(startIndex); } int current=0; while(rs.next()&¤t<size){ UserInfo user=new UserInfo(); user.setUserId(rs.getInt("uid")); user.setUsername(rs.getString("username")); user.setFace(rs.getString("face")); user.setSex(rs.getString("sex")); user.setEmail(rs.getString("email")); user.setPwdQuestion(rs.getString("pwdQuestion")); user.setPwdAnswer(rs.getString("pwdAnswer")); user.setRegDate(rs.getTimestamp("regDate")); user.setLoginCount(rs.getInt("loginCount")); user.setLastLogin(rs.getTimestamp("lastLogin")); user.setIsActive(rs.getByte("isActive")); user.setPrimeCount(rs.getInt("primeCount")); userList.add(user); current++; } } catch (Exception ex) { System.out.println(ex.getMessage()); userList=new ArrayList(); } finally { SqlTool.closeResultSet(rs); SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return userList; } } } /** *查询具有特权用户的列表 [email protected] startIndex 起始位置 [email protected] size 每次返回的个数 */ public ArrayList getPowerUserList(int startIndex,int size){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; conn=SqlTool.getConnection(); ArrayList userList=new ArrayList(size); if(conn==null){ return null; } else{ try { pstmt=conn.prepareStatement("select * from userinfo where uid in(select uid from role) order by uid"); rs=pstmt.executeQuery(); if(startIndex==0){ rs.beforeFirst(); } else{ rs.absolute(startIndex); } int current=0; while(rs.next()&¤t<size){ UserInfo user=new UserInfo(); user.setUserId(rs.getInt("uid")); user.setUsername(rs.getString("username")); user.setFace(rs.getString("face")); user.setSex(rs.getString("sex")); user.setEmail(rs.getString("email")); user.setPwdQuestion(rs.getString("pwdQuestion")); user.setPwdAnswer(rs.getString("pwdAnswer")); user.setRegDate(rs.getTimestamp("regDate")); user.setLoginCount(rs.getInt("loginCount")); user.setLastLogin(rs.getTimestamp("lastLogin")); userList.add(user); current++; } } catch (Exception ex) { System.out.println(ex.getMessage()); userList=new ArrayList(); } finally { SqlTool.closeResultSet(rs); SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return userList; } } } public boolean grantRole(int uid,String roleName){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; boolean success=false; conn=SqlTool.getConnection(); if(conn==null){ return success; } else{ try { pstmt=conn.prepareStatement("insert into role(uid,roleName,displayName)values(?,?,?)"); pstmt.setInt(1,uid); pstmt.setString(2,roleName); pstmt.setString(3,RoleInfo.convertRoleName(roleName)); pstmt.executeUpdate(); success=true; } catch (Exception ex) { success=false; } finally { SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return success; } } } public boolean revokeRole(int uid,String roleName){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; boolean success=false; conn=SqlTool.getConnection(); if(conn==null){ return success; } else{ try { pstmt=conn.prepareStatement("delete from role where uid=? and roleName=?"); pstmt.setInt(1,uid); pstmt.setString(2,roleName); pstmt.executeUpdate(); success=true; } catch (Exception ex) { success=false; } finally { SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return success; } } } /** *当用户忘记密码的时候,如果用户回答忘记密码提示问题正确,就重设用户密码。 [email protected] uid 忘记用户密码的用户编号 [email protected] 重设的密码 */ public String resetPassword(int uid){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; conn=SqlTool.getConnection(); if(conn==null){ return "0"; } else{ String password=""; StringBuffer sBuffer=new StringBuffer(); Random random=new Random(); for(int i=0;i<8;i++){ sBuffer.append(random.nextInt(10)); } password=sBuffer.toString(); try { pstmt=conn.prepareStatement("update userinfo set password=? where uid=?"); pstmt.setString(1,MD5Encode.encode(password)); pstmt.setInt(2,uid); pstmt.executeUpdate(); } catch (Exception ex) { password="0"; } finally { SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return password; } } } /** *更改密码 [email protected] uid 用户编号 [email protected] password 用户的新密码 [email protected] 是否成功更改了密码 */ public boolean changePassword(int uid,String password){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; boolean success=false; conn=SqlTool.getConnection(); if(conn==null){ return success; } else{ try { pstmt=conn.prepareStatement("update userinfo set password=? where uid=?"); pstmt.setString(1,MD5Encode.encode(password)); pstmt.setInt(2,uid); pstmt.executeUpdate(); success=true; } catch (Exception ex) { success=false; } finally { SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return success; } } } public ArrayList getRoleListByName(String username){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; conn=SqlTool.getConnection(); ArrayList roleList=new ArrayList(); if(conn==null) { return roleList; } else{ try { pstmt=conn.prepareStatement("select uid,roleName,displayName from role where username=? order by roleName"); pstmt.setString(1,username); rs=pstmt.executeQuery(); while(rs.next()){ RoleInfo roleInfo=new RoleInfo(); roleInfo.setId(rs.getInt("uid")); roleInfo.setRoleName(rs.getString("roleName")); roleInfo.setDisplayName(rs.getString("displayName")); roleList.add(roleInfo); } } catch (Exception ex) { return null; } finally { SqlTool.closeResultSet(rs); SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return roleList; } } } public ArrayList getRoleListById(int id){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; conn=SqlTool.getConnection(); ArrayList roleList=new ArrayList(); if(conn==null) { return roleList; } else{ try { pstmt=conn.prepareStatement("select uid,roleName,displayName from role where uid=? order by roleName"); pstmt.setInt(1,id); rs=pstmt.executeQuery(); while(rs.next()){ RoleInfo roleInfo=new RoleInfo(); roleInfo.setId(rs.getInt("uid")); roleInfo.setRoleName(rs.getString("roleName")); roleInfo.setDisplayName(rs.getString("displayName")); roleList.add(roleInfo); } } catch (Exception ex) { return null; } finally { SqlTool.closeResultSet(rs); SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return roleList; } } } /** *查询注册用户总数 [email protected] 网站所有注册用户的总数(包括禁止登录的用户)。 */ public int getUserCount(){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; int count=0; conn=SqlTool.getConnection(); if(conn==null) { return 0; } else{ try { pstmt=conn.prepareStatement("select uid from userinfo"); rs=pstmt.executeQuery(); rs.last(); count=rs.getRow(); } catch (Exception ex) { count=0; } finally { SqlTool.closeResultSet(rs); SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return count; } } } /** *获取网站最近的一个注册用户 [email protected] 用户信息 */ public UserInfo getLastUser(){ PreparedStatement pstmt=null; Connection conn=null; ResultSet rs=null; UserInfo user=null; conn=SqlTool.getConnection(); if(conn==null) { return user; } else{ try { pstmt=conn.prepareStatement("select * from userinfo where isActive=1 order by regDate desc"); rs=pstmt.executeQuery(); while(rs.next()){ user.setUserId(rs.getInt("uid")); user.setUsername(rs.getString("username")); user.setPassword(rs.getString("password")); user.setFace(rs.getString("face")); user.setSex(rs.getString("sex")); user.setEmail(rs.getString("email")); user.setPwdQuestion(rs.getString("pwdQuestion")); user.setPwdAnswer(rs.getString("pwdAnswer")); user.setRegDate(rs.getTimestamp("regDate")); user.setLoginCount(rs.getInt("loginCount")); user.setLastLogin(rs.getTimestamp("lastLogin")); } } catch (Exception ex) { user=null; } finally { SqlTool.closeResultSet(rs); SqlTool.closePreparedStatement(pstmt); SqlTool.closeConnection(conn); return user; } } } public static void main(String[] args){ UserTool tool=UserTool.getInstance(); //System.out.println(tool.checkRole("周金桥","bbsAdmin")); System.out.println(tool.getUserInfo("周金桥").getLoginCount()); //boolean success=tool.revokeRole(2,"tradeAdmin"); //tool.getUserList(0,50); //tool.getUserInfo(2); //UserInfo user=tool.getUserInfo(2); //boolean updated=tool.updateUserInfo(2,"790918",user.getFace(),user.getSex(),user.getEmail(),user.getPwdQuestion(),user.getPwdAswer()); //System.out.println(); } }   在几个频繁查询页面多次点击之后,居然出现了没有连接的情况,如下图: 停止点击一段时间后就又恢复到可以使用连接池状态,怪哉!每次使用完之后我都会关闭的,怎么就不能及时关闭呢? 而且日志文件里有如下信息:2006-8-30 10:06:11 org.logicalcobwebs.proxool.HouseKeeper sweep 警告: #0031 was active for 317484 milliseconds and has been removed automaticaly. The Thread responsible was named 'http-80-Processor23', but the last SQL it performed is unknown because the trace property is not enabled. 2006-8-30 10:06:11 org.logicalcobwebs.proxool.HouseKeeper sweep 警告: #0032 was active for 316281 milliseconds and has been removed automaticaly. The Thread responsible was named 'http-80-Processor23', but the last SQL it performed is unknown because the trace property is not enabled. 2006-8-30 10:06:11 org.logicalcobwebs.proxool.HouseKeeper sweep 警告: #0033 was active for 314734 milliseconds and has been removed automaticaly. The Thread responsible was named 'http-80-Processor23', but the last SQL it performed is unknown because the trace property is not enabled. 2006-8-30 10:06:11 org.logicalcobwebs.proxool.HouseKeeper sweep 警告: #0034 was active for 314062 milliseconds and has been removed automaticaly. The Thread responsible was named 'http-80-Processor23', but the last SQL it performed is unknown because the trace property is not enabled. 2006-8-30 10:06:11 org.logicalcobwebs.proxool.HouseKeeper sweep 警告: #0035 was active for 313328 milliseconds and has been removed automaticaly. The Thread responsible was named 'http-80-Processor23', but the last SQL it performed is unknown because the trace property is not enabled. 2006-8-30 10:06:11 org.logicalcobwebs.proxool.HouseKeeper sweep 警告: #0036 was active for 312406 milliseconds and has been removed automaticaly. The Thread responsible was named 'http-80-Processor23', but the last SQL it performed is unknown because the trace property is not enabled. 2006-8-30 10:06:11 org.logicalcobwebs.proxool.HouseKeeper sweep 警告: #0037 was active for 310234 milliseconds and has been removed automaticaly. The Thread responsible was named 'http-80-Processor23', but the last SQL it performed is unknown because the trace property is not enabled. 2006-8-30 10:08:22 org.logicalcobwebs.proxool.ConnectionPool getConnection 信息: 000181 -000008 (30/30/00) - Couldn't get connection because we are at maximum connection count and there are none available 2006-8-30 10:08:23 org.logicalcobwebs.proxool.ConnectionPool getConnection 信息: 000181 -000009 (30/30/00) - Couldn't get connection because we are at maximum connection count and there are none available 2006-8-30 10:08:23 org.logicalcobwebs.proxool.ConnectionPool getConnection 信息: 000181 -000010 (30/30/00) - Couldn't get connection because we are at maximum connection count and there are none available 2006-8-30 10:08:24 org.logicalcobwebs.proxool.ConnectionPool getConnection 信息: 000181 -000011 (30/30/00) - Couldn't get connection because we are at maximum connection count and there are none available 2006-8-30 10:08:24 org.logicalcobwebs.proxool.ConnectionPool getConnection 信息: 000181 -000012 (30/30/00) - Couldn't get connection because we are at maximum connection count and there are none available 难道调用它自己的方法不能关闭Connection? 有待进一步探索。   2010-12-01更新:这篇文章发布以后,没有想到很多朋友通过搜索引擎找到了它,大多数人都遇到了在本篇中描述的问题,在这里要告诉大家的是有一个Proxool的替代选择,那就是使用BoneCP数据库连接池,它不断支持使用JDBC的方式操作数据库,还可以在Hibernate中使用,关于BoneCP的介绍和详细使用方法请见《Java中的BoneCP数据库连接池用法》。

上一篇:很赞的詞曲
下一篇:应用框架的设计与实现学习手札之类工厂服务——反射

相关文章

相关评论