You may come across a situation where you need to set up a DSN for Oracle database(RAC) using service name instead of SID. In such scenario, you could use JDBC connection string to define the DSN. In this article, we will see how to set up DSN using service name in two simple steps. Log in to CF admin page -> Navigate to Data Sources-> Create a new DSN -> Select “Other” as driver. Specify the following settings: jdbc:macromedia:oracle://hostname:port;ServiceName=servicename;AlternateServers=(alternatehostname:port);ConnectionRetryCount=2; ConnectionRetryDelay=5 […]
ColdFusion (2016 release) has a webserver configuration tool for creating connectors with external web servers. These connectors work with Apache and IIS webservers. You can create one single connector (ALL) to run with all your websites or create individual connectors (ALL-Individually) for each website. We have seen scenarios, where users use “Virtual Host” to run multiple websites on a single server, in Apache.
In this blog, we will see, how to configure ColdFusion connector to work with multiple Virtual hosts in Apache and map the virtual hosts with individual instance of ColdFusion.