DbUtils (CUBA 7.0 API)

java.lang.Object
- com.haulmont.bali.db.DbUtils

@ThreadSafe
public final class DbUtils
extends java.lang.Object

A collection of JDBC helper methods. This class is thread safe.

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method and Description
`static void`	`close(java.sql.Connection conn)` Close a `Connection`, avoid closing if null.
`static void`	`close(java.sql.ResultSet rs)` Close a `ResultSet`, avoid closing if null.
`static void`	`close(java.sql.Statement stmt)` Close a `Statement`, avoid closing if null.
`static void`	`closeQuietly(java.sql.Connection conn)` Close a `Connection`, avoid closing if null and hide any SQLExceptions that occur.
`static void`	`closeQuietly(java.sql.Connection conn, java.sql.Statement stmt, java.sql.ResultSet rs)` Close a `Connection`, `Statement` and `ResultSet`.
`static void`	`closeQuietly(java.sql.ResultSet rs)` Close a `ResultSet`, avoid closing if null and hide any SQLExceptions that occur.
`static void`	`closeQuietly(java.sql.Statement stmt)` Close a `Statement`, avoid closing if null and hide any SQLExceptions that occur.
`static void`	`commitAndClose(java.sql.Connection conn)` Commits a `Connection` then closes it, avoid closing if null.
`static void`	`commitAndCloseQuietly(java.sql.Connection conn)` Commits a `Connection` then closes it, avoid closing if null and hide any SQLExceptions that occur.
`static boolean`	`loadDriver(java.lang.String driverClassName)` Loads and registers a database driver class.
`static void`	`printStackTrace(java.sql.SQLException e)` Print the stack trace for a SQLException to STDERR.
`static void`	`printStackTrace(java.sql.SQLException e, java.io.PrintWriter pw)` Print the stack trace for a SQLException to a specified PrintWriter.
`static void`	`printWarnings(java.sql.Connection conn)` Print warnings on a Connection to STDERR.
`static void`	`printWarnings(java.sql.Connection conn, java.io.PrintWriter pw)` Print warnings on a Connection to a specified PrintWriter.
`static void`	`rollback(java.sql.Connection conn)` Rollback any changes made on the given connection.
`static void`	`rollbackAndClose(java.sql.Connection conn)` Performs a rollback on the `Connection` then closes it, avoid closing if null.
`static void`	`rollbackAndCloseQuietly(java.sql.Connection conn)` Performs a rollback on the `Connection` then closes it, avoid closing if null and hide any SQLExceptions that occur.

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Method Detail
  - close
```
public static void close(java.sql.Connection conn)
                  throws java.sql.SQLException
```
    Close a Connection, avoid closing if null.
    
    Parameters:
    
    conn - Connection to close.
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - close
```
public static void close(java.sql.ResultSet rs)
                  throws java.sql.SQLException
```
    Close a ResultSet, avoid closing if null.
    
    Parameters:
    
    rs - ResultSet to close.
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - close
```
public static void close(java.sql.Statement stmt)
                  throws java.sql.SQLException
```
    Close a Statement, avoid closing if null.
    
    Parameters:
    
    stmt - Statement to close.
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - closeQuietly
```
public static void closeQuietly(java.sql.Connection conn)
```
    Close a Connection, avoid closing if null and hide any SQLExceptions that occur.
    
    Parameters:
    
    conn - Connection to close.
  - closeQuietly
```
public static void closeQuietly(java.sql.Connection conn,
                                java.sql.Statement stmt,
                                java.sql.ResultSet rs)
```
    Close a Connection, Statement and ResultSet. Avoid closing if null and hide any SQLExceptions that occur.
    
    Parameters:
    
    conn - Connection to close.
    
    stmt - Statement to close.
    
    rs - ResultSet to close.
  - closeQuietly
```
public static void closeQuietly(java.sql.ResultSet rs)
```
    Close a ResultSet, avoid closing if null and hide any SQLExceptions that occur.
    
    Parameters:
    
    rs - ResultSet to close.
  - closeQuietly
```
public static void closeQuietly(java.sql.Statement stmt)
```
    Close a Statement, avoid closing if null and hide any SQLExceptions that occur.
    
    Parameters:
    
    stmt - Statement to close.
  - commitAndClose
```
public static void commitAndClose(java.sql.Connection conn)
                           throws java.sql.SQLException
```
    Commits a Connection then closes it, avoid closing if null.
    
    Parameters:
    
    conn - Connection to close.
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - commitAndCloseQuietly
```
public static void commitAndCloseQuietly(java.sql.Connection conn)
```
    Commits a Connection then closes it, avoid closing if null and hide any SQLExceptions that occur.
    
    Parameters:
    
    conn - Connection to close.
  - loadDriver
```
public static boolean loadDriver(java.lang.String driverClassName)
```
    Loads and registers a database driver class. If this succeeds, it returns true, else it returns false.
    
    Parameters:
    
    driverClassName - of driver to load
    
    Returns:
    
    boolean true if the driver was found, otherwise false
  - printStackTrace
```
public static void printStackTrace(java.sql.SQLException e)
```
    Print the stack trace for a SQLException to STDERR.
    
    Parameters:
    
    e - SQLException to print stack trace of
  - printStackTrace
```
public static void printStackTrace(java.sql.SQLException e,
                                   java.io.PrintWriter pw)
```
    Print the stack trace for a SQLException to a specified PrintWriter.
    
    Parameters:
    
    e - SQLException to print stack trace of
    
    pw - PrintWriter to print to
  - printWarnings
```
public static void printWarnings(java.sql.Connection conn)
```
    Print warnings on a Connection to STDERR.
    
    Parameters:
    
    conn - Connection to print warnings from
  - printWarnings
```
public static void printWarnings(java.sql.Connection conn,
                                 java.io.PrintWriter pw)
```
    Print warnings on a Connection to a specified PrintWriter.
    
    Parameters:
    
    conn - Connection to print warnings from
    
    pw - PrintWriter to print to
  - rollback
```
public static void rollback(java.sql.Connection conn)
                     throws java.sql.SQLException
```
    Rollback any changes made on the given connection.
    
    Parameters:
    
    conn - Connection to rollback. A null value is legal.
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
  - rollbackAndClose
```
public static void rollbackAndClose(java.sql.Connection conn)
                             throws java.sql.SQLException
```
    Performs a rollback on the Connection then closes it, avoid closing if null.
    
    Parameters:
    
    conn - Connection to rollback. A null value is legal.
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs
    
    Since:
    
    DbUtils 1.1
  - rollbackAndCloseQuietly
```
public static void rollbackAndCloseQuietly(java.sql.Connection conn)
```
    Performs a rollback on the Connection then closes it, avoid closing if null and hide any SQLExceptions that occur.
    
    Parameters:
    
    conn - Connection to rollback. A null value is legal.
    
    Since:
    
    DbUtils 1.1

Class DbUtils

Method Summary

Methods inherited from class java.lang.Object

Method Detail

close

close

close

closeQuietly

closeQuietly

closeQuietly

closeQuietly

commitAndClose

commitAndCloseQuietly

loadDriver

printStackTrace

printStackTrace

printWarnings

printWarnings

rollback

rollbackAndClose

rollbackAndCloseQuietly