java.lang.Object
- org.jooq.tools.jdbc.JDBC41Connection
- - org.jooq.tools.jdbc.DefaultConnection
  - - org.jooq.tools.jdbc.BatchedConnection

All Implemented Interfaces:

AutoCloseable, Connection, Wrapper
```
public class BatchedConnection
extends DefaultConnection
```
A batching connection.
This connection buffers consecutive identical prepared statements for DELETE, INSERT, MERGE, UPDATE statements, instead of allowing for them to be executed directly.
Calls to PreparedStatement.executeUpdate() or PreparedStatement.execute() are replaced by PreparedStatement.addBatch(). The update count of such operations is always zero, and cannot be retrieved later on. When any of the following events happen, the batch is executed using Statement.executeBatch():
- The close() method is called (the call is not delegated to the wrapped connection).
- A Connection.prepareStatement(String) call is made with a different SQL string.
- Any other type of statement is created or other API is called, such as commit().
Author:

Lukas Eder

Field Summary
- Fields inherited from interface java.sql.Connection
  TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Constructor Summary

Constructors
Constructor Description

BatchedConnection(Connection delegate)

BatchedConnection(Connection delegate, int batchSize)

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`void`	`clearWarnings()`
`void`	`close()`
`void`	`commit()`
`Statement`	`createStatement()`
`Statement`	`createStatement(int resultSetType, int resultSetConcurrency)`
`Statement`	`createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)`
`boolean`	`getAutoCommit()`
`String`	`getCatalog()`
`Properties`	`getClientInfo()`
`String`	`getClientInfo(String name)`
`int`	`getHoldability()`
`int`	`getTransactionIsolation()`
`Map<String,Class<?>>`	`getTypeMap()`
`SQLWarning`	`getWarnings()`
`boolean`	`isReadOnly()`
`boolean`	`isValid(int timeout)`
`boolean`	`isWrapperFor(Class<?> iface)`
`CallableStatement`	`prepareCall(String sql)`
`CallableStatement`	`prepareCall(String sql, int resultSetType, int resultSetConcurrency)`
`CallableStatement`	`prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)`
`PreparedStatement`	`prepareStatement(String sql)`
`PreparedStatement`	`prepareStatement(String sql, int autoGeneratedKeys)`
`PreparedStatement`	`prepareStatement(String sql, int[] columnIndexes)`
`PreparedStatement`	`prepareStatement(String sql, int resultSetType, int resultSetConcurrency)`
`PreparedStatement`	`prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)`
`PreparedStatement`	`prepareStatement(String sql, String[] columnNames)`
`void`	`releaseSavepoint(Savepoint savepoint)`
`void`	`rollback()`
`void`	`rollback(Savepoint savepoint)`
`void`	`setAutoCommit(boolean autoCommit)`
`void`	`setCatalog(String catalog)`
`void`	`setClientInfo(String name, String value)`
`void`	`setClientInfo(Properties properties)`
`void`	`setHoldability(int holdability)`
`void`	`setReadOnly(boolean readOnly)`
`Savepoint`	`setSavepoint()`
`Savepoint`	`setSavepoint(String name)`
`void`	`setTransactionIsolation(int level)`
`void`	`setTypeMap(Map<String,Class<?>> map)`
`<T> T`	`unwrap(Class<T> iface)`

Methods inherited from class org.jooq.tools.jdbc.DefaultConnection
abort, beginRequest, createArrayOf, createBlob, createClob, createNClob, createSQLXML, createStruct, endRequest, getDelegate, getMetaData, getNetworkTimeout, getSchema, isClosed, nativeSQL, setNetworkTimeout, setSchema, setShardingKey, setShardingKey, setShardingKeyIfValid, setShardingKeyIfValid

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

- Constructor Detail
  - BatchedConnection
```
public BatchedConnection(Connection delegate)
```
  - BatchedConnection
```
public BatchedConnection(Connection delegate,
                         int batchSize)
```
- Method Detail
  - unwrap
```
public <T> T unwrap(Class<T> iface)
             throws SQLException
```
    Specified by:
    
    unwrap in interface Wrapper
    
    Overrides:
    
    unwrap in class DefaultConnection
    
    Throws:
    
    SQLException
  - isWrapperFor
```
public boolean isWrapperFor(Class<?> iface)
                     throws SQLException
```
    Specified by:
    
    isWrapperFor in interface Wrapper
    
    Overrides:
    
    isWrapperFor in class DefaultConnection
    
    Throws:
    
    SQLException
  - createStatement
```
public Statement createStatement()
                          throws SQLException
```
    Specified by:
    
    createStatement in interface Connection
    
    Overrides:
    
    createStatement in class DefaultConnection
    
    Throws:
    
    SQLException
  - createStatement
```
public Statement createStatement(int resultSetType,
                                 int resultSetConcurrency)
                          throws SQLException
```
    Specified by:
    
    createStatement in interface Connection
    
    Overrides:
    
    createStatement in class DefaultConnection
    
    Throws:
    
    SQLException
  - createStatement
```
public Statement createStatement(int resultSetType,
                                 int resultSetConcurrency,
                                 int resultSetHoldability)
                          throws SQLException
```
    Specified by:
    
    createStatement in interface Connection
    
    Overrides:
    
    createStatement in class DefaultConnection
    
    Throws:
    
    SQLException
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                          int resultSetType,
                                          int resultSetConcurrency)
                                   throws SQLException
```
    Specified by:
    
    prepareStatement in interface Connection
    
    Overrides:
    
    prepareStatement in class DefaultConnection
    
    Throws:
    
    SQLException
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                          int resultSetType,
                                          int resultSetConcurrency,
                                          int resultSetHoldability)
                                   throws SQLException
```
    Specified by:
    
    prepareStatement in interface Connection
    
    Overrides:
    
    prepareStatement in class DefaultConnection
    
    Throws:
    
    SQLException
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                          int autoGeneratedKeys)
                                   throws SQLException
```
    Specified by:
    
    prepareStatement in interface Connection
    
    Overrides:
    
    prepareStatement in class DefaultConnection
    
    Throws:
    
    SQLException
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                          int[] columnIndexes)
                                   throws SQLException
```
    Specified by:
    
    prepareStatement in interface Connection
    
    Overrides:
    
    prepareStatement in class DefaultConnection
    
    Throws:
    
    SQLException
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                          String[] columnNames)
                                   throws SQLException
```
    Specified by:
    
    prepareStatement in interface Connection
    
    Overrides:
    
    prepareStatement in class DefaultConnection
    
    Throws:
    
    SQLException
  - prepareCall
```
public CallableStatement prepareCall(String sql)
                              throws SQLException
```
    Specified by:
    
    prepareCall in interface Connection
    
    Overrides:
    
    prepareCall in class DefaultConnection
    
    Throws:
    
    SQLException
  - prepareCall
```
public CallableStatement prepareCall(String sql,
                                     int resultSetType,
                                     int resultSetConcurrency)
                              throws SQLException
```
    Specified by:
    
    prepareCall in interface Connection
    
    Overrides:
    
    prepareCall in class DefaultConnection
    
    Throws:
    
    SQLException
  - prepareCall
```
public CallableStatement prepareCall(String sql,
                                     int resultSetType,
                                     int resultSetConcurrency,
                                     int resultSetHoldability)
                              throws SQLException
```
    Specified by:
    
    prepareCall in interface Connection
    
    Overrides:
    
    prepareCall in class DefaultConnection
    
    Throws:
    
    SQLException
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql)
                                   throws SQLException
```
    Specified by:
    
    prepareStatement in interface Connection
    
    Overrides:
    
    prepareStatement in class DefaultConnection
    
    Throws:
    
    SQLException
  - commit
```
public void commit()
            throws SQLException
```
    Specified by:
    
    commit in interface Connection
    
    Overrides:
    
    commit in class DefaultConnection
    
    Throws:
    
    SQLException
  - rollback
```
public void rollback()
              throws SQLException
```
    Specified by:
    
    rollback in interface Connection
    
    Overrides:
    
    rollback in class DefaultConnection
    
    Throws:
    
    SQLException
  - rollback
```
public void rollback(Savepoint savepoint)
              throws SQLException
```
    Specified by:
    
    rollback in interface Connection
    
    Overrides:
    
    rollback in class DefaultConnection
    
    Throws:
    
    SQLException
  - close
```
public void close()
           throws SQLException
```
    Specified by:
    
    close in interface AutoCloseable
    
    Specified by:
    
    close in interface Connection
    
    Overrides:
    
    close in class DefaultConnection
    
    Throws:
    
    SQLException
  - setSavepoint
```
public Savepoint setSavepoint()
                       throws SQLException
```
    Specified by:
    
    setSavepoint in interface Connection
    
    Overrides:
    
    setSavepoint in class DefaultConnection
    
    Throws:
    
    SQLException
  - setSavepoint
```
public Savepoint setSavepoint(String name)
                       throws SQLException
```
    Specified by:
    
    setSavepoint in interface Connection
    
    Overrides:
    
    setSavepoint in class DefaultConnection
    
    Throws:
    
    SQLException
  - releaseSavepoint
```
public void releaseSavepoint(Savepoint savepoint)
                      throws SQLException
```
    Specified by:
    
    releaseSavepoint in interface Connection
    
    Overrides:
    
    releaseSavepoint in class DefaultConnection
    
    Throws:
    
    SQLException
  - setAutoCommit
```
public void setAutoCommit(boolean autoCommit)
                   throws SQLException
```
    Specified by:
    
    setAutoCommit in interface Connection
    
    Overrides:
    
    setAutoCommit in class DefaultConnection
    
    Throws:
    
    SQLException
  - getAutoCommit
```
public boolean getAutoCommit()
                      throws SQLException
```
    Specified by:
    
    getAutoCommit in interface Connection
    
    Overrides:
    
    getAutoCommit in class DefaultConnection
    
    Throws:
    
    SQLException
  - setReadOnly
```
public void setReadOnly(boolean readOnly)
                 throws SQLException
```
    Specified by:
    
    setReadOnly in interface Connection
    
    Overrides:
    
    setReadOnly in class DefaultConnection
    
    Throws:
    
    SQLException
  - isReadOnly
```
public boolean isReadOnly()
                   throws SQLException
```
    Specified by:
    
    isReadOnly in interface Connection
    
    Overrides:
    
    isReadOnly in class DefaultConnection
    
    Throws:
    
    SQLException
  - setCatalog
```
public void setCatalog(String catalog)
                throws SQLException
```
    Specified by:
    
    setCatalog in interface Connection
    
    Overrides:
    
    setCatalog in class DefaultConnection
    
    Throws:
    
    SQLException
  - getCatalog
```
public String getCatalog()
                  throws SQLException
```
    Specified by:
    
    getCatalog in interface Connection
    
    Overrides:
    
    getCatalog in class DefaultConnection
    
    Throws:
    
    SQLException
  - getWarnings
```
public SQLWarning getWarnings()
                       throws SQLException
```
    Specified by:
    
    getWarnings in interface Connection
    
    Overrides:
    
    getWarnings in class DefaultConnection
    
    Throws:
    
    SQLException
  - clearWarnings
```
public void clearWarnings()
                   throws SQLException
```
    Specified by:
    
    clearWarnings in interface Connection
    
    Overrides:
    
    clearWarnings in class DefaultConnection
    
    Throws:
    
    SQLException
  - setTransactionIsolation
```
public void setTransactionIsolation(int level)
                             throws SQLException
```
    Specified by:
    
    setTransactionIsolation in interface Connection
    
    Overrides:
    
    setTransactionIsolation in class DefaultConnection
    
    Throws:
    
    SQLException
  - getTransactionIsolation
```
public int getTransactionIsolation()
                            throws SQLException
```
    Specified by:
    
    getTransactionIsolation in interface Connection
    
    Overrides:
    
    getTransactionIsolation in class DefaultConnection
    
    Throws:
    
    SQLException
  - setTypeMap
```
public void setTypeMap(Map<String,Class<?>> map)
                throws SQLException
```
    Specified by:
    
    setTypeMap in interface Connection
    
    Overrides:
    
    setTypeMap in class DefaultConnection
    
    Throws:
    
    SQLException
  - getTypeMap
```
public Map<String,Class<?>> getTypeMap()
                                      throws SQLException
```
    Specified by:
    
    getTypeMap in interface Connection
    
    Overrides:
    
    getTypeMap in class DefaultConnection
    
    Throws:
    
    SQLException
  - setHoldability
```
public void setHoldability(int holdability)
                    throws SQLException
```
    Specified by:
    
    setHoldability in interface Connection
    
    Overrides:
    
    setHoldability in class DefaultConnection
    
    Throws:
    
    SQLException
  - getHoldability
```
public int getHoldability()
                   throws SQLException
```
    Specified by:
    
    getHoldability in interface Connection
    
    Overrides:
    
    getHoldability in class DefaultConnection
    
    Throws:
    
    SQLException
  - isValid
```
public boolean isValid(int timeout)
                throws SQLException
```
    Specified by:
    
    isValid in interface Connection
    
    Overrides:
    
    isValid in class DefaultConnection
    
    Throws:
    
    SQLException
  - setClientInfo
```
public void setClientInfo(String name,
                          String value)
                   throws SQLClientInfoException
```
    Specified by:
    
    setClientInfo in interface Connection
    
    Overrides:
    
    setClientInfo in class DefaultConnection
    
    Throws:
    
    SQLClientInfoException
  - setClientInfo
```
public void setClientInfo(Properties properties)
                   throws SQLClientInfoException
```
    Specified by:
    
    setClientInfo in interface Connection
    
    Overrides:
    
    setClientInfo in class DefaultConnection
    
    Throws:
    
    SQLClientInfoException
  - getClientInfo
```
public String getClientInfo(String name)
                     throws SQLException
```
    Specified by:
    
    getClientInfo in interface Connection
    
    Overrides:
    
    getClientInfo in class DefaultConnection
    
    Throws:
    
    SQLException
  - getClientInfo
```
public Properties getClientInfo()
                         throws SQLException
```
    Specified by:
    
    getClientInfo in interface Connection
    
    Overrides:
    
    getClientInfo in class DefaultConnection
    
    Throws:
    
    SQLException

Constructor	Description
`BatchedConnection(Connection delegate)`
`BatchedConnection(Connection delegate, int batchSize)`

Class BatchedConnection

Field Summary

Fields inherited from interface java.sql.Connection

Constructor Summary

Method Summary

Methods inherited from class org.jooq.tools.jdbc.DefaultConnection

Methods inherited from class java.lang.Object

Constructor Detail

BatchedConnection

BatchedConnection

Method Detail

unwrap

isWrapperFor

createStatement

createStatement

createStatement

prepareStatement

prepareStatement

prepareStatement

prepareStatement

prepareStatement

prepareCall

prepareCall

prepareCall

prepareStatement

commit

rollback

rollback

close

setSavepoint

setSavepoint

releaseSavepoint

setAutoCommit

getAutoCommit

setReadOnly

isReadOnly

setCatalog

getCatalog

getWarnings

clearWarnings

setTransactionIsolation

getTransactionIsolation

setTypeMap

getTypeMap

setHoldability

getHoldability

isValid

setClientInfo

setClientInfo

getClientInfo

getClientInfo