Guide to configure JNDI datasource in ColdFusion

(Originally written in Jul 2019. Updated Jan 2021.) Here’s a guide to show you how to configure JNDI datasource in ColdFusion (versions 10 and above). 1. Get the JDBC Driver The JDBC Driver for your particular database must be placed in <coldfusion>/cfusion/lib folder. 2. context.xml configuration Find the context.xml file in the <coldfusion>/cfusion/runtime/conf folder. Save a copy, then edit the file, adding a resource block before the closing tag </Context>, defining the database connection detail: <Resource name=”jdbc/test” auth=”Container” type=”javax.sql.DataSource” maxActive=”50″ […]

Connection String for ColdFusion (using Oracle advanced Security)

Oracle has introduced a new security feature, Oracle Advanced security, for Oracle databases. This feature provides better data encryption other advanced security features to secure user data. For more details on OAS, please refer: http://www.oracle.com/technetwork/database/options/advanced-security/overview/index.html After enabling this feature with an Oracle database, a user can create the connection using the connection string provided by Oracle with the help of Oracle JBDC drivers. However, when creating the secure connection using ColdFusion, there is an error when using the basic connection […]

Configuring Data Sources using Admin API in ColdFusion

Today, APIs are widely used and are very popular in the developer community. APIs make work easier, as developers can perform difficult task programmatically and automate repeatable routines.

In ColdFusion, there are Admin APIs available through which developers can add, modify, and delete Admin task programmatically. This is helpful for developers who do not have access to ColdFusion Administrator, for example, component event gateway, data sources, mail, and so on.