public static ResultSet executeAgainstSchema(final Query query, final Statement statement, final InclusionRule schemaInclusionRule) throws SQLException { requireNonNull(query, "No query provided"); final String sql = getQuery(query, schemaInclusionRule); LOGGER.log(Level.FINE, new StringFormat("Executing %s: %n%s", query.getName(), sql)); return executeSql(statement, sql); }
public static ResultSet executeAgainstSchema(final Query query, final Statement statement, final InclusionRule schemaInclusionRule) throws SQLException { requireNonNull(query, "No query provided"); final String sql = getQuery(query, schemaInclusionRule); LOGGER.log(Level.FINE, new StringFormat("Executing %s: %n%s", query.getName(), sql)); return executeSql(statement, sql); }
public static ResultSet executeAgainstTable(final Query query, final Statement statement, final Table table, final boolean isAlphabeticalSortForTableColumns, final Identifiers identifiers) throws SQLException { requireNonNull(query, "No query provided"); requireNonNull(identifiers, "No identifiers provided"); final String sql = getQuery(query, table, isAlphabeticalSortForTableColumns, identifiers); LOGGER.log(Level.FINE, new StringFormat("Executing %s: %n%s", query.getName(), sql)); return executeSql(statement, sql); }
public static ResultSet executeAgainstTable(final Query query, final Statement statement, final Table table, final boolean isAlphabeticalSortForTableColumns, final Identifiers identifiers) throws SQLException { requireNonNull(query, "No query provided"); requireNonNull(identifiers, "No identifiers provided"); final String sql = getQuery(query, table, isAlphabeticalSortForTableColumns, identifiers); LOGGER.log(Level.FINE, new StringFormat("Executing %s: %n%s", query.getName(), sql)); return executeSql(statement, sql); }
final ResultSet resultSet = executeSql(statement, sql);)
final ResultSet resultSet = executeSql(statement, sql);)
public static void executeScriptFromResource(final Connection connection, final String scriptResource) { try (final Statement statement = createStatement(connection);) { final String sqlScript = readResourceFully(scriptResource); if (!isBlank(sqlScript)) { for (final String sql: sqlScript.split(";")) { if (isBlank(sql)) { continue; } final ResultSet resultSet = executeSql(statement, sql, false); if (resultSet != null) { LOGGER .log(Level.WARNING, new StringFormat("Ignoring results from query <%s>", sql)); resultSet.close(); } } } } catch (final SQLException e) { LOGGER.log(Level.WARNING, e.getMessage(), e); } }
public static void executeScriptFromResource(final Connection connection, final String scriptResource) { try (final Statement statement = createStatement(connection);) { final String sqlScript = readResourceFully(scriptResource); if (!isBlank(sqlScript)) { for (final String sql: sqlScript.split(";")) { if (isBlank(sql)) { continue; } final ResultSet resultSet = executeSql(statement, sql, false); if (resultSet != null) { LOGGER .log(Level.WARNING, new StringFormat("Ignoring results from query <%s>", sql)); resultSet.close(); } } } } catch (final SQLException e) { LOGGER.log(Level.WARNING, e.getMessage(), e); } }
public static ResultSet executeSql(final Statement statement, final String sql, final boolean throwSQLException) throws SQLException { if (statement == null) { return null; } if (isBlank(sql)) { LOGGER.log(Level.FINE, "No SQL provided", new RuntimeException("No SQL provided")); return null; } try { statement.clearWarnings(); final boolean hasResults = statement.execute(sql); logSQLWarnings(statement); if (hasResults) { return statement.getResultSet(); } else { final int updateCount = statement.getUpdateCount();
public static ResultSet executeSql(final Statement statement, final String sql, final boolean throwSQLException) throws SQLException { if (statement == null) { return null; } if (isBlank(sql)) { LOGGER.log(Level.FINE, "No SQL provided", new RuntimeException("No SQL provided")); return null; } try { statement.clearWarnings(); final boolean hasResults = statement.execute(sql); logSQLWarnings(statement); if (hasResults) { return statement.getResultSet(); } else { final int updateCount = statement.getUpdateCount();
public static void executeScriptFromResource(final String scriptResource, final Connection connection) throws SchemaCrawlerException { try (final Statement statement = createStatement(connection);) { final String sqlScript = readResourceFully(scriptResource); if (!isBlank(sqlScript)) { for (final String sql: sqlScript.split(";")) { final ResultSet resultSet = executeSql(statement, sql); if (resultSet != null) { LOGGER.log(Level.WARNING, "Ignoring results from query: " + sql); resultSet.close(); } } } } catch (final SQLException e) { System.err.println(e.getMessage()); LOGGER.log(Level.WARNING, e.getMessage(), e); } }
try (final ResultSet results = executeSql(statement, sql, true);)
public static ResultSet executeAgainstSchema(final Query query, final Statement statement, final InclusionRule schemaInclusionRule) throws SQLException { requireNonNull(query, "No query provided"); final String sql = getQuery(query, schemaInclusionRule); LOGGER.log(Level.FINE, new StringFormat("Executing %s: %n%s", query.getName(), sql)); return executeSql(statement, sql); }
public static ResultSet executeAgainstTable(final Query query, final Statement statement, final Table table, final boolean isAlphabeticalSortForTableColumns, final Identifiers identifiers) throws SQLException { requireNonNull(query, "No query provided"); requireNonNull(identifiers, "No identifiers provided"); final String sql = getQuery(query, table, isAlphabeticalSortForTableColumns, identifiers); LOGGER.log(Level.FINE, new StringFormat("Executing %s: %n%s", query.getName(), sql)); return executeSql(statement, sql); }
public static ResultSet executeAgainstSchema(final Query query, final Statement statement, final InclusionRule schemaInclusionRule) throws SQLException { requireNonNull(query, "No query provided"); final String sql = getQuery(query, schemaInclusionRule); LOGGER.log(Level.FINE, new StringFormat("Executing %s: %n%s", query.getName(), sql)); return executeSql(statement, sql); }
public static ResultSet executeAgainstTable(final Query query, final Statement statement, final Table table, final boolean isAlphabeticalSortForTableColumns, final Identifiers identifiers) throws SQLException { requireNonNull(query, "No query provided"); requireNonNull(identifiers, "No identifiers provided"); final String sql = getQuery(query, table, isAlphabeticalSortForTableColumns, identifiers); LOGGER.log(Level.FINE, new StringFormat("Executing %s: %n%s", query.getName(), sql)); return executeSql(statement, sql); }
final ResultSet resultSet = executeSql(statement, sql);)
public static void executeScriptFromResource(final Connection connection, final String scriptResource) { try (final Statement statement = createStatement(connection);) { final String sqlScript = readResourceFully(scriptResource); if (!isBlank(sqlScript)) { for (final String sql: sqlScript.split(";")) { if (isBlank(sql)) { continue; } final ResultSet resultSet = executeSql(statement, sql, false); if (resultSet != null) { LOGGER .log(Level.WARNING, new StringFormat("Ignoring results from query <%s>", sql)); resultSet.close(); } } } } catch (final SQLException e) { LOGGER.log(Level.WARNING, e.getMessage(), e); } }
public static void executeScriptFromResource(final Connection connection, final String scriptResource) { try (final Statement statement = createStatement(connection);) { final String sqlScript = readResourceFully(scriptResource); if (!isBlank(sqlScript)) { for (final String sql: sqlScript.split(";")) { if (isBlank(sql)) { continue; } final ResultSet resultSet = executeSql(statement, sql, false); if (resultSet != null) { LOGGER .log(Level.WARNING, new StringFormat("Ignoring results from query <%s>", sql)); resultSet.close(); } } } } catch (final SQLException e) { LOGGER.log(Level.WARNING, e.getMessage(), e); } }
final MetadataResultSet results = new MetadataResultSet(executeSql(statement, schemataSql));)