"We use the Oracle Thin Driver - from Oracle's website - and we can access much longer fields than 4,000 characters. Sounds like he has some other issue going on.
Hmm, a quick google suggests that he is using the Oracle *8* drivers which do indeed have a 4,000 character limit - he should try the Oracle *9* drivers instead."
Would appear *not* to be a generic CFMX issue.
Can we confirm that this is not an issue of FarCry scripts simply setting the field size to a certain maximum on table creation? If this is the case, we can easily fix it in the code base and I guess folks can manually adjust the field limits on their Oracle installs.
-- geoff http://www.daemon.com.au/
Alex Park wrote:
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
