I had the same problem. I assumed it was because I was using the Oracle JDBC Type IV thin driver which does not comply to the JDBC 3.0 specification.
However, I did notice the following code, lines 258-260 in farcry_core/packages/farcry/alterType.cfc. db.type = 'CLOB'; db.length = 4000; stPropTypes['longchar'] = duplicate(db); This code is part of the getTypeDefaults method. According to the method's hint, it "initialises a reference structure that can be looked up to get default types/lengths for respective DB columns." I'm not really sure where/how this method is used, but it may be something to look into... --Nathan > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Bowden, Beth (NIH/NIEHS) > Sent: Monday, March 15, 2004 7:04 AM > To: FarCry Developers > Subject: [farcry-dev] RE: Database Problem > > Alex, > > We are just testing out FarCry and are having the same > problem. We're also using CFMX and Oracle 9i. > > I'm in the midst of coding a CF script to do the same thing as yours. > > Beth > > -----Original Message----- > From: Alex Park [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 11, 2004 9:07 PM > To: FarCry Developers > Subject: [farcry-dev] Database Problem > > > Hi, > > We can not use the far cry admin interface to post more than > 4000 characters > or so to a page. We can howerver use a cold fusion script to > insert more > than 4000 characters to a clob and have it display on the far > cry test site. > This does however brreak the admin. When we go to edit that page. > > We are using Cold Fusion MX, Oracle 9i on Windows 2003 > > Anyone else having this problem? > > Thanks, > Alex > > > > --- > 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
