JDBC Data Sources

A JDBC data source points to a database through the specified connection pool. To use the JDBC data source, you create a JDBC connection pool, create a JDBC data source definition, and register the definition to the Sun ONE Application Server instance. More than one J2EE component can use the same JDBC data source.

Creating a JDBC Data Source Definition

To create a JDBC data source definition:

  1. In the Explorer's Runtime tab, expand the Server Registry and expand Installed Servers and expand Sun ONE Application Server 7 node.

    note  If you do not see any Administration Server nodes, the Administration Server of the Sun ONE Application Server must be added under the Installed Servers subnode of the Server Registry node. See here for more information.

  2. Right-click the Unregistered JDBC Data Sources node and choose Add new Data Source.
  3. Enter properties for the JDBC data source definition. See JDBC Data Source Property Sheet for more information.
  4. Once the definition is created, you must register it to the application server instance where you want to create the JDBC data source. See Registering a JDBC Data Source Definition for more information.

Registering a JDBC Data Source Definition

To register a JDBC data source definition to an application server instance:

  1. In the Explorer's Runtime tab, expand the Server Registry and expand Installed Servers and expand Sun ONE Application Server 7 and expand Unregistered JDBC Data Sources node.
  2. Select the JDBC data source definition that you want to register and choose Register. The Select Server to Register to dialog box opens.
  3. Select the application server instance where you want to create the JDBC data source and click Register. The Information dialog box opens.
  4. Click OK to close the Information dialog box.
  5. Click OK to close the Select Server to Register to dialog box.
  6. To see the new JDBC data source, expand the application server instance and expand Registered JDBC Data Sources node.

Deleting a JDBC Data Source

To delete a JDBC data source from an application server instance:

  1. In the Explorer's Runtime tab, expand the Server Registry and expand Installed Servers and expand Sun ONE Application Server 7 and expand Administration Server and expand application server instance and expand Registered JDBC Data Sources node.
  2. Right-click the JDBC data source and choose Delete.

See also
   JDBC Data Source Property Sheet
Registering a Resource
Server Instance

Legal Notices