public void close() { if (conn != null) { DBUtils.closeQuietly(conn); } if (preparedStatement != null) { DBUtils.closeQuietly(preparedStatement); } } }
/** * Closes an <code>ResultSet</code> unconditionally. * <p> * Equivalent to {@link ResultSet#close()}, except any exceptions will be ignored. * This is typically used in finally blocks. * <p> * * @param output the ResultSet to close, may be null or already closed */ public static void closeQuietly(final ResultSet rs) { closeQuietly((AutoCloseable) rs); }
@Override public void close() throws IOException { DBUtils.closeQuietly(rs); DBUtils.closeQuietly(statement); DBUtils.closeQuietly(conn); }
/** * Closes an <code>Connection</code> unconditionally. * <p> * Equivalent to {@link Connection#close()}, except any exceptions will be ignored. * This is typically used in finally blocks. * <p> * * @param output the ResultSet to close, may be null or already closed */ public static void closeQuietly(final Connection conn) { closeQuietly((AutoCloseable) conn); }
/** * Closes an <code>Statement</code> unconditionally. * <p> * Equivalent to {@link Statement#close()}, except any exceptions will be ignored. * This is typically used in finally blocks. * <p> * * @param output the ResultSet to close, may be null or already closed */ public static void closeQuietly(final Statement stmt) { closeQuietly((AutoCloseable) stmt); }
public void close() { DBUtils.closeQuietly(stmt); DBUtils.closeQuietly(cnct); }
protected static void close(ResultSet resultSet, Statement stat, Connection conn) { OLAPContext.clearParameter(); DBUtils.closeQuietly(resultSet); DBUtils.closeQuietly(stat); DBUtils.closeQuietly(conn); }
public List<String> getHiveTableNames(String database) throws Exception { List<String> ret = Lists.newArrayList(); ResultSet tables = metaData.getTables(null, database, null, null); while (tables.next()) { ret.add(String.valueOf(tables.getObject(3))); } DBUtils.closeQuietly(tables); return ret; }
public List<String> getHiveDbNames() throws Exception { List<String> ret = Lists.newArrayList(); ResultSet schemas = metaData.getSchemas(); while (schemas.next()) { ret.add(String.valueOf(schemas.getObject(1))); } DBUtils.closeQuietly(schemas); return ret; }
@Override public long getHiveTableRows(String database, String tableName) throws Exception { ResultSet resultSet = null; long count = 0; try { String query = "select count(*) from "; resultSet = stmt.executeQuery(query.concat(database + "." + tableName)); if (resultSet.next()) { count = resultSet.getLong(1); } } finally { DBUtils.closeQuietly(resultSet); } return count; }
private void executeSql(SqlOperation operation) throws SQLException, IOException { Connection connection = null; try { connection = connectionManager.getConn(); // set a low translation level for best performance connection.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED); operation.execute(connection); queriedSqlNum++; } finally { DBUtils.closeQuietly(operation.rs); DBUtils.closeQuietly(operation.pstat); DBUtils.closeQuietly(connection); } }
private boolean checkTableExists(final String tableName, final Connection connection) throws SQLException { PreparedStatement ps = null; ResultSet rs = null; try { String checkTableExistsSql = sqls.getCheckTableExistsSql(tableName); ps = connection.prepareStatement(checkTableExistsSql); rs = ps.executeQuery(); while (rs.next()) { // use equalsIgnoreCase() as some RDBMS is case insensitive if (tableName.equalsIgnoreCase(rs.getString(1))) { return true; } } } finally { DBUtils.closeQuietly(rs); DBUtils.closeQuietly(ps); } return false; } });
@Override public void executeUpdate(String sql) throws Exception { Statement statement = null; Connection connection = manager.getConnection(); try { statement = connection.createStatement(); statement.execute(sql); } finally { DBUtils.closeQuietly(statement); manager.close(connection); } }
private ResultSet executeQuery() { String url = olapContext.olapSchema.getStarSchemaUrl(); String user = olapContext.olapSchema.getStarSchemaUser(); String pwd = olapContext.olapSchema.getStarSchemaPassword(); String sql = olapContext.sql.toString(); Statement stmt = null; try { conn = DriverManager.getConnection(url, user, pwd); stmt = conn.createStatement(); return stmt.executeQuery(sql); } catch (SQLException e) { throw new IllegalStateException(url + " can't execute query " + sql, e); } finally { DBUtils.closeQuietly(stmt); DBUtils.closeQuietly(conn); } }
private void executeSQL(String sql) throws SQLException { Connection con = SqlUtil.getConnection(dbconf); logger.info("Executing sql : {}", sql); try { SqlUtil.execUpdateSQL(con, sql); } finally { DBUtils.closeQuietly(con); } }
DBUtils.closeQuietly(rs); DBUtils.closeQuietly(stmt); DBUtils.closeQuietly(conn);
public HiveTableMeta getHiveTableMeta(String database, String tableName) throws SQLException { ResultSet columns = metaData.getColumns(null, database, tableName, null); HiveTableMetaBuilder builder = new HiveTableMetaBuilder(); builder.setTableName(tableName); List<HiveTableMeta.HiveTableColumnMeta> allColumns = Lists.newArrayList(); while (columns.next()) { String columnName = columns.getString(4); String dataType = columns.getString(6); String comment = columns.getString(12); dataType = considerDataTypePrecision(dataType, columns.getString(7), columns.getString(9)); allColumns.add(new HiveTableMeta.HiveTableColumnMeta(columnName, dataType, comment)); } builder.setAllColumns(allColumns); DBUtils.closeQuietly(columns); String exe = "use "; stmt.execute(exe.concat(database)); String des = "describe formatted "; ResultSet resultSet = stmt.executeQuery(des.concat(tableName)); extractHiveTableMeta(resultSet, builder); DBUtils.closeQuietly(resultSet); return builder.createHiveTableMeta(); }
@Override public void executeQuery(String query, List<List<String>> results, List<SelectedColumnMeta> columnMetas) throws Exception { Statement statement = null; Connection connection = manager.getConnection(); ResultSet resultSet = null; //extract column metadata ResultSetMetaData metaData = null; int columnCount = 0; try { statement = connection.createStatement(); resultSet = statement.executeQuery(query); extractResults(resultSet, results); metaData = resultSet.getMetaData(); columnCount = metaData.getColumnCount(); // fill in selected column meta for (int i = 1; i <= columnCount; ++i) { SelectedColumnMeta columnMeta = extractColumnMeta(metaData, i); columnMetas.add(columnMeta); } } finally { DBUtils.closeQuietly(resultSet); DBUtils.closeQuietly(statement); manager.close(connection); } }
throw new RuntimeException("Cannot evaluate metadata of query: " + query, e); } finally { DBUtils.closeQuietly(con); DBUtils.closeQuietly(rs); try { logger.debug("Cleaning up temp view.");
@Override public void executeQuery(String sql, List<List<String>> results, List<SelectedColumnMeta> columnMetas) { //extract column metadata ResultSet rs = null; ResultSetMetaData metaData; int columnCount; try (Connection conn = dataSource.getConnection(); Statement state = conn.createStatement()) { rs = state.executeQuery(sql); extractResults(rs, results); metaData = rs.getMetaData(); columnCount = metaData.getColumnCount(); // fill in selected column meta for (int i = 1; i <= columnCount; ++i) { int kylinTypeId = dataSource.toKylinTypeId(metaData.getColumnTypeName(i), metaData.getColumnType(i)); String kylinTypeName = dataSource.toKylinTypeName(kylinTypeId); columnMetas.add(new SelectedColumnMeta(metaData.isAutoIncrement(i), metaData.isCaseSensitive(i), false, metaData.isCurrency(i), metaData.isNullable(i), false, metaData.getColumnDisplaySize(i), metaData.getColumnLabel(i), metaData.getColumnName(i), null, null, null, metaData.getPrecision(i), metaData.getScale(i), kylinTypeId, kylinTypeName, metaData.isReadOnly(i), false, false)); } } catch (Exception e) { throw new RuntimeException("executeQuery failed", e); } finally { DBUtils.closeQuietly(rs); } }