Coldfusion 11 Standard vs. Enterprise

New Here ,
Sep 09, 2016 Sep 09, 2016

Copy link to clipboard

Copied

Hello all,

We are planning to upgrade our version 10 Enterprise as it would not connect to our Oracle 12c enterprise database.

What does CF 11 Standard give us that CF 10 Enterprise does not and would it be able to connect with Oracle 12c enterprise edition?

We have installed CF on multiple servers. Is that the key of standard (install on one server only) vs. enterprise (can install on multiple servers) and would CF 11 connect with Oracle 12c enterprise database.

Thanks

TOPICS
Getting started

Views

3.0K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct Answer

Adobe Employee , Nov 10, 2016 Nov 10, 2016
Hi,Since it's a 3rd party driver, you don't find it in drop down. Please follow the instructions below.1. Download the think driver from Oracle's website.2. You can copy the driver in \ColdFusion\cfusion\lib or ColdFusion\cfusion\wwwroot\WEB-INF\lib3. Restart ColdFusion service.4. Login to CFadmin>Datasources>Add Datasource name and from the drop down select as "Other".5. URL for connecting to Oracle are  a. If you have configured SID, follow the below URL            jdbc:oracle:thin:@//{HOSTNAM...

Likes

Translate

Translate
Guide ,
Sep 09, 2016 Sep 09, 2016

Copy link to clipboard

Copied

First of all, Enterprise has more features than Standard (or has unthrottled versions of some of the same features).  So Enterprise > Standard.  Compare Buying guide | Adobe ColdFusion Enterprise to Buying Guide | Adobe ColdFusion Standard .

Second, both Enterprise and Standard licenses only cover a single server.  Enterprise allows both more hardware resources (CPU cores) and multiple instances on the same server.  See http://wwwimages.adobe.com/content/dam/acom/en/legal/licenses-terms/pdf/ColdFusion-2016.pdf​ , section 3.1.

Third, you can no longer purchase ColdFusion 11 directly.  You can purchase ColdFusion 2016 (as long as you don't purchase from the Adobe store) and request a downgrade license key to allow you to run ColdFusion 11.

HTH,

-Carl V.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 10, 2016 Sep 10, 2016

Copy link to clipboard

Copied

so what you are saying is that we are forced to buy 2016 elsewhere besides Adobe and downgrade to 11 license during install? How much would that be?

woukd it be able to connect to oracle 12c enterprise edition?

we have 4 cf servers we wish to upgrade. Does that mean we have buy 4 enterprise licences?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Sep 11, 2016 Sep 11, 2016

Copy link to clipboard

Copied

Not exactly.  I just said the downgrade rights don't come with a license purchased online through the Adobe Store.  You should be able to purchase a downgradeable license through the Adobe Business Store or an authorized reseller. You might want to email cfinstall@adobe.com for assistance.  The downgrade should be free.

I don't think Enterprise Edition is required to connect to Oracle, but I could be wrong.  At the very least, you should be able to connect using Oracle's JDBC driver.

You'll need one license per server, but again, not sure if you need Standard or Enterprise.  Aside from the Oracle issue, is there anything else about your environment that might necessitate Enterprise Edition over Standard Edition?

-Carl V.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 11, 2016 Sep 11, 2016

Copy link to clipboard

Copied

We need to install it on several servers.

Where could we get updated jdbc drivers to work with oracle 12c running cf10 enterprise and how do we "install" them? Does cf 11 enterprise work with 12c? The only real difference between standard and enterprise Is that enterprise allows you to install on multiple servers, correct?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Sep 12, 2016 Sep 12, 2016

Copy link to clipboard

Copied

Hi,

CF10 oracle driver was not tested with Oracle 12c however with ColdFusion 11 it is compatible and supported. With Enterprise edition, you can create multiple instances but it doesn't mean that you can install one license of enterprise edition in multiple servers.

Please check the support matrix.

CF11: http://wwwimages.adobe.com/content/dam/Adobe/en/products/coldfusion/pdfs/cf11/coldfusion11-support-m...

CF10: https://www.adobe.com/content/dam/Adobe/en/products/coldfusion/pdfs/cf10/coldfusion10-support-matrix...

Thanks,

Priyank

Thanks,
Priyank Shrivastava

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 12, 2016 Sep 12, 2016

Copy link to clipboard

Copied

Hello Priyanks,

Where in the matrix did it say that for enterprise (or standard) that we CANNOT install on multiple servers? I just see minimum requirements.

Thanks for confirming about 12c for CF 11 (Standard or Enterprise)

We have 4 CF servers with multiple instances on each server. 2 production and 2 tests. I would think that we would need to purchase CF 11 enterprise so we can install or upgrade them for these 4 servers at least (or maybe install other ones from scratch and just port the code over as I heard that it's easier to do that than to actually upgrade from CF 10 to 11).

Thanks

L

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Sep 12, 2016 Sep 12, 2016

Copy link to clipboard

Copied

Hi,

You cannot purchase CF11 directly, you have to purchase CF2016(not from www.adobe.com) through re-seller. If you need assistance with that, please send an email at cf.install@adobe.com.

ColdFusion Standard doesn't have support for Oracle, it is a feature of Enterprise. In support matrix, there is chart where you can check the standard and enterprise features.

Thanks,

Priyank

Thanks,
Priyank Shrivastava

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Sep 12, 2016 Sep 12, 2016

Copy link to clipboard

Copied

I'll wager that there is a way to integrate Oracle 12 into the Standard edition of CF Server.  Probably download some drivers/patches/whatever, swap some files, reboot.

That's not to say that there is no advantage to Enterprise.  Some companies need it, some don't.  But I find it difficult to believe that, as robust as CF is, the Standard edition can't be made Oracle 12g compatible.

V/r,

^_^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Sep 12, 2016 Sep 12, 2016

Copy link to clipboard

Copied

Hi Jack,

Yes, you can use Oracle thin driver and connection string to connect to ColdFusion standard. I didn't say, you cannot connect Oracle, all I am saying is driver option is not there when you click on drop down.

Thanks,

Priyank

Thanks,
Priyank Shrivastava

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 12, 2016 Sep 12, 2016

Copy link to clipboard

Copied

It is not 12g we need to connect to but 12c Enterprise.

Where could we get these drivers? Oracle's site directly and that would mean we would have to recode our apps to use a connection string instead, correct?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Sep 13, 2016 Sep 13, 2016

Copy link to clipboard

Copied

Assuming you download the Oracle 12c driver from Oracle's site, you put the .jar file in the \ColdFusionXXX\cfusion\lib folder.  Might need to restart CF to have it pick up the .jar.  Then you can configure a datasource using that driver in one of two ways: through CF Administrator (just like setting up any other datasource, except you choose "other" for the driver type) or by defining it in Application.cfc.

Once the datasource is created, you should be able to use it anywhere in your application just like you'd use any other datasource.  No recoding should be required.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 13, 2016 Sep 13, 2016

Copy link to clipboard

Copied

i understand and then just add the jdbc url and driver class name along with the username and password.

this could be the cheaper option to go and keep version 10 to connect to Oracle 12c

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Nov 10, 2016 Nov 10, 2016

Copy link to clipboard

Copied

Priyank, you said "Yes, you can use Oracle thin driver and connection string to connect to ColdFusion standard. I didn't say, you cannot connect Oracle, all I am saying is driver option is not there when you click on drop down."

Why is it so hard to find the details on how to do that?  What files do I need to download from Oracle, where do I put them, and then how do I configure the DSN from within CF Server Administrator?

It shouldn't be this hard to do!!!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Nov 10, 2016 Nov 10, 2016

Copy link to clipboard

Copied

Hi,

Since it's a 3rd party driver, you don't find it in drop down. Please follow the instructions below.

1. Download the think driver from Oracle's website.

2. You can copy the driver in \ColdFusion\cfusion\lib or ColdFusion\cfusion\wwwroot\WEB-INF\lib

3. Restart ColdFusion service.

4. Login to CFadmin>Datasources>Add Datasource name and from the drop down select as "Other".

5. URL for connecting to Oracle are

  a. If you have configured SID, follow the below URL

            jdbc:oracle:thin:@//{HOSTNAME}:{PORT}/SID

  b. If you have configured service name, follow the below URL

            jdbc:oracle:thin:@//{HOSTNAME}:{PORT};servicename={servicename}

6. Driver Class: oracle.jdbc.driver.OracleDriver

7. Enter username and password and Submit.

Hope this helps.

Thanks,

Priyank

Thanks,
Priyank Shrivastava

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 10, 2016 Nov 10, 2016

Copy link to clipboard

Copied

LATEST

This is what I have done...

Downloaded the latest jdbc .jar (ojdbc7.jar) file and used that on a test server running CF 10 (try and use the same server release as your current production) and put it in CF's java classpath.   Restart your CF and see if it's there.

You download the jar file here

http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html

then follow Priyank's advice above for the jdbc url and driver class name

for example: JDBC URL: jdbc:oracle:thin:@yourOracleServer.yourDomain.com:1521:YourDatabaseSIDName

Driver class: oracle.jdbc.driver.OracleDriver

Driver Name: whatever you want to call it

Username: Username used to connect to the "YourDatabaseSIDName" located in "yourOracleServer.yourDomain.com"

Password: Password for the Username used to connect to the "YourDatabaseSIDName" located in "yourOracleServer.yourDomain.com"

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 12, 2016 Sep 12, 2016

Copy link to clipboard

Copied

cfinstall@adobe.com does not exist

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Sep 12, 2016 Sep 12, 2016

Copy link to clipboard

Copied

Hi,

We received your query and response has been sent to you.

Thanks,

Priyank

Thanks,
Priyank Shrivastava

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines