I have posted the query in wrong forum.Please let me know..
I am badly need of some help.
Thanks & Warm Regards,
Moving to the JCA forum as this has nothing to do with JBossTS.
Please post your *-ds.xml file. It sounds like you need a validation element to discard connections that have become state during the switch.
Please find the datasource xml file which we are using.
I deploy the datasource inside the deploy directory.
<datasources> <local-tx-datasource> <jndi-name>jdbc/oracleDS</jndi-name> <connection-url>jdbc:oracle:thin:@//ipaddress:port/SID</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>scott</user-name> <password>tiger</password> </local-tx-datasource> </datasources>
Please let me know what should be changed.
THanks & Warm Regards,
Yep, I thought so :-)
To get 'stale connection' like behavior you want to add one of the following to your *-ds.xml file:
Please read the FAQ for the particulars on these settings. There is a lot of other useful information in there as well :-)