Skip to main content
A
Anonymous
October 11, 2011
Answered

Problem with CLOBs in CF8 and Oracle 11.2.0.3

  • October 11, 2011
  • 3 replies
  • 3653 views

I've just noticed a problem with retrieving CLOBs in my ColdFusion applications. Any query that should return a CLOB is suddenly returning an empty string. I noticed this shortly after upgrading from Oracle 11.2.0.2 to 11.2.0.3. My best guess is that we are using driver version 3.6. I notice on the DataDirect web site, they list Oracle 11g support for version 3.7, but I don't see any reference to 3.7 on Adobe's website so I don't know if I can upgrade to it.

I don't actually know if the Oracle point version upgrade was what caused this or not. Has any one else experienced this problem?

This topic has been closed for replies.
Correct answer

Upgrading to CF9 seems to have fixed the problem. I'm not sure what component was causing the exact problem, though.

3 replies

A
Anonymous
January 29, 2013

Hi,

You can use the file called macromedia_drivers.jar from a release 9 or 10 of coldfusion, just replace it on every cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib you have.

You can use an evaluation version of ColdFusion to grab the file.

Do not forgot to check enable clob/blob into the DSN configuration page.

Regards.

A
Anonymous
Correct answer
December 25, 2011

Upgrading to CF9 seems to have fixed the problem. I'm not sure what component was causing the exact problem, though.

S
samer_sadek
Participant
November 8, 2011

We are having the same issue.

We tried installing the 11.2.0.3 driver (ojdbc6.jar) availabe at http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html and set is as a new datasource of type other, which worked fine for blobs, but now cannot return results from any stored procedures. It works well with queries, but not sps.

Were you able to solve it any other way?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices