Re: [Sqlrelay-discussion] SQLRelay can't handle queries larger than 65535 bytes

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

Your intuition is probably correct! :)

There's a parameter in the sqlrelay.conf file called maxquerysize that
determines the maximum length query that the sqlrelay server will
accept.  The default is 64K, but you can make it larger if you like.
See http://sqlrelay.sourceforge.net/sqlrelay/configuring.html for more
info on that.

It's odd that you get that particular error though.  I think that may be
a bug.  I did recently fix a bug that caused that error to show up in
several cases where it shouldn't, so it may be fixed in CVS.

Try modifying maxquerysize and see if it doesn't solve the problem.

David Muse
dav...@fi...

On Fri, 2008-01-18 at 12:53 +0100, Martin Fleurke wrote:
> Hello,
> 
> When you issue a query that is larger than 65535*) bytes, you get a 
> "Failed to get a cursor id. A network error may have ocurred." error.
> 
> This is with Oracle 10g as database, and php, and sqlrelay 0.39.4. The 
> php-OCI8 functions do not have this limit.
> 
> *) I could go to a max of 65536 according to php-strlen() function, but 
> I assume it has something to do with 2^16 = 65535.
> 
> Regards,
> 
> Martin
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>