From the Common Tasks section in the browser interface, click Sun Java System AS 8.
Under SJSAS AppServer Resources->SJSAS 8.1 JDBC Resource click Manage JDBC Resources.
Under Component Procedures click the Run action next to default: install.
In the Plan Parameters area, select the variable settings for the JDBC Resource you want to install.
If the variable settings have been established for this component, select the appropriate settings from the menu.
If the settings are not available from the menu, click Select From List.
The Select Variable Settings From List window displays.
To create a new set of variable settings, select Create Set.
The following list provides commonly-updated variables for the Install component.
Required. A name for the new variable set you create.
A unique ID to associate the JDBC Resource with an Install component.
The domain name in which this JDBC Resource will be located
To use variable components from another component, click Import Set.
For more information about importing variable sets, see “How to Run a Plan” in N1 Grid Service Provisioning System 5.0 Operation and Provisioning Guide.
Select the target host.
Deselect the Target Host Set checkbox.
If you want to run a detailed check (preflight) before installing, select Perform Detailed Preflight.
Click Run Plan (includes preflight).
From the Common Tasks section in the browser interface, click Sun Java System AS 8.
Under SJSAS AppServer Resources->SJSAS 8.1 JDBC Resource click Manage JDBC Resources.
Under Component Procedures click the Run action next to createJDBCResource.
Select the installation on which you want to create the JDBC resource.
Under Plan Variables:
Click Run Plan (includes preflight).
From the Common Tasks section in the browser interface, click Sun Java System AS 8.
Under SJSAS AppServer Resources->SJSAS 8.1 JDBC Resource click Manage JDBC Resources.
Under Component Procedures click the Run action next to deleteJDBCResource.
Select the installation on which you want to delete the JDBC resource.
Under Plan Variables:
Click Run Plan (includes preflight).
From the Common Tasks section in the browser interface, click Sun Java System AS 8.
Under SJSAS AppServer Resources->SJSAS 8.1 JDBC Resource click Manage JDBC Resources.
Under Component Procedures click the Run action next to listJDBCResources.
Select the installation on which you want to list the JDBC resources.
Under Plan Variables enter the target cluster or server instance name of the resource you want to delete.
Click Run Plan (includes preflight).
From the Common Tasks section in the browser interface, click Sun Java System AS 8.
Under SJSAS AppServer Resources->SJSAS 8.1 JDBC Resource click Manage JDBC Resources.
Under Component Procedures click the Run action next to createJDBCConnectionPool.
Select the installation on which you want to create the connection pool.
Under Plan Variables:
Set the name of the Connection Pool.
(Optional) Enter a description of the connection pool.
Enter the JDBC data source resource manager for your connection pool.
Enter the interface the data source class implements.
Valid entries are:
DataSource
ConnectionPoolDataSource
XADataSource
Enter the minimum number of connections created by the pool.
Enter the maximum number of connections maintained by the pool.
Enter the number of connections to be removed when the time out timer expires.
Enter the maximum number of seconds a connection can be idle in the pool.
Enter the transaction isolation level for the connection pool.
Valid entries are:
read-uncommitted
read-committed
repeatable-read
serializable
If the entry is blank, the default isolation level of the JDBC driver is used.
Specify whether the connections should be validated before being allocated to an application. Valid entries are true or false.
Enter any attribute name/value pairs for the JDBC driver.
Click Run Plan (includes preflight).
From the Common Tasks section in the browser interface, click Sun Java System AS 8.
Under SJSAS AppServer Resources->SJSAS 8.1 JDBC Resource click Manage JDBC Resources.
Under Component Procedures click the Run action next to deleteJDBCConnectionPool.
Select the installation on which you want to delete the JDBC resource.
Under Plan Variables:
Click Run Plan (includes preflight).
From the Common Tasks section in the browser interface, click Sun Java System AS 8.
Under SJSAS AppServer Resources->SJSAS 8.1 JDBC Resource click Manage JDBC Resources.
Under Component Procedures click the Run action next to listJDBCConnectionPools.
Select the installation on which you want to list the JDBC resources.
Click Run Plan (includes preflight).