It may be helpful to post your mssql-ds.xml file, but without seeing it, mt guess is
that you need to an exceptionsorter and a check-valid-sql tag to your mssql-ds.xml.
Something like this:
<local-tx-datasource>
<jndi-name>someDataSource</jndi-name>
<connection-url>
jdbc:microsoft:sqlserver://someUrl:1433;DatabaseName=someDb;SelectMethod=cursor
</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>someUser</user-name>
somePass
<exception-sorter-class-name>
com.yourpkg.SqlServerExceptionSorter
</exception-sorter-class-name>
<min-pool-size>10</min-pool-size>
<max-pool-size>20</max-pool-size>
<valid-connection-sql>
select count(*) from SomeConnectionTest
</valid-connection-sql>
</local-tx-datasource>
The sql used should be very fast. In my example SomeConnectionTest is a one column
table with only one row that is never changed. Also, you will have to develop an
ExceptionSorter, but there are several examples in the docs directory. Essentially,
try this:
public class SqlServerExceptionSorter implements ExceptionSorter, Serializable
{
public SqlServerExceptionSorter()
{
} // SqlServerExceptionSorter constructor
public boolean isExceptionFatal(SQLException e)
{
return true;
}
} // SqlServerExceptionSorter
if you want all Exceptions thrown to force the Connection to be removed from the
connection pool.
Finally, a search for ExceptionSorter and valid-connection-sql on this forum will
result in a lot of answers to this situation that may have more helpful info.
Hope this all helps,
-MLA
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3828558#3828558
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3828558
-------------------------------------------------------
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
