A Data Source is created via the Management Console. Connection Pooling is enabled by checking the "Pool Connections" checkbox on the Data Source definition pane.
Use the Desktop "Start" button as follows:
Start → Programs → Adobe JRun 4 → JRun Management Console
For ColdFusion 8:
Start → Programs → Adobe → ColdFusion 8 → JRun Management Console
In the following examples, all changes are made to the "default" server. The actual server that you choose will depend on your JRun configuration.
In the left pane, under "default", click on "Settings" and then "JVM Settings".
The right pane will have a "Classpaths" 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 "Update" to apply these changes and restart the JRun 4 server to make them take effect.
In the left pane, under "default", click on "Resources" and then "JDBC 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 |
Database Driver |
The Driver to use. Since the Teradata Driver is not listed, select "Not-Listed". | Not-Listed |
The values required to create the data source 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 |
Data Source Name |
This field was carried over from the previous form.
It can be used by JRun 4 clients to access this Data Source. |
TeraJDBC4 |
JNDI Name |
The JNDI name that can be used to look up this data source on the server | jdbc/TeradataDS |
Driver Class Name |
The name of the class that implements the java.sql.Driver interface. | com.teradata.jdbc.TeraDriver |
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 |
Username |
The database username. | guest |
Password |
The password of the user defined by "Username".
After this value is applied it will not be visible as cleartext in the panel. |
please |
Pool Connections |
All should remain checked which is their default value. |
After entering the required information, click on the "Submit" button to finish the data source creation.
The final screen should say "Data source has been created" at the top and your new Data Source should be visible in the list of "JDBC Data Sources", in the bottom table in the right pane.
Complete sample servlets are listed here.
It is important to ensure that a DataSource's "Native Results" checkbox is checked. When it is not checked, the following error message may be seen:
[Teradata JDBC Driver] : Method not supported with this release
of the Teradata Database: use the COMPAT_DBS and COMPAT_ISAUTOINC connection
options