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:
-
In the Explorer's Runtime tab,
expand the Server Registry
Installed Servers
Sun ONE Application Server 7 node.
|
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.
|
-
Right-click the Unregistered JDBC Data Sources node
and choose Add new Data Source.
-
Enter properties for the JDBC data source definition.
See JDBC Data Source Property Sheet
for more information.
-
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:
-
In the Explorer's Runtime tab,
expand the Server Registry
Installed Servers
Sun ONE Application Server 7
Unregistered JDBC Data Sources node.
-
Select the JDBC data source definition
that you want to register and choose Register.
The Select Server to Register to dialog box opens.
-
Select the application server instance where
you want to create the JDBC data source
and click Register.
The Information dialog box opens.
-
Click OK to close the Information dialog box.
-
Click OK to close the Select Server to Register to
dialog box.
-
To see the new JDBC data source,
expand the application server instance
Registered JDBC Data Sources node.
Deleting a JDBC Data Source
To delete a JDBC data source from
an application server instance:
-
In the Explorer's Runtime tab,
expand the Server Registry
Installed Servers
Sun ONE Application Server 7
Administration Server
application server instance
Registered JDBC Data Sources node.
-
Right-click the JDBC data source
and choose Delete.
Legal Notices