Create/Edit JDBC Resource

Use this page to create, or edit, a JDBC data source.

A JDBC data source represents the physical data source (for example, RDBMS) - it encapsulates the information required to connect to a specific data store using specific security credentials. The JDBC specification defines a number of standard properties used to specify this information and many vendors also provide there own properties for configuring proprietary features such as diagnostics and run-time optimizations. The Data Source provides a standard way to hold data source connection and configuration information outside of the application so modification does not require code changes.

The following table describes the fields and buttons on the screen. The left column lists the fields and buttons; the right column describes the functionality.

Field or Button
Description

JNDI Name

JDBC Resources are stored in the JNDI repository and are accessed using the JNDI name. The JNDI name has an explicit root at Java:comp:env/ and therefore you do not need to specify that part of the name. It is recommended that JDBC Resources (DataSources) are stored under the 'jdbc' sub-context so your JNDI name would typically be similar to this value; jdbc/EmployeeDB_DS.

Pool Name

Select a pool name for the new datasource, from the list of pool names in the drop-down list. You can create a new connection pool from the Connection Pool page. All registered connection pools will appear in this drop-down list.

The pool name that you specify points to a named pool definition, that specifies all aspects of database connectivity. More than one JDBC resource can use a single pool definition.

Description

A brief description that describes the purpose of the data source. Your description must not exceed 250 characters.

Data Source Enabled

Use this checkbox to enable or disable a datasource. A datasource cannot be used to connect to a database unless it is enabled.

OK

Click OK to save your new datasource.

Cancel

Click Cancel to cancel the new datasource. When you click cancel, you are returned to the main JDBC resources page, from where you can create a new datasource again.

See also

Manage JDBC Resources


Legal Notices
Copyright © 2004 Sun Microsystems, Inc. All rights reserved.
SUN PROPRIETARY/CONFIDENTIAL