JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle GlassFish Server 3.1 Administration Guide
search filter icon
search icon

Document Information


1.  Overview of GlassFish Server Administration

Default Settings and Locations

Configuration Tasks

Administration Tools

Instructions for Administering GlassFish Server

Part I Runtime Administration

2.  General Administration

3.  Administering Domains

4.  Administering the Virtual Machine for the Java Platform

5.  Administering Thread Pools

6.  Administering Web Applications

7.  Administering the Logging Service

8.  Administering the Monitoring Service

9.  Writing and Running JavaScript Clients to Monitor GlassFish Server

10.  Administering Life Cycle Modules

11.  Extending and Updating GlassFish Server

Part II Resources and Services Administration

12.  Administering Database Connectivity

About Database Connectivity

Setting Up the Database

To Install the Database and Database Driver

To Start the Database

To Stop the Database

Java DB Utility Scripts

To Configure Your Environment to Run Java DB Utility Scripts

Configuring Access to the Database

Administering JDBC Connection Pools

To Create a JDBC Connection Pool

To List JDBC Connection Pools

To Contact (Ping) a Connection Pool

To Reset (Flush) a Connection Pool

To Update a JDBC Connection Pool

To Delete a JDBC Connection Pool

Configuring Specific JDBC Connection Pool Features

Administering JDBC Resources

To Create a JDBC Resource

To List JDBC Resources

To Update a JDBC Resource

To Delete a JDBC Resource

Enabling the jdbc/__default Resource in a Clustered Environment

To Enable the jdbc/__default Resource for a Clustered Environment

Integrating the JDBC Driver

Supported Database Drivers

Making the JDBC Driver JAR Files Accessible

Automatic Detection of Installed Drivers

Configuration Specifics for JDBC Drivers

IBM DB2 Database Type 2 Driver

IBM DB2 Database Type 4 Driver

Java DB/Derby Type 4 Driver

MySQL Server Database Type 4 Driver

Oracle 10 Database Driver

Oracle 11 Database Driver

PostgreSQL Type 4 Driver

DataDirect Type 4 Driver for IBM DB2 Database

DataDirect Type 4 Driver for IBM Informix

DataDirect Type 4 Driver for Microsoft SQL Server Database

DataDirect Type 4 Driver for MySQL Server Database

DataDirect Type 4 Driver for Oracle 11 Database

DataDirect Type 4 Driver for Sybase Database

Inet Oraxo Driver for Oracle Database

Inet Merlia Driver for Microsoft SQL Server Database

Inet Sybelux Driver for Sybase Database

JConnect Type 4 Driver for Sybase ASE 12.5 Database

13.  Administering EIS Connectivity

14.  Administering Internet Connectivity

15.  Administering the Object Request Broker (ORB)

16.  Administering the JavaMail Service

17.  Administering the Java Message Service (JMS)

18.  Administering the Java Naming and Directory Interface (JNDI) Service

19.  Administering Transactions

Part III Appendixes

A.  Subcommands for the asadmin Utility


About Database Connectivity

A database management system (DBMS) provides facilities for storing, organizing, and retrieving data. The information in databases is often described as persistent data because it is saved on disk and exists after the application process ends. Most business applications store data in relational databases. Applications can access database information by using the Java Database Connectivity (JDBC) API.

The key elements of database connectivity are the following:

At runtime, the following sequence occurs when an application connects to a database:

  1. The application gets the JDBC resource associated with the database by making a call through the JNDI API.

    Using the JNDI name of the resource, the naming and directory service locates the JDBC resource. Each JDBC resource specifies a connection pool.

  2. Using the JDBC resource, the application gets a database connection.

    GlassFish Server retrieves a physical connection from the connection pool that corresponds to the database. The pool defines connection attributes such as the database name (URL), user name, and password.

  3. After the database connection is established, the application can read, modify, and add data to the database.

    The application accesses the database by making calls to the JDBC API. The JDBC driver translates the application’s JDBC calls into the protocol of the database server.

  4. When the application is finished accessing the database, the application closes the connection and returns the connection to the connection pool.