appserver/admingui/jdbc/src/main/help/en/help/ref-jdbcresources.html

<!--

    Copyright (c) 2005, 2018 Oracle and/or its affiliates. All rights reserved.

    This program and the accompanying materials are made available under the
    terms of the Eclipse Public License v. 2.0, which is available at
    http://www.eclipse.org/legal/epl-2.0.

    This Source Code may also be made available under the following Secondary
    Licenses when the conditions for such availability set forth in the
    Eclipse Public License v. 2.0 are satisfied: GNU General Public License,
    version 2 with the GNU Classpath Exception, which is available at
    https://www.gnu.org/software/classpath/license.html.

    SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0

-->

<p><a id="ref-jdbcresources" name="ref-jdbcresources"></a><a id="GHJDB00020" name="GHJDB00020"></a></p>

<h4><a id="sthref29" name="sthref29"></a>JDBC Resources</h4>
<a name="BEGIN" id="BEGIN"></a>
<p>A Java DataBase Connectivity (JDBC) resource (data source) provides applications with the means of connecting to a database. Typically, the administrator creates a JDBC resource for each database accessed by the applications deployed in a domain; however, more than one JDBC resource can be created for a database.</p>
<p>Applications get a database connection from a connection pool by looking up a data source on the Java Naming and Directory Interface (JNDI) API tree and then requesting a connection. The connection pool associated with the data source provides the connection to the application.</p>
<p>Use the JDBC Resources page to configure JDBC resources.</p>
<p>For each resource, the following information is provided.</p>
<dl>
<dt>JNDI Name</dt>
<dd>
<p>A unique name that identifies the JDBC resource.</p>
</dd>
<dt>Logical JNDI Name</dt>
<dd>
<p>The logical JNDI name for the resource. See <a href="../../../common/en/help/ref-logicaljndinames.html">Logical JNDI Names</a> for more information.</p>
</dd>
<dt>Enabled</dt>
<dd>
<p>(This column is displayed if only the default server instance, <code>server</code>, exists in the domain.)</p>
<p>A check mark if the resource is enabled, or an X if the resource is disabled.</p>
</dd>
<dt>Status</dt>
<dd>
<p>(This column is displayed if any clusters or standalone instances have been created in the domain.)</p>
<p>The number of clusters and standalone instances to which the resource is targeted and how many of these targets the resource is enabled on. For example, "Enabled on 2 of 4 Target(s)" means that the resource is targeted to four clusters and standalone instances and that it is enabled on two of these four targets.</p>
</dd>
<dt>Connection Pool</dt>
<dd>
<p>The JDBC connection pool associated with the resource.</p>
</dd>
<dt>Description</dt>
<dd>
<p>A short description of the resource.</p>
</dd>
</dl>
<p>The Resources table also contains the following options.</p>
<dl>
<dt>New</dt>
<dd>
<p>Button to create a new resource.</p>
</dd>
<dt>Delete</dt>
<dd>
<p>Button to delete one or more selected resources.</p>
</dd>
<dt>Enable</dt>
<dd>
<p>Button to enable one or more selected resources.</p>
</dd>
<dt>Disable</dt>
<dd>
<p>Button to disable one or more selected resources.</p>
</dd>
</dl>
<a id="sthref30" name="sthref30"></a>
<h5>Related Tasks</h5>
<ul>
<li>
<p><a href="task-setdbaccess.html">To Set Up Database Access</a></p>
</li>
<li>
<p><a href="task-integratejdbcdriver.html">To Integrate a JDBC Driver</a></p>
</li>
<li>
<p><a href="task-jdbcresourcenew.html">To Create a JDBC Resource</a></p>
</li>
<li>
<p><a href="task-jdbcresourcesedit.html">To Edit a JDBC Resource</a></p>
</li>
<li>
<p><a href="task-jdbcresourcesdelete.html">To Delete a JDBC Resource</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpoolnew.html">To Create a JDBC Connection Pool</a></p>
</li>
</ul>
<a id="sthref31" name="sthref31"></a>
<h5>Related asadmin Commands</h5>
<ul>
<li>
<p><a href="http://www.oracle.com/pls/topic/lookup?ctx=E26576_01&id=GSRFM00001"><code>add-resources</code>(1)</a></p>
</li>
<li>
<p><a href="http://www.oracle.com/pls/topic/lookup?ctx=E26576_01&id=GSRFM00037"><code>create-jdbc-resource</code>(1)</a></p>
</li>
<li>
<p><a href="http://www.oracle.com/pls/topic/lookup?ctx=E26576_01&id=GSRFM00089"><code>delete-jdbc-resource</code>(1)</a></p>
</li>
<li>
<p><a href="http://www.oracle.com/pls/topic/lookup?ctx=E26576_01&id=GSRFM00174"><code>list-jdbc-resources</code>(1)</a></p>
</li>
<li>
<p><a href="http://www.oracle.com/pls/topic/lookup?ctx=E26576_01&id=GSRFM00036"><code>create-jdbc-connection-pool</code>(1)</a></p>
</li>
<li>
<p><a href="http://www.oracle.com/pls/topic/lookup?ctx=E26576_01&id=GSRFM00234"><code>start-database</code>(1)</a></p>
</li>
<li>
<p><a href="http://www.oracle.com/pls/topic/lookup?ctx=E26576_01&id=GSRFM00239"><code>stop-database</code>(1)</a></p>
</li>
</ul>


<small>Copyright &#169; 2005, 2017, Oracle and/or its affiliates. All rights reserved. <a href="docinfo.html">Legal Notices</a></small>