Jboss datasource statistics JMX monitoring - inconsistent information?

That's because of the property no-tx-separate-pools See the documentation for XA Data Sources, in JBoss Server Configuration Guide: no-tx-separate-pools Pool transactional and non-transactinal connections separately Warning Using this option will cause your total pool size to be twice max-pool-size, because two actual pools will be created docs.redhat.com/docs/en-US/JBoss_Enterpr....

That's because of the property . See the documentation for XA Data Sources, in JBoss Server Configuration Guide: Pool transactional and non-transactinal connections separately Warning Using this option will cause your total pool size to be twice max-pool-size, because two actual pools will be created. docs.redhat.com/docs/en-US/JBoss_Enterpr....

OK, I can see i'm using that property. However, i'm using it in both datasources, and only the first is doubled... – erezul May 6 at 5:55 I'd suppose that's because you are using the AuditTrail connection in a different way than the main pool. Is there anything special in the AuditTrail?

Is it part of the main transaction? – partenon May 6 at 7:10 Well, the first datasource is used through while the other is used by another (third party) software library, so you may be right... any idea on how I can verify that? – erezul May 6 at 14:16 Not sure.

Perhaps looking at the documentation of this third party library. See if it tries to join an existing JTA transaction or not. I bet it doesn't.

Another way is, of course, just to remove this option and watch the pool :-) – partenon May 6 at 14:30 OK, now regarding the ConnectionDestroyedCount value... why should the datasource create double the connections it needs and then destroy 50%? I would expect it never to create more than MaxSize... – erezul May 6 at 14:43.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.