|
|||||||||
PREV NEXT | FRAMES NO FRAMES |
abs([field])
acos([field])
Operator.AND
Operator.AND
CONNECT BY
clause to the query
CONNECT BY NOCYCLE
clause to the
query
Factory create = new Factory();
create.select(field1, field2)
.hint("/*+ALL_ROWS*/")
.from(table1)
.execute();
USING
clause
If this is not supported by your RDBMS, then jOOQ will try to simulate
this behaviour using the information provided in this query.
USING
clause
If this is not supported by your RDBMS, then jOOQ will try to simulate
this behaviour using the information provided in this query.
OrderProvider.addLimit(int, int)
with offset = 0
LIMIT
or TOP
clauses!
LIMIT
or TOP
clauses!
LIMIT
or TOP
clauses!
LIMIT
or TOP
clauses!
LIMIT
or TOP
clauses!
1
in SQL!
newRecord();
setRecord(record);
ON DUPLICATE KEY UPDATE
clause of this
INSERT
statement, where this is supported.
ON DUPLICATE KEY UPDATE
clause of this
INSERT
statement, where this is supported.
ON DUPLICATE KEY UPDATE
clause of
this INSERT
statement, where this is supported.
AES_DECRYPT()
function
AES_DECRYPT()
function
AES_ENCRYPT()
function
AES_ENCRYPT()
function
GROUP BY
context.QueryPart
that can create an aliased QueryPart of itselfOperator.AND
operator.
Operator.AND
operator.
Operator.AND
operator.
Operator.AND
operator
Operator.AND
operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
Operator.AND
operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
Operator.AND
operator.
Operator.AND
operator.
Operator.AND
operator.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator and proceed to the next step.
Operator.AND
operator.
Operator.AND
operator.
Operator.AND
operator.
Operator.AND
operator
Operator.AND
operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
Operator.AND
operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
...
- andExists(Select<?>) -
Method in interface org.jooq.Condition
- Combine this condition with an EXISTS clause using the
Operator.AND
operator.
- andExists(Select<?>) -
Method in interface org.jooq.DeleteConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND
operator
- andExists(Select<?>) -
Method in interface org.jooq.DivideByOnConditionStep
- Combine the currently assembled conditions with an
EXISTS
clause using the Operator.AND
operator.
- andExists(Select<?>) -
Method in interface org.jooq.MergeOnConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND
operator and proceed to the next step.
- andExists(Select<?>) -
Method in interface org.jooq.SelectConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND
operator and proceed to the next step.
- andExists(Select<?>) -
Method in interface org.jooq.SelectHavingConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND
operator and proceed to the next step.
- andExists(Select<?>) -
Method in interface org.jooq.SelectOnConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND
operator and proceed to the next step.
- andExists(Select<?>) -
Method in interface org.jooq.SimpleSelectConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND
operator and proceed to the next step.
- andExists(Select<?>) -
Method in interface org.jooq.TableOnConditionStep
- Combine the currently assembled conditions with an
EXISTS
clause using the Operator.AND
operator.
- andExists(Select<?>) -
Method in interface org.jooq.UpdateConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND
operator
- andFollowing(int) -
Method in interface org.jooq.WindowRowsAndStep
- Add a
...
- andNot(Condition) -
Method in interface org.jooq.Condition
- Combine this condition with a negated other one using the
Operator.AND
operator.
- andNot(Condition) -
Method in interface org.jooq.DeleteConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND
operator
- andNot(Condition) -
Method in interface org.jooq.DivideByOnConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND
operator.
- andNot(Condition) -
Method in interface org.jooq.MergeOnConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND
operator and proceed to the next step.
- andNot(Condition) -
Method in interface org.jooq.SelectConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND
operator and proceed to the next step.
- andNot(Condition) -
Method in interface org.jooq.SelectHavingConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND
operator and proceed to the next step.
- andNot(Condition) -
Method in interface org.jooq.SelectOnConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND
operator and proceed to the next step.
- andNot(Condition) -
Method in interface org.jooq.SimpleSelectConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND
operator and proceed to the next step.
- andNot(Condition) -
Method in interface org.jooq.TableOnConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND
operator.
- andNot(Condition) -
Method in interface org.jooq.UpdateConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND
operator
- andNotExists(Select<?>) -
Method in interface org.jooq.Condition
- Combine this condition with a NOT EXIST clause using the
Operator.AND
operator.
- andNotExists(Select<?>) -
Method in interface org.jooq.DeleteConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND
operator
- andNotExists(Select<?>) -
Method in interface org.jooq.DivideByOnConditionStep
- Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.AND
operator.
- andNotExists(Select<?>) -
Method in interface org.jooq.MergeOnConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND
operator and proceed to the next step.
- andNotExists(Select<?>) -
Method in interface org.jooq.SelectConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND
operator and proceed to the next step.
- andNotExists(Select<?>) -
Method in interface org.jooq.SelectHavingConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND
operator and proceed to the next step.
- andNotExists(Select<?>) -
Method in interface org.jooq.SelectOnConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND
operator and proceed to the next step.
- andNotExists(Select<?>) -
Method in interface org.jooq.SimpleSelectConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND
operator and proceed to the next step.
- andNotExists(Select<?>) -
Method in interface org.jooq.TableOnConditionStep
- Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.AND
operator.
- andNotExists(Select<?>) -
Method in interface org.jooq.UpdateConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND
operator
- andPreceding(int) -
Method in interface org.jooq.WindowRowsAndStep
- Add a
...
- andUnboundedFollowing() -
Method in interface org.jooq.WindowRowsAndStep
- Add a
...
- andUnboundedPreceding() -
Method in interface org.jooq.WindowRowsAndStep
- Add a
...
- ANSIDATE -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- ArrayRecord<E> - Interface in org.jooq
- A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally
providing some convenience methods
- ArrayRecordImpl<T> - Class in org.jooq.impl
- A common base class for Oracle ARRAY types
This type is for JOOQ INTERNAL USE only.
- ArrayRecordImpl(String, DataType<T>, Configuration) -
Constructor for class org.jooq.impl.ArrayRecordImpl
- Deprecated. - 2.0.5 [#1179] - Please regenerate your schema and use
ArrayRecordImpl.ArrayRecordImpl(Schema, String, DataType, Configuration)
instead
- ArrayRecordImpl(String, DataType<T>) -
Constructor for class org.jooq.impl.ArrayRecordImpl
- Deprecated. - 2.0.5 [#1179] - Please regenerate your schema and use
ArrayRecordImpl.ArrayRecordImpl(Schema, String, DataType)
instead
- ArrayRecordImpl(Schema, String, DataType<T>, Configuration) -
Constructor for class org.jooq.impl.ArrayRecordImpl
- Create an empty array record
- ArrayRecordImpl(Schema, String, DataType<T>) -
Constructor for class org.jooq.impl.ArrayRecordImpl
- Create an empty array record
- as(String) -
Method in interface org.jooq.AliasProvider
- Get an aliased QueryPart.
- as(String) -
Method in interface org.jooq.Field
- Create an alias for this field
- as(String) -
Method in class org.jooq.impl.CustomField
-
- as(String) -
Method in class org.jooq.impl.TableImpl
- Subclasses may override this method to provide custom aliasing
implementations
Get an aliased QueryPart.
- as(Class<P>) -
Method in class org.jooq.tools.reflect.Reflect
- Create a proxy for the wrapped object allowing to typesafely invoke
methods on it using a custom interface
- asArrayDataType(Class<A>) -
Method in interface org.jooq.DataType
- Retrieve the data type for an Oracle-style ARRAY of this data type
- asArrayDataType(Class<A>) -
Method in class org.jooq.impl.AbstractDataType
-
- asc() -
Method in interface org.jooq.Field
- Create an ascending sort field from this field
- ascii() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- ascii(String) -
Static method in class org.jooq.impl.Factory
- Get the ascii(field) function
- ascii(Field<String>) -
Static method in class org.jooq.impl.Factory
- Get the ascii(field) function
This renders the ascii function:
ascii([field])
- asConvertedDataType(Converter<? super T, U>) -
Method in interface org.jooq.DataType
- Retrieve the data type for a given converter
- asConvertedDataType(Converter<? super T, U>) -
Method in class org.jooq.impl.AbstractDataType
-
- ASEDataType<T> - Class in org.jooq.util.ase
- Supported data types for the
SQLDialect.ASE
dialect - ASEFactory - Class in org.jooq.util.ase
- A
SQLDialect.ASE
specific factory - ASEFactory(Connection, SchemaMapping) -
Constructor for class org.jooq.util.ase.ASEFactory
- Deprecated. - 2.0.5 - Use
ASEFactory.ASEFactory(Connection, Settings)
instead
- ASEFactory(Connection, Settings) -
Constructor for class org.jooq.util.ase.ASEFactory
- Create a factory with connection and a settings configured
- ASEFactory(Connection) -
Constructor for class org.jooq.util.ase.ASEFactory
- Create a factory with connection
- asEnumDataType(Class<E>) -
Method in interface org.jooq.DataType
- Retrieve the data type for a given enum data type
- asEnumDataType(Class<E>) -
Method in class org.jooq.impl.AbstractDataType
-
- asField() -
Method in interface org.jooq.FieldLike
- The underlying field representation of this object
This method is useful for things like
SELECT y.*, (SELECT a FROM x) FROM y
- asField(String) -
Method in interface org.jooq.FieldLike
- The underlying field representation of this object
This method is useful for things like
SELECT y.*, (SELECT a FROM x) [alias] FROM y
- asField() -
Method in class org.jooq.impl.AbstractRoutine
-
- asField(String) -
Method in class org.jooq.impl.AbstractRoutine
-
- asin() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- asin(Number) -
Static method in class org.jooq.impl.Factory
- Get the arc sine(field) function
- asin(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the arc sine(field) function
This renders the asin function where available:
asin([field])
- asMasterDataType(Class<M>) -
Method in interface org.jooq.DataType
- Retrieve the data type for a given master data type
- asMasterDataType(Class<M>) -
Method in class org.jooq.impl.AbstractDataType
-
- asTable() -
Method in interface org.jooq.TableLike
- The underlying table representation of this object
This method is useful for things like
SELECT * FROM (SELECT * FROM x WHERE x.a = '1') WHERE ...
- asTable(String) -
Method in interface org.jooq.TableLike
- The underlying aliased table representation of this object
This method is useful for things like
SELECT * FROM (SELECT * FROM x WHERE x.a = '1') [alias] WHERE ...
- atan() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- atan(Number) -
Static method in class org.jooq.impl.Factory
- Get the arc tangent(field) function
- atan(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the arc tangent(field) function
This renders the atan function where available:
atan([field])
- atan2(Number) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- atan2(Field<? extends Number>) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- atan2(Number, Number) -
Static method in class org.jooq.impl.Factory
- Get the atan2(field, y) function
- atan2(Number, Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the atan2(field, y) function
- atan2(Field<? extends Number>, Number) -
Static method in class org.jooq.impl.Factory
- Get the atan2(field, y) function
- atan2(Field<? extends Number>, Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the atan2(field, y) function
This renders the atan2 or atn2 function where available:
atan2([x], [y]) or
atn2([x], [y])
- attach(Configuration) -
Method in interface org.jooq.Attachable
- Attach this object to a new
Configuration
- attach(Attachable...) -
Method in interface org.jooq.FactoryOperations
- Attach this
Factory
to some attachables
- attach(Collection<Attachable>) -
Method in interface org.jooq.FactoryOperations
- Attach this
Factory
to some attachables
- attach(Configuration) -
Method in class org.jooq.impl.AbstractRoutine
-
- attach(Configuration) -
Method in class org.jooq.impl.CustomCondition
-
- attach(Configuration) -
Method in class org.jooq.impl.CustomField
- Subclasses may further override this method
By default, nothing is done on an attachment event.
- attach(Configuration) -
Method in class org.jooq.impl.CustomTable
- Subclasses may further override this method
By default, nothing is done on an attachment event.
- attach(Attachable...) -
Method in class org.jooq.impl.Factory
- Attach this
Factory
to some attachables
- attach(Collection<Attachable>) -
Method in class org.jooq.impl.Factory
- Attach this
Factory
to some attachables
- Attachable - Interface in org.jooq
- An object in jOOQ that can have an underlying
Configuration
attached
or detached. - AttachableInternal - Interface in org.jooq
- Base functionality declaration for all
Attachable
s
This interface is for JOOQ INTERNAL USE only. - avg() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- avg(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the average over a numeric field: avg(field)
- avgDistinct(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the average over a numeric field: avg(distinct field)
- avgOver() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
Batch
's DSL API.Query
objects that are being executed in batch mode, or
empty if the query is unknown or if there was no jOOQ Query
If a single Query
is executed in non-batch mode, this will
return an array of length 1
, containing that
Query
Query
is executed in non-batch mode, this will
return an array of length 1
, containing that
Query
this between minValue and maxValue
this between minValue and maxValue
Types.BIGINT
type
Types.BIGINT
type
Types.BINARY
type
QueryPart
.
QueryPart
's.
QueryPart
's.
QueryPart
to a PreparedStatement
This method is for JOOQ INTERNAL USE only.
QueryPart
to a PreparedStatement
This method is for JOOQ INTERNAL USE only.
BindContext
for the context of this factory
This will return an initialised bind context as such:
Context.declareFields()
== false
Context.declareTables()
== false
RenderContext for JOOQ INTERNAL USE only.
QueryPart
to a PreparedStatement
This method is for JOOQ INTERNAL USE only.
QueryPart
's and their contained
values to a PreparedStatement
's bind variables.BindContext
for the context of this factory
This will return an initialised bind context as such:
Context.declareFields()
== false
Context.declareTables()
== false
RenderContext for JOOQ INTERNAL USE only.
PreparedStatement
Available attributes from ExecuteContext
:
ExecuteContext.getConnection()
: The connection used for
execution
ExecuteContext.configuration()
: The execution configuration
ExecuteContext.query()
: The Query
object, if a
jOOQ query is being executed or null
otherwise
ExecuteContext.routine()
: The Routine
object, if
a jOOQ routine is being executed or null
otherwise
ExecuteContext.sql()
: The rendered SQL
statement
that is about to be executed, or null
if the
SQL
statement is unknown..
PreparedStatement
Available attributes from ExecuteContext
:
ExecuteContext.getConnection()
: The connection used for
execution
ExecuteContext.configuration()
: The execution configuration
ExecuteContext.query()
: The Query
object, if a
jOOQ query is being executed or null
otherwise
ExecuteContext.routine()
: The Routine
object, if
a jOOQ routine is being executed or null
otherwise
ExecuteContext.sql()
: The rendered SQL
statement
that is about to be executed, or null
if the
SQL
statement is unknown..
Types.BIT
type
BIT_COUNT(field)
function, counting the number of
bits that are set in this number.
BIT_COUNT(field)
function, counting the number of
bits that are set in this number.
Types.BLOB
type
Types.BOOLEAN
type
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
CASE x WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
CASE x WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
DataType
has to be
"guessed" from the jOOQ-configured data types.
RenderContext.castMode()
RenderContext.CastMode.SOME
for a list of dialects
ceil([field]) or
ceiling([field])
... or simulates it elsewhere using round:
round([field] + 0.499999999999999)
Types.CHAR
type
Types.CLOB
type
PreparedStatement
and
ResultSet
If you fetch all records from the underlying ResultSet
, jOOQ
Cursor
implementations will close themselves for you.
COALESCE(value1, value2, ... , value n)
function
COALESCE(field1, field2, ... , field n)
function
Returns the dialect's equivalent to COALESCE:
Oracle COALESCE
COMPRESS()
function
COMPRESS()
function
fields[0] || fields[1] || ...
- Condition - Interface in org.jooq
- A condition to be used in a query's where part
- condition(String) -
Static method in class org.jooq.impl.Factory
- Create a new condition holding plain SQL.
- condition(String, Object...) -
Static method in class org.jooq.impl.Factory
- Create a new condition holding plain SQL.
- ConditionProvider - Interface in org.jooq
- A common interface for all objects holding conditions (e.g. queries)
- Configuration - Interface in org.jooq
- The Configuration holds data about sql dialects and connections
- configuration() -
Method in interface org.jooq.ExecuteContext
- The configuration wrapped by this context
- ConfigurationProvider - Interface in org.jooq
- Deprecated. - 2.1.0 [#1191] - Use
ExecuteListener.start(ExecuteContext)
instead to provide
jOOQ with valid connections - ConfigurationRegistry - Class in org.jooq
- Deprecated. - 2.1.0 [#1191] - Use
ExecuteListener.start(ExecuteContext)
instead to provide
jOOQ with valid connections - ConfigurationRegistry() -
Constructor for class org.jooq.ConfigurationRegistry
- Deprecated.
- connectBy(Condition) -
Method in interface org.jooq.SelectConnectByStep
- Add an Oracle-specific
CONNECT BY
clause to the query
- connectBy(String) -
Method in interface org.jooq.SelectConnectByStep
- Add an Oracle-specific
CONNECT BY
clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- connectBy(String, Object...) -
Method in interface org.jooq.SelectConnectByStep
- Add an Oracle-specific
CONNECT BY
clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- connectByIsCycle() -
Static method in class org.jooq.impl.Factory
- Retrieve the Oracle-specific
CONNECT_BY_ISCYCLE
pseudo-field
(to be used along with CONNECT BY
clauses)
- connectByIsLeaf() -
Static method in class org.jooq.impl.Factory
- Retrieve the Oracle-specific
CONNECT_BY_ISLEAF
pseudo-field
(to be used along with CONNECT BY
clauses)
- connectByNoCycle(Condition) -
Method in interface org.jooq.SelectConnectByStep
- Add an Oracle-specific
CONNECT BY NOCYCLE
clause to the
query
- connectByNoCycle(String) -
Method in interface org.jooq.SelectConnectByStep
- Add an Oracle-specific
CONNECT BY NOCYCLE
clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- connectByNoCycle(String, Object...) -
Method in interface org.jooq.SelectConnectByStep
- Add an Oracle-specific
CONNECT BY NOCYCLE
clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- Constants - Class in org.jooq
- Some publicly available constants used in jOOQ
- contains(T) -
Method in interface org.jooq.Field
- Convenience method for
Field.like(String, char)
including proper
adding of wildcards and escaping
SQL: this like ('%' || escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance
val(1133).contains(13)
If you're using SQLDialect.POSTGRES
, then you can use this method also to express the "ARRAY contains" operator.
- contains(Field<T>) -
Method in interface org.jooq.Field
- Convenience method for
Field.like(String, char)
including proper
adding of wildcards and escaping
SQL: this like ('%' || escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance
val(1133).contains(13)
If you're using SQLDialect.POSTGRES
, then you can use this method also to express the "ARRAY contains" operator.
- containsAny(String, char...) -
Static method in class org.jooq.tools.StringUtils
- Checks if the String contains any character in the given
set of characters.
- Context<C extends Context<C>> - Interface in org.jooq
- A context type that is used for rendering SQL or for binding
This interface is for JOOQ INTERNAL USE only.
- convert(Object) -
Method in interface org.jooq.DataType
- Convert an arbitrary object into
<T>
- convert(Object) -
Method in class org.jooq.impl.AbstractDataType
-
- Convert - Class in org.jooq.tools
- Utility methods for type conversions
This class provides less type-safety than the general jOOQ API methods.
- convert(Object, Converter<?, U>) -
Static method in class org.jooq.tools.Convert
- Convert an object to a type.
- convert(Object, Class<? extends T>) -
Static method in class org.jooq.tools.Convert
- Convert an object to a type.
- convert(List<?>, Class<? extends T>) -
Static method in class org.jooq.tools.Convert
- Convert a list of objects to a list of
T
, using
Convert.convert(Object, Class)
- convert(List<?>, Converter<?, U>) -
Static method in class org.jooq.tools.Convert
- Convert a list of objects to a list of
T
, using
Convert.convert(Object, Converter)
- convertArray(Object[], Converter<?, U>) -
Static method in class org.jooq.tools.Convert
- Convert an array into another one using a converter
This uses
Convert.convertArray(Object[], Class)
to convert the array to
an array of Converter.fromType()
first, before converting that
array again to Converter.toType()
- convertArray(Object[], Class<?>) -
Static method in class org.jooq.tools.Convert
- Convert an array into another one by these rules
If
toClass
is not an array class, then make it an array
class first
If toClass
is an array class, then create an instance
from it, and convert all elements in the from
array one by
one, using Convert.convert(Object, Class)
- Converter<T,U> - Interface in org.jooq
- A
Converter
for data types. - copy() -
Method in class org.jooq.impl.UpdatableRecordImpl
-
- copy() -
Method in interface org.jooq.UpdatableRecord
- Duplicate this record (in memory) and reset all fields from the primary
key or main unique key, such that a subsequent call to
UpdatableRecord.store()
will result in an INSERT
statement.
- cos() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- cos(Number) -
Static method in class org.jooq.impl.Factory
- Get the cosine(field) function
- cos(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the cosine(field) function
This renders the cos function where available:
cos([field])
- cosh() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- cosh(Number) -
Static method in class org.jooq.impl.Factory
- Get the hyperbolic cosine function: cosh(field)
- cosh(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the hyperbolic cosine function: cosh(field)
This renders the cosh function where available:
cosh([field])
... or simulates it elsewhere using
exp: (exp([field] * 2) + 1) / (exp([field] * 2))
- cot() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- cot(Number) -
Static method in class org.jooq.impl.Factory
- Get the cotangent(field) function
- cot(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the cotangent(field) function
This renders the cot function where available:
cot([field])
... or simulates it elsewhere using
sin and cos: cos([field]) / sin([field])
- coth() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- coth(Number) -
Static method in class org.jooq.impl.Factory
- Get the hyperbolic cotangent function: coth(field)
- coth(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the hyperbolic cotangent function: coth(field)
This is not supported by any RDBMS, but simulated using exp exp:
(exp([field] * 2) + 1) / (exp([field] * 2) - 1)
- count() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- count() -
Static method in class org.jooq.impl.Factory
- Get the count(*) function
- count(Field<?>) -
Static method in class org.jooq.impl.Factory
- Get the count(field) function
- countDistinct() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- countDistinct(Field<?>) -
Static method in class org.jooq.impl.Factory
- Get the count(distinct field) function
- countMatches(String, String) -
Static method in class org.jooq.tools.StringUtils
-
Counts how many times the substring appears in the larger String.
- countOver() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- create() -
Method in class org.jooq.tools.reflect.Reflect
- Call a constructor.
- create(Object...) -
Method in class org.jooq.tools.reflect.Reflect
- Call a constructor.
- createArray() -
Method in interface org.jooq.ArrayRecord
- Create an
Array
from this ArrayRecord
This method is for INTERNAL use only.
- createArray() -
Method in class org.jooq.impl.ArrayRecordImpl
-
- createField(String, DataType<T>, UDT<R>) -
Static method in class org.jooq.impl.UDTImpl
- Subclasses may call this method to create
UDTField
objects that
are linked to this table.
- createForeignKey(UniqueKey<U>, Table<R>, TableField<R, ?>...) -
Static method in class org.jooq.impl.AbstractKeys
- Factory method for foreign keys
- createIdentity(Table<R>, TableField<R, T>) -
Static method in class org.jooq.impl.AbstractKeys
- Factory method for identities
- createParameter(String, DataType<T>) -
Static method in class org.jooq.impl.AbstractRoutine
- Subclasses may call this method to create
UDTField
objects that
are linked to this table.
- createParameter(String, DataType<T>, boolean) -
Static method in class org.jooq.impl.AbstractRoutine
- Subclasses may call this method to create
UDTField
objects that
are linked to this table.
- createUniqueKey(Table<R>, TableField<R, ?>...) -
Static method in class org.jooq.impl.AbstractKeys
- Factory method for unique keys
- crossJoin(TableLike<?>) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
CROSS JOIN
a table to the last table
added to the FROM
clause using
Table.crossJoin(TableLike)
If this syntax is unavailable, it is simulated with a regular
INNER JOIN
.
- crossJoin(String) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
CROSS JOIN
a table to the last table
added to the FROM
clause using
Table.crossJoin(String)
If this syntax is unavailable, it is simulated with a regular
INNER JOIN
.
- crossJoin(String, Object...) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
CROSS JOIN
a table to the last table
added to the FROM
clause using
Table.crossJoin(String, Object...)
- crossJoin(TableLike<?>) -
Method in interface org.jooq.Table
CROSS JOIN
a table to this table.
- crossJoin(String) -
Method in interface org.jooq.Table
CROSS JOIN
a table to this table.
- crossJoin(String, Object...) -
Method in interface org.jooq.Table
CROSS JOIN
a table to this table.
- CSVParser - Class in org.jooq.tools.csv
- A very simple CSV parser released under a commercial-friendly license.
- CSVParser() -
Constructor for class org.jooq.tools.csv.CSVParser
- Constructs CSVParser using a comma for the separator.
- CSVParser(char) -
Constructor for class org.jooq.tools.csv.CSVParser
- Constructs CSVParser with supplied separator.
- CSVParser(char, char) -
Constructor for class org.jooq.tools.csv.CSVParser
- Constructs CSVParser with supplied separator and quote char.
- CSVParser(char, char, char) -
Constructor for class org.jooq.tools.csv.CSVParser
- Constructs CSVReader with supplied separator and quote char.
- CSVParser(char, char, char, boolean) -
Constructor for class org.jooq.tools.csv.CSVParser
- Constructs CSVReader with supplied separator and quote char.
- CSVParser(char, char, char, boolean, boolean) -
Constructor for class org.jooq.tools.csv.CSVParser
- Constructs CSVReader with supplied separator and quote char.
- CSVReader - Class in org.jooq.tools.csv
- A very simple CSV reader released under a commercial-friendly license.
- CSVReader(Reader) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader using a comma for the separator.
- CSVReader(Reader, char) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator.
- CSVReader(Reader, char, char) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator and quote char.
- CSVReader(Reader, char, char, boolean) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator, quote char and quote
handling behavior.
- CSVReader(Reader, char, char, char) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator and quote char.
- CSVReader(Reader, char, char, int) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator and quote char.
- CSVReader(Reader, char, char, char, int) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator and quote char.
- CSVReader(Reader, char, char, char, int, boolean) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator and quote char.
- CSVReader(Reader, char, char, char, int, boolean, boolean) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator and quote char.
- cube(Field<?>...) -
Static method in class org.jooq.impl.Factory
- Create a CUBE(field1, field2, .., fieldn) grouping field
This has been observed to work with the following databases:
DB2
Oracle
SQL Server
Sybase SQL Anywhere
Please check the SQL Server documentation for a very nice explanation of
CUBE
, ROLLUP
, and GROUPING SETS
clauses in grouping contexts: http://msdn.microsoft.com/en-US/library/bb522495.aspx
- CUBRIDDataType<T> - Class in org.jooq.util.cubrid
- Supported data types for the
SQLDialect.CUBRID
dialect - CUBRIDFactory - Class in org.jooq.util.cubrid
- A
SQLDialect.CUBRID
specific factory - CUBRIDFactory(Connection, SchemaMapping) -
Constructor for class org.jooq.util.cubrid.CUBRIDFactory
- Deprecated. - 2.0.5 - Use
CUBRIDFactory.CUBRIDFactory(Connection, Settings)
instead
- CUBRIDFactory(Connection, Settings) -
Constructor for class org.jooq.util.cubrid.CUBRIDFactory
- Create a factory with connection and a settings configured
- CUBRIDFactory(Connection) -
Constructor for class org.jooq.util.cubrid.CUBRIDFactory
- Create a factory with connection
- cumeDist() -
Static method in class org.jooq.impl.Factory
- The
cume_dist() over ([analytic clause])
function.
- currentDate() -
Static method in class org.jooq.impl.Factory
- Get the current_date() function
This translates into any dialect
- currentTime() -
Static method in class org.jooq.impl.Factory
- Get the current_time() function
This translates into any dialect
- currentTimestamp() -
Static method in class org.jooq.impl.Factory
- Get the current_timestamp() function
This translates into any dialect
- currentUser() -
Static method in class org.jooq.impl.Factory
- Get the current_user() function
This translates into any dialect
- currval(Sequence<T>) -
Method in interface org.jooq.FactoryOperations
- Convenience method to fetch the CURRVAL for a sequence directly from this
Factory
's underlying JDBC Connection
- currval(Sequence<T>) -
Method in class org.jooq.impl.Factory
- Convenience method to fetch the CURRVAL for a sequence directly from this
Factory
's underlying JDBC Connection
- currval() -
Method in class org.jooq.impl.SequenceImpl
-
- currval() -
Method in interface org.jooq.Sequence
- Get the current value of this sequence
- Cursor<R extends Record> - Interface in org.jooq
- Cursors allow for lazy, sequential access to an underlying JDBC
ResultSet
. - CustomCondition - Class in org.jooq.impl
- A base class for custom
Condition
implementations in client code. - CustomCondition() -
Constructor for class org.jooq.impl.CustomCondition
-
- CustomField<T> - Class in org.jooq.impl
- A base class for custom
Field
implementations in client code. - CustomField(String, DataType<T>) -
Constructor for class org.jooq.impl.CustomField
-
- CustomRecord<R extends TableRecord<R>> - Class in org.jooq.impl
- A base class for custom
TableRecord
implementations in client code. - CustomRecord(Table<R>) -
Constructor for class org.jooq.impl.CustomRecord
-
- CustomTable<R extends TableRecord<R>> - Class in org.jooq.impl
- A base class for custom
Table
implementations in client code. - CustomTable(String) -
Constructor for class org.jooq.impl.CustomTable
-
- CustomTable(String, Schema) -
Constructor for class org.jooq.impl.CustomTable
-
DataAccessException
is a generic RuntimeException
indicating that something went wrong while executing a SQL statement from
jOOQ.Types.DATE
type
Factory.extract(java.util.Date, DatePart)
with DatePart.DAY
Factory.extract(Field, DatePart)
with DatePart.DAY
INTERVAL DAY TO SECOND
data type.SQLDialect.DB2
dialectSQLDialect.DB2
specific factoryDB2Factory.DB2Factory(Connection, Settings)
instead
Types.DECIMAL
type
Types.DECIMAL
type
Field
in the SELECT
clause of the query).
Context.declareFields()
QueryPart
is able to declare fields in a
SELECT
clause.
QueryPart
is able to declare tables in a
FROM
clause or JOIN
clause.
Table
in the FROM
or JOIN
clause of the
query).
Context.declareTables()
Case
statement.
DECODE(expression, search, result[, search , result]... [, default])
function
DECODE(expression, search, result[, search , result]... [, default])
function
DECODE(expression, search, result[, search , result]... [, default])
function
DECODE(expression, search, result[, search , result]... [, default])
function
Returns the dialect's equivalent to DECODE:
Oracle DECODE
Other dialects:
CASE WHEN [this = search] THEN [result],
[WHEN more...
- decode(String, String) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DECODE()
function
Don't mix this up with the various Factory.decode()
methods!
- decode(Field<String>, Field<String>) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DECODE()
function
Don't mix this up with the various Factory.decode()
methods!
- DEFAULT_ESCAPE_CHARACTER -
Static variable in class org.jooq.tools.csv.CSVParser
- The default escape character to use if none is supplied to the
constructor.
- DEFAULT_IGNORE_LEADING_WHITESPACE -
Static variable in class org.jooq.tools.csv.CSVParser
- The default leading whitespace behavior to use if none is supplied to the
constructor
- DEFAULT_QUOTE_CHARACTER -
Static variable in class org.jooq.tools.csv.CSVParser
- The default quote character to use if none is supplied to the
constructor.
- DEFAULT_SEPARATOR -
Static variable in class org.jooq.tools.csv.CSVParser
- The default separator to use if none is supplied to the constructor.
- DEFAULT_SKIP_LINES -
Static variable in class org.jooq.tools.csv.CSVReader
- The default line to start reading.
- DEFAULT_STRICT_QUOTES -
Static variable in class org.jooq.tools.csv.CSVParser
- The default strict quote behavior to use if none is supplied to the
constructor
- DefaultExecuteListener - Class in org.jooq.impl
- A publicly available default implementation of
ExecuteListener
. - DefaultExecuteListener() -
Constructor for class org.jooq.impl.DefaultExecuteListener
-
- defaultIfEmpty(String, String) -
Static method in class org.jooq.tools.StringUtils
- Returns either the passed in String, or if the String is
empty or
null
, the value of defaultStr
.
- defaultSchema -
Variable in class org.jooq.conf.RenderMapping
-
- defaultSettings() -
Static method in class org.jooq.conf.SettingsTools
- Retrieve the configured default settings
If the JVM flag
-Dorg.jooq.settings
points to a valid
settings file on the classpath, this will be loaded
If the JVM flag -Dorg.jooq.settings
points to a valid
settings file on the file system, this will be loaded
If a valid settings file is found on the classpath at
/jooq-settings.xml
, this will be loaded
Otherwise, a new Settings
object is created with its
defaults
- defaultString(String) -
Static method in class org.jooq.tools.StringUtils
-
Returns either the passed in String, or if the String is
null
, an empty String ("").
- defaultString(String, String) -
Static method in class org.jooq.tools.StringUtils
- Returns either the passed in String, or if the String is
null
, the value of defaultStr
.
- deg() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- deg(Number) -
Static method in class org.jooq.impl.Factory
- Calculate degrees from radians from this field
- deg(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Calculate degrees from radians from this field
This renders the degrees function where available:
degrees([field])
... or simulates it elsewhere:
[field] * 180 / PI
- Delete<R extends Record> - Interface in org.jooq
- A
Query
that can delete data in the database. - delete(Table<R>) -
Method in interface org.jooq.FactoryOperations
- Create a new DSL delete statement.
- delete(Table<R>) -
Method in class org.jooq.impl.Factory
- Create a new DSL delete statement.
- delete() -
Method in class org.jooq.impl.UpdatableRecordImpl
-
- delete() -
Method in interface org.jooq.UpdatableRecord
- Deletes this record from the database, based on the value of the primary
key or main unique key.
- DeleteConditionStep<R extends Record> - Interface in org.jooq
- This type is used for the
Delete
's DSL API. - DeleteFinalStep<R extends Record> - Interface in org.jooq
- This type is used for the
Delete
's DSL API. - DeleteQuery<R extends Record> - Interface in org.jooq
- A query used for deletion of data
- deleteQuery(Table<R>) -
Method in interface org.jooq.FactoryOperations
- Create a new
DeleteQuery
- deleteQuery(Table<R>) -
Method in class org.jooq.impl.Factory
- Create a new
DeleteQuery
- deleteUsing(TableField<R, ?>...) -
Method in class org.jooq.impl.TableRecordImpl
-
- deleteUsing(TableField<R, ?>...) -
Method in interface org.jooq.TableRecord
- Deletes this record from the database, based on the value of the provided
keys.
- deleteWhere(Condition) -
Method in interface org.jooq.MergeMatchedDeleteStep
- Add an additional
DELETE WHERE
clause to the preceding
WHEN MATCHED THEN UPDATE
clause.
- DeleteWhereStep<R extends Record> - Interface in org.jooq
- This type is used for the
Delete
's DSL API. - denseRank() -
Static method in class org.jooq.impl.Factory
- The
dense_rank() over ([analytic clause])
function.
- DerbyDataType<T> - Class in org.jooq.util.derby
- Supported data types for the
SQLDialect.DERBY
dialect - DerbyFactory - Class in org.jooq.util.derby
- A
SQLDialect.DERBY
specific factory - DerbyFactory(Connection, SchemaMapping) -
Constructor for class org.jooq.util.derby.DerbyFactory
- Deprecated. - 2.0.5 - Use
DerbyFactory.DerbyFactory(Connection, Settings)
instead
- DerbyFactory(Connection, Settings) -
Constructor for class org.jooq.util.derby.DerbyFactory
- Create a factory with connection and a settings configured
- DerbyFactory(Connection) -
Constructor for class org.jooq.util.derby.DerbyFactory
- Create a factory with connection
- desc() -
Method in interface org.jooq.Field
- Create a descending sort field from this field
- desDecrypt(String) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_DECRYPT()
function
- desDecrypt(Field<String>) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_DECRYPT()
function
- desDecrypt(String, String) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_DECRYPT()
function
- desDecrypt(Field<String>, Field<String>) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_DECRYPT()
function
- desEncrypt(String) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_ENCRYPT()
function
- desEncrypt(Field<String>) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_ENCRYPT()
function
- desEncrypt(String, String) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_ENCRYPT()
function
- desEncrypt(Field<String>, Field<String>) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_ENCRYPT()
function
- DetachedException - Exception in org.jooq.exception
- An operation was invoked on a detached object (
Query
,
QueryPart
, or UpdatableRecord
). - DetachedException(String) -
Constructor for exception org.jooq.exception.DetachedException
- Constructor for DetachedException.
- div(Number) -
Method in interface org.jooq.Field
- An arithmetic expression dividing this by value
If this is a numeric field, then the result is a number of the same
type as this field.
- div(Field<? extends Number>) -
Method in interface org.jooq.Field
- An arithmetic expression dividing this by value
If this is a numeric field, then the result is a number of the same
type as this field.
- divideBy(Table<?>) -
Method in interface org.jooq.Table
- Create a new
TABLE
reference from this table, applying
relational division.
- DivideByOnConditionStep - Interface in org.jooq
- An intermediate type for the construction of a relational division.
- DivideByOnStep - Interface in org.jooq
- An intermediate type for the construction of a relational division
- DivideByReturningStep - Interface in org.jooq
- An intermediate type for the construction of a relational division
- DOUBLE -
Static variable in class org.jooq.impl.SQLDataType
- The
Types.DOUBLE
type
- DOUBLE -
Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- DOUBLE -
Static variable in class org.jooq.util.db2.DB2DataType
-
- DOUBLE -
Static variable in class org.jooq.util.derby.DerbyDataType
-
- DOUBLE -
Static variable in class org.jooq.util.h2.H2DataType
-
- DOUBLE -
Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- DOUBLE -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- DOUBLE -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- DOUBLE -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- DOUBLE_PRECISION -
Static variable in class org.jooq.util.ase.ASEDataType
-
- DOUBLE_PRECISION -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- DOUBLEPRECISION -
Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- DOUBLEPRECISION -
Static variable in class org.jooq.util.derby.DerbyDataType
-
- DOUBLEPRECISION -
Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- DOUBLEPRECISION -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- DOUBLEPRECISION -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- DOUBLEPRECISION -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- doubleValue() -
Method in class org.jooq.tools.unsigned.UByte
-
- doubleValue() -
Method in class org.jooq.tools.unsigned.UInteger
-
- doubleValue() -
Method in class org.jooq.tools.unsigned.ULong
-
- doubleValue() -
Method in class org.jooq.tools.unsigned.UShort
-
- doubleValue() -
Method in class org.jooq.types.DayToSecond
-
- doubleValue() -
Method in interface org.jooq.types.Interval
-
- doubleValue() -
Method in class org.jooq.types.YearToMonth
-
E
literal (Euler number)
This will be any of the following:
The underlying RDBMS' E
literal or E()
function
Math.E
""
.
ENCODE()
function
ENCODE()
function
Field.like(String, char)
including proper
adding of wildcards and escaping
SQL: this like ('%' || escape(value, '\')) escape '\'
Note: This also works with numbers, for instance
val(1133).endsWith(33)
Field.like(String, char)
including proper
adding of wildcards and escaping
SQL: this like ('%' || escape(value, '\')) escape '\'
Note: This also works with numbers, for instance
val(1133).endsWith(33)
EnumType
by its MySQL-specific index
If your MySQL enum type contains these three values: A, B, C
, then this will be the mapping of indexes to values:
|
|||||||||
PREV NEXT | FRAMES NO FRAMES |