org.databene.commons.db
Class DBUtil

java.lang.Object
  org.databene.commons.db.DBUtil

public class DBUtil
extends java.lang.Object

Provides database related utility methods.

Created: 06.01.2007 19:27:02

Author:

Volker Bergmann

Method Summary

static boolean	available(java.lang.String url, java.lang.String driverClass, java.lang.String user, java.lang.String password)
static void	checkReadOnly(java.lang.String sql, boolean readOnly)
static void	close(java.sql.Connection connection) Closes a database connection silently
static void	close(java.sql.ResultSet resultSet)
static void	close(java.sql.Statement statement)
static java.sql.Connection	connect(JDBCConnectData data)
static java.sql.Connection	connect(java.lang.String url, java.lang.String driverClassName, java.lang.String user, java.lang.String password)
static java.lang.Object[]	currentLine(java.sql.ResultSet resultSet) Deprecated. replaced by ResultSetConverter
static java.lang.String	escape(java.lang.String text)
static int	executeUpdate(java.lang.String sql, java.sql.Connection connection)
static java.lang.String	format(java.sql.ResultSet resultSet)
static void	logMetaData(java.sql.Connection connection)
static java.lang.Object[]	nextLine(java.sql.ResultSet resultSet) Deprecated. replaced by ConvertingIterable(ResultSetIterator, ResultSetConverter)
static java.lang.Object	parseResultSet(java.sql.ResultSet resultSet)
static java.sql.PreparedStatement	prepareStatement(java.sql.Connection connection, java.lang.String sql, boolean readOnly)
static java.sql.PreparedStatement	prepareStatement(java.sql.Connection connection, java.lang.String sql, boolean readOnly, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
static java.lang.Object	query(java.lang.String query, java.sql.Connection connection)
static long	queryLong(java.lang.String query, java.sql.Connection connection)
static java.lang.Object	queryScalar(java.lang.String query, java.sql.Connection connection)
static <T> T[]	queryScalarArray(java.lang.String query, java.lang.Class<T> componentType, java.sql.Connection connection)
static java.lang.String	queryString(java.sql.PreparedStatement statement)
static ResultsWithMetadata	queryWithMetadata(java.lang.String query, java.sql.Connection connection)
static java.lang.Object	runScript(java.lang.String scriptText, java.sql.Connection connection, boolean ignoreComments, ErrorHandler errorHandler)
static java.lang.Object	runScript(java.lang.String scriptUri, java.lang.String encoding, java.sql.Connection connection, boolean ignoreComments, ErrorHandler errorHandler)

Methods inherited from class java.lang.Object

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

Method Detail

connect

public static java.sql.Connection connect(JDBCConnectData data)
                                   throws ConnectFailedException

Throws:

ConnectFailedException

connect

public static java.sql.Connection connect(java.lang.String url,
                                          java.lang.String driverClassName,
                                          java.lang.String user,
                                          java.lang.String password)
                                   throws ConnectFailedException

Throws:

ConnectFailedException

available

public static boolean available(java.lang.String url,
                                java.lang.String driverClass,
                                java.lang.String user,
                                java.lang.String password)

close

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

Closes a database connection silently

close

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

close

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

parseResultSet

public static java.lang.Object parseResultSet(java.sql.ResultSet resultSet)
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

nextLine

@Deprecated
public static java.lang.Object[] nextLine(java.sql.ResultSet resultSet)
                                   throws java.sql.SQLException

Deprecated. replaced by ConvertingIterable(ResultSetIterator, ResultSetConverter)

Throws:

java.sql.SQLException

currentLine

@Deprecated
public static java.lang.Object[] currentLine(java.sql.ResultSet resultSet)
                                      throws java.sql.SQLException

Deprecated. replaced by ResultSetConverter

Throws:

java.sql.SQLException

format

public static java.lang.String format(java.sql.ResultSet resultSet)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

queryString

public static java.lang.String queryString(java.sql.PreparedStatement statement)

queryLong

public static long queryLong(java.lang.String query,
                             java.sql.Connection connection)

queryScalar

public static java.lang.Object queryScalar(java.lang.String query,
                                           java.sql.Connection connection)

runScript

public static java.lang.Object runScript(java.lang.String scriptUri,
                                         java.lang.String encoding,
                                         java.sql.Connection connection,
                                         boolean ignoreComments,
                                         ErrorHandler errorHandler)
                                  throws java.io.IOException

Throws:

java.io.IOException

runScript

public static java.lang.Object runScript(java.lang.String scriptText,
                                         java.sql.Connection connection,
                                         boolean ignoreComments,
                                         ErrorHandler errorHandler)

executeUpdate

public static int executeUpdate(java.lang.String sql,
                                java.sql.Connection connection)
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

queryScalarArray

public static <T> T[] queryScalarArray(java.lang.String query,
                                       java.lang.Class<T> componentType,
                                       java.sql.Connection connection)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

query

public static java.lang.Object query(java.lang.String query,
                                     java.sql.Connection connection)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatement

public static java.sql.PreparedStatement prepareStatement(java.sql.Connection connection,
                                                          java.lang.String sql,
                                                          boolean readOnly)
                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatement

public static java.sql.PreparedStatement prepareStatement(java.sql.Connection connection,
                                                          java.lang.String sql,
                                                          boolean readOnly,
                                                          int resultSetType,
                                                          int resultSetConcurrency,
                                                          int resultSetHoldability)
                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

escape

public static java.lang.String escape(java.lang.String text)

queryWithMetadata

public static ResultsWithMetadata queryWithMetadata(java.lang.String query,
                                                    java.sql.Connection connection)
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

checkReadOnly

public static void checkReadOnly(java.lang.String sql,
                                 boolean readOnly)

logMetaData

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