| Refresh | Home EGTry.com

a hello world example to connect teradata through jdbc


jar needed

tdgssconfig.jar
terajdbc4.jar


java sample code

package db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class HelloTeradataJDBC {


	public static void main(String[] args) throws Exception {
		String connurl="jdbc:teradata://tdwprod.egtry.com";

		Class.forName("com.teradata.jdbc.TeraDriver");
		Connection conn=DriverManager.getConnection(connurl, "javauser1", "password1");
		String query="select * from aed_views.View1";
		
		PreparedStatement stmt=conn.prepareStatement(query);
		ResultSet rs=stmt.executeQuery();
		while(rs.next()) {
			String col1=rs.getString(1);
			System.out.println("col1="+col1);
		}

	}

}