import java.sql.*;
import java.util.Properties;

public class TeiidClient {

    public static void main(String[] args) {

        try {
            //step1 load the driver class  
            Class.forName("org.teiid.jdbc.TeiidDriver");

            Properties info = new Properties();

            info.setProperty("user",     "user");
            info.setProperty("password", "user");
            // info.setProperty("ResultSetCacheMode", "true");

            String url = "jdbc:teiid:Benchmark@mm://10.20.230.16:31000";

            //step2 create  the connection object  
            Connection connection = DriverManager.getConnection(url, info);

            //step3 create the statement object  
            Statement stmt = connection.createStatement();

            //step4 execute query  
            ResultSet rs = stmt.executeQuery(args[0]);

            ResultSetMetaData rsmd = rs.getMetaData();

            while (rs.next()) {
                int numberOfColumns = rsmd.getColumnCount();

                for (int i = 1 ; i < numberOfColumns ; i++) {
                    System.out.print(rs.getObject(i));
                    System.out.print(", ");
                }
                System.out.println(rs.getObject(numberOfColumns));
            }

            stmt.close();
  
            //step5 close the connection object  
            connection.close();
        
        } catch(Exception e) {
            System.out.println(e);
        }
    }  
}