Skip to main content
B
bell_the_cat
Inspiring
September 11, 2024
Question

ColdFusion support for Oracle 23c/23ai and multitenant architecture?

  • September 11, 2024
  • 2 replies
  • 1195 views

My company is starting to investigate upgrading from Oracle 19c to 23c/23ai (whatever you want to call it) and we have a couple apps running on ColdFusion.  We are currently on CF 2021, but expect to upgrade to CF 2023 by the end of the year.  The support matrices for CF 2021 & 2023 only show support up to Oracle 19c.   First question - any idea when/if Adobe will support newer versions of Oracle than 19c?  Will it be in one of the current CF versions or future 202?

 

I understand the support matrix docs only list the versions that Adobe has officially tested and it could be possible to download and use an OJDBC driver directly from Oracle, setting it up as an "Other" datasource, however I can't find any documentation on whether ColdFusion has support for multitenant architecture and what changes need to be made for multitenancy, which is apparently available in Oracle 19c and required in 23c/23ai.  

 

There is an old forum posting from 2014 asking about connecting CF 11 to Oracle 12c and how to change the connection string for multitenant, but no answers.  

 

Second question, has anyone successfully connected CF with an Oracle multitenant DB (any version)?  If so, can you please provide details on how?  JDBC string, updated drivers, config changes, etc.  

    This topic has been closed for replies.

    2 replies

    J
    jmaitino
    Inspiring
    October 9, 2024

    I actually ended up using OJDBC11 with a connection string:

     

    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST={IPAddress/Servername})(PORT = 1521)))(CONNECT_DATA=(SERVICE_NAME = database.domain.com)))
    Driver Class: oracle.jdbc.OracleDriver
    Driver Name: Oracle JDBC11
    User Name: {username}
    Password: {password}

    Connection String: EncryptionLevel=required;EncryptionTypes=(AES256);DataIntegrityLevel=required;DataIntegrityTypes=(SHA256);

     

    B
    bell_the_catAuthor
    Inspiring
    October 9, 2024

    Could you please add which version ColdFusion, which version Oracle, and confirm Oracle is configured as multitenant?  Thanks!

    J
    jmaitino
    Inspiring
    October 9, 2024

    I am using Coldfusion 2021 Enterprise.  We recently upraded to Oracle 23, and when we did I started getting sporadic database connectivity issues using CF's Oracle package.   I do not believe we used a multi tenant database.

     

    I am still testing my connectivity, but as of today, we are no longer getting the "Error Executing Database Query." errors from Coldfusion.  

     

    I would think that if the user can connect using sqlplus and the TNS entries, then they could simply copy that TNS entry string into the above URL: JDBC URL: jdbc:oracle:thin:@{TNS Connect String}

     

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    September 12, 2024

    Please say more about what you mean by the question, "when/if Adobe will support newer versions of Oracle than 19c?" . According to the ColdFusion 2023 Support Matrix, ColdFusion 2023 does in fact support Oracle 19c.

     

    Multitenant architecture is design, not implementation. As an application server, ColdFusion is tasked with implementation, for a given design. In this case, the multitenant design pertains to the Oracle database. Therefore, asking whether ColdFusion has support for multitenant architecture is, I think, not a relevant question. I would therefore expect ColdFusion 2023 to work with multitenant Oracle 19c.

    I have yet to work with multitenant Oracle. Nevertheless, I have a suggestion. 

    You could configure ColdFusion to connect to a specific pluggable database within Oracle's multitenant architecture as follows:

    1.  Download the Oracle JDBC driver and copy it to the ColdFusion lib directory.
    2.  Restart ColdFusion (to load the new driver).
    3.  Configure the new data source in the ColdFusion Administrator, selecting "Other" as driver.
    4.  Use the following format:
      <JDBC_URL>: jdbc:oracle:thin:@//<host>:<port>/<service_name>
      <host>: The hostname or IP address of your Oracle server.
      <port>: The port number (default is 1521).
      <service_name>: The service name of your (multitenant) pluggable database.
    B
    bell_the_catAuthor
    Inspiring
    September 12, 2024
    Please say more about what you mean by the question, "when/if Adobe will support newer versions of Oracle than 19c?" . According to the ColdFusion 2023 Support Matrix, ColdFusion 2023 does in fact support Oracle 19c.

     

    There are at least two versions newer than Oracle 19c - 21c and 23c/23ai.  As explained in my original post, we are currently on 19c but looking at upgrading to 23c/23ai.  My question was when will Adobe ColdFusion support newer versions of Oracle, i.e., 21c and 23c/23ai?

     

    Regarding multitenant, we have not yet switched to using multitenant architecture in Oracle, so I don't know what, if anything, needs to change in the JDBC connection string or datasource config from ColdFusion.  The only posting I found on Adobe Community indicated the standard JDBC string might not work.  I was looking for responses from people who had successfully connected ColdFusion 2021/2023 to an Oracle multitenant database, and whether they had to make any adjustments on the ColdFusion side to connect.

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    September 12, 2024

    Fair enough. Let's hope that Adobe's ColdFusion team and fellow ColdFusion developers who have successfully connected ColdFusion to an Oracle multitenant database will chime in. 

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