95 lines
6.5 KiB
HTML
95 lines
6.5 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 data sources for your application server</title>
|
||
|
|
</head>
|
||
|
|
|
||
|
|
<BODY>
|
||
|
|
<!-- Java sync-link -->
|
||
|
|
<SCRIPT LANGUAGE="Javascript" SRC="../../../rzahg/synch.js" TYPE="text/javascript"></SCRIPT>
|
||
|
|
|
||
|
|
<h4><a name="guimngdtsrs"></a>Manage data sources for your application server</h4>
|
||
|
|
|
||
|
|
<p>A data source represents a specific database that is used by one or more applications installed in your application server. Data sources provide connection pooling and a JNDI name which can be used by applications to access the data source. The Manage Data Sources form allows you to view a list of all the defined data sources for an application server, create new data sources, modify the properties of an existing data source, or remove a data source.</p>
|
||
|
|
|
||
|
|
<p>To manage your data sources for 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 Data Sources</strong>.</li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
<p>From the Manage Data Sources form, you can do the following:</p>
|
||
|
|
<ul>
|
||
|
|
<li><a href="#createdsource">Create a new data source</a></li>
|
||
|
|
<li><a href="#edtpropdsource">Edit the properties of an existing data source</a></li>
|
||
|
|
<li><a href="#remove">Remove a data source</a></li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<p><a name="createdsource"></a><strong>Create a new data source</strong></p>
|
||
|
|
|
||
|
|
<p><strong>Note:</strong> With the exception of step 1, the below steps can be used with the Create Data Source wizard.</p>
|
||
|
|
<ol>
|
||
|
|
<li>Click <strong>Create</strong>.</li>
|
||
|
|
<li>Specify a name for the data source in the <strong>Data source name</strong> field. This value specifies the user-defined name of the data source.</li>
|
||
|
|
<li>Click <strong>Next</strong>.</li>
|
||
|
|
<li>Select a JDBC provider for your data source.
|
||
|
|
<ul>
|
||
|
|
<li><strong>Create new JDBC provider</strong><br>
|
||
|
|
Select this option to create a new JDBC provider for your data source.
|
||
|
|
<ol type="a">
|
||
|
|
<li>Click <strong>Next</strong>.</li>
|
||
|
|
<li>See <a href="guimngjdbcpvdrs.htm#createjdbc">Create a new JDBC provider</a> for instructions on how to create a JDBC provider for your data source.</li>
|
||
|
|
</ol></li>
|
||
|
|
<li><strong>Select an existing JDBC provider</strong><br>
|
||
|
|
Select this option to use a preexisting JDBC provider.
|
||
|
|
<ol type="a">
|
||
|
|
<li>Click <strong>Next</strong>.</li>
|
||
|
|
<li>Select a JDBC provider from the table.</li>
|
||
|
|
<li>Click <strong>Next</strong>.</li>
|
||
|
|
</ol></li>
|
||
|
|
</ul></li>
|
||
|
|
<li>Specify a name for the database in the <strong>Database name</strong> field. This value specifies the name of the database that the current data source represents. If the database resides on the same physical machine as the application server, this value is *LOCAL. If the database is on a different machine, this value is the name of the server where the database resides.</li>
|
||
|
|
<li>Specify a name for the collection, schema or library for the database in the <strong>Collection, Schema or Library name</strong> field. This value specifies additional information to access the database data. Collection, schema, and library all represent organized collections of named objects (tables) in a database. When you specify the collection name, you do not need to use fully qualified table names in the application code.</li>
|
||
|
|
<li>Click <strong>Next</strong>.</li>
|
||
|
|
<li>Specify a name for the JNDI in the <strong>JNDI name</strong> field or keep the provided value. The wizard provides a JNDI name for the data source. It is recommended that you use this default value. The Java Naming and Directory Interface (JNDI) provides naming and directory functionality for Java applications and resources. Applications use JNDI to access named Java objects. The conventional format of JNDI names for data sources is jdbc/<em>dataSourceName</em>.</li>
|
||
|
|
<li>Click <strong>Next</strong>.</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="edtpropdsource"></a><strong>Edit the properties of an existing data source</strong></p>
|
||
|
|
<ol>
|
||
|
|
<li>Select a data source from the <strong>All data sources</strong> table.</li>
|
||
|
|
<li>Click <strong>Properties</strong>.</li>
|
||
|
|
<li>You can edit one or more of the properties shown for the data source.
|
||
|
|
<ul>
|
||
|
|
<li><strong>Data source name</strong><br>
|
||
|
|
Specify a new name in the <strong>Data source name</strong> field. This value specifies the user-defined name of the data source.</li>
|
||
|
|
<li><strong>Database name</strong><strong></strong><br>
|
||
|
|
Specify a name for the database in the <strong>Database name</strong> field. This value specifies the name of the database that the current data source represents. If the database resides on the same physical machine as the application server, this value is *LOCAL. If the database is on a different machine, this value is the name of the server where the database resides.</li>
|
||
|
|
<li><strong>Collection, schema, or library name</strong><br>
|
||
|
|
Specify a new collection, schema, or library name. Collections, schemas, and libraries all represent organized collections of named objects (tables) in a database.</li>
|
||
|
|
<li><strong>JNDI name</strong><br>
|
||
|
|
Specify a name for the JNDI in the <strong>JNDI name</strong> field or keep the provided value. The Java Naming and Directory Interface (JNDI) provides naming and directory functionality for Java applications and resources. Applications use JNDI to access named Java objects. The conventional format of JNDI names for data sources is jdbc/<em>dataSourceName</em>.</li>
|
||
|
|
<li><strong>Data source description</strong><br>
|
||
|
|
Specify a brief description in the <strong>Data source description</strong> field. This value specifies the user-defined description of the data source.</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 data source</strong></p>
|
||
|
|
<ol>
|
||
|
|
<li>Select a data source from the table.</li>
|
||
|
|
<li>Click <strong>Remove</strong>.</li>
|
||
|
|
<li>Click <strong>OK</strong>.</li>
|
||
|
|
</ol>
|
||
|
|
|
||
|
|
</body>
|
||
|
|
</html>
|