A Data Source is created via the Administrative Console. Connection Pooling is set to "on" by default via an Advanced Setting within the Data Source titled "Maintain Connections".
Use the Desktop "Start" button as follows:
Start → Programs → Adobe → ColdFusion 10 → Administrator
In the left pane, under "SERVER SETTINGS", click on "Java and JVM"
The right pane will have a "ColdFusion Class Path" entry. Beginning with Teradata JDBC Driver 16.20.00.11, enter the full path name for terajdbc4.jar. With older versions of the Teradata JDBC Driver, enter the full path names for terajdbc4.jar and tdgssconfig.jar.
Click "Submit Changes" to apply these changes and restart the ColdFusion service to make them take effect.
Additional configuration is required when ColdFusion Sandbox Security is enabled.
How to use the Teradata JDBC Driver with ColdFusion Sandbox Security
In the left pane, under "DATA & SERVICES", click on "Data Sources".
Enter a "Data Source Name" and select a Driver and then click "Add".
Field |
Value |
Example |
Data Source Name |
The name you will later use to refer to this Data Source. | TeraJDBC4 |
Driver |
The Driver to use. Since the Teradata Driver is not listed, select "Other". | Other |
The values required to create the connection pool are outlined in the following table. Please note that the username of "guest" and password of "please" are examples and should be replaced by the actual username/password combination for your database system.
Field |
Value |
Example |
CF Data Source Name |
This field was carried over from the previous form. It can be used by ColdFusion scripts to access this Data Source. | TeraJDBC4 |
JDBC URL |
Defines the URL that will be passed to the driver.
The example database hostname is "whomooz".
You should use the actual database hostname for your site.
Please note that any connection URL parameter such as "CHARSET" or "TMODE" must be set within this URL parameter. These CANNOT be set within the properties panel. |
jdbc:teradata://whomooz |
Driver Class |
The name of the class that implements the java.sql.Driver interface. | com.teradata.jdbc.TeraDriver |
Driver Name |
An optional name that you want to assign to this driver. | Teradata |
User Name |
The database username. | guest |
Password |
The password of the user defined by "User Name".
After this value is applied it will not be visible as cleartext in the panel. |
please |
After entering the required information, click on the "Submit" button to test the Data Source.
The final screen should say "data source updated successfully" at the top and your new Data Source should be visible in the list of "Connected Data Sources", in the bottom table in the right pane.
ColdFusion provides its own markup language for using Data Sources.