aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes question about EJB Transaction and connection pool? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "question about EJB Transaction and connection pool?" Watch "question about EJB Transaction and connection pool?" New topic
Author

question about EJB Transaction and connection pool?

Robert Strong
Ranch Hand

Joined: Sep 10, 2002
Posts: 84
hi,

I'm using BEA Webloigc8.1 Stateless Session Bean/DAO/Oracle stored proc.
but I'm not quite clear how Transaction Manager work with Resource Manager, like Connection pool.


my understanding is that, in a weblogic transaction, a stateless session bean interact with several DAOs, and for each method of DAO a connection is acquired from connection pool. I've heard that the connection will not return to pool until the transaction commits.

My question is that, does it mean that for a weblogic transaction, multiple connections might be allocated to it? and if multiple connections are allocated, then how many oracle transactions would be started? or multiple connections share the same oracle transaction?

I didn't feel it make sense to start multiple oracle transactions, cause deadlock might be incurred in a single weblogic transaction.

any help appreciated!
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

The connection object will be shared.


Groovy
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: question about EJB Transaction and connection pool?