HI,
This is my mssql-ds.xml
<local-tx-datasource>
<jndi-name>AirDeccanDS</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://10.220.74.82:1433;SelectMethod=cursor;DatabaseName=AirDeccan</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<!-- sql to call when connection is created
<new-connection-sql>SELECT * FROM COUNTRY</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from
pool
<check-valid-connection-sql>SELECT * FROM COUNTRY</check-valid-connection-sql>
-->
</local-tx-datasource>
But didn't understand that how does it will help me to reterive a connection to
database, when network gets down in between and resumes up immediately.
My application uses serviceLocator pattern where i use to get datasource through the
JNDI name.
MoreOver I have my own AppExceptionHandler for the whole application which handles
anytype of Exception, filters it and ouput is controlled as per the business logic.
I possible can you send me an working example.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3828792#3828792
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3828792
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
