sf.util

Class DatabaseUtility

java.lang.Object

sf.util.DatabaseUtility

@UtilityMarker
public final class DatabaseUtility
extends Object

Utility methods.

Author:

Sualeh Fatehi

Method Summary

Modifier and Type	Method and Description
static void	checkConnection(Connection connection)
static Statement	createStatement(Connection connection)
static void	executeScriptFromResource(Connection connection, String scriptResource)
static ResultSet	executeSql(Statement statement, String sql)
static ResultSet	executeSql(Statement statement, String sql, boolean throwSQLException)
static long	executeSqlForLong(Connection connection, String sql)
static Object	executeSqlForScalar(Connection connection, String sql)
static void	logSQLWarnings(ResultSet resultSet)
static void	logSQLWarnings(Statement statement)
static List<String>	readResultsVector(ResultSet results) Reads a single column result set as a list.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

checkConnection

public static void checkConnection(Connection connection)
                            throws SchemaCrawlerException

Throws:

SchemaCrawlerException

createStatement

public static Statement createStatement(Connection connection)
                                 throws SchemaCrawlerException,
                                        SQLException

Throws:

SchemaCrawlerException

SQLException

executeScriptFromResource

public static void executeScriptFromResource(Connection connection,
                                             String scriptResource)
                                      throws SchemaCrawlerException

Throws:

SchemaCrawlerException

executeSql

public static ResultSet executeSql(Statement statement,
                                   String sql)
                            throws SQLException

Throws:

SQLException

executeSql

public static ResultSet executeSql(Statement statement,
                                   String sql,
                                   boolean throwSQLException)
                            throws SQLException

Throws:

SQLException

executeSqlForLong

public static long executeSqlForLong(Connection connection,
                                     String sql)
                              throws SchemaCrawlerException

Throws:

SchemaCrawlerException

executeSqlForScalar

public static Object executeSqlForScalar(Connection connection,
                                         String sql)
                                  throws SchemaCrawlerException

Throws:

SchemaCrawlerException

logSQLWarnings

public static void logSQLWarnings(ResultSet resultSet)

logSQLWarnings

public static void logSQLWarnings(Statement statement)

readResultsVector

public static List<String> readResultsVector(ResultSet results)
                                      throws SQLException

Reads a single column result set as a list.

Parameters:

results - Result set

Returns:

List

Throws:

SQLException - On an exception