Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Session parameters and connection pools

Tony HaslerMay 1 2015 — edited May 1 2015

Hi,

Suppose I issue a command such as "ALTER SESSION SET WORKAREA_SIZE_POLICY=MANUAL" inside a stored procedure called via JDBC and then release the connection back to the pool.  When the connection is next reused by a completely independant Weblogic thread is there any chance that the non-default setting could be inherited by the new thread?

I realize that there is a conceptual difference between a process, a connection, and a session so theoretically the answer to my question should be "no."

But is that the case in real life?

--Tony

This post has been answered by Joe Weinstein-Oracle on May 1 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 29 2015
Added on May 1 2015
3 comments
1,458 views