com.bea.p13n.util.jdbc
Class JdbcHelper

java.lang.Object
  com.bea.p13n.util.jdbc.JdbcHelper

public class JdbcHelper
extends Object

This class contains helper methods for jdbc resources.

Method Summary

static void	close(Connection con) Close a connection, ignoring any errors.
static SQLException	close(Connection connection, ResultSet resultSet, Statement statement, SQLException sqlException) Used to preserve first occuring instance of a SQLException, so it may be rethrown after cleanup
static void	close(ResultSet rs) Close a result set, ignoring any errors.
static void	close(ResultSet rs, Statement stmt, Connection con) Close a connection, statement and resultset, ignoring errors.
static void	close(Statement stmt) Close a statement, ignoring any errors.
static String	getClobAsString(ResultSet resultSet, int columnIndex) Convenience method to read a String from a clob.
static String	getClobAsString(ResultSet resultSet, String columnName) Convenience method to read a String from a clob.
static JdbcHelper	getInstance() Deprecated since there are no instance methods remaining on this class
static Transaction	getTransaction() Returns the transaction
static void	resumeTransaction(Transaction suspendedTransaction) Resumes the suspended transaction if it is not null.
static void	setClobAsString(PreparedStatement statement, int parameterIndex, String clobData) Convenience method to set a clob field from a String.
static String	showIsolationLevel(Connection connection) Show transaction isolation level of connection
static UserTransaction	startTransaction() Start a new transaction
static Transaction	suspendTransaction() Suspend any current transaction (unless suspendTransaction is false).

Methods inherited from class java.lang.Object

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

Method Detail

getInstance

@Deprecated
public static JdbcHelper getInstance()

Deprecated since there are no instance methods remaining on this class

getClobAsString

public static String getClobAsString(ResultSet resultSet,
                                     int columnIndex)
                              throws SQLException

Convenience method to read a String from a clob. This method retrieves a Reader from ResultSet.getCharacterStream(int) and reads that data into a String. It may be safe in many cases to simply call ResultSet.getString(int), however that may not work consistently across all drivers, especially with larger strings.

Parameters

resultSet - the result set to read

columnIndex - the column to read. First column is 1...

Returns

a String containing the clob data

Throws

SQLException - if an error occurs

getClobAsString

public static String getClobAsString(ResultSet resultSet,
                                     String columnName)
                              throws SQLException

Convenience method to read a String from a clob. This method retrieves a Reader from ResultSet.getCharacterStream(String) and reads that data into a String. It may be safe in many cases to simply call ResultSet.getString(int), however that may not work consistently across all drivers, especially with larger strings.

Parameters

resultSet - the result set to read

columnName - the name of the column to read.

Returns

a String containing the clob data

Throws

SQLException - if an error occurs

setClobAsString

public static void setClobAsString(PreparedStatement statement,
                                   int parameterIndex,
                                   String clobData)
                            throws SQLException

Convenience method to set a clob field from a String. This method creates a StringReader arounc clobData and calls PreparedStatement.setCharacterStream(int, java.io.Reader, int) It may be safe in many cases to simply call PreparedStatement.setString(int,String), however that may not work consistently across all drivers, especially with larger strings.

Parameters

statement - the prepared statement

parameterIndex - the parameter to set. First parameter is 1...

clobData - string to set on the clob

Throws

SQLException - if an error occurs

close

public static void close(Connection con)

Close a connection, ignoring any errors.

Parameters

con - The Connection object to be closed.

close

public static void close(Statement stmt)

Close a statement, ignoring any errors.

Parameters

stmt - The Statement object to be closed.

close

public static void close(ResultSet rs)

Close a result set, ignoring any errors.

Parameters

rs - The ResultSet object to be closed.

close

public static void close(ResultSet rs,
                         Statement stmt,
                         Connection con)

Close a connection, statement and resultset, ignoring errors.

Parameters

rs - The ResultSet object to be closed.

stmt - The Statement object to be closed.

con - The Connection object to be closed.

close

public static SQLException close(Connection connection,
                                 ResultSet resultSet,
                                 Statement statement,
                                 SQLException sqlException)

Used to preserve first occuring instance of a SQLException, so it may be rethrown after cleanup

Parameters

connection -

resultSet -

statement -

sqlException -

showIsolationLevel

public static String showIsolationLevel(Connection connection)
                                 throws SQLException

Show transaction isolation level of connection

Throws

SQLException

startTransaction

public static UserTransaction startTransaction()
                                        throws SQLException

Start a new transaction

Throws

SQLException

suspendTransaction

public static Transaction suspendTransaction()

Suspend any current transaction (unless suspendTransaction is false).

Returns

the suspended transaction (or null if none)

resumeTransaction

public static void resumeTransaction(Transaction suspendedTransaction)

Resumes the suspended transaction if it is not null.

Parameters

suspendedTransaction - Transaction to resume.

getTransaction

public static Transaction getTransaction()

Returns the transaction