auto reconnect in jboss-as-7.1.1.Final

2.8k views Asked by At

:D Hi there

I have installed jboss-as-7.1.1.Final for my webapp.

Its running normally for every activity except one thing. When ms sql server services was restarted or stopped a while, my jboss wouldn't rebuild the connection to datasource automatically.

I must restarting jboss manually, so it can rebuild the connection again.

What i want is jboss autoreconnecting when that problem happen again. Below is my datacource config, could you tell me please what i am miss?

....
<datasource jndi-name="java:jboss/MsSqlDS" pool-name="MsSqlDS" enabled="true" use-java-context="true" use-ccm="false">
   <connection-url>jdbc:sqlserver://localhost:1433;databaseName=dummy</connection-url>
   <driver>sqlserver2008</driver>
   <pool>
          <min-pool-size>5</min-pool-size>
          <max-pool-size>50</max-pool-size>
          <prefill>false</prefill>
          <use-strict-min>false</use-strict-min>
          <flush-strategy>FailingConnectionOnly</flush-strategy>
   </pool>
   <security>
          <user-name>sa</user-name>
          <password>*******</password>
   </security>
   <validation>
          <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"/>
   </validation>
</datasource>
....

note : i have try this

<validation> 
   <check-valid-connection-sql>select 1</check-valid-connection-sql>
</validation>

based on Is there any way to have the JBoss connection pool reconnect to Oracle when connections go bad?

but still not work for me

Thanks & Regards

Newbie

0

There are 0 answers