Running out of connection

[dwong]

Hi,

Sorry if this is a dump question, please give me any direction about it.

I am using JBoss 3.0.3 and Oracle8i running Solaris. I have successfully create session beans and entity beans. For CMP entity beans, the db connection gets from the connection pool. However, I face the problem of running out of connection allowed (the max. no. of connection specified in oracle init file).

In the jboss config. file (oracle-service.xml), I specify the init connection be 5, and it is correct from v$session. However, after running a while, the connection is keeping increased and not shrink to a lower number (at least for over an hour as witnessed by me).

Any hints for me ?

Thanks.

[dwong]

For CMP beans, I do not need explicit manipulation of the db connection, rite ? As I understand, we do not have any control on getting connection from pool or close the connection for CMP entity beans. Am I rite ?

[dwong]

Sorry, I am not sure if this is a dump question, but I need somebody's help. Or should I ask it somewhere else ?

Thanks.