Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "Configuring Database Sessions (ELUG)"
m (→Introduction to Database Session Configuration) |
m |
||
(3 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | + | [[Image:Elug draft icon.png]] '''For the latest EclipseLink documentation, please see http://www.eclipse.org/eclipselink/documentation/ ''' | |
− | [[ | + | |
− | + | ||
− | + | ---- | |
− | + | <div style="float:right;border:1px solid #000000;padding:5px">__TOC__ | |
− | + | [[Special:Whatlinkshere/Configuring Database Sessions (ELUG)|Related Topics]]</div> | |
This table lists the configurable options for database sessions. | This table lists the configurable options for database sessions. | ||
Line 13: | Line 11: | ||
<span id="Table 91-1"></span> | <span id="Table 91-1"></span> | ||
− | |||
− | |||
{| class="RuleFormalMax" dir="ltr" title="Configurable Options for Database Session" summary="This table lists the configurable options common to Database Sessions and categorizes them as Basic and Advanced and indicates if the option can be configured with the Workbench, Java, or both." width="100%" border="1" frame="border" rules="all" cellpadding="3" frame="border" rules="all" | {| class="RuleFormalMax" dir="ltr" title="Configurable Options for Database Session" summary="This table lists the configurable options common to Database Sessions and categorizes them as Basic and Advanced and indicates if the option can be configured with the Workbench, Java, or both." width="100%" border="1" frame="border" rules="all" cellpadding="3" frame="border" rules="all" | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
Line 22: | Line 18: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r2c1-t2" headers="r1c1-t2" align="left" | | | id="r2c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[#Configuring External Connection Pools|Configuring External Connection Pools]] | |
| headers="r2c1-t2 r1c2-t2" align="left" | | | headers="r2c1-t2 r1c2-t2" align="left" | | ||
[[Image:support.gif|Supported]]<br> | [[Image:support.gif|Supported]]<br> | ||
Line 29: | Line 25: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r3c1-t2" headers="r1c1-t2" align="left" | | | id="r3c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[Configuring%20a%20Session%20(ELUG)#Configuring a Primary Mapping Project|Configuring a Primary Mapping Project]] | |
| headers="r3c1-t2 r1c2-t2" align="left" | | | headers="r3c1-t2 r1c2-t2" align="left" | | ||
[[Image:support.gif|Supported]]<br> | [[Image:support.gif|Supported]]<br> | ||
Line 36: | Line 32: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r4c1-t2" headers="r1c1-t2" align="left" | | | id="r4c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[Configuring%20a%20Session%20(ELUG)#Configuring a Session Login|Configuring a Session Login]] | |
| headers="r4c1-t2 r1c2-t2" align="left" | | | headers="r4c1-t2 r1c2-t2" align="left" | | ||
[[Image:support.gif|Supported]]<br> | [[Image:support.gif|Supported]]<br> | ||
Line 43: | Line 39: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r5c1-t2" headers="r1c1-t2" align="left" | | | id="r5c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[Configuring%20a%20Session%20(ELUG)#Configuring Logging|Configuring Logging]] | |
| headers="r5c1-t2 r1c2-t2" align="left" | | | headers="r5c1-t2 r1c2-t2" align="left" | | ||
[[Image:support.gif|Supported]]<br> | [[Image:support.gif|Supported]]<br> | ||
Line 50: | Line 46: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r6c1-t2" headers="r1c1-t2" align="left" | | | id="r6c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[Configuring%20a%20Session%20(ELUG)#Configuring Multiple Mapping Projects|Configuring Multiple Mapping Projects]] | |
| headers="r6c1-t2 r1c2-t2" align="left" | | | headers="r6c1-t2 r1c2-t2" align="left" | | ||
[[Image:support.gif|Supported]]<br> | [[Image:support.gif|Supported]]<br> | ||
Line 57: | Line 53: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r7c1-t2" headers="r1c1-t2" align="left" | | | id="r7c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[Configuring%20a%20Session%20(ELUG)#Configuring a Performance Profiler|Configuring a Performance Profiler]] | |
| headers="r7c1-t2 r1c2-t2" align="left" | | | headers="r7c1-t2 r1c2-t2" align="left" | | ||
[[Image:support.gif|Supported]]<br> | [[Image:support.gif|Supported]]<br> | ||
Line 64: | Line 60: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r8c1-t2" headers="r1c1-t2" align="left" | | | id="r8c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[Configuring%20a%20Session%20(ELUG)#Configuring an Exception Handler|Configuring an Exception Handler]] | |
| headers="r8c1-t2 r1c2-t2" align="left" | | | headers="r8c1-t2 r1c2-t2" align="left" | | ||
[[Image:support.gif|Supported]]<br> | [[Image:support.gif|Supported]]<br> | ||
Line 71: | Line 67: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r9c1-t2" headers="r1c1-t2" align="left" | | | id="r9c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[Configuring%20a%20Session%20(ELUG)#Configuring a Session Customizer Class|Configuring a Session Customizer Class]] | |
| headers="r9c1-t2 r1c2-t2" align="left" | | | headers="r9c1-t2 r1c2-t2" align="left" | | ||
[[Image:support.gif|Supported]]<br> | [[Image:support.gif|Supported]]<br> | ||
Line 78: | Line 74: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r10c1-t2" headers="r1c1-t2" align="left" | | | id="r10c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[Configuring%20a%20Session%20(ELUG)#Configuring the Server Platform|Configuring the Server Platform]] | |
| headers="r10c1-t2 r1c2-t2" align="left" | | | headers="r10c1-t2 r1c2-t2" align="left" | | ||
[[Image:support.gif|Supported]]<br> | [[Image:support.gif|Supported]]<br> | ||
Line 85: | Line 81: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r11c1-t2" headers="r1c1-t2" align="left" | | | id="r11c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[Configuring%20a%20Session%20(ELUG)#Configuring Session Event Listeners|Configuring Session Event Listeners]] | |
| headers="r11c1-t2 r1c2-t2" align="left" | | | headers="r11c1-t2 r1c2-t2" align="left" | | ||
[[Image:support.gif|Supported]]<br> | [[Image:support.gif|Supported]]<br> | ||
Line 92: | Line 88: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r12c1-t2" headers="r1c1-t2" align="left" | | | id="r12c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[Configuring%20a%20Coordinated%20Cache%20(ELUG)|Configuring a Coordinated Cache]] | |
| headers="r12c1-t2 r1c2-t2" align="left" | | | headers="r12c1-t2 r1c2-t2" align="left" | | ||
[[Image:support.gif|Supported]]<br> | [[Image:support.gif|Supported]]<br> | ||
Line 99: | Line 95: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r13c1-t2" headers="r1c1-t2" align="left" | | | id="r13c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[Configuring%20a%20Session%20(ELUG)#Configuring the Integrity Checker|Configuring the Integrity Checker]] | |
| headers="r13c1-t2 r1c2-t2" align="left" | | | headers="r13c1-t2 r1c2-t2" align="left" | | ||
[[Image:support.gif|Supported]]<br> | [[Image:support.gif|Supported]]<br> | ||
Line 106: | Line 102: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| id="r14c1-t2" headers="r1c1-t2" align="left" | | | id="r14c1-t2" headers="r1c1-t2" align="left" | | ||
− | + | [[Configuring%20a%20Session%20(ELUG)#Configuring Named Queries at the Session Level|Configuring Named Queries at the Session Level]] | |
| headers="r14c1-t2 r1c2-t2" align="left" | | | headers="r14c1-t2 r1c2-t2" align="left" | | ||
[[Image:unsupport.gif|Unsupported]]<br> | [[Image:unsupport.gif|Unsupported]]<br> | ||
Line 113: | Line 109: | ||
|} | |} | ||
− | + | ||
==Configuring External Connection Pools== | ==Configuring External Connection Pools== | ||
Line 120: | Line 116: | ||
We recommend 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%20a%20Data%20Source%20Login%20(ELUG)#Configuring External Connection Pooling|Configuring External Connection Pooling]]): in this case, you should allocate a new database session per user/thread or request. | We recommend 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%20a%20Data%20Source%20Login%20(ELUG)#Configuring External Connection Pooling|Configuring External Connection Pooling]]): in this case, you should allocate a new database session per user/thread or request. | ||
− | |||
− | |||
{| class="NoteWarn oac_no_warn" width="80%" border="1" frame="hsides" rules="groups" cellpadding="3" frame="hsides" rules="groups" | {| class="NoteWarn oac_no_warn" width="80%" border="1" frame="hsides" rules="groups" cellpadding="3" frame="hsides" rules="groups" | ||
Line 128: | Line 122: | ||
|} | |} | ||
− | |||
The usage of an external connection pool reduces the number of the database session login and logout attempts to acquire the database connection. | The usage of an external connection pool reduces the number of the database session login and logout attempts to acquire the database connection. | ||
+ | |||
+ | |||
Line 138: | Line 133: | ||
[[Category: EclipseLink User's Guide]] | [[Category: EclipseLink User's Guide]] | ||
− | [[Category: | + | [[Category: Release 1]] |
[[Category: Task]] | [[Category: Task]] |
Latest revision as of 15:09, 16 July 2012
For the latest EclipseLink documentation, please see http://www.eclipse.org/eclipselink/documentation/
This table lists the configurable options for database sessions.
Option | Workbench |
Java |
---|---|---|
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.
We recommend 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.