getConnection problem when reached the MaxSize on the Jboss

[william]

The problem occurred when maximum connection reached (we have set it to 50) and thereafter all connections failed to query even after a long time.

The following is a part of the error messages

[ERROR,Default] Tue Apr 02 16:24:25 GMT+08:00 2002
[ERROR,Default] java.lang.NullPointerException
[ERROR,Default] at
org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)

Pls help.

[maouche]

Hi,

If you don't know the maxsize, you can set the MaxSize attribute to 0.
Then you have an illimited pool.

You can try it.

[davidjencks]

Be sure to set blocking true and use a blocking timeout. Then at least you won't get npe's.

Are you closing connections after you use them? This is how they are returned to the pool. Close them in a finally block.

I can't really recommend providing for infinite resource utilization by setting maxsize=0. Find out what the expected load is and size the pool accordingly.