RE: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-11 Thread Shahar Solomianik
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tim Taylor Sent: Wednesday, April 11, 2001 2:21 AM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging Oracle's DataSources don't do pooling in the sense of maintaining pools of physical con

Re: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-10 Thread Tim Taylor
Oracle's DataSources don't do pooling in the sense of maintaining pools of physical connections (nneded for speed). Oracle calls minerva's type of pooling "connection caching" in their documentation for their JDBC 2.0 drivers. Oracle provides an "example" implementation of a cache called Ora

Re: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-10 Thread Toby Allsopp
On Tue, Apr 10, 2001 at 05:55:27PM +0200, Shahar Solomianik wrote: > Toby, I think you are right. > I replaced the mbean configuration to use XADataSourceLoader and minerva (I > had to patch minerva to support scrollable result sets...), tested the > server under load and it was MUCH faster. > I d

RE: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-10 Thread Shahar Solomianik
visible to the human eye Thanks, Shahar. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Toby Allsopp Sent: Tuesday, April 10, 2001 3:47 AM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging On Mon, Apr 09, 2001

Re: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Toby Allsopp
On Mon, Apr 09, 2001 at 11:20:36PM +0200, Shahar Solomianik wrote: > Apart from things like that in my code (bmp entities and stateless sessions) > : > > Context ctx = new InitialContext(); > DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/OracleDB"); > conn = ds.getC

RE: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Shahar Solomianik
Shahar. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Toby Allsopp Sent: Monday, April 09, 2001 10:33 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging On Mon, Apr 09, 2001 at 10:05:43PM +0200, Shahar Solomianik wrote: &

Re: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Toby Allsopp
On Mon, Apr 09, 2001 at 10:05:43PM +0200, Shahar Solomianik wrote: > Im pretty sure I do get my transactions managed by jboss. are you 100% sure > about that ? I think we should make sure that we're talking about the same thing. Can you post the code that uses the XADataSource, please? Toby. >

RE: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Shahar Solomianik
t: Monday, April 09, 2001 8:47 PM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging > > > RawXADataSourceLoader is not a replacement for XADataSourceLoader. > > The latter binds a DataSource implementation into JNDI which provides > conne

Re: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Toby Allsopp
47 PM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging > > > RawXADataSourceLoader is not a replacement for XADataSourceLoader. > > The latter binds a DataSource implementation into JNDI which provides > connection pooling. The

RE: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Shahar Solomianik
To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging RawXADataSourceLoader is not a replacement for XADataSourceLoader. The latter binds a DataSource implementation into JNDI which provides connection pooling. The latter binds an XADataSource in JNDI, which

Re: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Toby Allsopp
RawXADataSourceLoader is not a replacement for XADataSourceLoader. The latter binds a DataSource implementation into JNDI which provides connection pooling. The latter binds an XADataSource in JNDI, which provides pretty much nothing that application components should be messing with. How are yo

RE: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Shahar Solomianik
:[EMAIL PROTECTED]]On Behalf Of Simphoukham, Southin Sent: Monday, April 09, 2001 2:15 PM To: '[EMAIL PROTECTED]' Subject: RE: [JBoss-user] Solving Oracle Connection Pool Hanging Shahar, How do you do that? Do you replace org.jboss.jdbc.XADataSourceLoader?

RE: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Simphoukham, Southin
PROTECTED] Subject: RE: [JBoss-user] Solving Oracle Connection Pool Hanging Use RawXADataSource and it works (at least for me) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tim Taylor Sent: Saturday, April 07, 2001 11:56 PM To: [EMAIL PROTECTED] Subject

RE: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-09 Thread Shahar Solomianik
Use RawXADataSource and it works (at least for me) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tim Taylor Sent: Saturday, April 07, 2001 11:56 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging I tend to agree

Re: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-07 Thread Tim Taylor
I tend to agree that the JBoss-blocking behavior of incorrectly set up XADataSources is a bug. I ran into this too, and judging from the number of "Oracle pool hanging" messages on this list, a lot of people are running into it. I think it happens at the end of the pool creation when XADataS

Re: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-05 Thread danch
that's exactly what you're supposed to do. "Simphoukham, Southin" wrote: > > Tim > > Do you know of a work around? In my code I have been closing connections, > therefore releasing them back to the pool. > > Thanks, > > Southin Confidential e-mail for addressee only. Access to this e-mail b

RE: [JBoss-user] Solving Oracle Connection Pool Hanging

2001-04-05 Thread Simphoukham, Southin
Tim Do you know of a work around? In my code I have been closing connections, therefore releasing them back to the pool. Thanks, Southin -Original Message- From: Tim Kemp [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 9:09 AM To: 'Jboss-User (E-mail) Subject: [JBoss-user] S