100 lines
5.9 KiB
HTML
100 lines
5.9 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>Manage JDBC providers for your application server</title>
|
||
|
|
</head>
|
||
|
|
|
||
|
|
<BODY>
|
||
|
|
<!-- Java sync-link -->
|
||
|
|
<SCRIPT LANGUAGE="Javascript" SRC="../../../rzahg/synch.js" TYPE="text/javascript"></SCRIPT>
|
||
|
|
|
||
|
|
<h4><a name="guimngjdbcpvdrs"></a>Manage JDBC providers for your application server</h4>
|
||
|
|
|
||
|
|
<p>A JDBC provider specifies how database connections are created for data sources that are associated with the provider and which JDBC driver is used for the connection. Creating JDBC providers define the JDBC driver that your application uses. The Manage JDBC Providers form allows you to view the list of defined JDBC providers, create a new JDBC provider, modify the properties of an existing JDBC provider, or remove a JDBC provider from your application server. WebSphere Application Server - Express for iSeries supports these JDBC drivers:</p>
|
||
|
|
|
||
|
|
<ul>
|
||
|
|
<li>DB2 UDB for iSeries (IBM Developer Kit for Java JDBC driver - V5R2 and later)</li>
|
||
|
|
<li>DB2 UDB for iSeries (IBM Developer Kit for Java JDBC driver, JTA-enabled - V5R2 and later)</li>
|
||
|
|
<li>DB2 UDB for iSeries (IBM Developer Kit for Java JDBC driver - V5R1 and earlier)</li>
|
||
|
|
<li>DB2 UDB for iSeries (IBM Developer Kit for Java JDBC driver, JTA-enabled - V5R1 and earlier)</li>
|
||
|
|
<li>DB2 UDB for iSeries (IBM Toolbox for Java JDBC driver)</li>
|
||
|
|
<li>DB2 UDB for iSeries (IBM Toolbox for Java JDBC driver, JTA-enabled)</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<p>For additional information on the IBM Toolbox for Java JDBC driver, see <a href="refjdbcdrv.htm">The IBM Toolbox for Java JDBC driver</a>.</p>
|
||
|
|
|
||
|
|
<p>To manage your JDBC providers on an application server, follow these steps:</p>
|
||
|
|
<ol>
|
||
|
|
<li><a href="../../../rzaie/rzaiegetstarted.htm">Start the HTTP Server Administration interface</a>.</li>
|
||
|
|
<li>Click the <strong>Manage</strong> tab.</li>
|
||
|
|
<li>Select an application server from the <strong>Server</strong> list.</li>
|
||
|
|
<li>Expand <strong>Resource Configuration</strong>.</li>
|
||
|
|
<li>Click <strong>Manage JDBC Providers</strong>.</li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
<p>From the Manage JDBC Providers form, you can do the following:</p>
|
||
|
|
<ul>
|
||
|
|
<li><a href="#createjdbc">Create a new JDBC provider</a></li>
|
||
|
|
<li><a href="#edtpropjdbc">Edit the properties of existing JDBC provider</a></li>
|
||
|
|
<li><a href="#remove">Remove a JDBC provider</a></li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<p><a name="createjdbc"></a><strong>Create a new JDBC provider</strong></p>
|
||
|
|
|
||
|
|
<p><strong>Note:</strong> With the exception of step 1, these steps also apply to the Create JDBC Provider wizard.</p>
|
||
|
|
<ol>
|
||
|
|
<li>Click <strong>Create</strong>.</li>
|
||
|
|
<li>Specify a name for your new JDBC provider in the <strong>JDBC provider name</strong> field.</li>
|
||
|
|
<li>Click <strong>Next.</strong></li>
|
||
|
|
<li>Select the database access method.
|
||
|
|
<ul>
|
||
|
|
<li><strong>Local - IBM Developer Kit for Java JDBC(TM) driver</strong><br>
|
||
|
|
Select this option if the application server and the database are located on the same system.</li>
|
||
|
|
<li><strong>Remote - IBM Toolkit for Java JDBC(TM) driver </strong><br>
|
||
|
|
Select this option if the application server and the database are located on separate systems or logical partitions (LPAR).</li>
|
||
|
|
</ul></li>
|
||
|
|
<li>Select Java Transaction API (JTA) enablement.
|
||
|
|
<ul>
|
||
|
|
<li><strong>Enabled</strong><br>
|
||
|
|
JTA is enabled. JTA supports two-phase commit, which is a database protocol that ensures a transaction is completely committed to the database. This is necessary for transactions that are comprised of multiple updates to one or more databases. If one of the updates fails, the entire transaction fails, and all updates that were made in the transaction are rolled back. This ensures that only complete information is saved.</li>
|
||
|
|
<li><strong>Disabled</strong><br>
|
||
|
|
JTA is disabled. If you do not need to use two-phase commit, disable JTA. For example, if a transaction only updates one database, JTA is not required. Disabling JTA can improve application performance.</li>
|
||
|
|
</ul></li>
|
||
|
|
<li>The summary page lists all of the choices you have made in the wizard. If any of the information displayed is incorrect, click <strong>Back</strong> until you reach the wizard form with the incorrect information and make your corrections. Click <strong>Finish</strong> to complete the wizard.</li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
<p><a name="edtpropjdbc"></a><strong>Edit the properties of existing JDBC provider</strong></p>
|
||
|
|
<ol>
|
||
|
|
<li>Select a JDBC provider from the <strong>JDBC providers</strong> table.</li>
|
||
|
|
<li>Click <strong>Properties</strong>.</li>
|
||
|
|
<li>You can edit one or more properties shown for the JDBC provider. <strong> </strong>
|
||
|
|
<ul>
|
||
|
|
<li><strong>Edit the JDBC provider name or description</strong>
|
||
|
|
<ol type="a">
|
||
|
|
<li>Click the <strong>General</strong> tab in the JDBC Provider Properties form. This value allows for an optional user-defined descriptions of the JDBC provider.</li>
|
||
|
|
<li>Specify a new name for the JDBC provider in the <strong>JDBC provider name</strong> field.</li>
|
||
|
|
<li>Specify a new description for the JDBC provider in the <strong>JDBC provider description</strong> field.</li>
|
||
|
|
<li>Specify a new JDBC class path in the <strong>Class path</strong> field.
|
||
|
|
This field is only available if the database access method is remote.</li>
|
||
|
|
</ol></li>
|
||
|
|
<li><strong>Add, edit, or delete a data source</strong>
|
||
|
|
<ol type="a">
|
||
|
|
<li>Click the <strong>Data Sources</strong> tab in the JDBC Provider Properties form. For more information on managing data sources, see <a href="guimngdtsrs.htm">Manage data sources for your application server</a>.</li>
|
||
|
|
</ol></li>
|
||
|
|
</ul></li>
|
||
|
|
<li>Click <strong>Apply</strong> or <strong>OK</strong> to save your changes.</li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
<p><a name="remove"></a><strong>Remove a JDBC provider</strong></p>
|
||
|
|
<ol>
|
||
|
|
<li>Select a JDBC provider from the table.</li>
|
||
|
|
<li>Click <strong>Remove</strong>.</li>
|
||
|
|
<li>Click <strong>OK</strong></li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
</body>
|
||
|
|
</html>
|