JDBC

In the JDBC area of the Administration Console, you can configure and monitor JDBC connections, including Connection Pools, MultiPools, Data Sources, and Tx Data Sources.

 

---

Tasks

Creating and Configuring a JDBC Connection Pool

1. Click to expand the JDBC node.

2. Click the Connection Pools node. The Connection Pool table displays in the right pane showing all the connection pools defined in your domain.

3. Click the Configure a New JDBC Connection Pool text link. A dialog displays in the right pane showing the tabs associated with configuring a new connection pool.

4. Enter values in the Name, URL, Driver Classname, Properties, and Passwords attribute fields. For more information about connection pool general attributes, see Attributes.

5. Click Create to create a connection pool instance with the name you specified in the Name field. The new instance is added under the Connection Pools node in the left pane.

6. Click the Connections tab and change the attribute fields or accept the default values as assigned. For connection attribute descriptions, see Attributes. Click Apply to save your changes.

7. Click the Testing tab and change the attribute fields or accept the default values as assigned. For testing attribute descriptions, see Attributes. Click Apply to save your changes.

8. Click the Targets tab and assign the connection pool to servers and clusters. See Assigning a JDBC Connection Pool to One or More Servers or Clusters for instructions. Click Apply to save your changes.

For what's next in setting connectivity, see the Configuration Procedures in Managing JDBC Connectivity.

Cloning a JDBC Connection Pool

1. Click to expand the JDBC and Connection Pool nodes.

2. Right-click the connection pool you want to clone and select Clone poolname. A dialog displays in the right pane showing the tabs associated with cloning a connection pool. All attribute values except Name are the same as those in cloned pool, including Connection, Testing, and Target attributes.

3. Enter a new Name. Optionally, you can modify the URL, Driver Classname, and Properties attribute fields. For more information about connection pool general attributes, see Attributes.

4. Click Clone to create a connection pool with the attributes you specified on the General tab and with cloned values on all other tabs. The new connection pool is added under the Connection Pools node in the left pane.

5. Optionally, click the remaining tabs for the connection pool and change the attribute fields or accept the current values.

6. Click Apply to save any changes you make.

Deleting a JDBC Connection Pool

1. In the left pane, click to expand the JDBC and Connection Pool nodes to display the list of connection pools in the current domain.

2. Right-click the connection pool you want to delete and select Delete poolname. A dialog displays in the right pane asking you to confirm your deletion request.

3. Click Yes to delete the connection pool.

Assigning a JDBC Connection Pool to One or More Servers or Clusters

1. In the left pane, click to expand the JDBC and Connection Pool nodes to display the list of connection pools in the current domain.

2. Click the connection pool that you want to assign. A dialog displays in the right pane showing the tabs associated with this instance.

3. Click the Targets tab.

4. Complete the following steps for the Servers or Clusters tabs:

   1. Select one or more targets in the Available column to which you want to assign the connection pool.

   2. Click the mover control to move the targets you selected to the Chosen column.

   3. Click Apply to save your assignments.

Adding a Note to a JDBC Connection Pool

1. In the left pane, click to the JDBC node to expand it.

2. Click the Connection Pools node to expand it and show the list of connection pools defined in your domain.

3. Click the connection pool to which you want to add a note. A dialog displays in the right pane showing tabs with attributes for the connection pool.

4. Click the Notes tab. Type the note in the Notes field.

5. Click Apply to save your changes.

Monitoring Connections in a JDBC Connection Pool

1. In the left pane, click to the JDBC node to expand it.

2. Click the Connection Pools node to expand it and show the list of connection pools defined in your domain.

3. Click the connection pool for which you want to see database connection information. A dialog displays in the right pane showing tabs with attributes for the connection pool.

4. Click the Monitoring tab and then click the Monitor all Active Pools text link. A table displays with information about connections in the selected JDBC connection pool.

Creating and Configuring a JDBC MultiPool

1. Click to expand the JDBC node.

2. Click the MultiPools node. The MultiPools table displays in the right pane showing all the MultiPools defined in your domain.

3. Click the Configure a New JDBC MultiPool text link. A dialog displays in the right pane showing the tabs associated with configuring a new MultiPool.

4. On the General tab do the following:

   1. Enter a value in the Name attribute field.

   2. Select one of the following options in the Algorithm Type drop-down list:

      Load Balancing—Select this option if you want to use connections from all connection pools in the MultiPool to balance the load between connection pools and underlying DBMS servers.

      High Availability—Select this option if you want to use all available connections in one pool before using connections in another.

5. Click Create to create a MultiPool instance with the name and attributes you specified on the General tab. The new instance is added under the MultiPools node in the left pane.

6. On the Pools tab do the following:

   1. Select the connection pools from the Pool List in the Available column that you want to assign to the MultiPool.

   2. Click the mover control to move the connection pools you selected to the Chosen column.

7. Click Apply to save your changes.

For what's next in the configuration process, see the Configuration Procedures in Managing JDBC Connectivity.

Cloning a JDBC MultiPool

1. In the left pane, click to expand the JDBC and MultiPool nodes.

2. Right-click the MultiPool you want to clone and select Clone MultiPool name. A dialog displays in the right pane showing the tabs associated with cloning a MultiPool.

3. Enter a value in the Name attribute field and optionally select a value for Algorithm Type.

4. Click Clone to create a MultiPool with the attributes you specified on the General tab and with cloned values on all other tabs. The new MultiPool is added under the MultiPools node in the left pane.

5. Optionally, click the remaining tabs for the MultiPool and change the attribute fields or accept the current values.

6. Click Apply to save any changes you make.

Assigning a JDBC MultiPool to One or More Servers

1. In the left pane, click to expand the JDBC and MultiPool nodes.

2. Click the MultiPool you want to assign. A dialog displays in the right pane showing the tabs associated with this MultiPool.

3. Click the Targets tab and complete the following steps:

   1. Select the servers in the Available column to which you want to assign the MultiPool.

   2. Click the right arrow to move the target servers you selected to the Chosen column.

   3. Click Apply to save your changes.

Adding a Note to a JDBC MultiPool

1. In the left pane, click the JDBC node to expand it.

2. Click the MultiPools node to expand it and show the list of multipools defined in your domain.

3. Click the MultiPool to which you want to add a note. A dialog displays in the right pane showing tabs with attributes for the MultiPool.

4. Click the Notes tab. Type the note in the Notes field.

5. Click Apply to save your changes.

Deleting a JDBC MultiPool

1. In the left pane, click to expand the JDBC and MultiPools nodes to display the list of MultiPools in the current domain.

2. Right-click the MultiPool you want to delete and select Delete MultiPool name. A dialog displays in the right pane asking you to confirm your deletion request.

3. Click Yes to delete the MultiPool.

Creating and Configuring a JDBC Data Source

1. In the left pane, click to expand the JDBC node.

2. Click the Data Sources node. The Data Sources table displays in the right pane showing all the data sources defined in your domain.

3. Click the Configure a New JDBC Data Source text link. A dialog displays in the right pane showing the tabs associated with configuring a new data source.

4. Enter values in the Name, JNDI Name, and Pool Name attribute fields. For more information about the attributes on the Configuration tab, see Attributes.

5. Click Create to create a data source with the attributes you specified on the Configuration tab. The new data source is added under the Data Sources node in the left pane.

6. Click the Targets tab and complete the following steps for the Servers and Clusters tabs:

   1. Select one or more target servers in the Available column to which you want to assign the data source.

   2. Click the right arrow to move the target servers you selected to the Chosen column.

   3. Click Apply to save your changes.

For what's next in the configuration process, see Configuration Procedures in Managing JDBC Connectivity.

Cloning a JDBC Data Source

1. In the left pane, click to expand the JDBC node.

2. Click Data Sources to view any configured data sources for your domainn.

3. Right-click the data source you want to clone and select Clone Data Source name. A dialog displays in the right pane showing the tabs associated with cloning a data source.

4. Enter values in the Name and JNDI Name attribute fields. Optionally, you can modify the other attribute values on the Configuration tab.

   Note: You must specify a new JNDI Name for the new data source. The new data source cannot use the same JNDI Name as the original data source.

   For more information about the attributes on the Configuration tab, see Attributes.

5. Click Clone to create a data source with the attributes you specified on the Configuration tab and with cloned values on all other tabs. The new data source is added under the Data Sources node in the left pane.

6. Optionally, click the remaining tabs for the data source and change the attribute fields or accept the current values.

7. Click Apply to save any changes you make.

Assigning a JDBC Data Source to a Server or Cluster

1. In the left pane, click to expand the JDBC and Data Sources nodes.

2. Click the data source you want to assign. A dialog displays in the right pane showing the tabs with attributes for the data source.

3. Click the Targets tab and complete the following steps for the Servers and Clusters tabs:

   1. Select one or more target servers in the Available column to which you want to assign to the data source.

   2. Click the right arrow to move the target servers you selected to the Chosen column.

   3. Click Apply to save your changes.

Adding a Note to a Data Source or Tx Data Source

1. In the left pane, click to expand the JDBC node.

2. Click the Data Sources or Tx Data Sources node to expand it and show the list of data sources or tx data sources defined in your domain.

3. Click the data source or tx data source to which you want to add a note. A dialog displays in the right pane showing tabs with attributes for the selected object.

4. Click the Notes tab. Type the note in the Notes field.

5. Click Apply to save your changes.

Deleting a Data Source or Tx Data Source

1. In the left pane, click to expand the JDBC node, then click to expand the Data Sources or Tx Data Sources node to display the list of data sources or tx data sources in the current domain.

2. Right-click the object you want to delete and select Delete object name. A dialog displays in the right pane asking you to confirm your deletion request.

3. Click Yes to delete the data source or tx data source.

Creating and Configuring a Tx Data Source

1. In the left pane, click to expand the JDBC node.

2. Click the Tx Data Sources node. The Tx Data Sources table displays in the right pane showing all the tx data sources defined in your domain.

3. Click the Configure a New JDBC Tx Data Source text link. A dialog displays in the right pane showing the tabs associated with configuring a new tx data source.

4. Enter values in the Name, JNDI Name, and Pool Name attribute fields. For more information about the attributes on the Configuration tab, see Attributes.

5. If the connection pool associated with the tx data source does not use an XA-compliant JDBC driver, select Emulate Two-Phase Commit for non-XA Driver.

6. Click Create to create a tx data source with the name you specified in the Name field. The new tx data source is added under the Tx Data Sources node in the left pane.

7. Click the Targets tab and complete the following steps for the Servers and Clusters tabs:

   1. Select one or more target servers in the Available column to which you want to assign the tx data source.

   2. Click the right arrow to move the target servers you selected to the Chosen column.

   3. Click Apply to save your changes.

Note: Do not create two Tx Data Sources that point to the same connection pool. If a transaction uses two different Tx Data Sources which are both pointed to the same connection pool, you will get an XA_PROTO error when you try to access the second connection.

Cloning a JDBC Tx Data Source

1. In the left pane, click to expand the JDBC and Tx Data Sources nodes.

2. Right-click the tx data source you want to clone and select Clone Tx Data Source name. A dialog displays in the right pane showing the tabs associated with cloning a tx data source.

3. Enter values in the Name and JNDI Name attribute fields. Optionally, you can modify the other attribute values on the Configuration tab.

   Note: You must specify a new JNDI Name for the new data source. The new data source cannot use the same JNDI Name as the original data source.

   For more information about the attributes on the Configuration tab, see Attributes.

4. Click Clone to create a tx data source with the attributes you specified on the Configuration tab and with cloned values on all other tabs. The new tx data source is added under the Tx Data Sources node in the left pane.

5. Optionally, click the remaining tabs for the tx data source and change the attribute fields or accept the current values.

6. Click Apply to save any changes you make.

Assigning a Tx Data Source to a Server or Cluster

1. In the left pane, click to expand the JDBC and Tx Data Sources nodes.

2. Select the tx data source that you want to assign to a server or cluster. A dialog displays in the right pane showing tabs with attributes for the selected tx data source.

3. Select the Targets tab.

4. On the Servers and Clusters tabs, choose one or both of these options:

   1. To assign the tx data source to a server or cluster, select a target in the list of Available targets and click the right arrow to move it to the Chosen list. You can select multiple targets by Shift-clicking or Ctrl-clicking targets in the list.

   2. To unassign the tx data source from a server or cluster, select a target in the list of Chosen targets and click the left arrow to move it to the Available list. You can select multiple targets by Shift-clicking or Ctrl-clicking targets in the list.

5. Click Apply to save your changes.

Creating and Configuring a JDBC Data Source Factory

1. Set up a JDBC connection pool in the Administration Console. See Managing JDBC Connectivity in the Administration Guide for more information.

2. In the left pane, click Services and expand JDBC.

3. Select JDBC Data Source Factory and in the right pane click the Configure a New JDBC Data Source Factory text link.

4. Enter values in the Name, User Name, URL, Driver Class Name, and Factory Name, attribute fields.

5. Enter any connection properties in the Properties attribute field.

6. Click Create to create the JDBC Data Source Factory. The new Data Source Factory is added under the JDBC Data source Node in the left pane.

7. Click Apply to save your changes.

8. See Resource Factories in Programming Enterprise Java Beans for more information on using the data source factory.