| <!-- |
| |
| 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="task-setdbaccess" name="task-setdbaccess"></a><a id="GHJDB00030" name="GHJDB00030"></a></p> |
| |
| <h4><a id="sthref2" name="sthref2"></a>To Set Up Database Access</h4> |
| <a name="BEGIN" id="BEGIN"></a> |
| <p>To store, organize, and retrieve data, most applications use relational databases.</p> |
| <p>GlassFish Server includes a copy of the Java DB database and is preconfigured with the ability to access this database.</p> |
| <ol> |
| <li> |
| <p>Install a supported database product.</p> |
| <p>For a list of supported databases, see <a href="http://www.oracle.com/pls/topic/lookup?ctx=E26576_01&id=GSRLN"><i>Oracle GlassFish Server Release Notes</i></a>.</p> |
| </li> |
| <li> |
| <p>Install a driver supporting the JDBC API (JDBC driver) for the database.</p> |
| <p>Ensure that the driver you want to use to create database connections is installed on all servers on which you want to deploy the data source.</p> |
| </li> |
| <li> |
| <p>Ensure that the driver's JAR file is accessible to the domain's server instance.</p> |
| <p>See <a href="task-integratejdbcdriver.html">To Integrate a JDBC Driver</a>.</p> |
| </li> |
| <li> |
| <p>Create the database.</p> |
| <p>Usually, the application provider delivers scripts for creating and populating the database.</p> |
| </li> |
| <li> |
| <p>Create a connection pool for the database.</p> |
| <p>See <a href="task-jdbcconnectionpoolnew.html">To Create a JDBC Connection Pool</a>.</p> |
| </li> |
| <li> |
| <p>Create a JDBC resource that points to the connection pool.</p> |
| <p>See <a href="task-jdbcresourcenew.html">To Create a JDBC Resource</a>.</p> |
| </li> |
| </ol> |
| <a id="sthref3" name="sthref3"></a> |
| <h5>See Also</h5> |
| <ul> |
| <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> |
| <li> |
| <p><a href="task-jdbcconnectionpooledit.html">To Edit JDBC Connection Pool General Settings</a></p> |
| </li> |
| <li> |
| <p><a href="task-jdbcconnectionpooladvance.html">To Edit JDBC Connection Pool Advanced Attributes</a></p> |
| </li> |
| <li> |
| <p><a href="task-verifyconnpoolsettings.html">To Verify Connection Pool Settings</a></p> |
| </li> |
| <li> |
| <p><a href="task-jdbcconnectionpoolproperty.html">To Edit JDBC Connection Pool Properties</a></p> |
| </li> |
| <li> |
| <p><a href="task-jdbcconnectionpooldelete.html">To Delete a JDBC Connection Pool</a></p> |
| </li> |
| </ul> |
| |
| |
| <small>Copyright © 2005, 2017, Oracle and/or its affiliates. All rights reserved. <a href="docinfo.html">Legal Notices</a></small> |