en.help.ref-jdbcconnectionpools.html Maven / Gradle / Ivy
Show all versions of console-jdbc-plugin-help
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, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices