appserver/tests/appserv-tests/devtests/connector/v3/datasource-definition/client/Client.java

/*
 * Copyright (c) 2002, 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.ejb.ejb30.hello.session3;

import java.net.*;
import java.io.*;
import javax.naming.*;
import javax.sql.*;
import java.sql.*;

import com.sun.ejte.ccl.reporter.SimpleReporterAdapter;


import jakarta.annotation.sql.*;


@DataSourceDefinitions(
        value = {


               @DataSourceDefinition(name = "java:global/env/Appclient_DataSource",
                        className = "org.apache.derby.jdbc.ClientXADataSource",
                        portNumber = 1527,
                        serverName = "localhost",
                        user = "APP",
                        password = "APP",
                        databaseName = "hello-client-annotation-global",
                        properties = {"connectionAttributes=;create=true"},
                        isolationLevel = 8
                ),


                @DataSourceDefinition(name = "java:comp/env/Appclient_DataSource",
                        minPoolSize = 0,
                        initialPoolSize = 0,
                        className = "org.apache.derby.jdbc.ClientXADataSource",
                        portNumber = 1527,
                        serverName = "localhost",
                        user = "APP",
                        password = "APP",
                        databaseName = "hello-client-annotation-comp",
                        properties = {"connectionAttributes=;create=true"},
                        isolationLevel = -1
                ),
                //test case to ensure that isolationLevel specified as integer in annotation
                //is converted to DD equivalent string.
                //The only way to confirm the fix for IT 9292 is that appclient console
                //should not have "invalidDescriptorFailureException" printed
                @DataSourceDefinition(name = "java:comp/env/Appclient_DataSource1",
                        minPoolSize = 0,
                        initialPoolSize = 0,
                        className = "org.apache.derby.jdbc.ClientXADataSource",
                        portNumber = 1527,
                        serverName = "localhost",
                        user = "APP",
                        password = "APP",
                        databaseName = "hello-client-annotation-comp",
                        properties = {"connectionAttributes=;create=true"},
                        isolationLevel = 4
                ),
                //test case to ensure that isolationLevel specified as integer in annotation
                //is converted to DD equivalent string.
                //The only way to confirm the fix for IT 9292 is that appclient console
                //should not have "invalidDescriptorFailureException" printed
                //no isolation level specified
		@DataSourceDefinition(name = "java:comp/env/Appclient_DataSource2",
                        minPoolSize = 0,
                        initialPoolSize = 0,
                        className = "org.apache.derby.jdbc.ClientXADataSource",
                        portNumber = 1527,
                        serverName = "localhost",
                        user = "APP",
                        password = "APP",
                        databaseName = "hello-client-annotation-comp",
                        properties = {"connectionAttributes=;create=true"}
                )
        }
)

public class Client {

    private String host;
    private String port;

    private static SimpleReporterAdapter stat =
            new SimpleReporterAdapter("appserv-tests");


    public Client(String[] args) {
        host = (args.length > 0) ? args[0] : "localhost";
        port = (args.length > 1) ? args[1] : "4848";
    }

    public static void main(String[] args) {
        stat.addDescription("datasource-definitionclient");
        Client client = new Client(args);
        client.doTest();
        stat.printSummary("datasource-definitionID");
    }

    public void doTest() {

        String env = null;
        try {

/*
            InitialContext ic = new InitialContext();
            boolean global = lookupDataSource("java:global/env/Appclient_DataSource");
            boolean comp = lookupDataSource("java:comp/env/Appclient_DataSource");
            if (global && comp) {
                System.out.println("4444 appclient Success");
                System.out.println("AppClient successful injection of EMF references!");
            } else {
                System.out.println("4444 appclient failure");
                throw new RuntimeException("Appclient failure");
            }
*/



            boolean compds = lookupDataSource("java:comp/env/compds",true);
            boolean defaultds = lookupDataSource("java:comp/env/defaultds",true);
            boolean moduleds = lookupDataSource("java:module/env/moduleds", true);
            boolean appds = lookupDataSource("java:app/env/appclient/appds",true);
            boolean globalds = lookupDataSource("java:global/env/ts/datasource/appclient/globalds",true);

            boolean comp = lookupDataSource("java:comp/env/Appclient_DataSource",true);
            boolean comp_dd = lookupDataSource("java:comp/env/Appclient_DD_DataSource",true);
            boolean globalAppclient = lookupDataSource("java:global/env/Appclient_DataSource", true);

            boolean globalServlet_DataSource = lookupDataSource("java:global/env/Servlet_DataSource", true);
            boolean compServlet_DataSource = lookupDataSource("java:comp/env/Servlet_DataSource", false);

            boolean globalHelloSfulEJB = lookupDataSource("java:global/env/HelloStatefulEJB_DataSource", true);
            boolean compHelloSfulEJB = lookupDataSource("java:comp/env/HelloStatefulEJB_DataSource", false);
            boolean appHelloStatefulEjb = lookupDataSource("java:app/env/HelloStatefulEJB_DataSource", true);

            boolean globalHelloEJB = lookupDataSource("java:global/env/HelloEJB_DataSource", true);
            boolean compHelloEJB = lookupDataSource("java:comp/env/HelloEJB_DataSource", false);

            boolean globalServlet_DD_DataSource = lookupDataSource("java:global/env/Servlet_DD_DataSource", true);
            boolean compServlet_DD_DataSource = lookupDataSource("java:comp/env/Servlet_DD_DataSource", false);

            boolean globalHelloStateful_DD_DataSource = lookupDataSource("java:global/env/HelloStatefulEJB_DD_DataSource", true);
            boolean compHelloStateful_DD_DataSource = lookupDataSource("java:comp/env/HelloStatefulEJB_DD_DataSource", false);

            boolean globalHello_DD_DataSource = lookupDataSource("java:global/env/HelloEJB_DD_DataSource", true);
            boolean compHello_DD_DataSource = lookupDataSource("java:comp/env/HelloEJB_DD_DataSource", false);



            if (compds && defaultds && moduleds && appds && globalds && comp && comp_dd &&  globalAppclient && globalServlet_DataSource && !compServlet_DataSource && globalHelloSfulEJB &&
                    globalServlet_DD_DataSource && !compServlet_DD_DataSource
                    && !compHelloSfulEJB && globalHelloEJB
                    && !compHelloEJB && globalHelloStateful_DD_DataSource
                    && !compHelloStateful_DD_DataSource && globalHello_DD_DataSource
                    && !compHello_DD_DataSource && appHelloStatefulEjb)
            {
                System.out.println("AppClient successful lookup of datasource definitions !");
                stat.addStatus("DataSource-Definition-appclient-test", stat.PASS);
            } else {
                System.out.println("AppClient lookup not successful" );
                stat.addStatus("DataSource-Definition-appclient-test", stat.FAIL);
                throw new RuntimeException("Appclient failure during lookup of datasource definitions");
            }

            String url = "http://" + host + ":" + port +
                    "/datasource-definition/servlet";
            System.out.println("invoking DataSource-Definition test servlet at " + url);
            int code = invokeServlet(url);


            if (code != 200) {
                System.out.println("Incorrect return code: " + code);
                stat.addStatus("DataSource-Definition-web-ejb-test", stat.FAIL);
            } else {
                stat.addStatus("DataSource-Definition-web-ejb-test", stat.PASS);
            }
        } catch (Exception ex) {
            System.out.println("DataSource-Definition web & ejb test failed.");
            stat.addStatus("DataSource-Definition-web-ejb-test", stat.FAIL);
            ex.printStackTrace();
        }

        return;

    }

    private boolean lookupDataSource(String dataSourceName, boolean expectSuccess) {
        Connection c = null;
        try {
            InitialContext ic = new InitialContext();
            DataSource ds = (DataSource) ic.lookup(dataSourceName);
            c = ds.getConnection();
            System.out.println("got connection : " + c);
            return true;
        } catch (Exception e) {
            if(expectSuccess){
            	e.printStackTrace();
            }
            return false;
        } finally {
            try {
                if (c != null) {
                    c.close();
                }
            } catch (Exception e) {
            }
        }
    }

    private int invokeServlet(String url) throws Exception {

        URL u = new URL(url);

        HttpURLConnection c1 = (HttpURLConnection) u.openConnection();
        int code = c1.getResponseCode();
        InputStream is = c1.getInputStream();
        BufferedReader input = new BufferedReader(new InputStreamReader(is));
        String line = null;
        while ((line = input.readLine()) != null)
            System.out.println(line);
        if (code != 200) {
            System.out.println("Incorrect return code: " + code);
        }
        return code;
    }

}