Ben Forta

AdobeStock_455007340

Free Oracle 10g XE

Home » Free Oracle 10g XE

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.

,

7 responses to “Free Oracle 10g XE”

  1. Scott Stroz Avatar
    Scott Stroz

    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.

    Reply
  2. Steven Erat Avatar
    Steven Erat

    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.

    Reply
  3. Scott Stroz Avatar
    Scott Stroz

    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.

    Reply
  4. rich Avatar
    rich

    Steven, any advantages to using the Oracle JDBC drivers for 10g over the native CF drivers?

    Reply
  5. Steven Erat Avatar
    Steven Erat

    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.

    Reply
  6. Aaron Rouse Avatar
    Aaron Rouse

    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.

    Reply
  7. Peter Avatar
    Peter

    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

    Reply

Leave a Reply