Hi Mike, I've just done this as a workaround but still think Radiator should close the database connection between refresh intervals.
Why don't you want to use CPAN modules? You can ship known working versions bundled with Radiator. -- Best regards, Alex On Thu, 2010-10-28 at 23:31 +0200, Mike McCauley wrote: > Hello Alexander, > > maybe you could reduce the RefreshPeriod in your ClientListSQL to less than an > hour (or whatever the retain time is in the firewall is) so the SQL session > stays up? > > Cheers. > > On Friday 29 October 2010 12:36:02 am Alexander Hartmaier wrote: > > Still happens with newest DBI and DBD::Oracle. > > I assume radiator doesn't close the db connection and a firewall removes > > it from its state table which leads to dropped packets after an hour > > when radiator tries to use the db connection again. > > > > You might want to look into DBIx::Connector which handles some problems > > automatically. > > > *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien Handelsgericht Wien, FN 79340b *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* Notice: This e-mail contains information that is confidential and may be privileged. If you are not the intended recipient, please notify the sender and then delete this e-mail immediately. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* _______________________________________________ radiator mailing list [email protected] http://www.open.com.au/mailman/listinfo/radiator
