On CFMX if you have checked CLOB & BLOB does that mean you should change
the 2 buffers to an empty string or just leave them at their defaults
64000?
S
Ken Smith <[EMAIL PROTECTED]>
12/16/2003 10:18 AM
Please respond to spectra-talk
To: Spectra-Talk <[EMAIL PROTECTED]>
cc:
Subject: RE: Large objects "blowing up"
Gentlemen,
You use long text buffer size or long text retrieval. If you enable long
text retrieval CF will dynamically calculate the needed buffer size. It
will then use it. If you leave long text retrieval off, it will use the
buffer size you enter as the maximum. Long text retrieval is inefficient
and should only be used when absolutely necessary. If you do use it,
create
a duplicate DSN without to use when you are not bringing back long text.
CFMX behaves the same way. You specify a long text buffer OR enable
CLOB/BLOB retrieval.
FYI.
--Ken
Regards,
Ken Smith
Senior Engineer, Certified ColdFusion 5 Developer
ColdFusion/Spectra Product Support
(617) 219-7723
mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Announcing Macromedia DevNet Subscriptions
Maximize your power with our new premium software
subscription for Macromedia developers
Find out more: http://www.macromedia.com/go/devnetsubs/
<http://www.macromedia.com/go/devnetsubs/>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 3:53 PM
To: Spectra-Talk
Subject: Re: Large objects "blowing up"
I made sure that long text wsa enabled and upped the buffer to 128000,
instead of the 64000 it was set at. Issue is still happening.
Any other ideas?
Geoff Bowers <[EMAIL PROTECTED]>
12/08/2003 10:07 PM
Please respond to spectra-talk
To: Spectra-Talk <[EMAIL PROTECTED]>
cc:
Subject: Re: Large objects "blowing up"
Shawn,
[EMAIL PROTECTED] wrote:
> Since migrating to 1.5.2 (and 1.5.3) I've been having problems with
large
> content objects (64k plus) blowing up for no apparent reason. Initially
it
> will look like they are created successfully, but then all of the data
in
> OBJECTDATA just goes away leaving me with invalid objects. It is my
> understanding that objects of that size are split between the objects
and
> extendeddata tables, but it has been that way since the first version of
> Spectra. Has anyone else run across this and if so, what was the fix?
You might try enabling long text on the datasource and increasing the
buffer to a larger size to see if that doesn't help the packet through.
-- geoff
http://www.daemon.com.au/ <http://www.daemon.com.au/>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
