seam in production and database connection broken

[alexeicu]

Hi, I have a  seam 2.2 app into jboss 4.2.3 in production enviroment. When I restart the database, the app can't reconnect to the database, I got some errors related to database connection such as.

• org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
• java.net.SocketException: Connection reset by peer: socket write error

How can i fix it without to restart the app.

thanks.

[cyberanto]

I need to point out that if you need to restart the database frequently there is something wrong with your processes or your app/db code.

Now specifically to your question, you should be able to do this through the JMX Concole http://localhost:8080/jmx-console/. Click on to the jboss.jdbc filter in the left sidebar, then on your datasource. On that page you will see options to stop and start the datasource.