appserver/tests/appserv-tests/devtests/jdbc/sqltracemonitoring/client/SimpleBMPClient.java

/*
 * Copyright (c) 2017, 2018 Oracle and/or its affiliates. All rights reserved.
 *
 * This program and the accompanying materials are made available under the
 * terms of the Eclipse Public License v. 2.0, which is available at
 * http://www.eclipse.org/legal/epl-2.0.
 *
 * This Source Code may also be made available under the following Secondary
 * Licenses when the conditions for such availability set forth in the
 * Eclipse Public License v. 2.0 are satisfied: GNU General Public License,
 * version 2 with the GNU Classpath Exception, which is available at
 * https://www.gnu.org/software/classpath/license.html.
 *
 * SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0
 */

package com.sun.s1asdev.jdbc.statementwrapper.client;

import javax.naming.*;
import java.rmi.*;
import java.util.*;

import com.sun.s1asdev.jdbc.statementwrapper.ejb.SimpleBMPHome;
import com.sun.s1asdev.jdbc.statementwrapper.ejb.SimpleBMP;
import com.sun.ejte.ccl.reporter.SimpleReporterAdapter;
import javax.management.MBeanServerConnection;
import javax.management.ObjectName;
import javax.management.remote.JMXServiceURL;
import javax.management.remote.JMXConnector;
import javax.management.remote.JMXConnectorFactory;

public class SimpleBMPClient {

    public static SimpleReporterAdapter stat = new SimpleReporterAdapter();
    public static final Object lock = new Object();
    public static int NO_OF_THREADS = 5;
    public static final int JMX_PORT = 8686;
    public static final String HOST_NAME = "localhost";
    public long sumTotal = 0;
    public boolean successExecuting = true;

    public SimpleBMPClient(int option){
        if(option == 1) {
            execute();
        } else if(option == 2) {
            try {
                getMonitorablePropertyOfConnectionPool("ql-jdbc-pool", "frequsedsqlqueries");
            } catch(Exception ex) {
                ex.printStackTrace();
            }
        }
    }

    private void execute() {

        WorkerThread workers[] = new WorkerThread[NO_OF_THREADS];
        for(int i=0; i< workers.length;i++){
            int j = i+1;
            //System.out.println("Thread T" + j + " to be executed for " + j + " times");
            workers[i] = new WorkerThread(j, "customer_stmt_wrapper"+j);
        }

        for(int i=0; i<workers.length;i++){
            workers[i].start();
        }

        if(successExecuting) {
            stat.addStatus("SQL Trace monitoring Test1 ", stat.PASS);
        } else {
            stat.addStatus("SQL Trace monitoring Test1 ", stat.FAIL);
        }
        stat.printSummary();
    }

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

        stat.addDescription("SQL Tracing tests");
        if (args != null && args.length > 0) {
            String param = args[0];

            switch (Integer.parseInt(param)) {
                case 1: {//run the threads
                    new SimpleBMPClient(1);
                    break;
                }
                case 2: { //compare monitoring stats
                    new SimpleBMPClient(2);
                    break;
                }
            }
        }
    }

    class WorkerThread extends Thread{

        private int timesToExecuteQuery = 0;

        public WorkerThread(int noExecs, String name){
            super(name);
            timesToExecuteQuery = noExecs;
        }

        public void run() {
            try{
                InitialContext ic = new InitialContext();
                Object objRef = ic.lookup("java:comp/env/ejb/SimpleBMPHome");
                SimpleBMPHome simpleBMPHome = (SimpleBMPHome)
                javax.rmi.PortableRemoteObject.narrow(objRef, SimpleBMPHome.class);

                SimpleBMP simpleBMP = simpleBMPHome.create();
                String tableName = Thread.currentThread().getName();
                String tableValue = "iiop";
                for(int i=0; i<timesToExecuteQuery; i++) {
                    simpleBMP.preparedStatementTest1(tableName, tableValue);
                }
            }catch(Exception e){
                System.out.println("Thread : " + Thread.currentThread().getName() + "did not run ");
                e.printStackTrace();
                SimpleBMPClient.this.successExecuting = false;
            }
        }
    }

    public void getMonitorablePropertyOfConnectionPool(String poolName, String monitoringStat) throws Exception {

        boolean passed = false;
        final String urlStr = "service:jmx:rmi:///jndi/rmi://" + HOST_NAME + ":" + JMX_PORT + "/jmxrmi";
        final JMXServiceURL url = new JMXServiceURL(urlStr);

        final JMXConnector jmxConn = JMXConnectorFactory.connect(url);
        final MBeanServerConnection connection = jmxConn.getMBeanServerConnection();

        ObjectName objectName =
                new ObjectName("amx:pp=/mon/server-mon[server],type=jdbcra-mon,name=resources/" + poolName);

        javax.management.openmbean.CompositeDataSupport returnValue =
                (javax.management.openmbean.CompositeDataSupport)
                connection.getAttribute(objectName, monitoringStat);

        String freqUsedQueries = (String) returnValue.get("current");
        String delimiter = "%%%EOL%%%";
        StringTokenizer st = new StringTokenizer(freqUsedQueries, delimiter);

        List<String> queryList = new LinkedList<String>();
        List<String> expectedQueryList = new LinkedList<String>();
        expectedQueryList.add("select * from customer_stmt_wrapper5 where c_phone= ?");
        expectedQueryList.add("select * from customer_stmt_wrapper4 where c_phone= ?");
        expectedQueryList.add("select * from customer_stmt_wrapper3 where c_phone= ?");

        while(st.hasMoreTokens()) {
            String query = st.nextToken().trim();
            if(!query.equals("")) {
                queryList.add(query);
            }
        }
        /*for(int k=0; k<queryList.size(); k++) {
            System.out.println(">>>>> query=" + queryList.get(k));
        }*/

        passed = expectedQueryList.equals(queryList);

        if(passed) {
            stat.addStatus("SQL Trace monitoring Test2 ", stat.PASS);
        } else {
            stat.addStatus("SQL Trace monitoring Test2 ", stat.FAIL);
        }
        stat.printSummary();
    }

}