Use Java For Data Integration

public class SimpleQuery
{
    public static void main(String[] args)
    {
        Statement stmnt = null;
        ResultSet rset = null;
        try
        {
            Class driverClass =
                Class.forName("com.twoewe.cloudjdbc.TwoEweSaaSDriver");
            DriverManager.registerDriver((Driver) driverClass.newInstance());
            Properties jdbcProperties = new Properties();
            jdbcProperties.put("user", args[1]);
            jdbcProperties.put("password", args[2]);
            Connection l_conn = DriverManager.getConnection(
                              "jdbc:twoewes:saas:@" + args[0] + ":443"
                            , jdbcProperties);
            l_conn.setAutoCommit(false);

            PreparedStatement pstmnt = l_conn.prepareStatement(
                "SELECT A.PERSON_ID, B.NAME_TYPE, B.FIRST_NAME, B.LAST_NAME " +
                "  FROM PER_ALL_PEOPLE_F A, PER_PERSON_NAMES_F B " +
                " WHERE A.PERSON_ID=B.PERSON_ID and rownum<10");
            rset = pstmnt.executeQuery();
            cloudDriverTest2.print(rset);
            l_conn.close();
        }
        catch (Exception e)
        {
            System.err.println(e.getMessage());
            e.printStackTrace();
        }
    }
}
                    

PERSON_ID          NAME_TYPE          FIRST_NAME           LAST_NAME
------------------ ------------------ -------------------- ------------------
300000047606111    US                 Alan                 Cook
300000047606111    GLOBAL             Alan                 Cook
300000047606111    GLOBAL             Alan                 Cook
300000047606111    US                 Alan                 Cook
300000047606111    GLOBAL             Alan                 Cook
300000047606111    US                 Alan                 Cook
300000047606111    GLOBAL             Alan                 Cook
300000047606111    US                 Alan                 Cook
300000047626100    US                 Mandy                Steward

Process finished with exit code 0