ExceptionSorter

[sysuser1]

Hello,

I have got a question about database connection.
I saw in the JCA forum a case that interested me, this is about network problem while accessing database in my case a postgresql 7.4.
When an application is successfully deployed and running on Jboss3.2.3 server, then the network goes down and resumes up the application faces the following error:
Connection reset by peer: socket error..
in several post I saw indications for the solution which is to add an ExceptionSorter. But I am not familiar with this term and I see evocation of exceptionSorter only for oracle database
My question are:
-what is an ExceptionSorter ?
- Is it possible to find a sample code of this?
- Is is specific to JBoss or other application server have can have one too?

Thanks very much for your helps

Thanks for any helps

[adrian.brock]

The exception sorter checks SQLExceptions.
It is a jboss/vendor specific class:
http://cvs.sourceforge.net/viewcvs.py/jboss/jbosscx/src/main/org/jboss/resource/adapter/jdbc/vendor/

It is less useful than check-valid-connection-sql,
The exception sorter only checks errors after you have run an sql statement,
meaning you have to have one failure visible to the application.

[sysuser1]

thanks fro your prompt reply.
I have got another questions about the check-valid-connection-sql, in the database-ds.xml file does this tag allow to test the connection to the database?
On the other hand if I have got a DB server and Jboss server installed on two different machine and the network goes down and resumes up,Is JBoss able to establish the connection if it breaks due to network problem, on its own?

Thanks again for helps

[adrian.brock]

http://jboss.org/wiki/Wiki.jsp?page=JBossForums