Skip to main content
W
wrightch
Participant
June 16, 2021
Answered

Create an Oracle Datasource in ColdFusion 2021

  • June 16, 2021
  • 1 reply
  • 1930 views

Does anyone know the correct syntax/ settings to create an Oracle datasource in ColdFusion 2021? I just did an upgrade and when it imported Oracle datasources, it claims the "Use of Adobe JDBC Drivers is restricted." and we were using macromedia.jdbc.MacromediaDriver. We also have the Oracle thin client installed but I'm not sure of syntax for the JDBC URL and placement of jar files. Can anyone point me in the right direction? Thanks!

    This topic has been closed for replies.
    Correct answer Priyank Shrivastava.

    Do you have an example connection string? And what is the Driver Class?


    Hi,

     

    Here I have the example.

     

    When you select "Other" as Driver option. For Oracle thin driver, here is the URL and Driver Class.

    URL: jdbc:oracle:thin:@<hostname>:<port>/SID   // This is with SID

    URL: jdbc:macromedia:oracle://<hostname>:<port>;ServiceName=<dbname> // This is with Service Name

    Driver Class: oracle.jdbc.driver.OracleDriver

     

    Please try this and let me know if that helps.

     

     

    1 reply

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity Expert
    Community Expert
    June 16, 2021

    I'm not aware of any such "restriction". Please confirm exactly where you saw that message (log? UI?), and please quote the exact message.

     

    So, had you installed cf 2021 or someone else? was  the full installer used, or the zip install? If the latter, were all modules installed, esp. ones related to jdbc? See the cf admin's last option on left for info on modules. 

    /Charlie (troubleshooter, carehart. org)
    W
    wrightchAuthor
    Participant
    June 16, 2021

    I have a standard ColdFusion 2021 license installed using the GUI
    The error states:
    ava.sql.SQLException: Use of Adobe JDBC Drivers is restricted. Drivers can
    only be used with Adobe server products. Please check that your license
    supports the requested driver.


    Chloris Wright
    Sr. Web Application Engineer
    The Catholic University of America - Technology Services

    W
    wrightchAuthor
    Participant
    June 16, 2021

    Since we received that, we're trying to use the Oracle Thin clin but receive the error:

     

    java.sql.SQLException: No suitable driver found 

     

    I'm sure we're not placing the jar in the correct place but we've put it in cfusion\lib and wwwroot\WEB-INF\lib and still no luck

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