验证数据库连接有效性Druid

最新推荐文章于 2025-03-17 11:17:15 发布

阿飞Sirx

最新推荐文章于 2025-03-17 11:17:15 发布

阅读量1.7k

点赞数

分类专栏：系统设计文章标签： java

本文链接：https://blog.youkuaiyun.com/weixin_37632716/article/details/123459923

版权

系统设计专栏收录该内容

67 篇文章

订阅专栏

public boolean validateObject(PooledObject<PoolableConnection> p){
  try{
    validateLifeTime(p);
    validateConnection(p.getObject());
    return true;
  }catch(Exception e){
    return false;
  }
}

private void validateLifetime(PooledObject<PoolableConnection> p) throws Exception{
  if(maxConnLifetimeMillis > 0){
    long lifetime = System.currentTimeMillis()-p.getCreateTime();
    if(lifetime > maxConnLifetimeMillis){
      throw new LifetimeExceededException();    
    }
  }
}

public void validateConnection() throws SQLException{
  if(conn.isClosed()){
    throw new SQLException("validateConnection : connection closed");
  }
  conn.validate(_validationQuery,_validationQueryTimeout);

}