Java tutorial
/* * This file is part of AceQL. * AceQL: Remote JDBC access over HTTP. * Copyright (C) 2015, KawanSoft SAS * (http://www.kawansoft.com). All rights reserved. * * AceQL is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * AceQL 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 Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA * 02110-1301 USA * * Any modifications to this file must keep this entire header * intact. */ package org.kawanfw.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.kawanfw.commons.util.Tag; import org.kawanfw.sql.jdbc.ConnectionHttp; import org.kawanfw.sql.json.no_obfuscation.CallableStatementHolder; import org.kawanfw.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.PRODUCT_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.PRODUCT_PRODUCT_FAIL + "Internal File does not exists: " + file; throw new SQLException(message, new IOException(message)); } catch (IOException e) { String message = Tag.PRODUCT_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.PRODUCT_PRODUCT_FAIL + "Internal File is empty: " + file; throw new SQLException(message, new IOException(message)); } line = JsonLineDecryptor.decrypt(line, connectionHttp); return CallableStatementHolderTransportJson.fromJson(line); } }