Connection Pool panel

It is used for viewing connection information and for deleting unused connections. See the panel.

The options available in this panel are as follows:

Disconnect

Cancels the selected connection from working.

Connection Information Table

The table consists of these columns:

• User
  The user who triggered the connection.
• URL - URL1
  JDBC URL that can establish a connection to your database. The URL contents are case sensitive.
• Expiration Time
  The period of time in seconds it takes for an active connection to expire. "0" means that the active connection will not expire.
• Idle Expiration Time
  The period of time for when a free connection can be idle before it is closed. The connection will not be released until the defined time has reached its limit. "1" means that the connection will be released after 1 second. "0" means the connection will be closed right after it starts idling.
• Maximum Connection Count
  The maximum number of connections based on the URL. Once the number of the connections reaches the maximum, a new connection will be blocked until a free connection becomes available. Generally speaking, the fewer the connections, the better the performance of JReport Server. "0" means that there will be no limit on the number of the connections.
• Maximum Share Count
  The maximum number of requests in one connection that can be executed simultaneously. Once the number of the requests reaches the maximum, a new connection will be created to connect to the database. "1" means that one request in one connection can be executed simultaneously. "0" means that there will be no limit to the maximum number of requests sharing one connection and that all the requests in one connection can be executed simultaneously. The smaller the number of requests, the better the performance of JReport Server.
• Attempts
  The number of times the engine will try to establish a new connection. "1" means that the engine will only try once to create a new connection. This property has a close relation to the property Maximum Connection Count. Once the number of the connections reaches the maximum, a new connection will be blocked until a free connection becomes available.
• Interval
  The interval the engine will wait for between attempts to create a new connection if a previous try has failed. "0" means that the engine will start the next attempt immediately. The unit of the property value is milliseconds.
• Last User Connection Time
  The time when the user connection was last established.
• Current Idle Time
  The time for when the free connection has been idle.
• Current Share Count
  The number of requests in the connections that are being executed concurrently.