Re: [Sqlrelay-discussion] possible bug

[David M. <dav...@fi...>]

The most common cause of that is if there's a firewall (especially a
Cisco PIX firewall) between SQL Relay and the database.  See
http://sqlrelay.sourceforge.net/sqlrelay/faq.html#firewallhang
for more details.

If there's no firewall, then there could be a bug.  I'd need to know
more details though.  If you're using a relatively new version (0.35 or
newer) then SQL Relay should be able to handle it if the database goes
down or otherwise becomes inaccessible and comes back up, but it's
possible that there's still a bug in that code.

David Muse
dav...@fi...

On Thu, 2005-06-16 at 16:23 -0500, Frank Wiles wrote:
>   Hi Everyone, 
> 
>   I'm trying to use SQLRelay with an Oracle 8 database and keep running
>   into a problem.  Every so often, after several hours of perfect use,
>   SQLRelay completely stops being able to communicate with the database.
>   Btw, I'm using the Perl DBI and DBD::SQLRelay libraries to connect
>   to the database. 
> 
>   There are some known network connectivity issues between the database
>   and client server where SQLRelay is running, but even when 
>   connectivity is restored database queries will not go through. 
>  
>   Has anyone else run into this problem before? 
> 
>  ---------------------------------
>    Frank Wiles <fr...@wi...>
>    http://www.wiles.org
>  ---------------------------------
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>