How To Configure v$session Parameters For J2EE Application Using a Connection Pool (Doc ID 459103.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Containers for J2EE - Version 10.1.3.0.0 to 10.1.3.5.0 [Release AS10gR3]
Information in this document applies to any platform.
***Checked for relevance on 08-Jul-2010***


Goal

The requirement addressed in this article is how to configure the JDBC connection in the Oracle Application Server connection pool to have custom values for the v$session parameters.
For example, v$session.program can take the value of 'iAS connection pool', rather than the default JDBC value.

This requirement can easily be accomplished from the application code by using the JDBC driver parameters, but it is also possible to accomplish this from the connection pool. This allows different applications using the same connection pool to have the same v$session parameter values.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms