Skip site navigation (1) Skip section navigation (2)

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

From: Altaf Malik <mmalik_altaf(at)yahoo(dot)com>
To: Stef <svb(at)ucs(dot)co(dot)za>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: An I/O error occured while sending to the backend.
Date: 2008-01-07 17:40:54
Message-ID: 397984.39861.qm@web39111.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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(at)ucs(dot)co(dot)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?

Kind Regards
Stefan

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


       
---------------------------------
Never miss a thing.   Make Yahoo your homepage.

In response to

pgsql-jdbc by date

Next:From: Daniel MigowskiDate: 2008-01-07 19:16:45
Subject: Re: TypeInfoCache
Previous:From: Daniel MigowskiDate: 2008-01-07 16:48:35
Subject: Re: TypeInfoCache

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group