Each connection in the pool has its own Oracle session.
Thanks for ur reply.
Iam using oracle session tables in my application.
if i populate that table using one connection object and closes that.
i could acess that data using another connection object got from pool.
Thanks in advance
What is an oracle session table? Can you give the create table syntax that you use to create one of these?
Is this similar to global temporary tables as described here (http://www.oracle-base.com/articles/8i/TemporaryTables.php).
To further help with your question. A pooled connection should use the same session. Once a pooled connection is returned to the pool, you can expect that another user request could use that same pooled connection and the same session.