java - UCP工作算法

Question

这个问题已经有答案了:

Closing JDBC Connections in Pool (3 个回答)

已关闭 5 年前。

我使用 Oracle 的通用连接池。我正在研究这个计划

class Action {
  static PoolDataSource initPool() {
    PoolDataSource pds = PoolDataSourceFactory.getPoolDataSource();
    pds.setConnectionFactoryClassName("oracle.jdbc.pool.OracleDataSource");
    pds.setURL(".........");
    pds.setUser("user");
    pds.setPassword("pass");
    pds.setInitialPoolSize(0);
    return pds;
  }

  static final PoolDataSource pds = initPool();

  void doAction() {
    Connection connection = pds.getConnection();
    ..........
    connection.close();  // ????
  }
}

需要调用connection.close()吗？ doAction之后完成还是使用池的整个感觉会丢失，并且那里的连接应该保持打开状态，直到它们自己超时关闭为止？

Answer 1

TL;博士。是的，关闭它们。它实际上并没有关闭，而是返回到连接池以供下一次 getConnection() 调用。

完整的文档在这里: https://docs.oracle.com/cd/E11882_01/java.112/e12265/connect.htm#CHDJCGGB

Borrowed connections that are no longer being used should be returned to the pool so that they can be available for the next connection request. The close method is used to close connections and automatically returns the connections to the pool. The close method does not physically remove the connection from the pool.

Borrowed connections that are not closed will remain borrowed; subsequent requests for a connection result in a new connection being created if no connections are available. This behavior can cause many connections to be created and can affect system performance.