|
|||||||||
| 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
Attachables
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() == falseContext.declareTables() == falseQueryPart 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() == falseContext.declareTables() == falsePreparedStatement
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 | ||||||||