Connection Pooling Issues

[cdk]

Hi all,

I have an application that is using mysql high availability on the back end.

I have just tested this high availability feature and once the mysql backend changes over, our threads in the connection pool are all gone.  These threads do not recover unless we restart JBoss which defeats the purpose of high availability.

Is there a setting in a datasource file that I can add ?

Our datasource file only have these two connection pool settings:

	<min-pool-size>10</min-pool-size>
	<max-pool-size>100</max-pool-size>

Hope this is enough info I'm quite new to java technologies.

Thanks,

-ck

[vnooka]

You have not mentioned the nature of datasource you have used but to be able to use the high availability feature you'll have to use HA datasource.

Plz refer the following link for more info

http://www.mastertheboss.com/jboss-application-server/82-jboss-datasource-ha.html

Hope this helps!