package com.wmc.demo.teiid;

import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import org.postgresql.Driver;
import org.postgresql.PGProperty;
import org.postgresql.ds.PGSimpleDataSource;

public class TeiidDemoClient {

	public static void main(String[] args) throws Exception {
		//----------------------------------------------------------
		// Connect to the Teiid server over the network,
		// using an ordinary Postgres JDBC driver.
		// Note that there is ZERO code that is aware of Teiid
		//----------------------------------------------------------
		System.out.println("Starting test");
		PGSimpleDataSource pgds = new PGSimpleDataSource();
		DriverManager.setLogWriter(new PrintWriter(System.out, true));
		Driver.setLogLevel(Driver.DEBUG);
		pgds.setUser(args[0]);
		pgds.setServerName(args[1]);
		pgds.setDatabaseName("test");
		pgds.setProperty(PGProperty.GSS_LIB, "GSSAPI");
		// Would typically be postgres, but my developer SPN is for http
		pgds.setProperty(PGProperty.KERBEROS_SERVER_NAME, "http");
		pgds.setLogLevel(Driver.DEBUG);
		Connection conn = pgds.getConnection();
		Statement st = conn.createStatement();
		ResultSet rs = st.executeQuery("SELECT NUM, ADDR FROM LOCATION");
		while (rs.next()) {
			System.out.println(rs.getString(1) + " " + rs.getString(2));
		}
		st.close();
		conn.close();
		System.out.println("Test complete, exiting");
	}
}