RE: Inserting Blobs

[Mark Matthews]

On Fri, 11 Feb 2000, John Zollinger wrote:

> > I wouldn't classify it as a bug, the exception that is thrown is
> > misleading,
> > I'll give you that, so the fact that I'm not throwing an SQLException when
> > you try to write > 65K packets is a bug. However, limiting the packet size
> > to 65K is not a bug, considering that before I did that I had users
> > mysteriously crashing their mysql servers by sending too large of packets.
> 
> So, if we need to insert blobs larger than 65K (a LONGBLOG), what should we
> do?  Is it ok to increase the MAXBUF (and recompile the driver), or is that
> going to cause the mysterious problems you hint at above?

You can do that, which will work until you create packets that are larger
than your server will accept, or use 2.0pre (which is beta) which has the
ability (in most cases) to figure out how large a packet your server will
accept and enforces that maximum size.

	-Mark