doubt in jboss connection pooling

[sriram4java1]

hi all,

I am using jboss connection pooling for my web app.
my database is oracle.

I want to know whether all connection in pool use only one session or
each connection creates its own session


Thanks in advance

[smarlow]

Hi,

Each connection in the pool has its own Oracle session.

Scott

[sriram4java1]

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
Sriram

[smarlow]

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.