sun.com | docs.sun.com |  | How To Buy | My Sun | Worldwide Sites |

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

User Commands | create-jdbc-connection-pool(1)

- NAME
- SYNOPSIS
- DESCRIPTION
- OPTIONS
- OPERANDS
- EXAMPLES
- EXIT STATUS
- INTERFACE EQUIVALENT
- SEE ALSO

## NAME

> create-jdbc-connection-pool - registers the JDBC connection pool to the named instance

## SYNOPSIS

> ``create-jdbc-connection-pool` --user admin_user[ --password admin_password ] [ --host localhost ][ --port 4848 ][ --passwordfile filename ][ --secure|-s ] [ --instance instance_name ]--datasourceclassname classname[ --restype res_type ] [ --steadypoolsize 8 ][ --maxpoolsize 32 ][ --maxwait 6000 ][ --poolresize 2 ] [ --idletimeout 300 ][ --isolationlevel isolation_level ][ --isisolationguaranteed=true ] [ --isconnectvalidatereq=false ][ --validationmethod auto-commit ] [ --validationtable table_name ][ --failconnection=false ][ --description text ] [ --property (name=value)[ :name=value ]* ]connection_pool_ID`

## DESCRIPTION

> Registers the JDBC connection pool to the named instance.

## OPTIONS

> --user

>   administrative user associated for the instance.

> --password

>   administrative password corresponding to the administrative user.

> --host

>   host name of the machine hosting the administrative instance.

> --port

>   administrative port number associated with the administrative host.

> --passwordfile

>   file containing passwords appropriate for the command (e.g., administrative instance).

> --secure

>   if true, uses SSL/TLS to communicate with the administrative instance.

> --instance

>   name of the instance.

> --datasourceclassname

>   name of the vendor sujpplied JDBC datasource resource manager.

> --restype

>   must be specified to disambiguate when a Datasource class implements both interfaces. An error is produced when this option has a legal value and the indicated interface is not implemented by the datasource class. This option has no default value.

> --steadypoolsize

>   minimum and initial number of connections maintained in the pool.

> --maxpoolsize

>   maximum number of connections that can be created.

> --maxwait

>   the amount of time a caller will wait before a connection timeout is sent. The default is 60 seconds. A value of 0 forces the caller to wait indefinitely.

> --poolresize

>   number of connections to be removed when `idletimeout` timer expires. Connections that have idled for longer than the timeout are candidates for removal. When the pool size reaches `steadypoolsize`, the connection removal stops.

> --idletimeout

>   maximum time (in seconds) that a connection can remain idle in the pool. After this time, the implementation can close this connection. It is recommended that this timeout is kept shorter than the server side timeout to prevent the accumulation of unusable connections in the application.

> --isolationlevel

>   specifies the transaction-isolation-level on the pooled database connections. This option does not have a default value. If not specified, the pool operates with default isolation level provided y the JDBC driver. A desired isolation level can be set using one of the standard transaction isolation levels: read-uncommitted, read-committed, repeatable-read, serializable. Applications that change the isolation level on a pooled connection programmatically risk polluting the pool. This could lead to program errors.

> --isconnectvalidatereq

>   if set to true connections are validated (checked to see if they are usable) before giving out the application. The default is false.

> --validationmethod

>   name of the validation table used to perform a query to validate a connection.

> --validationtable

>   name of the validation table used to perform a query to validate a connection. This parameter is mandatory if connection-validation-type is set to table. Verification by accessing a user specified table may become necessary for connection validation.

> --failconnection

>   if set to true, all connection in the pool must be closed if a single validation check fails; defaults to false. One attempt is made to re-establish failed connections.

> --description

>   text description of the JDBC connection pool.

> --property

>   optional attributes name/value pairs for configuring the connection pool.

## OPERANDS

> connection_pool_id

>   name of the JDBC connection pool to be created.

## EXAMPLES

> Example 1. Using create-jdbc-connection-pool

> > >     asadmin> create-jdbc-connection-pool --user admin --password adminadmin
> > >     --host fuyako --port 7070 --instance server1 --datasourceclassname XA
> > >     --restype jax.sql.DataSource --isolationlevel serializable --isconnectvalidatereq=true
> > >     --validationmethod auto-commit --description "XA Connection"
> > >     --property DatabaseName="jdbc\:pointbase\:server\:\/\/localhost\/sample"
> > >     :User=public:Password=public XA_connection_pool
> > >     Created the JDBC connection pool resource with id=XA_connection_pool

> > Where: the XA_connection_pool is created. The escape character \ is used in the --property option to distinguish the colons (:) and the backslash (/).

## EXIT STATUS

> 0

>   command executed successfully

> 1

>   error in executing the command

## INTERFACE EQUIVALENT

> JDBC folder, Connection Pool page

## SEE ALSO

> `delete-jdbc-connection-pool`(1), `list-jdbc-connection-pool`(1)

Sun Java System Application Server | Go To Top | Last Changed 24 Dec 2003

Company Info | Contact | Copyright 2004 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms.