org.jminor.common.db

Class Databases

java.lang.Object

org.jminor.common.db.Databases

public final class Databases
extends java.lang.Object

Utility class for Database implementations and misc. database related things.

See Also:

Database.DATABASE_TYPE

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	Databases.QueryCounter A class for counting query types, providing averages over time

Field Summary

Fields

Modifier and Type	Field and Description
static ResultPacker<java.lang.Integer>	INTEGER_RESULT_PACKER A result packer for fetching integers from a result set containing a single integer column
static ResultPacker<java.lang.Long>	LONG_RESULT_PACKER A result packer for fetching longs from a result set containing a single long column
static Databases.QueryCounter	QUERY_COUNTER A synchronized query counter.

Method Summary

Modifier and Type	Method and Description
static void	closeSilently(java.sql.Connection connection) Closes the given Connection instance, swallowing any SQLExceptions that occur
static void	closeSilently(java.sql.ResultSet resultSet) Closes the given ResultSet instance, swallowing any SQLExceptions that occur
static void	closeSilently(java.sql.Statement statement) Closes the given Statement instance, swallowing any SQLExceptions that occur
static java.lang.String	createLogMessage(User user, java.lang.String sqlStatement, java.util.List values, java.lang.Exception exception, MethodLogger.Entry entry) Creates a log message from the given information
static Database.Statistics	getDatabaseStatistics() Returns the statistics gathered via QUERY_COUNTER.
static Database	getInstance()
static boolean	isValid(java.sql.Connection connection, Database database, int timeoutInSeconds) Returns true if the given connection is valid, if the underlying driver supports isValid() it is used, otherwise a simple query is run

Methods inherited from class java.lang.Object

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

Field Detail

QUERY_COUNTER

public static final Databases.QueryCounter QUERY_COUNTER

A synchronized query counter.

See Also:

getDatabaseStatistics()

INTEGER_RESULT_PACKER

public static final ResultPacker<java.lang.Integer> INTEGER_RESULT_PACKER

A result packer for fetching integers from a result set containing a single integer column

LONG_RESULT_PACKER

public static final ResultPacker<java.lang.Long> LONG_RESULT_PACKER

A result packer for fetching longs from a result set containing a single long column

Method Detail

getInstance

public static Database getInstance()

Returns:

a Database instance based on the current runtime database type property

Throws:

java.lang.IllegalArgumentException - in case an unsupported database type is specified

java.lang.RuntimeException - in case of an exception occurring while instantiating the database implementation instance

See Also:

Database.DATABASE_TYPE, Database.getDatabaseType()

closeSilently

public static void closeSilently(java.sql.ResultSet resultSet)

Closes the given ResultSet instance, swallowing any SQLExceptions that occur

Parameters:

resultSet - the result set to close

closeSilently

public static void closeSilently(java.sql.Statement statement)

Closes the given Statement instance, swallowing any SQLExceptions that occur

Parameters:

statement - the statement to close

closeSilently

public static void closeSilently(java.sql.Connection connection)

Closes the given Connection instance, swallowing any SQLExceptions that occur

Parameters:

connection - the connection to close

isValid

public static boolean isValid(java.sql.Connection connection,
                              Database database,
                              int timeoutInSeconds)

Returns true if the given connection is valid, if the underlying driver supports isValid() it is used, otherwise a simple query is run

Parameters:

connection - the connection to validate

database - the underlying database implementation

timeoutInSeconds - the timeout

Returns:

true if the connection is valid

getDatabaseStatistics

public static Database.Statistics getDatabaseStatistics()

Returns the statistics gathered via QUERY_COUNTER.

Returns:

a Database.Statistics object containing query statistics collected since the last time this function was called.

createLogMessage

public static java.lang.String createLogMessage(User user,
                                                java.lang.String sqlStatement,
                                                java.util.List values,
                                                java.lang.Exception exception,
                                                MethodLogger.Entry entry)

Creates a log message from the given information

Parameters:

user - the user

sqlStatement - the sql statement

values - the values

exception - the exception, if any

entry - the log entry

Returns:

a log message