en.help.ref-jdbcconnectionpools.html Maven / Gradle / Ivy
Show all versions of console-jdbc-plugin Show documentation
Connection Pools
A JDBC connection pool contains a group of JDBC connections that are created when the connection pool is registered. Connection pools use a JDBC driver to create physical database connections. Your application borrows a connection from the pool, uses it, then returns it to the pool by closing it. To create a JDBC resource, specify the associated connection pool. Multiple JDBC resources can specify a single connection pool.
A JDBC connection pool is a group of reusable connections for a particular database. Because creating each new physical connection is time-consuming, the server maintains a pool of available connections to increase performance. When an application requests a connection, it obtains one from the pool. When an application closes a connection, the connection is returned to the pool.
When creating a connection pool with the Administration Console, you are defining the aspects of a connection to a specific database.
Use the JDBC Connection Pools page to configure JDBC connection pools.
For each connection pool, the following information is provided.
- Pool Name
-
The name of the connection pool.
- Resource Type
-
The resource type of the connection pool.
- Classname
-
The name of the vendor-specific class that implements the javax.sql.XADataSource
, java.sql.ConnectionPoolDataSource
, javax.sql.DataSource
, or java.sql.Driver
API.
- Description
-
A short description of the connection pool.
The Pools table also contains the following options.
- New
-
Button to create a new connection pool.
- Delete
-
Button to delete one or more selected connection pools.
Related Tasks
-
-
-
-
-
-
-
-
Related asadmin Commands
-
-
-
-
-
-
-
-
Copyright © 2005, 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices