Skip to main content
T
tanguyr
Participating Frequently
July 20, 2010
Question

CF 8.0.1 can't connect to oracle database after upgrade to 11g

  • July 20, 2010
  • 1 reply
  • 3447 views

Hello,

The company where i work is upgrading their Oracle databases from version 10 to version 11. Since this upgrade, i am not able to validate datasources pointing to the new 11g instance (connections to the old oracle 10 instance still work fine, but this will be removed soon).

After creating a new or editing an existing datasource, or when clicking the "verify" icon next to the datasource name in the CF admin, i get the error message:

Connection verification failed for data source: formZ
java.sql.SQLException: [Macromedia][Oracle JDBC Driver]null
The root cause was that: java.sql.SQLException: [Macromedia][Oracle JDBC Driver]null

I am running ColdFusion 8,0,1,195765  Developer Edition on my local workstation (XP Pro), in the J2EE deployment inside weblogic 9.2

My java version is 1.5.0_12-b04, my datadirect driver version is 3.6

Is anybody here running CF8 with an Oracle 11g database? Did you have to do something special to get this working or was it all fine out of the box?

Any help would be appreciated.

Regs,

/t

This topic has been closed for replies.

1 reply

ilssac
ilssac
Inspiring
July 20, 2010

Yes, we used 8.0.1 for three years just fine with the out-of-the-box Oracle JDBC driver against our 11g databases.  This drive is only available in the Enterprise edition though.  (And, of course, the development edition since it is an IP limited version of Enterpise)

We recently upgraded to 9 so we no longer are using 8.0.1 against our Oracle 11g database servers.

T
tanguyrAuthor
Participating Frequently
July 22, 2010

Hello ilssac,

Thanks for your response. Do you know off the top of your head which release of Oracle 11g you were running at the time?

Regs,

/t

Owainnorth
Owainnorth
Inspiring
July 22, 2010

Not at all helpful I know, but we're currently running:

CF 8,0,1,195765 Standard on Windows

CF 8,0,1,195765 Standard on Linux

Oracle 11.1.0.6.0 - 64bit on Linux

And we've never had any issues at all, so it definitely works.

O.

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