All Downloads are FREE. Search and download functionalities are using the official Maven repository.

en.help.ref-jdbcconnectionpools.html Maven / Gradle / Ivy

There is a newer version: 8.0.0-JDK17-M7
Show newest version


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




© 2015 - 2024 Weber Informatics LLC | Privacy Policy