Re: [JDBC] An I/O error occured while sending to the backend.

This is because when your database is down, all the 'connected' instances of Connection become invalid. Since pooled connection is created once, it should be restarted on each database restart. This is possible either by restarting the JBoss, or restarting the Datasource in jboss by the using JMX console.   http://www.onjava.com/pub/a/onjava/2001/07/16/jboss.html?page=last&x-showcontent=text

  You'll have to do something. It'll not re-connect automatically.    

  Regards,
  Altaf Malik
  EnterpriseDB
  www.enterprisedb.com       

Stef <svb@ucs.co.za> wrote:
  Hi all,

I'm using jboss 4.0.2 and j2sdk version 1.5.0_11-b03 connecting to postgresql 8.1.4 using the jdbc3 postgres driver.

I'm using the Connection pool manager of JBoss to control the connections to the database. When I restart postgres without restarting JBoss as well, I get this error reported in JBoss : An I/O error occured while sending to the backend.

The problem is that JBoss never recovers from this , and it's only fixed when I restart JBoss. I can understand that this error may happen occasionally, but I need to be able to recover from this situation without restarting JBoss.

Does anyone have any idea what I can do?

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

Kind Regards
Stefan

---------------------------(end of broadcast)---------------------------