Max Capacity of Conn Pool

[HaniRocks]

Hi everyone,

I have given the Max Capacity of conn pool to 70,
Capacity increment 1,Initial Capacity 1.

How does weblogic decide as to how many connections shud be kept in the pool?

I got the following error.
Checked the number of user sessions in the oracle dbase,it was 73.So I increased the maximum capacity to 90.

After a couple of days i got the same error.
This time user session was 93.I have icreased the max capacity to 120.

va.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool to allocate to applications, please increase the size of the pool and retry.

Regards,
Hani

 

[Diancecht]

I don't get the question.

If properly coded, connections are released and as soon as they end, so WL marks them as avaliable again.

Cheers,
Dian