Oracle has released a beta of Oracle Database 10g Express Edition, an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that’s free to develop, deploy, and distribute. And yes, it works with ColdFusion MX 7. Thanks to John Farrar for bringing this to my attention.
Any idea on how to get CF connected to the DB?
I got the db up and running, but am unable to connect with CF, and resources are scarce at best.
Scott,
You can download the Oracle 10g Release 2 JDBC driver from Oracle here:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
Then configure it as "Other" in the ColdFusion Administrator datasource page. I’ll blog on TalkingTree.com details of how to do this shortly.
Steve – I was able to get connected using the native drivers. My problem stemmed from the fact that I did not know how to fid out SID of the server. After poking around the Oracle web based amdin, I discovered that the ‘name’ (found under the setting page) should be used for SID in the datasource.
Steven, any advantages to using the Oracle JDBC drivers for 10g over the native CF drivers?
ColdFusion MX 7.01 release notes state support for Oracle 10g and ships Macromedia driver version 3.3 which is the same as CFMX 7.0. However, you may want to consider using the Oracle JDBC driver matching the database version, especially since there is a 10g Release 2 JDBC driver available from Oracle which seems perfectly paired for the XE release. I’ll look into the question further.
I have not had a chance to just try this but am curious would these instructions work with the standard version of CF or does one need to step up to the enterprise? Was considering maybing trying XE with CF 7.01 std for a small intranet is why I am asking.
I was able to set up an Oracle datsource in CF without installing a new driver. I think I chose Oracle as my driver, then put XE as the SID name. I left the Server field blank and left the Port field as the default 1521. I like the Express Edition of Oracle much better for development here at home because it’s not nearly as big as the full version.
Cheers,
Peter