liquibase.util

Class JdbcUtils

java.lang.Object

liquibase.util.JdbcUtils

public abstract class JdbcUtils
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
static int	TYPE_UNKNOWN Constant that indicates an unknown (or unspecified) SQL type.

Constructor Summary

Constructors

Constructor and Description
JdbcUtils()

Method Summary

Methods

Modifier and Type	Method and Description
static void	closeResultSet(java.sql.ResultSet rs) Close the given JDBC ResultSet and ignore any thrown exception.
static void	closeStatement(java.sql.Statement stmt) Close the given JDBC Statement and ignore any thrown exception.
static java.lang.Object	getResultSetValue(java.sql.ResultSet rs, int index) Retrieve a JDBC column value from a ResultSet, using the most appropriate value type.
static java.lang.String	getValueForColumn(java.sql.ResultSet rs, java.lang.String columnNameToCheck, Database database) Checks whether a result set has a column matching the specified column name.
static boolean	isNumeric(int sqlType) Check whether the given SQL type is numeric.
static java.lang.Object	requiredSingleResult(java.util.Collection results) Return a single result object from the given Collection.

Methods inherited from class java.lang.Object

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

Field Detail

TYPE_UNKNOWN

public static final int TYPE_UNKNOWN

Constant that indicates an unknown (or unspecified) SQL type.

See Also:

Types, Constant Field Values

Constructor Detail

JdbcUtils

public JdbcUtils()

Method Detail

closeStatement

public static void closeStatement(java.sql.Statement stmt)

Close the given JDBC Statement and ignore any thrown exception. This is useful for typical finally blocks in manual JDBC code.

Parameters:

stmt - the JDBC Statement to close (may be null)

closeResultSet

public static void closeResultSet(java.sql.ResultSet rs)

Close the given JDBC ResultSet and ignore any thrown exception. This is useful for typical finally blocks in manual JDBC code.

Parameters:

rs - the JDBC ResultSet to close (may be null)

getResultSetValue

public static java.lang.Object getResultSetValue(java.sql.ResultSet rs,
                                 int index)
                                          throws java.sql.SQLException

Retrieve a JDBC column value from a ResultSet, using the most appropriate value type. The returned value should be a detached value object, not having any ties to the active ResultSet: in particular, it should not be a Blob or Clob object but rather a byte array respectively String representation.

Uses the getObject(index) method, but includes additional "hacks" to get around Oracle 10g returning a non-standard object for its TIMESTAMP datatype and a java.sql.Date for DATE columns leaving out the time portion: These columns will explicitly be extracted as standard java.sql.Timestamp object.

Parameters:

rs - is the ResultSet holding the data

index - is the column index

Returns:

the value object

Throws:

java.sql.SQLException - if thrown by the JDBC API

See Also:

Blob, Clob, Timestamp

isNumeric

public static boolean isNumeric(int sqlType)

Check whether the given SQL type is numeric.

Parameters:

sqlType - the SQL type to be checked

Returns:

whether the type is numeric

requiredSingleResult

public static java.lang.Object requiredSingleResult(java.util.Collection results)
                                             throws DatabaseException

Return a single result object from the given Collection.

Throws an exception if 0 or more than 1 element found.

Parameters:

results - the result Collection (can be null)

Returns:

the single result object

Throws:

DatabaseException

getValueForColumn

public static java.lang.String getValueForColumn(java.sql.ResultSet rs,
                                 java.lang.String columnNameToCheck,
                                 Database database)
                                          throws java.sql.SQLException

Checks whether a result set has a column matching the specified column name. The column name is first changed to match the database format. E.g. an unquoted columnName in h2 will be converted to uppercase so the column name that is being checked for is really the uppercase version of the column name,

Parameters:

rs - result set to check

columnNameToCheck - column name to check

Returns:

The value if found, null if not found

Throws:

java.sql.SQLException