| <!-- |
| |
| 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 © 2005, 2017, Oracle and/or its affiliates. All rights reserved. <a href="docinfo.html">Legal Notices</a></small> |