Problem In Connection Pooling

[siva]

Dear All

We have a common stateless session ejb called DataEJB which connects to database and performs query execution.DataEJB uses connection pooling of jboss server which is configured.Now when i start using this DataEJB mulitiple times simultanously its giving sql exception.

on the debuging process we came to know that it has crossed the connection limit of Oracle server(8i).which means that connection instances is not back to the pool after executing the query.i.e when i pass 10 insert query's to DataEJB it creates 10 connection pooling instances.Out of this only one insert is commited and rest 9 is not commited.when i restart my jboss server all the 9 connection pooling instances are killed and hence records are commited.

we explictly closed the connection in the finally block of DataEJB after executing the query it did't work.

kindly guide us in solving the same.

[gaetanzoritchak]

I've got the same problem using CMP and Oracle. I noticed the connection is not released on a call on a create method on the home.

I'm interested by the solution.

[siva]

Hi

That was a problem with JBoss Server itself.
This problem did't come for me when i started using jboss 2.4.6 version .pl try using this version of jboss,which might solve ur problem.

Still if u could't solve ur problem u can get back to me.

with rgds
shiva