[Zope-Perl] ZDBI_DA lost connection

[Gisle Aas]

Ulrich Wisser <u.wisser@publisher.de> writes:

> I use ZDBI_DA with DBD::Adabas (from CPAN). After a short period
> of inactivity (30 min. or less) the databas connection is lost.

There should AFAIK not be anything in ZDBI_DA that closes connections
at all.  The &Zope::dbi_close function is even a noop.

> Is there something I can do to prevent that? Is it possible
> to reconnect automatically?
> 
> DBD::Adabas is mostly DBD::ODBC renamed to Adabas and changed to
> use the Adabas ODBC libraries. I use it in a lot of projects,
> it is working with Apache::DBI.

One thing that might be different is that Zope runs with real
multi-threading.  You might be able to set up test cases that use the
dbi.py module directly.

Regards,
Gisle


> System:
> 
> Linux 2.2.14
> Zope 2.2.5
> Perl 5.6.1-TRIAL1
> Python 1.5.2
> DBI 1.14
> DBD::Adabas 0.2003
> --
> Searchengine Know How  - Webpromotion - Optimization - Internal Search
> World Wide Web Publisher, Ulrich Wisser, Odensvag 13, S-14571 Norsborg
> http://www.publisher.de   Tel: +46-8-53460905    Fax: +46-8-534 609 06