Oracle on CFMX 7

[Murat Demirci]

"Bill_Sahlas" <bsahlas@macromedia.com>, haber iletisinde þunlarý
yazdý:cugmdg$1lt$1@forums.macromedia.com...

>"The Oracle Thin Client will not work with CLOBS/BLOBS on
> CFMX. It doesn't implement this part of the JDBC spec in a Vendor neutral
> fashion."

Is this still true for new JDBC drivers that are released by Oracle in year
2004?

Murat.

[Mustache2]

Hi all,

I?m using CF 7 Standard and Oracle JDBC drivers to update a CLOB field. I
cant?make it work, even with cfqueryparam.

How can I work with CF 7 Stantard and Oracle JDBC drivers using CLOB fields ?
I can?t afford CF 7 Enterprise.

Thx in advance.

[pdrich]

Mustache2, we are using CFMX Standard with the OCI driver
(oracle.jdbc.OracleDriver - jdbc:oracle:oci8:@myservername). In the data
source Advanced Settings, check the CLOB box (enable long text retrieval).
There is a problem when I try to update more than one CLOB in a single SQL
statement, so I have to split it into more than one query. (Note: I don't get
an error when I update two CLOBs in a single query, it just swaps the content
of the two fields!) If you have a lot of CLOBs, splitting into multiple
queries could be a pain, but we only have two, so this is a good workaround.

You can independently buy the DataDirect drivers (same as come packaged with
Enterprise), but they are more expensive to purchase than it would cost to
upgrade CFMX!

The cfquery SQL is below.

UPDATE MYTABLE
SET MYFIELD = <cfqueryparam value="#form.myvar#" cfsqltype="CF_SQL_CLOB">