We've had several problems with the UA:
After an MS SQL failover, JBOSS does not reconnect to the DB. This is a
fresh UA install (with a migrate from a previous db). Version 4.0.2
Patch C on Window server 2008.

This is the XML for connection:


<?xml version="1.0" encoding="UTF-8"?>

<connection-url>jdbc:sqlserver://SQL.test.host.nl:1433;DatabaseName=userappdb;respo nseBuffering=full</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver </driver-class>


I've found the option to add: <check-valid-connection-sql>SELECT 1 FROM

Will this solve my reconnect problems after failover?

PS: Responsebuffering=full was added because of some errors.. don't know
which ones anymore, but you can ignore that part of the XML.

Sjoerdk's Profile: https://forums.netiq.com/member.php?userid=1135
View this thread: https://forums.netiq.com/showthread.php?t=48245