src-main.org.awakefw.sql.jdbc.util.CallableUtil Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of awake-sql Show documentation
Awake SQL is an open source framework that allows remote and secure JDBC access through HTTP.
The newest version!
/*
 * This file is part of Awake SQL. 
 * Awake SQL: Remote JDBC access over HTTP.                                    
 * Copyright (C) 2013,  KawanSoft SAS
 * (http://www.kawansoft.com). All rights reserved.                    
 *                                                                         
 * Awake SQL is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.         
 *              
 * Awake SQL is distributed in the hope that it will be useful,               
 * but WITHOUT ANY WARRANTY; without even the implied warranty of                
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU          
 * Lesser General Public License for more details.       
 *                                  
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, see .
 *
 * If you develop commercial activities using Awake SQL, you must: 
 * a) disclose and distribute all source code of your own product,
 * b) license your own product under the GNU General Public License.
 * 
 * You can be released from the requirements of the license by
 * purchasing a commercial license. Buying such a license will allow you 
 * to ship Awake SQL with your closed source products without disclosing 
 * the source code.
 *
 * For more information, please contact KawanSoft SAS at this
 * address: [email protected]
 * 
 * Any modifications to this file must keep this entire header
 * intact.
 */
package org.awakefw.sql.jdbc.util;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.io.LineNumberReader;
import java.sql.SQLException;

import org.apache.commons.io.IOUtils;
import org.awakefw.file.util.Tag;
import org.awakefw.sql.jdbc.ConnectionHttp;
import org.awakefw.sql.json.no_obfuscation.CallableStatementHolder;
import org.awakefw.sql.json.no_obfuscation.CallableStatementHolderTransportJson;

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

    /**
     * Protected
     */
    public CallableUtil() {
	
    }

    public static CallableStatementHolder fromRsFile(File file,
            ConnectionHttp connectionHttp) throws SQLException {
        if (!file.exists()) {
            String message = Tag.AWAKE_PRODUCT_FAIL
        	    + "Internal File does not exists: " + file;
            throw new SQLException(message, new IOException(message));
        }
    
        String line = null;
        LineNumberReader lineNumberReader = null;
    
        try {
            lineNumberReader = new LineNumberReader(new FileReader(file));
            line = lineNumberReader.readLine();
        } catch (FileNotFoundException e) {
            String message = Tag.AWAKE_PRODUCT_FAIL
        	    + "Internal File does not exists: " + file;
            throw new SQLException(message, new IOException(message));
        } catch (IOException e) {
            String message = Tag.AWAKE_PRODUCT_FAIL
        	    + "I/O Error when reading file: " + file;
            throw new SQLException(message, new IOException(message));
        } finally {
            IOUtils.closeQuietly(lineNumberReader);
        }
    
        if (line == null) {
            String message = Tag.AWAKE_PRODUCT_FAIL
        	    + "Internal File is empty: " + file;
            throw new SQLException(message, new IOException(message));
        }
    
        line = JsonLineDecryptor.decrypt(line, connectionHttp);
    
        return CallableStatementHolderTransportJson.fromJson(line);
    }

}