package javaapplication;
import java.sql.*;

public class Main {

    private static int requestCount =  150 ;
    private static int connectCount =  10 ;
    private static String sql = null;

    public static void main(String[] args) {
        System.out.print("Starting: " + sql);
        sql = args[ 0 ] + args[ 1 ];

        for (int i =  0 ; i < connectCount; i++){
            TestDB2();
            //TestFireBird();
        }
        System.out.println("Done");
    }

    private static void TestFireBird(){
        try{
            Class.forName("org.firebirdsql.jdbc.FBDriver");//.newInstance();
        }
        catch(Exception e) {System.err.println("Error" + e.getMessage());}
        try
        {
            Connection Conn = DriverManager.getConnection(
                "jdbc:firebirdsql:localhost/3050:c:/dbs/testfbdb.fdb",
            "lodin", "passw");

            //System.out.println("Connection is opened: " + !Conn.isClosed());

            DoSQLCode(Conn, sql);
            //System.out.println ("Closing connection...");
            Conn.close();
        }
        catch(Exception e){
            System.err.println("Error" + e.getMessage());
            return;
        }
       // System.out.println("OK");
    }

    private static void TestDB2(){
        try{
            Class.forName("com.ibm.db2.jcc.DB2Driver");//.newInstance();
        }
        catch(Exception e) {System.out.println("Error" + e.getMessage());}
        //System.out.println("Done!");
        try
        {
            Connection Conn = DriverManager.getConnection(
                "jdbc:db2:testdb",
            "admin", "passw");

            //System.out.println("Connection is opened: " + !Conn.isClosed());

            DoSQLCode(Conn, sql);

            //System.out.println ("Closing connection...");
            Conn.close();
        }
        catch(Exception e){
            System.err.println("Error" + e.getMessage());
            return;
        }
        //System.out.println("OK");
    }

    private static void DoSQLCode(Connection Conn, String query){
        for (int k =  0 ; k < requestCount; k++)
        {
            try
            {
                Statement stmt = Conn.createStatement();
                //System.out.println("Creating...");
                ResultSet rs = stmt.executeQuery(query);
                //System.out.println("Executing...");
                ResultSetMetaData rsmd = rs.getMetaData();
                String columns[] = new String[rsmd.getColumnCount()];
                while(rs.next()){
                    for (int i =  0 ; i < columns.length; i++){
                        columns[i] = rsmd.getColumnName(i+ 1 );
                        //System.out.print(columns[i] + " = " + rs.getString(columns[i]) + " ");
                    }
                    //System.out.println();
                }
                stmt.close();
            }
            catch (Exception e){System.out.println(e.toString());}
        }
    }
}

    private static int requestCount =  10 ;
    private static int connectCount =  10 ;

SELECT COUNT(*) FROM TableName WHERE ID NOT IN(
  SELECT ID FROM TableName WHERE (MOD(ID, 2 ) =  0 )
)