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
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:@//{HOSTNAM
...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.
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?
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.
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?
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.
Thanks,
Priyank
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
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
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,
^_^
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
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?
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.
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
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!!!
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
Copy link to clipboard
Copied
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"
Copy link to clipboard
Copied
cfinstall@adobe.com does not exist
Copy link to clipboard
Copied
Hi,
We received your query and response has been sent to you.
Thanks,
Priyank