BDP 2.5 does not re-open broken pooled connections

Thread View: borland.public.delphi.database.bdp

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by mikeachamberlain Mon, 04 Dec 2006 23:21

#149

Author: mikeachamberlain
Date: Mon, 04 Dec 2006 23:21

22 lines
1827 bytes

Hi there.

I have noticed that if the database server (IB 7.5) crashes, then any
apps using connection pooling with the BDP 2.5 need to be restarted to
regain their connections after the database is brought back up.  The
following error is repeatedly thrown upon trying to use a connection:

Unable to complete network request to host "dbserver1".

This is a bit rubbish really, and there's no reason why the connection
pool shouldn't automatically re-connect these broken connections
without requiring a restart.

Does anyone know if this is possible, or have any advice on a
workaround?

(Sorry for re-posting this in another groups, I didn't realise there
was a dedicated BDP group.)

Cheers,

Mike

Re: BDP 2.5 does not re-open broken pooled connections

Author: Kimberly Erickson
Date: Wed, 20 Dec 2006 15:16

11 lines
1340 bytes

Hello,

I have the same problem with an oracle database and an ASP.NET website. 
  The oracle database is rebooted weekly.  Then the ASP.NET website 
generates errors.  I am using connection pooling.  How can I make the 
connection pool "reconnect" to the database when this happens?  I trap 
the error in the global.pas file now, but how can I fix it?

Thanks,

Kimberly Erickson

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads