Re: [Sqlrelay-discussion] Unknown prepared statement handler?

[Lawrence, G. <gla...@uc...>]

We had this problem (although different error message as we were talking to DB2) and the Cisco FWSM timing out TCP sessions was the culprit. I think we set something up on the OS to twiddle the TCP keepalives so that the FWSM saw enough traffic to keep the things going. If this sounds like what might be causing your problem I can get the firewall and OS folks to give me the details of exactly what they did...

-----Original Message-----
From: David Muse [mailto:dav...@fi...] 
Sent: Tuesday, April 14, 2009 1:06 PM
To: Discussion of topics related to SQL Relay
Subject: Re: [Sqlrelay-discussion] Unknown prepared statement handler?

It sounds like something between SQL Relay and the DB is disconnecting
the 2 of them from each other if they've been idle.  A common culprit is
a Cisco PIX firewall.  Is there a Cisco PIX firewall between SQL Relay
and the DB?
http://sqlrelay.sourceforge.net/sqlrelay/faq.html#firewallhang

Aside from that, I can't think of anything that could cause that to
happen.

Dave Muse
dav...@fi...