95 Configuring Database Sessions

This chapter describes the various components that you must configure in order to use database sessions.

This chapter includes the following sections:

Introduction to Database Session Configuration
Configuring External Connection Pools

Table 95-1 lists the configurable options for database sessions.

95.1 Introduction to Database Session Configuration

Table 95-1 lists the configurable options for database sessions.

Table 95-1 Configurable Options for Database Session

Option	Oracle JDeveloper	TopLink Workbench	Java
External connection pools (see Section 95.2, "Configuring External Connection Pools")
Primary mapping project (see Section 89.2, "Configuring a Primary Mapping Project")
Session login (see Section 89.3, "Configuring a Session Login")
Logging (see Section 89.4, "Configuring Logging")
Multiple mapping projects (see Section 89.5, "Configuring Multiple Mapping Projects")
Performance profiler (see Section 89.6, "Configuring a Performance Profiler")
Exception handler (see Section 89.7, "Configuring an Exception Handler")
Session customizer class (see Section 89.8, "Configuring a Session Customizer Class")
Server platform (see Section 89.9, "Configuring the Server Platform")
Session event listeners (see Section 89.10, "Configuring Session Event Listeners")
Coordinated cache (see Chapter 103, "Configuring a Coordinated Cache")
Integrity checker (see Section 89.11, "Configuring the Integrity Checker")
Named queries (see Section 89.13, "Configuring Named Queries at the Session Level")

95.2 Configuring External Connection Pools

Unlike a server session, a database session does not provide internal connection pools. A database session only has a single database connection that it uses for its life cycle.

Oracle recommends that you use a server and client session in a three-tier environment. Alternatively, you can use a database session with an external connection pool (see Section 97.4, "Configuring External Connection Pooling"): in this case, you should allocate a new database session per user/thread or request.

WARNING:

Do not allow the concurrent use of a database session by multiple users/threads.

The usage of an external connection pool reduces the number of the database session login and logout attempts to acquire the database connection.