org.olat.core.commons.persistence
Class DBQueryImpl

java.lang.Object
  org.olat.core.commons.persistence.DBQueryImpl

All Implemented Interfaces:

DBQuery

public class DBQueryImpl
extends java.lang.Object
implements DBQuery

A DBQueryImpl is a wrapper around a Hibernate Query object.

Author:

Andreas Ch. Kapp

Field Summary

static java.util.Map<java.lang.String,SimpleProbe>	listTableStatsMap_
static java.util.Set<java.lang.String>	registeredTables_

Constructor Summary

DBQueryImpl(org.hibernate.Query q)
Default construcotr.

Method Summary

int	executeUpdate(org.hibernate.FlushMode nullOrFlushMode) Execute the update or delete statement.
java.lang.String[]	getNamedParameters()
java.lang.String	getQueryString()
org.hibernate.type.Type[]	getReturnTypes()
java.util.Iterator	iterate()
java.util.List	list()
DBQuery	setBigDecimal(int position, java.math.BigDecimal number)
DBQuery	setBigDecimal(java.lang.String name, java.math.BigDecimal number)
DBQuery	setBinary(int position, byte[] val)
DBQuery	setBinary(java.lang.String name, byte[] val)
DBQuery	setBoolean(int position, boolean val)
DBQuery	setBoolean(java.lang.String name, boolean val)
DBQuery	setByte(int position, byte val)
DBQuery	setByte(java.lang.String name, byte val)
DBQuery	setCacheable(boolean cacheable)
DBQuery	setCacheRegion(java.lang.String cacheRegion)
DBQuery	setCalendar(int position, java.util.Calendar calendar)
DBQuery	setCalendar(java.lang.String name, java.util.Calendar calendar)
DBQuery	setCalendarDate(int position, java.util.Calendar calendar)
DBQuery	setCalendarDate(java.lang.String name, java.util.Calendar calendar)
DBQuery	setCharacter(int position, char val)
DBQuery	setCharacter(java.lang.String name, char val)
DBQuery	setDate(int position, java.util.Date date)
DBQuery	setDate(java.lang.String name, java.util.Date date)
DBQuery	setDouble(int position, double val)
DBQuery	setDouble(java.lang.String name, double val)
DBQuery	setEntity(int position, java.lang.Object val)
DBQuery	setEntity(java.lang.String name, java.lang.Object val)
DBQuery	setFirstResult(int firstResult)
DBQuery	setFloat(int position, float val)
DBQuery	setFloat(java.lang.String name, float val)
DBQuery	setInteger(int position, int val)
DBQuery	setInteger(java.lang.String name, int val)
DBQuery	setLocale(int position, java.util.Locale locale)
DBQuery	setLocale(java.lang.String name, java.util.Locale locale)
void	setLockMode(java.lang.String alias, org.hibernate.LockMode lockMode)
DBQuery	setLong(int position, long val)
DBQuery	setLong(java.lang.String string, long value)
DBQuery	setMaxResults(int maxResults)
DBQuery	setParameter(int position, java.lang.Object val)
DBQuery	setParameter(int position, java.lang.Object val, org.hibernate.type.Type type)
DBQuery	setParameter(java.lang.String name, java.lang.Object val)
DBQuery	setParameter(java.lang.String name, java.lang.Object val, org.hibernate.type.Type type)
DBQuery	setParameterList(java.lang.String name, java.util.Collection vals)
DBQuery	setParameterList(java.lang.String name, java.util.Collection vals, org.hibernate.type.Type type)
DBQuery	setParameterList(java.lang.String name, java.lang.Object[] vals)
DBQuery	setParameterList(java.lang.String name, java.lang.Object[] vals, org.hibernate.type.Type type)
DBQuery	setProperties(java.lang.Object bean)
DBQuery	setSerializable(int position, java.io.Serializable val)
DBQuery	setSerializable(java.lang.String name, java.io.Serializable val)
DBQuery	setShort(int position, short val)
DBQuery	setShort(java.lang.String name, short val)
DBQuery	setString(int position, java.lang.String val)
DBQuery	setString(java.lang.String string, java.lang.String value)
DBQuery	setText(int position, java.lang.String val)
DBQuery	setText(java.lang.String name, java.lang.String val)
DBQuery	setTime(int position, java.util.Date date)
DBQuery	setTime(java.lang.String name, java.util.Date date)
DBQuery	setTimeout(int timeout)
DBQuery	setTimestamp(int position, java.util.Date date)
DBQuery	setTimestamp(java.lang.String name, java.util.Date date)
java.lang.Object	uniqueResult()

Methods inherited from class java.lang.Object

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

Field Detail

listTableStatsMap_

public static final java.util.Map<java.lang.String,SimpleProbe> listTableStatsMap_

registeredTables_

public static final java.util.Set<java.lang.String> registeredTables_

Constructor Detail

DBQueryImpl

public DBQueryImpl(org.hibernate.Query q)

Default construcotr.

Parameters:

q -

Method Detail

setLong

public DBQuery setLong(java.lang.String string,
                       long value)

Specified by:

setLong in interface DBQuery

Returns:

See Also:

DBQuery.setLong(java.lang.String, long)

setString

public DBQuery setString(java.lang.String string,
                         java.lang.String value)

Specified by:

setString in interface DBQuery

Returns:

See Also:

DBQuery.setString(java.lang.String, java.lang.String)

setTime

public DBQuery setTime(java.lang.String name,
                       java.util.Date date)

Specified by:

setTime in interface DBQuery

Returns:

See Also:

DBQuery.setTime(java.lang.String, java.util.Date)

executeUpdate

public int executeUpdate(org.hibernate.FlushMode nullOrFlushMode)

Description copied from interface: DBQuery

Execute the update or delete statement. The semantics are compliant with the ejb3 Query.executeUpdate() method.

Specified by:

executeUpdate in interface DBQuery

Parameters:

nullOrFlushMode - either pass null if you don't want to set the FlushMode - otherwise pass the FlushMode you want to set on the query for execution

Returns:

the number of entities updated or deleted

See Also:

DBQuery.executeUpdate(FlushMode)

list

public java.util.List list()

Specified by:

list in interface DBQuery

Returns:

See Also:

DBQuery.list()

getNamedParameters

public java.lang.String[] getNamedParameters()

Specified by:

getNamedParameters in interface DBQuery

Returns:

See Also:

DBQuery.getNamedParameters()

getQueryString

public java.lang.String getQueryString()

Specified by:

getQueryString in interface DBQuery

Returns:

See Also:

DBQuery.getQueryString()

getReturnTypes

public org.hibernate.type.Type[] getReturnTypes()

Specified by:

getReturnTypes in interface DBQuery

Returns:

See Also:

DBQuery.getReturnTypes()

iterate

public java.util.Iterator iterate()

Returns:

iterator

setBigDecimal

public DBQuery setBigDecimal(int position,
                             java.math.BigDecimal number)

Specified by:

setBigDecimal in interface DBQuery

Returns:

See Also:

DBQuery.setBigDecimal(int, java.math.BigDecimal)

setBigDecimal

public DBQuery setBigDecimal(java.lang.String name,
                             java.math.BigDecimal number)

Specified by:

setBigDecimal in interface DBQuery

Returns:

See Also:

DBQuery.setBigDecimal(java.lang.String, java.math.BigDecimal)

setBinary

public DBQuery setBinary(int position,
                         byte[] val)

Specified by:

setBinary in interface DBQuery

Returns:

See Also:

DBQuery.setBinary(int, byte[])

setBinary

public DBQuery setBinary(java.lang.String name,
                         byte[] val)

Specified by:

setBinary in interface DBQuery

Returns:

See Also:

DBQuery.setBinary(java.lang.String, byte[])

setBoolean

public DBQuery setBoolean(int position,
                          boolean val)

Specified by:

setBoolean in interface DBQuery

Returns:

See Also:

DBQuery.setBoolean(int, boolean)

setBoolean

public DBQuery setBoolean(java.lang.String name,
                          boolean val)

Specified by:

setBoolean in interface DBQuery

Returns:

See Also:

DBQuery.setBoolean(java.lang.String, boolean)

setByte

public DBQuery setByte(int position,
                       byte val)

Specified by:

setByte in interface DBQuery

Returns:

See Also:

DBQuery.setByte(int, byte)

setByte

public DBQuery setByte(java.lang.String name,
                       byte val)

Specified by:

setByte in interface DBQuery

Returns:

See Also:

DBQuery.setByte(java.lang.String, byte)

setCacheable

public DBQuery setCacheable(boolean cacheable)

Specified by:

setCacheable in interface DBQuery

Returns:

See Also:

DBQuery.setCacheable(boolean)

setCacheRegion

public DBQuery setCacheRegion(java.lang.String cacheRegion)

Specified by:

setCacheRegion in interface DBQuery

Returns:

See Also:

DBQuery.setCacheRegion(java.lang.String)

setCalendar

public DBQuery setCalendar(int position,
                           java.util.Calendar calendar)

Specified by:

setCalendar in interface DBQuery

Returns:

See Also:

DBQuery.setCalendar(int, java.util.Calendar)

setCalendar

public DBQuery setCalendar(java.lang.String name,
                           java.util.Calendar calendar)

Specified by:

setCalendar in interface DBQuery

Returns:

See Also:

DBQuery.setCalendar(java.lang.String, java.util.Calendar)

setCalendarDate

public DBQuery setCalendarDate(int position,
                               java.util.Calendar calendar)

Specified by:

setCalendarDate in interface DBQuery

Returns:

See Also:

DBQuery.setCalendarDate(int, java.util.Calendar)

setCalendarDate

public DBQuery setCalendarDate(java.lang.String name,
                               java.util.Calendar calendar)

Specified by:

setCalendarDate in interface DBQuery

Returns:

See Also:

DBQuery.setCalendarDate(java.lang.String, java.util.Calendar)

setCharacter

public DBQuery setCharacter(int position,
                            char val)

Specified by:

setCharacter in interface DBQuery

Returns:

See Also:

DBQuery.setCharacter(int, char)

setCharacter

public DBQuery setCharacter(java.lang.String name,
                            char val)

Specified by:

setCharacter in interface DBQuery

Returns:

See Also:

DBQuery.setCharacter(java.lang.String, char)

setDate

public DBQuery setDate(int position,
                       java.util.Date date)

Specified by:

setDate in interface DBQuery

Returns:

See Also:

DBQuery.setDate(int, java.util.Date)

setDate

public DBQuery setDate(java.lang.String name,
                       java.util.Date date)

Specified by:

setDate in interface DBQuery

Returns:

See Also:

DBQuery.setDate(java.lang.String, java.util.Date)

setDouble

public DBQuery setDouble(int position,
                         double val)

Specified by:

setDouble in interface DBQuery

Returns:

See Also:

DBQuery.setDouble(int, double)

setDouble

public DBQuery setDouble(java.lang.String name,
                         double val)

Specified by:

setDouble in interface DBQuery

Returns:

See Also:

DBQuery.setDouble(java.lang.String, double)

setEntity

public DBQuery setEntity(int position,
                         java.lang.Object val)

Specified by:

setEntity in interface DBQuery

Returns:

See Also:

DBQuery.setEntity(int, java.lang.Object)

setEntity

public DBQuery setEntity(java.lang.String name,
                         java.lang.Object val)

Specified by:

setEntity in interface DBQuery

Returns:

See Also:

DBQuery.setEntity(java.lang.String, java.lang.Object)

setFirstResult

public DBQuery setFirstResult(int firstResult)

Specified by:

setFirstResult in interface DBQuery

Returns:

See Also:

DBQuery.setFirstResult(int)

setFloat

public DBQuery setFloat(int position,
                        float val)

Specified by:

setFloat in interface DBQuery

Returns:

See Also:

DBQuery.setFloat(int, float)

setFloat

public DBQuery setFloat(java.lang.String name,
                        float val)

Specified by:

setFloat in interface DBQuery

Returns:

See Also:

DBQuery.setFloat(java.lang.String, float)

setInteger

public DBQuery setInteger(int position,
                          int val)

Specified by:

setInteger in interface DBQuery

Returns:

See Also:

DBQuery.setInteger(int, int)

setInteger

public DBQuery setInteger(java.lang.String name,
                          int val)

Specified by:

setInteger in interface DBQuery

Returns:

See Also:

DBQuery.setInteger(java.lang.String, int)

setLocale

public DBQuery setLocale(int position,
                         java.util.Locale locale)

Specified by:

setLocale in interface DBQuery

Returns:

See Also:

DBQuery.setLocale(int, java.util.Locale)

setLocale

public DBQuery setLocale(java.lang.String name,
                         java.util.Locale locale)

Specified by:

setLocale in interface DBQuery

Returns:

See Also:

DBQuery.setLocale(java.lang.String, java.util.Locale)

setLockMode

public void setLockMode(java.lang.String alias,
                        org.hibernate.LockMode lockMode)

Specified by:

setLockMode in interface DBQuery

See Also:

DBQuery.setLockMode(java.lang.String, org.hibernate.LockMode)

setLong

public DBQuery setLong(int position,
                       long val)

Specified by:

setLong in interface DBQuery

Returns:

See Also:

DBQuery.setLong(int, long)

setMaxResults

public DBQuery setMaxResults(int maxResults)

Specified by:

setMaxResults in interface DBQuery

Returns:

See Also:

DBQuery.setMaxResults(int)

setParameter

public DBQuery setParameter(int position,
                            java.lang.Object val,
                            org.hibernate.type.Type type)

Specified by:

setParameter in interface DBQuery

Returns:

See Also:

DBQuery.setParameter(int, java.lang.Object, org.hibernate.type.Type)

setParameter

public DBQuery setParameter(int position,
                            java.lang.Object val)

Specified by:

setParameter in interface DBQuery

Returns:

See Also:

DBQuery.setParameter(int, java.lang.Object)

setParameter

public DBQuery setParameter(java.lang.String name,
                            java.lang.Object val,
                            org.hibernate.type.Type type)

Specified by:

setParameter in interface DBQuery

Returns:

See Also:

DBQuery.setParameter(java.lang.String, java.lang.Object, org.hibernate.type.Type)

setParameter

public DBQuery setParameter(java.lang.String name,
                            java.lang.Object val)

Specified by:

setParameter in interface DBQuery

Returns:

See Also:

DBQuery.setParameter(java.lang.String, java.lang.Object)

setParameterList

public DBQuery setParameterList(java.lang.String name,
                                java.util.Collection vals,
                                org.hibernate.type.Type type)

Specified by:

setParameterList in interface DBQuery

Returns:

See Also:

DBQuery.setParameterList(java.lang.String, java.util.Collection, org.hibernate.type.Type)

setParameterList

public DBQuery setParameterList(java.lang.String name,
                                java.util.Collection vals)

Specified by:

setParameterList in interface DBQuery

Returns:

See Also:

DBQuery.setParameterList(java.lang.String, java.util.Collection)

setParameterList

public DBQuery setParameterList(java.lang.String name,
                                java.lang.Object[] vals,
                                org.hibernate.type.Type type)

Specified by:

setParameterList in interface DBQuery

Returns:

See Also:

DBQuery.setParameterList(java.lang.String, java.lang.Object[], org.hibernate.type.Type)

setParameterList

public DBQuery setParameterList(java.lang.String name,
                                java.lang.Object[] vals)

Specified by:

setParameterList in interface DBQuery

Returns:

See Also:

DBQuery.setParameterList(java.lang.String, java.lang.Object[])

setProperties

public DBQuery setProperties(java.lang.Object bean)

Specified by:

setProperties in interface DBQuery

Returns:

See Also:

DBQuery.setProperties(java.lang.Object)

setSerializable

public DBQuery setSerializable(int position,
                               java.io.Serializable val)

Specified by:

setSerializable in interface DBQuery

Returns:

See Also:

DBQuery.setSerializable(int, java.io.Serializable)

setSerializable

public DBQuery setSerializable(java.lang.String name,
                               java.io.Serializable val)

Specified by:

setSerializable in interface DBQuery

Returns:

See Also:

DBQuery.setSerializable(java.lang.String, java.io.Serializable)

setShort

public DBQuery setShort(int position,
                        short val)

Specified by:

setShort in interface DBQuery

Returns:

See Also:

DBQuery.setShort(int, short)

setShort

public DBQuery setShort(java.lang.String name,
                        short val)

Specified by:

setShort in interface DBQuery

Returns:

See Also:

DBQuery.setShort(java.lang.String, short)

setString

public DBQuery setString(int position,
                         java.lang.String val)

Specified by:

setString in interface DBQuery

Returns:

See Also:

DBQuery.setString(int, java.lang.String)

setText

public DBQuery setText(int position,
                       java.lang.String val)

Specified by:

setText in interface DBQuery

Returns:

See Also:

DBQuery.setText(int, java.lang.String)

setText

public DBQuery setText(java.lang.String name,
                       java.lang.String val)

Specified by:

setText in interface DBQuery

Returns:

See Also:

DBQuery.setText(java.lang.String, java.lang.String)

setTime

public DBQuery setTime(int position,
                       java.util.Date date)

Specified by:

setTime in interface DBQuery

Returns:

See Also:

DBQuery.setTime(int, java.util.Date)

setTimeout

public DBQuery setTimeout(int timeout)

Specified by:

setTimeout in interface DBQuery

Returns:

See Also:

DBQuery.setTimeout(int)

setTimestamp

public DBQuery setTimestamp(int position,
                            java.util.Date date)

Specified by:

setTimestamp in interface DBQuery

Returns:

See Also:

DBQuery.setTimestamp(int, java.util.Date)

setTimestamp

public DBQuery setTimestamp(java.lang.String name,
                            java.util.Date date)

Specified by:

setTimestamp in interface DBQuery

Returns:

See Also:

DBQuery.setTimestamp(java.lang.String, java.util.Date)

uniqueResult

public java.lang.Object uniqueResult()

Specified by:

uniqueResult in interface DBQuery

Returns:

See Also:

DBQuery.uniqueResult()