blob: e2df7183568e86a258f85b403ed0d5805c946ee7 [file] [log] [blame]
type=page
status=published
title=delete-jdbc-connection-pool
next=delete-jdbc-resource.html
prev=delete-javamail-resource.html
~~~~~~
= delete-jdbc-connection-pool
[[delete-jdbc-connection-pool-1]][[GSRFM00088]][[delete-jdbc-connection-pool]]
== delete-jdbc-connection-pool
Removes the specified JDBC connection pool
[[sthref777]]
=== Synopsis
[source]
----
asadmin [asadmin-options] delete-jdbc-connection-pool [--help]
[--cascade={false|true}]
[--target target]
jdbc_connection_pool_id
----
[[sthref778]]
=== Description
The `delete-jdbc-connection-pool` subcommand deletes a JDBC connection
pool. Before running this subcommand, all associations to the JDBC
connection pool must be removed.
This subcommand is supported in remote mode only.
[[sthref779]]
=== Options
asadmin-options::
Options for the `asadmin` utility. For information about these
options, see the link:asadmin.html#asadmin-1m[`asadmin`(1M)] help page.
`--help`::
`-?`::
Displays the help text for the subcommand.
`--cascade`::
If the option is set to true, all the JDBC resources associated with
the pool, apart from the pool itself, are deleted. When set to false,
the deletion of pool fails if any resources are associated with the
pool. Resources must be deleted explicitly or the option must be set
to true. The default value is false.
`--target`::
Do not specify this option. This option is retained for compatibility
with earlier releases. If you specify this option, a syntax error does
not occur. Instead, the subcommand runs successfully and displays a
warning message that the option is ignored.
[[sthref780]]
=== Operands
jdbc_connection_pool_id::
The name of the JDBC resource to be removed.
[[sthref781]]
=== Examples
[[GSRFM556]][[sthref782]]
==== Example 1   Deleting a JDBC Connection Pool
This example deletes the `sample_derby_pool` JDBC connection pool.
[source]
----
asadmin> delete-jdbc-connection-pool --cascade=false sample_derby_pool
Command delete-jdbc-connection-pool executed correctly.
----
[[sthref783]]
=== Exit Status
0::
subcommand executed successfully
1::
error in executing the subcommand
[[sthref784]]
=== See Also
link:asadmin.html#asadmin-1m[`asadmin`(1M)]
link:create-jdbc-connection-pool.html#create-jdbc-connection-pool-1[`create-jdbc-connection-pool`(1)],link:list-jdbc-connection-pools.html#list-jdbc-connection-pools-1[`list-jdbc-connection-pools`(1)]