105 lines
5.3 KiB
HTML
105 lines
5.3 KiB
HTML
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
|
||
|
|
<html>
|
||
|
|
<head>
|
||
|
|
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
|
||
|
|
<LINK rel="stylesheet" type="text/css" href="../../../rzahg/ic.css">
|
||
|
|
|
||
|
|
<title>Administer JDBC providers and data sources with the administrative console</title>
|
||
|
|
</head>
|
||
|
|
|
||
|
|
<BODY>
|
||
|
|
<!-- Java sync-link -->
|
||
|
|
<SCRIPT LANGUAGE="Javascript" SRC="../../../rzahg/synch.js" TYPE="text/javascript"></SCRIPT>
|
||
|
|
|
||
|
|
<h4><a name="acjdbc"></a>Administer JDBC providers and data sources with the administrative console</h4>
|
||
|
|
|
||
|
|
<p>These sections describe how use the administrative console to configure, modify, and remove JDBC providers and data sources:</p>
|
||
|
|
<ul>
|
||
|
|
<li><a href="#config">Configure JDBC providers and data sources</a></li>
|
||
|
|
<li><a href="#modify">Modify JDBC providers and data sources</a></li>
|
||
|
|
<li><a href="#remove">Remove JDBC providers and data sources</a></li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<p><strong><a name="config"></a>Configure JDBC providers and data sources</strong></p>
|
||
|
|
|
||
|
|
<p>To configure a JDBC provider, follow these steps:</p>
|
||
|
|
|
||
|
|
<ol>
|
||
|
|
<li><a href="acstart.htm">Start the WebSphere administrative console</a>.</li>
|
||
|
|
<li>In the topology tree, expand <strong>Resources</strong> and click <strong>JDBC Providers</strong>.</li>
|
||
|
|
<li>Verify that the scope is set to the server level.</li>
|
||
|
|
<li>On the <strong>JDBC Providers</strong> page, click <strong>New</strong>.</li>
|
||
|
|
<li>In the <strong>JDBC Providers</strong> field, select one of the supported providers. WebSphere Application Server - Express for iSeries supports all of the DB2 UDB for iSeries drivers. For the IBM Developer Kit for Java JDBC drivers, select the correct driver for your version of i5/OS.</li>
|
||
|
|
<li>Click <strong>Apply</strong>.</li>
|
||
|
|
<li>The name and implementation classname for the provider are provided for you.
|
||
|
|
<p><strong>Note:</strong> The <strong>Native Library Path</strong> is not configurable on iSeries.</p></li>
|
||
|
|
<li>Click <strong>Apply</strong> or <strong>OK</strong>.</li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
<p>After you create a JDBC provider, configure data sources for the provider. To configure a data source, follow these steps:</p>
|
||
|
|
|
||
|
|
<ol>
|
||
|
|
<li>On the <strong>JDBC Providers</strong> page, click the name of the JDBC provider for which you want to configure a data source.</li>
|
||
|
|
<li>On the JDBC provider's detail page, click <strong>Data Sources</strong>.</li>
|
||
|
|
<li>On the <strong>Data Sources</strong> page, click <strong>New</strong>.</li>
|
||
|
|
<li>Specify a name for the data source. You can also specify optional properties on this page.</li>
|
||
|
|
<li>Click <strong>Apply</strong>.</li>
|
||
|
|
<li>You can configure these additional properties for the data source:
|
||
|
|
<ul>
|
||
|
|
<li><strong>Connection Pooling</strong></li>
|
||
|
|
<li><strong>Custom Properties</strong></li>
|
||
|
|
</ul></li>
|
||
|
|
<li><a href="acsave.htm">Save the configuration</a>.</li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
<p><strong><a name="modify"></a>Modify JDBC providers and data sources</strong></p>
|
||
|
|
|
||
|
|
<p>To modify a JDBC provider, follow these steps:</p>
|
||
|
|
|
||
|
|
<ol>
|
||
|
|
<li><a href="acstart.htm">Start the WebSphere administrative console</a>.</li>
|
||
|
|
<li>In the topology tree, expand <strong>Resources</strong> and click <strong>JDBC Providers</strong>.</li>
|
||
|
|
<li>Verify that the scope is set to the server level.</li>
|
||
|
|
<li>On the <strong>JDBC Providers</strong> page, click the name of the provider that you want to modify.</li>
|
||
|
|
<li>Make your changes.</li>
|
||
|
|
<li>Click <strong>Apply</strong>.</li>
|
||
|
|
<li><a href="acsave.htm">Save the configuration</a>.</li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
<p>You can also modify data sources for the provider. To modify a data source, follow these steps:</p>
|
||
|
|
|
||
|
|
<ol>
|
||
|
|
<li>On the <strong>JDBC Providers</strong> page, click the name of the JDBC provider that includes the data source that you want to modify.</li>
|
||
|
|
<li>On the JDBC provider's detail page, click <strong>Data Sources</strong>.</li>
|
||
|
|
<li>On the <strong>Data Sources</strong> page, click the name of the data source that you want to modify.</li>
|
||
|
|
<li>Make your changes.</li>
|
||
|
|
<li>Click <strong>Apply</strong>.</li>
|
||
|
|
<li>To modify additional properties for the data source, click <strong>Connection Pooling</strong> or <strong>Custom Properties</strong> at the bottom of the page.</li>
|
||
|
|
<li><a href="acsave.htm">Save the configuration</a>.</li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
<p><strong><a name="remove"></a>Remove JDBC providers and data sources</strong></p>
|
||
|
|
|
||
|
|
<p>To remove a JDBC provider follow these steps:</p>
|
||
|
|
|
||
|
|
<ol>
|
||
|
|
<li><a href="acstart.htm">Start the WebSphere administrative console</a>.</li>
|
||
|
|
<li>In the topology tree, expand <strong>Resources</strong> and click <strong>JDBC Providers</strong>.</li>
|
||
|
|
<li>Verify that the scope is set to the server level.</li>
|
||
|
|
<li>On the <strong>JDBC Providers</strong> page, select the checkbox for the provider that you want to remove.</li>
|
||
|
|
<li>Click <strong>Delete</strong>.</li>
|
||
|
|
<li><a href="acsave.htm">Save the configuration</a>.</li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
<p>To remove a data source, follow these steps:</p>
|
||
|
|
|
||
|
|
<ol>
|
||
|
|
<li>On the <strong>JDBC Providers</strong> page, click the name of the JDBC provider that contains the data source that you want to remove.</li>
|
||
|
|
<li>On the JDBC provider's detail page, click <strong>Data Sources</strong>.</li>
|
||
|
|
<li>On the <strong>Data Sources</strong> page, select the checkbox for the data source you want to remove.</li>
|
||
|
|
<li>Click <strong>Delete</strong>.</li>
|
||
|
|
<li><a href="acsave.htm">Save the configuration</a>.</li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
</body>
|
||
|
|
</html>
|