Oracle® TopLink Developer's Guide 10g Release 3 (10.1.3.1.0) Part Number B28218-01 |
|
|
View PDF |
This chapter describes the various components that you must configure in order to use database sessions.
Table 80-1 lists the configurable options for database sessions.
Table 80-1 lists the configurable options for database sessions.
Table 80-1 Configurable Options for Database Session
Option | Type | TopLink Workbench |
Java |
---|---|---|---|
"Configuring External Connection Pools" |
Basic |
||
"Configuring a Primary Mapping Project" |
Basic |
||
|
Basic |
||
|
Basic |
||
"Configuring Multiple Mapping Projects" |
Advanced |
||
"Configuring a Performance Profiler" |
Advanced |
||
"Configuring an Exception Handler" |
Advanced |
||
"Configuring Customizer Class" |
Advanced |
||
"Configuring the Server Platform" |
Advanced |
||
"Configuring Session Event Listeners" |
Advanced |
||
"Configuring a Coordinated Cache" |
Advanced |
||
"Configuring the Integrity Checker" |
Advanced |
||
"Configuring Named Queries at the Session Level" |
Basic |
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 "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.