This content has been marked as final.
Show 5 replies
-
1. Re: Stale Connection Support
subramaniam.venkat Mar 20, 2007 4:03 PM (in response to subramaniam.venkat)Hello All,
I have posted the query in wrong forum.Please let me know..
I am badly need of some help.
Thanks & Warm Regards,
SubramaniamV -
2. Re: Stale Connection Support
weston.price Mar 20, 2007 4:10 PM (in response to subramaniam.venkat)Moving to the JCA forum as this has nothing to do with JBossTS.
-
3. Re: Stale Connection Support
weston.price Mar 20, 2007 4:16 PM (in response to subramaniam.venkat)Please post your *-ds.xml file. It sounds like you need a validation element to discard connections that have become state during the switch.
-
4. Re: Stale Connection Support
subramaniam.venkat Mar 21, 2007 5:32 AM (in response to subramaniam.venkat)Hello Weston,
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,
Subramaniam V -
5. Re: Stale Connection Support
weston.price Mar 21, 2007 6:27 AM (in response to subramaniam.venkat)Yep, I thought so :-)
To get 'stale connection' like behavior you want to add one of the following to your *-ds.xml file:<check-valid-connection-sql> <valid-connection-checker-class-name>
Please read the FAQ for the particulars on these settings. There is a lot of other useful information in there as well :-)
FAQ
http://wiki.jboss.org/wiki/Wiki.jsp?page=FAQJBossJCA
Also see:
http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources
http://wiki.jboss.org/wiki/Wiki.jsp?page=JBossJCAPooling
Also see