Hi,

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:

Code:
--------------------

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

<datasources>
<local-tx-datasource>
<jndi-name>IDMUADataSource</jndi-name>
<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>
<security-domain>EncryptDBPassword</security-domain>
</local-tx-datasource>
</datasources>


--------------------


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

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
------------------------------------------------------------------------
Sjoerdk's Profile: https://forums.netiq.com/member.php?userid=1135
View this thread: https://forums.netiq.com/showthread.php?t=48245