Notice: this Wiki will be going read only early in 2024 and edits will no longer be 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 |
||
Line 2: | Line 2: | ||
[[Special:Whatlinkshere/Configuring Database Sessions (ELUG)|Related Topics]]</div> | [[Special:Whatlinkshere/Configuring Database Sessions (ELUG)|Related Topics]]</div> | ||
This section describes the various components that you must configure in order to use database sessions. | This section describes the various components that you must configure in order to use database sessions. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
This table lists the configurable options for database sessions. | This table lists the configurable options for database sessions. | ||
Line 13: | Line 7: | ||
<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 14: | ||
|- 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 21: | ||
|- 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 28: | ||
|- 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 35: | ||
|- 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 42: | ||
|- 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 49: | ||
|- 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 56: | ||
|- 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 63: | ||
|- 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 70: | ||
|- 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 77: | ||
|- 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 84: | ||
|- 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 91: | ||
|- 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 98: | ||
|- 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 105: | ||
|} | |} | ||
− | + | ||
+ | |||
==Configuring External Connection Pools== | ==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. | 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%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 118: | ||
|} | |} | ||
− | |||
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. | ||
+ | |||
+ | |||
Revision as of 14:55, 17 December 2007
This section describes the various components that you must configure in order to use database sessions.
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.