org.h2.util

Class JdbcUtils

java.lang.Object

org.h2.util.JdbcUtils

public class JdbcUtils
extends Object

This is a utility class with JDBC helper functions.

Method Summary

Methods

Modifier and Type	Method and Description
static void	closeSilently(Connection conn) Close a connection without throwing an exception.
static void	closeSilently(ResultSet rs) Close a result set without throwing an exception.
static void	closeSilently(Statement stat) Close a statement without throwing an exception.
static String	escapeMetaDataPattern(String pattern) Escape table or schema patterns used for DatabaseMetaData functions.
static Connection	getConnection(String driver, String url, Properties prop) Open a new database connection with the given settings.
static Connection	getConnection(String driver, String url, String user, String password) Open a new database connection with the given settings.
static String	getDriver(String url) Get the driver class name for the given URL, or null if the URL is unknown.
static void	load(String url) Load the driver class for the given URL, if the database URL is known.

Methods inherited from class java.lang.Object

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

Method Detail

closeSilently

public static void closeSilently(Statement stat)

Close a statement without throwing an exception.

Parameters:

stat - the statement or null

closeSilently

public static void closeSilently(Connection conn)

Close a connection without throwing an exception.

Parameters:

conn - the connection or null

closeSilently

public static void closeSilently(ResultSet rs)

Close a result set without throwing an exception.

Parameters:

rs - the result set or null

getConnection

public static Connection getConnection(String driver,
                       String url,
                       String user,
                       String password)
                                throws SQLException

Open a new database connection with the given settings.

Parameters:

driver - the driver class name

url - the database URL

user - the user name

password - the password

Returns:

the database connection

Throws:

SQLException

escapeMetaDataPattern

public static String escapeMetaDataPattern(String pattern)

Escape table or schema patterns used for DatabaseMetaData functions.

Parameters:

pattern - the pattern

Returns:

the escaped pattern

getConnection

public static Connection getConnection(String driver,
                       String url,
                       Properties prop)
                                throws SQLException

Open a new database connection with the given settings.

Parameters:

driver - the driver class name

url - the database URL

prop - the properties containing at least the user name and password

Returns:

the database connection

Throws:

SQLException

getDriver

public static String getDriver(String url)

Get the driver class name for the given URL, or null if the URL is unknown.

Parameters:

url - the database URL

Returns:

the driver class name

load

public static void load(String url)

Load the driver class for the given URL, if the database URL is known.

Parameters:

url - the database URL