2 Replies Latest reply on Feb 15, 2008 5:33 AM by mjsale

    Oracle Encryption and CF 8

      Hello All

      I am wondering if anyone has any information about how well CF 8 Enterprise will work with Oracle with encryption enabled? I know that in the past you had to use the JDBC or Thin client drivers for CF to make this work, but the one downfall was that these drivers didn't support running stored procedures in CF. Does anyone know if things have changed in CF8? Can I now connect to an Oracle datasource that uses encryption while still being able to use stored procedures in CF?

        • 1. Re: Oracle Encryption and CF 8
          Grizzly9279 Level 1
          What sort of Oracle encryption are you referring to? TDE (transparent database encryption?)

          We're still on CF 7, and we're using the JDBC-OCI drivers (not thin!). We only have Oracle 10g Standard Edition (not Enterprise), so we don't have Oracle TDE available to us. We ended up writing our own package library in Oracle and leveraged the DBMS_CRYPTO package to handle our encryption needs.

          The JDBC-OCI drivers were necessary for us to take advantage of Oracle RAC (with TAF), as well as stored procedures as you mentioned. We have run into one issue however, and that is, the JDBC-OCI drivers appear to hang endlessly if you try to return a LOB object to ColdFusion from a stored proc. LOB fetches need to take place in <cfquery> tags it would seem. Other than that the JDBC-OCI drivers have worked out great for us. The only downside is that you really need to have a full Oracle client installed on your ColdFusion server (we're using an Oracle 10g Run-time client install). Not a big deal, but it's yet another thing that you have to install, and worry about patching, etc.

          It is my understanding that if you are using the JDBC-OCI drivers, you would be able to take advantage of Oracle TDE. I've never had the opportunity to try this myself however.

          I hope this helps...feel free to reply with more information if you still have questions.
          • 2. Re: Oracle Encryption and CF 8
            mjsale Level 1
            Thanks for the info. Does anyone have any other info for CF 8 with TDE?