DbOomQuery (Jodd API Documentation)

java.lang.Object
- jodd.db.DbQuery<DbOomQuery>
- - jodd.db.oom.DbOomQuery

All Implemented Interfaces:

java.lang.AutoCloseable
```
public class DbOomQuery
extends DbQuery<DbOomQuery>
```
A simple ORM extension for DbQuery.
OOM extension may map results to objects in two ways:
- auto mode - when result set is mapped to provided types, and
- mapped mode - requires explicit mapping definitions.

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

static class jodd.db.DbQueryBase.State
Query states.

Nested Classes
Modifier and Type	Class and Description
`static class`	`jodd.db.DbQueryBase.State` Query states.

Field Summary

Fields
Modifier and Type	Field and Description
`protected boolean`	`autoClose`
`protected boolean`	`cacheEntities`
`protected java.sql.CallableStatement`	`callableStatement`
`protected QueryConcurrencyType`	`concurrencyType`
`protected java.sql.Connection`	`connection`
`protected DbOom`	`dbOom`
`protected boolean`	`debug`
`protected long`	`elapsed`
`protected boolean`	`entityAwareMode`
`protected int`	`fetchSize`
`protected boolean`	`forcePreparedStatement` If set to `true` all created statements will be prepared.
`protected java.lang.String[]`	`generatedColumns`
`protected JoinHintResolver`	`hintResolver`
`protected java.lang.String[]`	`hints`
`protected QueryHoldability`	`holdability`
`protected int`	`maxRows`
`protected java.sql.PreparedStatement`	`preparedStatement`
`protected jodd.db.DbQueryParser`	`query`
`protected jodd.db.DbQueryBase.State`	`queryState`
`protected java.util.Set<java.sql.ResultSet>`	`resultSets`
`protected DbSession`	`session`
`protected DbSqlGenerator`	`sqlgen`
`protected java.lang.String`	`sqlString`
`protected long`	`start`
`protected java.sql.Statement`	`statement`
`protected static int`	`totalOpenResultSetCount`
`protected QueryScrollType`	`type`

Constructor Summary

Constructors
Constructor and Description
`DbOomQuery(DbOom dbOom, java.sql.Connection conn, DbSqlGenerator sqlgen)`
`DbOomQuery(DbOom dbOom, java.sql.Connection conn, java.lang.String sqlString)`
`DbOomQuery(DbOom dbOom, DbSession session, DbSqlGenerator sqlgen)`
`DbOomQuery(DbOom dbOom, DbSession session, java.lang.String sqlString)`
`DbOomQuery(DbOom dbOom, DbSqlGenerator sqlgen)`
`DbOomQuery(DbOom dbOom, java.lang.String sqlString)`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`protected Q`	`_this()`
`DbOomQuery`	`autoClose()` Defines that query should be automatically closed immediately after using.
`DbOomQuery`	`cacheEntities(boolean cacheEntities)` Defines if entities should be cached in `ResultSetMapper`.
`protected void`	`checkCreated()` Checks if query is created (and not yet initialized or closed) and throws an exception if it is not.
`protected void`	`checkInitialized()` Checks if query is initialized and throws an exception if it is not.
`protected void`	`checkNotClosed()` Checks if query is not closed and throws an exception if it is.
`void`	`close()` Closes the query and all created results sets and detaches itself from the session.
`protected void`	`close(ResultSetMapper rsm, boolean closeQuery)` Closes results set or whole query.
`Q`	`closeAllResultSets()` Closes all result sets created by this query.
`Q`	`closeCursorsAtCommit()`
`protected java.sql.SQLException`	`closeQuery()` Closes all assigned result sets and then closes the query.
`void`	`closeResultSet(java.sql.ResultSet rs)` Closes single result set that was created by this query.
`Q`	`concurrentReadOnly()`
`Q`	`concurrentUpdatable()`
`protected ResultSetMapper`	`createResultSetMapper(java.sql.ResultSet resultSet)` Factory for result sets mapper.
`DbOomQuery`	`entityAwareMode(boolean entityAware)` Defines entity-aware mode for entities tracking in result collection.
`java.sql.ResultSet`	`execute()` Executes the query.
`protected ResultSetMapper`	`executeAndBuildResultSetMapper()` Executes the query and returns `builded ResultSet mapper`.
`DbCallResult`	`executeCall()`
`long`	`executeCount()` Special execute() for 'select count(*)' queries.
`protected long`	`executeCount(boolean close)` Executes count queries and optionally closes query afterwards.
`int`	`executeUpdate()` Executes UPDATE, INSERT or DELETE queries.
`protected int`	`executeUpdate(boolean closeQuery)` Executes UPDATE, INSERT or DELETE queries and optionally closes the query.
`<T> T`	`find()`
`<T> T`	`find(java.lang.Class... types)`
`protected <T> T`	`find(java.lang.Class[] types, boolean close, java.sql.ResultSet resultSet)`
`<T> T`	`find(QueryMapper<T> queryMapper)` `Executes` the query and `maps` single result row.
`java.lang.Object`	`findGeneratedColumns(java.lang.Class... types)` Finds generated columns.
`<T> T`	`findGeneratedKey(java.lang.Class<T> type)` Finds generated key column of given type.
`Q`	`forcePreparedStatement()` Forces creation of prepared statements.
`QueryConcurrencyType`	`getConcurrencyType()`
`long`	`getExecutionTime()` Returns query execution elapsed time in milliseconds.
`int`	`getFetchSize()` Returns fetch size.
`java.lang.String[]`	`getGeneratedColumnNames()` Returns generated column names.
`java.sql.ResultSet`	`getGeneratedColumns()` Returns generated columns.
`long`	`getGeneratedKey()` Returns generated key i.e. first generated column as `long`.
`java.lang.Object`	`getGeneratedKeyObject()`
`QueryHoldability`	`getHoldability()`
`int`	`getMaxRows()` Returns max rows.
`int`	`getOpenResultSetCount()` Returns number of created result sets that are still not explicitly closed.
`jodd.db.DbQueryBase.State`	`getQueryState()` Returns query state.
`java.lang.String`	`getQueryString()` Returns query SQL string.
`DbSession`	`getSession()` Returns used `DbSession`.
`static int`	`getTotalOpenResultSetCount()` Returns total number of open result sets.
`QueryScrollType`	`getType()`
`Q`	`holdCursorsOverCommit()`
`void`	`init()` Initializes the query if not already initialized.
`protected void`	`init(DbOom dbOom)`
`protected void`	`initializeJdbc()` Performs JDBC initialization of the query.
`protected void`	`initSession(DbSession session)` Initializes session.
`boolean`	`isActive()` Returns `true` if query is active: created and possibly initialized.
`boolean`	`isClosed()` Returns `true` if query is closed.
`boolean`	`isInDebugMode()`
`boolean`	`isInitialized()` Returns `true` if query is initialized.
`<T> java.util.Iterator<T>`	`iterate()`
`<T> java.util.Iterator<T>`	`iterate(java.lang.Class... types)`
`protected <T> java.util.Iterator<T>`	`iterate(java.lang.Class[] types, boolean close)`
`<T> java.util.List<T>`	`list()`
`<T> java.util.List<T>`	`list(java.lang.Class... types)`
`protected <T> java.util.List<T>`	`list(java.lang.Class[] types, int max, boolean close)` Iterates result set, maps rows to classes and populates resulting array list.
`<T> java.util.List<T>`	`list(int max)`
`<T> java.util.List<T>`	`list(int max, java.lang.Class... types)`
`<T> java.util.List<T>`	`list(QueryMapper<T> queryMapper)` `Executes` the query, iterates result set and `maps` each row.
`<T> java.util.Set<T>`	`listSet()`
`<T> java.util.Set<T>`	`listSet(java.lang.Class... types)`
`protected <T> java.util.Set<T>`	`listSet(java.lang.Class[] types, int max, boolean close)`
`<T> java.util.Set<T>`	`listSet(int max)`
`<T> java.util.Set<T>`	`listSet(int max, java.lang.Class... types)`
`<T> java.util.Set<T>`	`listSet(QueryMapper<T> queryMapper)` `Executes` the query, iterates all rows and `maps` them.
`void`	`populateGeneratedKeys(java.lang.Object entity)` Populates entity with generated column values from executed query.
`protected void`	`prepareQuery()` Prepares the query after initialization.
`protected java.lang.String`	`preprocessSql(java.lang.String sqlString)` Pre-process SQL before using it.
`static DbOomQuery`	`query(java.sql.Connection conn, DbSqlGenerator sqlgen)`
`static DbOomQuery`	`query(java.sql.Connection conn, java.lang.String sqlString)`
`static DbOomQuery`	`query(DbSession session, DbSqlGenerator sqlgen)`
`static DbOomQuery`	`query(DbSession session, java.lang.String sqlString)`
`static DbOomQuery`	`query(DbSqlGenerator sqlgen)`
`static DbOomQuery`	`query(java.lang.String sqlString)`
`Q`	`resetGeneratedColumns()` Resets creating generated columns.
`protected void`	`resolveColumnDbSqlType(java.sql.Connection connection, DbEntityColumnDescriptor dec)` Resolves column db sql type and populates it in column descriptor if missing.
`protected java.lang.Object`	`resolveRowResults(java.lang.Object[] row)` Prepares a row (array of rows mapped object) using hints.
`protected void`	`saveResultSet(java.sql.ResultSet rs)` Stores result set.
`Q`	`setConcurrencyType(QueryConcurrencyType concurrencyType)`
`Q`	`setDebug(boolean debug)`
`Q`	`setDebugMode()`
`Q`	`setFetchSize(int rows)` Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.
`Q`	`setGeneratedColumns(java.lang.String... columns)` Specifies columns which values will be generated by database.
`Q`	`setGeneratedKey()` Specifies that database will generate some columns values, usually the single id.
`Q`	`setHoldability(QueryHoldability holdability)`
`Q`	`setMaxRows(int maxRows)` Sets the limit for the maximum number of rows that any ResultSet object can contain to the given number.
`Q`	`setType(QueryScrollType type)`
`java.lang.String`	`toString()`
`Q`	`typeForwardOnly()`
`Q`	`typeScrollInsensitive()`
`Q`	`typeScrollSensitive()`
`DbOomQuery`	`withHints(java.lang.String... hints)` Specifies multiple hints for the query.
`DbOomQuery`	`withHints(java.lang.String hint)` Specifies hints for the query.

Methods inherited from class jodd.db.DbQuery
clearParameters, outBoolean, outBoolean, outByte, outByte, outDouble, outDouble, outFloat, outFloat, outInteger, outInteger, outLong, outLong, outString, outString, setArray, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setAsciiStream, setBatch, setBatch, setBatch, setBean, setBigDecimal, setBigDecimal, setBigInteger, setBigInteger, setBlob, setBlob, setBoolean, setBoolean, setBoolean, setBoolean, setByte, setByte, setByte, setByte, setBytes, setBytes, setCharacterStream, setCharacterStream, setClob, setClob, setDate, setDate, setDouble, setDouble, setDouble, setDouble, setFloat, setFloat, setFloat, setFloat, setInteger, setInteger, setInteger, setInteger, setLong, setLong, setLong, setLong, setMap, setNull, setNull, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setObject, setObjects, setObjects, setRef, setRef, setShort, setShort, setShort, setShort, setString, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, setURL

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

- Field Detail
  - sqlgen
```
protected final DbSqlGenerator sqlgen
```
  - hintResolver
```
protected JoinHintResolver hintResolver
```
  - hints
```
protected java.lang.String[] hints
```
  - cacheEntities
```
protected boolean cacheEntities
```
  - entityAwareMode
```
protected boolean entityAwareMode
```
  - dbOom
```
protected final DbOom dbOom
```
  - queryState
```
protected jodd.db.DbQueryBase.State queryState
```
  - connection
```
protected java.sql.Connection connection
```
  - session
```
protected DbSession session
```
  - sqlString
```
protected java.lang.String sqlString
```
  - statement
```
protected java.sql.Statement statement
```
  - preparedStatement
```
protected java.sql.PreparedStatement preparedStatement
```
  - callableStatement
```
protected java.sql.CallableStatement callableStatement
```
  - resultSets
```
protected java.util.Set<java.sql.ResultSet> resultSets
```
  - query
```
protected jodd.db.DbQueryParser query
```
  - forcePreparedStatement
```
protected boolean forcePreparedStatement
```
    If set to true all created statements will be prepared.
  - autoClose
```
protected boolean autoClose
```
  - type
```
protected QueryScrollType type
```
  - concurrencyType
```
protected QueryConcurrencyType concurrencyType
```
  - holdability
```
protected QueryHoldability holdability
```
  - debug
```
protected boolean debug
```
  - generatedColumns
```
protected java.lang.String[] generatedColumns
```
  - fetchSize
```
protected int fetchSize
```
  - maxRows
```
protected int maxRows
```
  - start
```
protected long start
```
  - elapsed
```
protected long elapsed
```
  - totalOpenResultSetCount
```
protected static int totalOpenResultSetCount
```
- Constructor Detail
  - DbOomQuery
```
public DbOomQuery(DbOom dbOom,
                  java.sql.Connection conn,
                  java.lang.String sqlString)
```
  - DbOomQuery
```
public DbOomQuery(DbOom dbOom,
                  DbSession session,
                  java.lang.String sqlString)
```
  - DbOomQuery
```
public DbOomQuery(DbOom dbOom,
                  java.lang.String sqlString)
```
  - DbOomQuery
```
public DbOomQuery(DbOom dbOom,
                  java.sql.Connection conn,
                  DbSqlGenerator sqlgen)
```
  - DbOomQuery
```
public DbOomQuery(DbOom dbOom,
                  DbSession session,
                  DbSqlGenerator sqlgen)
```
  - DbOomQuery
```
public DbOomQuery(DbOom dbOom,
                  DbSqlGenerator sqlgen)
```
- Method Detail
  - query
```
public static DbOomQuery query(java.sql.Connection conn,
                               java.lang.String sqlString)
```
  - query
```
public static DbOomQuery query(DbSession session,
                               java.lang.String sqlString)
```
  - query
```
public static DbOomQuery query(java.lang.String sqlString)
```
  - query
```
public static DbOomQuery query(java.sql.Connection conn,
                               DbSqlGenerator sqlgen)
```
  - query
```
public static DbOomQuery query(DbSession session,
                               DbSqlGenerator sqlgen)
```
  - query
```
public static DbOomQuery query(DbSqlGenerator sqlgen)
```
  - init
```
protected void init(DbOom dbOom)
```
  - prepareQuery
```
protected void prepareQuery()
```
    Prepares the query after initialization. Besides default work, it checks if sql generator is used, and if so, generator hints and query parameters will be used for this query. Note regarding hints: since hints can be added manually, generators hints will be ignored if there exists some manually set hints.
  - resolveColumnDbSqlType
```
protected void resolveColumnDbSqlType(java.sql.Connection connection,
                                      DbEntityColumnDescriptor dec)
```
    Resolves column db sql type and populates it in column descriptor if missing.
  - preprocessSql
```
protected java.lang.String preprocessSql(java.lang.String sqlString)
```
    Pre-process SQL before using it. If string starts with a non-ascii char or it has no spaces, it will be loaded from the query map.
  - withHints
```
public DbOomQuery withHints(java.lang.String hint)
```
    Specifies hints for the query. Provided string is split on ',' separator.
  - withHints
```
public DbOomQuery withHints(java.lang.String... hints)
```
    Specifies multiple hints for the query.
  - resolveRowResults
```
protected java.lang.Object resolveRowResults(java.lang.Object[] row)
```
    Prepares a row (array of rows mapped object) using hints. Returns either single object or objects array.
  - cacheEntities
```
public DbOomQuery cacheEntities(boolean cacheEntities)
```
    Defines if entities should be cached in ResultSetMapper. Overrides default value in DbEntityManager.
  - executeAndBuildResultSetMapper
```
protected ResultSetMapper executeAndBuildResultSetMapper()
```
    Executes the query and returns builded ResultSet mapper.
  - createResultSetMapper
```
protected ResultSetMapper createResultSetMapper(java.sql.ResultSet resultSet)
```
    Factory for result sets mapper.
  - entityAwareMode
```
public DbOomQuery entityAwareMode(boolean entityAware)
```
    Defines entity-aware mode for entities tracking in result collection.
  - iterate
```
public <T> java.util.Iterator<T> iterate(java.lang.Class... types)
```
  - iterate
```
public <T> java.util.Iterator<T> iterate()
```
  - iterate
```
protected <T> java.util.Iterator<T> iterate(java.lang.Class[] types,
                                            boolean close)
```
  - list
```
public <T> java.util.List<T> list(java.lang.Class... types)
```
  - list
```
public <T> java.util.List<T> list()
```
  - list
```
public <T> java.util.List<T> list(int max,
                                  java.lang.Class... types)
```
  - list
```
public <T> java.util.List<T> list(int max)
```
  - list
```
protected <T> java.util.List<T> list(java.lang.Class[] types,
                                     int max,
                                     boolean close)
```
    Iterates result set, maps rows to classes and populates resulting array list.
    
    Parameters:
    
    types - mapping types
    
    max - max number of rows to collect, -1 for all
    
    close - true if query is closed at the end, otherwise false.
    
    Returns:
    
    list of mapped entities or array of entities
  - listSet
```
public <T> java.util.Set<T> listSet(java.lang.Class... types)
```
  - listSet
```
public <T> java.util.Set<T> listSet()
```
  - listSet
```
public <T> java.util.Set<T> listSet(int max,
                                    java.lang.Class... types)
```
  - listSet
```
public <T> java.util.Set<T> listSet(int max)
```
  - listSet
```
protected <T> java.util.Set<T> listSet(java.lang.Class[] types,
                                       int max,
                                       boolean close)
```
  - find
```
public <T> T find(java.lang.Class... types)
```
  - find
```
public <T> T find()
```
  - find
```
protected <T> T find(java.lang.Class[] types,
                     boolean close,
                     java.sql.ResultSet resultSet)
```
  - findGeneratedKey
```
public <T> T findGeneratedKey(java.lang.Class<T> type)
```
    Finds generated key column of given type.
  - findGeneratedColumns
```
public java.lang.Object findGeneratedColumns(java.lang.Class... types)
```
    Finds generated columns.
  - populateGeneratedKeys
```
public void populateGeneratedKeys(java.lang.Object entity)
```
    Populates entity with generated column values from executed query.
  - autoClose
```
public DbOomQuery autoClose()
```
    Defines that query should be automatically closed immediately after using. Should be called before actual statement execution.
    
    Overrides:
    
    autoClose in class DbQuery<DbOomQuery>
  - close
```
protected void close(ResultSetMapper rsm,
                     boolean closeQuery)
```
    Closes results set or whole query.
  - _this
```
protected Q _this()
```
  - getQueryState
```
public jodd.db.DbQueryBase.State getQueryState()
```
    Returns query state.
  - checkNotClosed
```
protected void checkNotClosed()
```
    Checks if query is not closed and throws an exception if it is.
  - checkCreated
```
protected void checkCreated()
```
    Checks if query is created (and not yet initialized or closed) and throws an exception if it is not.
  - checkInitialized
```
protected void checkInitialized()
```
    Checks if query is initialized and throws an exception if it is not.
  - isClosed
```
public boolean isClosed()
```
    Returns true if query is closed.
  - isActive
```
public boolean isActive()
```
    Returns true if query is active: created and possibly initialized. Opened query may be not initialized.
  - isInitialized
```
public boolean isInitialized()
```
    Returns true if query is initialized. Initialized query is the one that has created JDBC statements.
  - getSession
```
public DbSession getSession()
```
    Returns used DbSession.
  - saveResultSet
```
protected void saveResultSet(java.sql.ResultSet rs)
```
    Stores result set.
  - forcePreparedStatement
```
public Q forcePreparedStatement()
```
    Forces creation of prepared statements.
  - init
```
public final void init()
```
    Initializes the query if not already initialized. Usually, user doesn't have to invoke it at all, since it will be called before all methods that deals directly with JDBC statement. Throws an exception if called on closed query.
  - initSession
```
protected void initSession(DbSession session)
```
    Initializes session. When not specified (i.e. is null), session is fetched from session provider.
  - initializeJdbc
```
protected void initializeJdbc()
```
    Performs JDBC initialization of the query. Obtains connection, parses the SQL query string and creates statements. Initialization is performed only once, when switching to initialized state.
  - closeAllResultSets
```
public Q closeAllResultSets()
```
    Closes all result sets created by this query. Query remains active.
  - closeQuery
```
protected java.sql.SQLException closeQuery()
```
    Closes all assigned result sets and then closes the query. Query becomes closed.
  - close
```
public void close()
```
    Closes the query and all created results sets and detaches itself from the session.
    
    Specified by:
    
    close in interface java.lang.AutoCloseable
  - closeResultSet
```
public void closeResultSet(java.sql.ResultSet rs)
```
    Closes single result set that was created by this query. It is not necessary to close result sets explicitly, since DbQueryBase.close() method closes all created result sets. Query remains active.
  - getType
```
public QueryScrollType getType()
```
  - setType
```
public Q setType(QueryScrollType type)
```
  - typeForwardOnly
```
public Q typeForwardOnly()
```
  - typeScrollSensitive
```
public Q typeScrollSensitive()
```
  - typeScrollInsensitive
```
public Q typeScrollInsensitive()
```
  - getConcurrencyType
```
public QueryConcurrencyType getConcurrencyType()
```
  - setConcurrencyType
```
public Q setConcurrencyType(QueryConcurrencyType concurrencyType)
```
  - concurrentReadOnly
```
public Q concurrentReadOnly()
```
  - concurrentUpdatable
```
public Q concurrentUpdatable()
```
  - getHoldability
```
public QueryHoldability getHoldability()
```
  - setHoldability
```
public Q setHoldability(QueryHoldability holdability)
```
  - holdCursorsOverCommit
```
public Q holdCursorsOverCommit()
```
  - closeCursorsAtCommit
```
public Q closeCursorsAtCommit()
```
  - isInDebugMode
```
public boolean isInDebugMode()
```
  - setDebug
```
public Q setDebug(boolean debug)
```
  - setDebugMode
```
public Q setDebugMode()
```
  - getGeneratedColumnNames
```
public java.lang.String[] getGeneratedColumnNames()
```
    Returns generated column names.
  - setGeneratedColumns
```
public Q setGeneratedColumns(java.lang.String... columns)
```
    Specifies columns which values will be generated by database.
  - setGeneratedKey
```
public Q setGeneratedKey()
```
    Specifies that database will generate some columns values, usually the single id.
  - resetGeneratedColumns
```
public Q resetGeneratedColumns()
```
    Resets creating generated columns.
  - getFetchSize
```
public int getFetchSize()
```
    Returns fetch size.
    
    See Also:
    
    setFetchSize(int)
  - setFetchSize
```
public Q setFetchSize(int rows)
```
    Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed. The number of rows specified affects only result sets created using this statement. If the value specified is zero, then the hint is ignored. The default value is zero.
    
    See Also:
    
    Statement.setFetchSize(int)
  - getMaxRows
```
public int getMaxRows()
```
    Returns max rows.
    
    See Also:
    
    setMaxRows(int)
  - setMaxRows
```
public Q setMaxRows(int maxRows)
```
    Sets the limit for the maximum number of rows that any ResultSet object can contain to the given number. If the limit is exceeded, the excess rows are silently dropped. Zero means there is no limit.
    
    See Also:
    
    Statement.setMaxRows(int)
  - getExecutionTime
```
public long getExecutionTime()
```
    Returns query execution elapsed time in milliseconds. Returns -1 if query is still not executed.
  - execute
```
public java.sql.ResultSet execute()
```
    Executes the query. If this method is invoked at least once, the query or all created ResultSets must be explicitly closed at the end of query usage. This can be done explicitly by calling DbQueryBase.closeResultSet(ResultSet) оr implicitly, during DbQueryBase.close().
    
    See Also:
    
    Statement.execute(String)
  - executeCall
```
public DbCallResult executeCall()
```
  - executeUpdate
```
public int executeUpdate()
```
    Executes UPDATE, INSERT or DELETE queries. Query is not closed afterwards unless auto close mode is set.
    
    See Also:
    
    Statement.executeUpdate(String)
  - executeUpdate
```
protected int executeUpdate(boolean closeQuery)
```
    Executes UPDATE, INSERT or DELETE queries and optionally closes the query.
    
    See Also:
    
    Statement.executeUpdate(String)
  - executeCount
```
public long executeCount()
```
    Special execute() for 'select count(*)' queries. Query is not closed after the execution unless auto-close mode is set. Doesn't check if query is really a count query, so it would work for any query that has number in the first column of result. If result set returns zero rows (very unlikely), returns -1.
  - executeCount
```
protected long executeCount(boolean close)
```
    Executes count queries and optionally closes query afterwards.
  - list
```
public <T> java.util.List<T> list(QueryMapper<T> queryMapper)
```
    Executes the query, iterates result set and maps each row.
  - find
```
public <T> T find(QueryMapper<T> queryMapper)
```
    Executes the query and maps single result row.
  - listSet
```
public <T> java.util.Set<T> listSet(QueryMapper<T> queryMapper)
```
    Executes the query, iterates all rows and maps them.
  - getGeneratedColumns
```
public java.sql.ResultSet getGeneratedColumns()
```
    Returns generated columns.
  - getGeneratedKey
```
public long getGeneratedKey()
```
    Returns generated key i.e. first generated column as long.
  - getGeneratedKeyObject
```
public java.lang.Object getGeneratedKeyObject()
```
  - getQueryString
```
public java.lang.String getQueryString()
```
    Returns query SQL string. For prepared statements, returned sql string with quick-and-dirty replaced values.
  - toString
```
public java.lang.String toString()
```
    Overrides:
    
    toString in class java.lang.Object
    
    See Also:
    
    getQueryString()
  - getTotalOpenResultSetCount
```
public static int getTotalOpenResultSetCount()
```
    Returns total number of open result sets.
    
    See Also:
    
    getOpenResultSetCount()
  - getOpenResultSetCount
```
public int getOpenResultSetCount()
```
    Returns number of created result sets that are still not explicitly closed.
    
    See Also:
    
    getTotalOpenResultSetCount()

Class DbOomQuery

Nested Class Summary

Field Summary

Constructor Summary

Method Summary

Methods inherited from class jodd.db.DbQuery

Methods inherited from class java.lang.Object

Field Detail

sqlgen

hintResolver

hints

cacheEntities

entityAwareMode

dbOom

queryState

connection

session

sqlString

statement

preparedStatement

callableStatement

resultSets

query

forcePreparedStatement

autoClose

type

concurrencyType

holdability

debug

generatedColumns

fetchSize

maxRows

start

elapsed

totalOpenResultSetCount

Constructor Detail

DbOomQuery

DbOomQuery

DbOomQuery

DbOomQuery

DbOomQuery

DbOomQuery

Method Detail

query

query

query

query

query

query

init

prepareQuery

resolveColumnDbSqlType

preprocessSql

withHints

withHints

resolveRowResults

cacheEntities

executeAndBuildResultSetMapper

createResultSetMapper

entityAwareMode

iterate

iterate

iterate

list

list

list

list

list

listSet

listSet

listSet

listSet

listSet

find

find

find

findGeneratedKey

findGeneratedColumns

populateGeneratedKeys

autoClose