org.kawanfw.sql.servlet.ServerQueryExecutorUtil Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of aceql-http Show documentation

AceQL HTTP is a framework of REST like http APIs that allow to access to remote SQL databases over http from any device that supports http. AceQL HTTP is provided with four client SDK: - The AceQL C# Client SDK allows to wrap the HTTP APIs using Microsoft SQL Server like calls in their code, just like they would for a local database. - The AceQL Java Client SDK allows to wrap the HTTP APIs using JDBC calls in their code, just like they would for a local database. - The AceQL Python Client SDK allows SQL calls to be encoded with standard unmodified DB-API 2.0 syntax

There is a newer version: 12.2

Show newest version

/*
 * Copyright (c)2022 KawanSoft S.A.S. All rights reserved.
 * 
 * Use of this software is governed by the Business Source License included
 * in the LICENSE.TXT file in the project's root directory.
 *
 * Change Date: 2026-11-01
 *
 * On the date above, in accordance with the Business Source License, use
 * of this software will be governed by version 2.0 of the Apache License.
 */
package org.kawanfw.sql.servlet;

import java.io.IOException;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Date;

import javax.servlet.http.HttpServletRequest;

import org.kawanfw.sql.servlet.sql.callable.aceqlproc.DefaultServerQueryExecutorWrapper;
import org.kawanfw.sql.util.FrameworkDebug;

/**
 * @author Nicolas de Pomereu
 *
 */
public class ServerQueryExecutorUtil {

    private static boolean DEBUG = FrameworkDebug.isSet(ServerQueryExecutorUtil.class);
    
    /**
     * Static class.
     */
    protected ServerQueryExecutorUtil() {

    }

    public static boolean isExecuteServerQuery(HttpServletRequest request, OutputStream out, String action,
	    Connection connection) throws SQLException, IOException {

	if (action.equals(HttpParameter.EXECUTE_SERVER_QUERY)) {
	    
//	    try {
//		ServerQueryExecutorWrapper serverQueryExecutorWrapper = ServerQueryExecutorWrapperCreator
//			.createInstance();
//		serverQueryExecutorWrapper.executeQuery(request, out, action, connection);
//	    } catch (SQLException exception) {
//		throw exception;
//	    }
//	    catch (Exception exception) {
//		throw new SQLException(exception);
//	    }
	    
	    DefaultServerQueryExecutorWrapper defaultServerQueryExecutorWrapper = new DefaultServerQueryExecutorWrapper();
	    try {
		defaultServerQueryExecutorWrapper.executeQuery(request, out, action, connection);
	    } catch (ClassNotFoundException e) {
		throw new SQLException(e);
	    }

	    return true;
	} else {
	    return false;
	}
    }

  
    public static void debug(String s) {
	if (DEBUG) {
	    System.out.println(new Date() + " " + s);
	}
    }

}