Ok I also confirm that we also have 4000 character limit on the CLOB fields. I also enable long text retrieval CLOB in the admin section in coldfusion. I have used Coldfusion MX 6.1 enterprise drivers with no luck. I have used Oracel thin drivers with no luck I have used Older drivers ( fixes from coldfusion tech notes) no luck. I have received coldfusion new jdbc drivers from macromedia today( it has not been released) again no luck!
Please Help "Nathan Mische" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] After further investigation I have confirmed *my* problem to be the Oracle's thin driver. It seems to put a 4000 character limit on the CLOB fields, even if you have the " -- Enable long text retrieval (CLOB)." option checked in the administrator. As soon as I go over 4000 characters I get this error: 17070 Data size bigger than max size for this type This is what I expected, but I just though I should confirm. I would really like to see this issue resolved, but I'm not sure what else I can do without CFMX Enterprise. In case you are wondering why I'm so interested in Alex's plight, I'm hoping to convince management to upgrade to Enterprise so that I can deploy FarCry on Oracle 9i. I would like to use Oracle because we are already running Oracle9i and have an Oracle DBA in-house. If there is anything else I can do, let me know. --Nathan > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Alex Park > Sent: Tuesday, March 16, 2004 1:05 PM > To: FarCry Developers > Subject: [farcry-dev] Re: Database Problem > > This did not work :( > > Any other ideas? > > > Alex > > > "Craig McDonald" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > > By default they can hold up to 4gig... > > > > But I think 32760 is a good start. > > > > The oracle datasource also needs to be setup in CF Admin with the > > "Enable long text retrieval (CLOB)" option checked. Otherwise, only > > 4000 characters will be pushed into the db on insert (probably the > > reason the 4000 limit is there... > > > > Cheers, > > Craig > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > Brendan Sisson > > Sent: Tuesday, 16 March 2004 9:50 AM > > To: FarCry Developers > > Subject: [farcry-dev] Re: Database Problem > > > > > > Nathan Mische wrote: > > > > > db.type = 'CLOB'; > > > db.length = 4000; > > > stPropTypes['longchar'] = duplicate(db); > > > > > > Nice pick up Nathan, this would be the problem. Anyone know a good > > default size for Oracle CLOB fields? > > > > -Brendan > > http://farcry.daemon.com.au > > > > > > --- > > You are currently subscribed to farcry-dev as: > [EMAIL PROTECTED] > > To unsubscribe send a blank email to > > [EMAIL PROTECTED] > > > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > > http://www.mxdu.com/ + 24-25 February, 2004 > > > > > > > > > > --- > You are currently subscribed to farcry-dev as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
