Teradata JDBC Driver Learning Examples

Teradata Download Center > Teradata JDBC Driver > Teradata JDBC Sample Programs > Teradata JDBC Driver Learning Examples

This documentation represents proprietary information of Teradata Corporation, and is protected by US, foreign and international intellectual property laws, including US Federal copyright law, and as such, may not be disclosed to third parties, or otherwise copied or duplicated in any form, in whole or in part, without the prior written consent of Teradata Corporation.

The purpose of this documentation is to provide examples of programs that can be used as a guide for purposes of developing JDBC applications solely for use with the Teradata Database, and is provided as an illustration of how JDBC functions operate with the Teradata Database.

This documentation, including the example programs, are provided on an "AS-IS" basis, and under no circumstances will Teradata be liable for any damages (including direct, indirect, consequential, special, punitive, incidental damages) resulting from any use even if notified of the possibility of any damages. Teradata reserves the right to change or withdraw any of the information provided in this documentation without notice.

The learning examples are split into distinct modules. Every module consists of one or more examples within a general theme, exemplifying a specific aspect of the JDBC driver. All examples are thoroughly documented to explain newly encountered features as they are used.

The modules are as follows:

Module	Description
0	Sets up the environment, creating necessary tables and indexes
1	Shows how to obtain result set meta data for a SQL statement
2	Illustrates performing insertions into the sample tables
3	Illustrates performing selections from the sample tables
4	Illustrates performing updates to the sample tables
5	Illustrates performing deletions from the sample tables
6	Illustrates creation and execution of stored procedures
7	Illustrates execution of multi-statement requests
8	Illustrates creation and execution of macros
9	Illustrates obtaining various information about the database
10	Illustrates searching for specific information about the database
11	Illustrates obtaining and modifying client access product options
12	Illustrates using the J2SE 5.0 (JDK 1.5) JdbcRowSetImpl
13	Illustrates using DataSources
14	Illustrates creation and execution of User-Defined Functions (UDFs)
15	Illustrates Teradata-specific data type conversions
16	Illustrates the use of JDBC Escape Syntax
18	Illustrates the use of JDBC Updatable Result Set
19	Illustrates the use of SET QUERY_BAND statement
99	Cleans up the environment

The table below shows the example breakdown into modules, with the respective example file name and description.

Module	File Name	Program Description
0	T20000JD.java	Set up the example environment (users, databases, tables, indexes)
0	T20001JD.java	Set up the example environment (users, databases, tables, indexes)
0	T20002JD.java	Set up the example environment (users, databases, tables, indexes)
0	T20003JD.java	Set up the example environment (users, databases, global temporary tables, indexes)
1	T20100JD.java	Execute a SQL statement and obtain any result set column meta data
1	T20101JD.java	Execute a SQL statement and obtain any result set column meta data
2	T20200JD.java	Insert non LOB columns into a row in a table, without using parameter markers
2	T20201JD.java	Insert non LOB columns into a row in a table, using parameter markers
2	T20202JD.java	Insert LOB columns into a row in a table, without using parameter markers
2	T20203JD.java	Insert LOB columns into a row in a table, using parameter markers
2	T20204JD.java	Insert data into a table and display the generated keys
2	T20205JD.java	Insert data into a table using FastLoad with auto-commit true
2	T20206JD.java	Insert data into a table using FastLoad with auto-commit false
2	T20207JD.java	Insert data into a table using FastLoad with auto-commit false and verify FastLoad sessions
3	T20300JD.java	Select non-LOB columns from a specific row, from a table, without using parameter markers for the predicate values. Also obtain column meta data.
3	T20301JD.java	Select non-LOB columns from a specific row, from a table, using parameter markers for the predicate values. Also obtain column meta data.
3	T20302JD.java	Select LOB columns from a specific row, from a table, without using parameter markers for the predicate values. Also obtain column meta data.
3	T20303JD.java	Select LOB columns from a specific row, from a table, using parameter markers for the predicate values. Also obtain column meta data.
3	T20304JD.java	Obtain result set metadata prior to executing the prepared statement
3	T20305JD.java	Obtain parameter metadata prior to executing the prepared statement
3	T20306JD.java	Select data from a table using FastExport without parameter marker
3	T20307JD.java	Select data from a table using FastExport with parameter marker
3	T20308JD.java	Select data from a table using FastExport with parameter marker and verify FastExport sessions
4	T20400JD.java	Update a non-LOB column from a specific row, from a table, without using parameter markers for the update and predicate values
4	T20401JD.java	Update a non-LOB column from a specific row, from a table, using parameter markers for the update and predicate values
4	T20402JD.java	Update a LOB column from a specific row, from a table, without using parameter markers for the update and predicate values
4	T20403JD.java	Update a LOB column from a specific row, from a table, using parameter markers for the update and predicate values
4	T20404JD.java	Update a LOB column from a specific row, from a table, using the set methods for the update and predicate values
5	T20500JD.java	Delete a specific row, from a table, without using parameter markers for predicate values
5	T20501JD.java	Delete a specific row, from a table, using parameter markers for the predicate values
6	T20600JD.java	Create (if allowed) and execute a stored procedure and obtain its results (no LOB parameters)
6	T20601JD.java	Create (if allowed) and execute a stored procedure and obtain its results (LOB parameters)
6	T20602JD.java	Create (if allowed) and execute an external stored procedure and obtain its results
6	T20603JD.java	Install (if allowed) a jar file for sample Java Stored Procedures
6	T20604JD.java	Create (if allowed) and execute a Java Stored Procedure (no LOB parameters)
6	T20605JD.java	Create (if allowed) and execute a Java Stored Procedure (with a LOB parameter)
6	T20606JD.java	Create (if allowed) and execute a SQL stored procedure and retrieve its dynamic result set
6	T20607JD.java	Create (if allowed) and execute a Java stored procedure and retrieve its dynamic result set
6	T20608JD.java	Create (if allowed) and execute a Java stored procedure and retrieve its multiple dynamic result sets
7	T20700JD.java	Execute a multi-statement request that contains only non-SELECT statements, and obtain the results
7	T20701JD.java	Execute a multi-statement request that contains only SELECT statements, and obtain the results
7	T20702JD.java	Execute a multi-statement request that contains both SELECT and non-SELECT statements, and obtain the results
7	T20703JD.java	Execute a multi-statement INSERT request and display the generated keys
7	T20704JD.java	Execute a multi-statement batch INSERT request and display the generated keys
7	T20705JD.java	Execute a multi-statement request and make all results available simultaneously
8	T20800JD.java	Execute a macro that contains only non-SELECT statements, and obtain the results
8	T20801JD.java	Execute a macro that contains only SELECT statements, and obtain the results.
8	T20802JD.java	Execute a macro that contains both SELECT and non-SELECT statements, and obtain the results.
9	T20900JD.java	Obtain meta data about the client access product
9	T20901JD.java	Obtain a list of reserved words
9	T20902JD.java	Obtain a list of all supported SQL data types
9	T20903JD.java	Obtain a list of all table types
9	T20904JD.java	Obtain table index meta data
9	T20905JD.java	Obtain the names of all databases
9	T20906JD.java	Obtain the names of all tables in all databases
9	T20907JD.java	Obtain the names of all columns in all tables in all databases
9	T20908JD.java	Obtain the names of all procedures in all databases
9	T20909JD.java	Obtain the names of all procedure columns in all databases
9	T20910JD.java	Obtain a list of primary key columns for a specific table
9	T20911JD.java	Obtain an optimal set of columns that uniquely identifies a row for a specific table
9	T20912JD.java	Obtain a list of the user-defined types (UDTs) defined in a particular schema
9	T20913JD.java	Obtain a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog
9	T20914JD.java	Demonstrate use of SET SESSION RATE and MONITOR SESSION.
10	T21000JD.java	Search for a specific table type
10	T21001JD.java	Search for specific databases by name
10	T21002JD.java	Search for specific databases by wildcard characters
10	T21003JD.java	Search for specific tables by name (a table here can actually any object that Teradata thinks of as in the "TVM" category, such as stored procedures and UDFs)
10	T21004JD.java	Search for specific tables by wildcard characters
10	T21005JD.java	Search for specific columns by name
10	T21006JD.java	Search for specific columns by wildcard characters
10	T21007JD.java	Search for specific procedures by name
10	T21008JD.java	Search for specific procedures by name by wildcard characters
10	T21009JD.java	Search for specific procedure columns by name
10	T21010JD.java	Search for specific procedure columns by wildcard characters
11	T21100JD.java	Getting and setting connection options
11	T21101JD.java	Getting and setting statement options
11	T21102JD.java	Use transaction isolation level TRANSACTION_READ_UNCOMMITTED
11	T21104JD.java	Use URL/DataSource Parameter NEW_PASSWORD to automatically handle Database Password expiration
11	T21105JD.java	Use URL/DataSource Parameter USEXVIEWS
12	T21200JD.java	Create and use JdbcRowSetImpl, given a connection URL, user, and password
12	T21201JD.java	Create and use JdbcRowSetImpl, given an existing connection
12	T21202JD.java	Create and use JdbcRowSetImpl, given an existing result set
13	T21300JD.java	Programmatically create a DataSource (see note below)
13	T21301JD.java	Programmatically create a ConnectionPoolDataSource (see note below)
13	T21302JD.java	Obtain a connection from a DataSource (see note below)
14	T21400JD.java	Create and execute a User-Defined Function (UDF)
14	T21401JD.java	Install a jar file for sample Java User Defined Function (JUDF)
14	T21402JD.java	Create and execute a Java User Defined Function (JUDF)
15	T21500JD.java	Perform Teradata-specific data type conversions
16	T21600JD.java	Use JDBC Escape Syntax
18	T21800JD.java	Use JDBC Updatable Result Set from a non-prepared Statement
18	T21801JD.java	Use JDBC Updatable Result Set from a PreparedStatement
18	T21802JD.java	Use JDBC Updatable Result Set from a CallableStatement
19	T21900JD.java	Use SET QUERY_BAND statement
19	T21901JD.java	Use SET QUERY_BAND statement with PROXYUSER
99	T29900JD.java	Clean up the example environment (user, database, tables, indexes)

A sample application to test a connection is also provided, sample1.java.

Use the following procedure to run the Teradata JDBC Driver Learning Examples:

Download a supported JDK to your development platform.
Download and copy samples.jar, terajdbc4.jar, and tdgssconfig.jar to your development platform. Note: tdgssjava.jar is also required for TTU 8.2/Teradata JDBC Driver 3.4 or earlier releases. The commands below assume that all the files are copied to the same directory on your development platform.
Go to the directory where samples.jar is located and unjar the sample applications:
jar xvf samples.jar
Modify the sample application sample1.java with your Teradata Database information.
You need to change the following:
- Name of the Teradata Database.
- Userid and password for the Teradata Database.
Compile the modified sample application by entering the following:
javac sample1.java
Run the application on Windows by entering the following:
java -classpath .;terajdbc4.jar;tdgssconfig.jar sample1
Or run the application on UNIX by entering the following:
java -classpath .:terajdbc4.jar:tdgssconfig.jar sample1
With TTU 8.2/Teradata JDBC Driver 3.4 or earlier releases, run the application on Windows by entering the following:
java -classpath .;terajdbc4.jar;tdgssjava.jar;tdgssconfig.jar sample1
With TTU 8.2/Teradata JDBC Driver 3.4 or earlier releases, run the application on UNIX by entering the following:
java -classpath .:terajdbc4.jar:tdgssjava.jar:tdgssconfig.jar sample1

Note: The "." entry, representing the current directory, on the classpath in the commands above is what enables Java to locate the sample1.class file.

Repeat steps 4, 5, and 6 for each of the other Learning Example programs.

Note: The Java Stored Procedure samples in Module 6 must be compiled and placed into the SampleJXSP.jar file before they can be installed on the Teradata Database. The steps listed below assume that you have already unjarred the contents of samples.jar

Compile the Java Stored Procedure samples by entering the following:
javac -d . BookInfo.java DeptJobInfo.java EmpInfo.java
Jar the Java Stored Procedure samples by entering the following:
jar cvf SampleJXSP.jar com/teradata/sample/BookInfo.class com/teradata/sample/DeptJobInfo.class com/teradata/sample/EmpInfo.class
Modify the sample application T20603JD.java with your Teradata Database information.
You need to change the following:
- Name of the Teradata Database.
- Userid and password for the Teradata Database.
Compile the modified sample application by entering the following:
javac T20603JD.java
Run the application on Windows by entering the following:
java -classpath .;terajdbc4.jar;tdgssconfig.jar T20603JD
Or run the application on UNIX by entering the following:
java -classpath .:terajdbc4.jar:tdgssconfig.jar T20603JD
As shown above, tdgssjava.jar must also be listed on the classpath for TTU 8.2/Teradata JDBC Driver 3.4 or earlier releases.

Note:The Java User Defined Function sample in module 14 must be compiled and placed into the SampleJavaUDF.jar file before they are installed on the Teradata database. The steps listed below assume that you have already unjarred the contents of samples.jar

Compile the Java User Defined Function sample by entering the following:
javac -d . JavaUDFClass.java
Jar the Java User Defined Function sample by entering the following:
jar cvf SampleJavaUDF.jar com/teradata/sample/JavaUDFClass.class
Modify the sample application T21401JD.java with your Teradata Database information.
You need to change the following:
- Name of the Teradata Database.
- Userid and password for the Teradata Database.
Compile the modified sample application by entering the following:
javac T21401JD.java
Run the application on Windows by entering the following:
java -classpath .;terajdbc4.jar;tdgssconfig.jar T21401JD
Or run the application on UNIX by entering the following:
java -classpath .:terajdbc4.jar:tdgssconfig.jar T21401JD
As shown above, tdgssjava.jar must also be listed on the classpath for TTU 8.2/Teradata JDBC Driver 3.4 or earlier releases.

Note: The Module 13 DataSource Learning Examples require the com.sun.jndi.fscontext.RefFSContextFactory class, which is included in the fscontext.jar file of the J2EE SDK. In order to run the Module 13 DataSource Learning Examples, you need to download and install the J2EE SDK from Sun and include fscontext.jar and providerutil.jar on your classpath.

Download Files

samples.jar ( 269.84 KB )

Questions or Feedback

Related Resources

Teradata Developer Exchange

Teradata Discussion Forums

White Papers

Teradata Support Services

Teradata User Groups

Find more downloads (including early access and unsupported releases) on Teradata Developer Exchange.

Company Newsroom Site Help Site Map Privacy/Legal Contact Us