Connection not released in the pool for an ejbCreate

[gaetanzoritchak]

Hi,

I'm evaluating CMP1.1 with JBoss 2.4.4 and Oracle 8.1.7.

I made a simple test witch just create few instance of a CMP without calling any business methods. After 10 call, my client test is blocking. When I look at my datasource I can see that the 10 max connection I configured in the jboss.jcml (see below) file are used.

My Bean is defined with a TX_REQUIRED attribute for both home and remote methods.

Any ideas?

Gaetan,



MyDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

jdbc:oracle:thin:@lkjgc:1521:dev1
1200000
titi
10
toto
false
false
false
true
120000
1800000
false
1.0
0
true

[gaetanzoritchak]

The problem was on my code. I was using a connection to retrieve an id from a sequence without closing it.