package db;

 

 

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

 

public class jdbcTeradataConnectionTestCertificate {

 

 

 

    public static void main(String[] args) throws Exception 
    {

try 
{

String serverURL = "jdbc:teradata://172.28.130.20/LOGMECH=LDAP"; // Worked on my laptop, but not main main pc
Class.forName("com.teradata.jdbc.TeraDriver");
String username = "!NEDVFCollections";
String password = "xxxxx";

Connection con = DriverManager.getConnection(serverURL, username, password);

String query="select top 2* from NED_COLL_TABLES.T_PM_PREPAY_FIN WHERE SYS = 8773";
		
		PreparedStatement stmt=con.prepareStatement(query);
		ResultSet rs=stmt.executeQuery();
		while(rs.next()) 
		{
			String col1=rs.getString(1);
			System.out.println("col1="+col1);
		}

}

 

 

catch (Exception e) 
{
e.printStackTrace();
}

 

 

}