org.jooq.impl

Class TableImpl<R extends Record>

java.lang.Object

org.jooq.impl.TableImpl<R>

All Implemented Interfaces:

java.io.Serializable, QueryPart, QueryPartInternal, Table<R>, TableLike<R>

Direct Known Subclasses:

CustomTable

public class TableImpl<R extends Record>
extends java.lang.Object

A common base type for tables

This type is for JOOQ INTERNAL USE only. Do not reference directly

Author:

Lukas Eder

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
protected Field<?>[]	parameters

Constructor Summary

Constructors

Constructor and Description
TableImpl(java.lang.String name)
TableImpl(java.lang.String name, Schema schema)
TableImpl(java.lang.String name, Schema schema, Table<R> aliased)
TableImpl(java.lang.String name, Schema schema, Table<R> aliased, Field<?>[] parameters)
TableImpl(java.lang.String name, Schema schema, Table<R> aliased, Field<?>[] parameters, java.lang.String comment)

Method Summary

Modifier and Type	Method and Description
void	accept(Context<?> ctx) This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
Table<R>	as(java.lang.String as) Subclasses may override this method to provide custom aliasing implementations Create an alias for this table.
Table<R>	as(java.lang.String as, java.lang.String... fieldAliases) Subclasses may override this method to provide custom aliasing implementations Create an alias for this table and its fields Note that the case-sensitivity of the returned table and columns depends on Settings.getRenderNameStyle().
Table<R>	asOfScn(Field<? extends java.lang.Number> scn) Create an SQLDialect.ORACLE flashback query clause from this table.
Table<R>	asOfScn(java.lang.Number scn) Create an SQLDialect.ORACLE flashback query clause from this table.
Table<R>	asOfTimestamp(Field<java.sql.Timestamp> timestamp) Create an SQLDialect.ORACLE flashback query clause from this table.
Table<R>	asOfTimestamp(java.sql.Timestamp timestamp) Create an SQLDialect.ORACLE flashback query clause from this table.
Table<R>	asTable() The underlying table representation of this object This method is useful for things like SELECT * FROM (SELECT * FROM x WHERE x.a = '1') WHERE ...
Table<R>	asTable(java.lang.String alias) The underlying aliased table representation of this object
Table<R>	asTable(java.lang.String alias, java.lang.String... fieldAliases) The underlying aliased table representation of this object
void	bind(BindContext ctx) Deprecated.
Clause[]	clauses(Context<?> ctx) The Clauses that are represented by this query part.
protected DSLContext	create() Internal convenience method
protected DSLContext	create(Configuration configuration) Internal convenience method
protected DSLContext	create(Context<?> ctx) Internal convenience method
protected <T> TableField<R,T>	createField(java.lang.String name, DataType<T> type) Subclasses may call this method to create TableField objects that are linked to this table.
protected <T> TableField<R,T>	createField(java.lang.String name, DataType<T> type, java.lang.String comment) Subclasses may call this method to create TableField objects that are linked to this table.
protected <T,U> TableField<R,U>	createField(java.lang.String name, DataType<T> type, java.lang.String comment, Binding<T,U> binding) Subclasses may call this method to create TableField objects that are linked to this table.
protected <T,U> TableField<R,U>	createField(java.lang.String name, DataType<T> type, java.lang.String comment, Converter<T,U> converter) Subclasses may call this method to create TableField objects that are linked to this table.
protected <T,X,U> TableField<R,U>	createField(java.lang.String name, DataType<T> type, java.lang.String comment, Converter<X,U> converter, Binding<T,X> binding) Subclasses may call this method to create TableField objects that are linked to this table.
protected static <R extends Record,T> TableField<R,T>	createField(java.lang.String name, DataType<T> type, Table<R> table) Subclasses may call this method to create TableField objects that are linked to this table.
protected static <R extends Record,T> TableField<R,T>	createField(java.lang.String name, DataType<T> type, Table<R> table, java.lang.String comment) Subclasses may call this method to create TableField objects that are linked to this table.
protected static <R extends Record,T,U> TableField<R,U>	createField(java.lang.String name, DataType<T> type, Table<R> table, java.lang.String comment, Binding<T,U> binding) Subclasses may call this method to create TableField objects that are linked to this table.
protected static <R extends Record,T,U> TableField<R,U>	createField(java.lang.String name, DataType<T> type, Table<R> table, java.lang.String comment, Converter<T,U> converter) Subclasses may call this method to create TableField objects that are linked to this table.
protected static <R extends Record,T,X,U> TableField<R,U>	createField(java.lang.String name, DataType<T> type, Table<R> table, java.lang.String comment, Converter<X,U> converter, Binding<T,X> binding) Subclasses may call this method to create TableField objects that are linked to this table.
Table<Record>	crossApply(java.lang.String sql) CROSS APPLY a table to this table.
Table<Record>	crossApply(java.lang.String sql, java.lang.Object... bindings) CROSS APPLY a table to this table.
Table<Record>	crossApply(java.lang.String sql, QueryPart... parts) CROSS APPLY a table to this table.
Table<Record>	crossApply(TableLike<?> table) CROSS APPLY a table to this table.
Table<Record>	crossJoin(java.lang.String sql) CROSS JOIN a table to this table.
Table<Record>	crossJoin(java.lang.String sql, java.lang.Object... bindings) CROSS JOIN a table to this table.
Table<Record>	crossJoin(java.lang.String sql, QueryPart... parts) CROSS JOIN a table to this table.
Table<Record>	crossJoin(TableLike<?> table) CROSS JOIN a table to this table.
boolean	declaresCTE() Subclasses may override this
boolean	declaresFields() Subclasses may override this
boolean	declaresTables() Subclasses may override this
boolean	declaresWindows() Subclasses may override this
DivideByOnStep	divideBy(Table<?> divisor) Create a new TABLE reference from this table, applying relational division.
boolean	equals(java.lang.Object that) Check whether this QueryPart can be considered equal to another QueryPart.
<T> Field<T>	field(Field<T> field) Get a specific field from this Record.
Field<?>	field(int index) Get a specific field from this Record.
<T> Field<T>	field(int index, java.lang.Class<T> type) Get a specific field from this Record and coerce it to type.
<T> Field<T>	field(int index, DataType<T> dataType) Get a specific field from this Record and coerce it to dataType.
Field<?>	field(java.lang.String string) Get a specific field from this Record.
<T> Field<T>	field(java.lang.String name, java.lang.Class<T> type) Get a specific field from this Record and coerce it to type.
<T> Field<T>	field(java.lang.String name, DataType<T> dataType) Get a specific field from this Record and coerce it to dataType.
Field<?>[]	fields() Get all fields from this Record.
Row	fieldsRow() Get this table's fields as a Row
Table<R>	forceIndex(java.lang.String... indexes) Specify a MySQL style table hint for query optimisation.
Table<R>	forceIndexForGroupBy(java.lang.String... indexes) Specify a MySQL style table hint for query optimisation.
Table<R>	forceIndexForJoin(java.lang.String... indexes) Specify a MySQL style table hint for query optimisation.
Table<R>	forceIndexForOrderBy(java.lang.String... indexes) Specify a MySQL style table hint for query optimisation.
TableOnStep	fullOuterJoin(java.lang.String sql) FULL OUTER JOIN a table to this table.
TableOnStep	fullOuterJoin(java.lang.String sql, java.lang.Object... bindings) FULL OUTER JOIN a table to this table.
TableOnStep	fullOuterJoin(java.lang.String sql, QueryPart... parts) FULL OUTER JOIN a table to this table.
TableOnStep	fullOuterJoin(TableLike<?> table) FULL OUTER JOIN a table to this table.
java.lang.String	getComment() The comment given to the table.
Identity<R,? extends java.lang.Number>	getIdentity() Retrieve the table's IDENTITY information, if available.
java.util.List<UniqueKey<R>>	getKeys() Retrieve all of the table's unique keys.
java.lang.String	getName() The name of this table.
UniqueKey<R>	getPrimaryKey() Retrieve the table's primary key
TableField<R,? extends java.util.Date>	getRecordTimestamp() A "timestamp" field holding record timestamp information used for optimistic locking jOOQ supports optimistic locking in UpdatableRecord.store() and UpdatableRecord.delete() if Settings.isExecuteWithOptimisticLocking() is enabled.
java.lang.Class<? extends R>	getRecordType() Subclasses must override this method if they use the generic type parameter for other types than Record The record type produced by this table.
TableField<R,? extends java.lang.Number>	getRecordVersion() A "version" field holding record version information used for optimistic locking jOOQ supports optimistic locking in UpdatableRecord.store() and UpdatableRecord.delete() if Settings.isExecuteWithOptimisticLocking() is enabled.
java.util.List<ForeignKey<R,?>>	getReferences() Get the list of FOREIGN KEY's of this table
<O extends Record> java.util.List<ForeignKey<O,R>>	getReferencesFrom(Table<O> other) Get a list of FOREIGN KEY's of a specific table, referencing a this table.
<O extends Record> java.util.List<ForeignKey<R,O>>	getReferencesTo(Table<O> other) Get a list of FOREIGN KEY's of this table, referencing a specific table.
Schema	getSchema() Get the table schema.
int	hashCode() Generate a hash code from this QueryPart.
Table<R>	ignoreIndex(java.lang.String... indexes) Specify a MySQL style table hint for query optimisation.
Table<R>	ignoreIndexForGroupBy(java.lang.String... indexes) Specify a MySQL style table hint for query optimisation.
Table<R>	ignoreIndexForJoin(java.lang.String... indexes) Specify a MySQL style table hint for query optimisation.
Table<R>	ignoreIndexForOrderBy(java.lang.String... indexes) Specify a MySQL style table hint for query optimisation.
TableOnStep	join(java.lang.String sql) INNER JOIN a table to this table.
TableOnStep	join(java.lang.String sql, java.lang.Object... bindings) INNER JOIN a table to this table.
TableOnStep	join(java.lang.String sql, QueryPart... parts) INNER JOIN a table to this table.
TableOnStep	join(TableLike<?> table) INNER JOIN a table to this table.
TableOptionalOnStep	join(TableLike<?> table, JoinType type) Join a table to this table using a JoinType Depending on the JoinType, a subsequent TableOnStep.on(Condition...) or TableOnStep.using(Field...) clause is required.
TablePartitionByStep	leftOuterJoin(java.lang.String sql) LEFT OUTER JOIN a table to this table.
TablePartitionByStep	leftOuterJoin(java.lang.String sql, java.lang.Object... bindings) LEFT OUTER JOIN a table to this table.
TablePartitionByStep	leftOuterJoin(java.lang.String sql, QueryPart... parts) LEFT OUTER JOIN a table to this table.
TablePartitionByStep	leftOuterJoin(TableLike<?> table) LEFT OUTER JOIN a table to this table.
Table<Record>	naturalJoin(java.lang.String sql) NATURAL JOIN a table to this table.
Table<Record>	naturalJoin(java.lang.String sql, java.lang.Object... bindings) NATURAL JOIN a table to this table.
Table<Record>	naturalJoin(java.lang.String sql, QueryPart... parts) NATURAL JOIN a table to this table.
Table<Record>	naturalJoin(TableLike<?> table) NATURAL JOIN a table to this table.
Table<Record>	naturalLeftOuterJoin(java.lang.String sql) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	naturalLeftOuterJoin(java.lang.String sql, java.lang.Object... bindings) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	naturalLeftOuterJoin(java.lang.String sql, QueryPart... parts) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	naturalLeftOuterJoin(TableLike<?> table) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	naturalRightOuterJoin(java.lang.String sql) NATURAL RIGHT OUTER JOIN a table to this table.
Table<Record>	naturalRightOuterJoin(java.lang.String sql, java.lang.Object... bindings) NATURAL RIGHT OUTER JOIN a table to this table.
Table<Record>	naturalRightOuterJoin(java.lang.String sql, QueryPart... parts) NATURAL RIGHT OUTER JOIN a table to this table.
Table<Record>	naturalRightOuterJoin(TableLike<?> table) NATURAL RIGHT OUTER JOIN a table to this table.
R	newRecord() Create a new Record of this table's type.
Table<Record>	outerApply(java.lang.String sql) OUTER APPLY a table to this table.
Table<Record>	outerApply(java.lang.String sql, java.lang.Object... bindings) OUTER APPLY a table to this table.
Table<Record>	outerApply(java.lang.String sql, QueryPart... parts) OUTER APPLY a table to this table.
Table<Record>	outerApply(TableLike<?> table) OUTER APPLY a table to this table.
PivotForStep	pivot(java.util.Collection<? extends Field<?>> aggregateFunctions) Create a new TABLE reference from this table, pivoting it into another form.
PivotForStep	pivot(Field<?>... aggregateFunctions) Create a new TABLE reference from this table, pivoting it into another form.
RecordType<R>	recordType() The record type produced by this table.
TablePartitionByStep	rightOuterJoin(java.lang.String sql) RIGHT OUTER JOIN a table to this table.
TablePartitionByStep	rightOuterJoin(java.lang.String sql, java.lang.Object... bindings) RIGHT OUTER JOIN a table to this table.
TablePartitionByStep	rightOuterJoin(java.lang.String sql, QueryPart... parts) RIGHT OUTER JOIN a table to this table.
TablePartitionByStep	rightOuterJoin(TableLike<?> table) RIGHT OUTER JOIN a table to this table.
void	toSQL(RenderContext ctx) Deprecated.
java.lang.String	toString() Render a SQL string of this QueryPart For improved debugging, this renders a SQL string of this QueryPart with inlined bind variables.
protected DataAccessException	translate(java.lang.String sql, java.sql.SQLException e) Internal convenience method
Table<R>	useIndex(java.lang.String... indexes) Specify a MySQL style table hint for query optimisation.
Table<R>	useIndexForGroupBy(java.lang.String... indexes) Specify a MySQL style table hint for query optimisation.
Table<R>	useIndexForJoin(java.lang.String... indexes) Specify a MySQL style table hint for query optimisation.
Table<R>	useIndexForOrderBy(java.lang.String... indexes) Specify a MySQL style table hint for query optimisation.
VersionsBetweenAndStep<R,java.lang.Number>	versionsBetweenScn(Field<? extends java.lang.Number> scn) Create an SQLDialect.ORACLE flashback versions query clause from this table.
VersionsBetweenAndStep<R,java.lang.Number>	versionsBetweenScn(java.lang.Number scn) Create an SQLDialect.ORACLE flashback versions query clause from this table.
VersionsBetweenAndStep<R,java.lang.Number>	versionsBetweenScnMinvalue() Create an SQLDialect.ORACLE flashback versions query clause from this table.
VersionsBetweenAndStep<R,java.sql.Timestamp>	versionsBetweenTimestamp(Field<java.sql.Timestamp> timestamp) Create an SQLDialect.ORACLE flashback versions query clause from this table.
VersionsBetweenAndStep<R,java.sql.Timestamp>	versionsBetweenTimestamp(java.sql.Timestamp timestamp) Create an SQLDialect.ORACLE flashback versions query clause from this table.
VersionsBetweenAndStep<R,java.sql.Timestamp>	versionsBetweenTimestampMinvalue() Create an SQLDialect.ORACLE flashback versions query clause from this table.
Table<R>	with(java.lang.String hint) Specify a SQL Server style table hint for query optimisation.

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.jooq.QueryPart

toString

Field Detail

parameters

protected final Field<?>[] parameters

Constructor Detail

TableImpl

public TableImpl(java.lang.String name)

TableImpl

public TableImpl(java.lang.String name,
                 Schema schema)

TableImpl

public TableImpl(java.lang.String name,
                 Schema schema,
                 Table<R> aliased)

TableImpl

public TableImpl(java.lang.String name,
                 Schema schema,
                 Table<R> aliased,
                 Field<?>[] parameters)

TableImpl

public TableImpl(java.lang.String name,
                 Schema schema,
                 Table<R> aliased,
                 Field<?>[] parameters,
                 java.lang.String comment)

Method Detail

clauses

public final Clause[] clauses(Context<?> ctx)

Description copied from interface: QueryPartInternal

The Clauses that are represented by this query part.

QueryParts can specify several Clauses for which an event will be emitted before (in forward order) and after (in reverse order) visiting the the query part through Context.visit(QueryPart)

This method is for JOOQ INTERNAL USE only. Do not reference directly

Specified by:

clauses in interface QueryPartInternal

Returns:

The Clauses represented by this query part or null or an empty array if this query part does not represent a clause.

accept

public final void accept(Context<?> ctx)

Description copied from interface: QueryPartInternal

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Specified by:

accept in interface QueryPartInternal

as

public Table<R> as(java.lang.String as)

Subclasses may override this method to provide custom aliasing implementations

Create an alias for this table.

Note that the case-sensitivity of the returned table depends on Settings.getRenderNameStyle(). By default, table aliases are quoted, and thus case-sensitive!

Parameters:

as - The alias name

Returns:

The table alias

as

public Table<R> as(java.lang.String as,
                   java.lang.String... fieldAliases)

Subclasses may override this method to provide custom aliasing implementations

Create an alias for this table and its fields

Note that the case-sensitivity of the returned table and columns depends on Settings.getRenderNameStyle(). By default, table aliases are quoted, and thus case-sensitive!

Derived column lists for table references

Note, not all databases support derived column lists for their table aliases. On the other hand, some databases do support derived column lists, but only for derived tables. jOOQ will try to turn table references into derived tables to make this syntax work. In other words, the following statements are equivalent:

 -- Using derived column lists to rename columns (e.g. Postgres)
 SELECT t.a, t.b
 FROM my_table t(a, b)

 -- Nesting table references within derived tables (e.g. SQL Server)
 SELECT t.a, t.b
 FROM (
   SELECT * FROM my_table
 ) t(a, b)
 

Derived column lists for derived tables

Other databases may not support derived column lists at all, but they do support common table expressions. The following statements are equivalent:

 -- Using derived column lists to rename columns (e.g. Postgres)
 SELECT t.a, t.b
 FROM (
   SELECT 1, 2
 ) AS t(a, b)

 -- Using UNION ALL to produce column names (e.g. MySQL)
 SELECT t.a, t.b
 FROM (
   SELECT null a, null b FROM DUAL WHERE 1 = 0
   UNION ALL
   SELECT 1, 2 FROM DUAL
 ) t
 

Parameters:

as - The alias name

fieldAliases - The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names.

Returns:

The table alias

getRecordType

public java.lang.Class<? extends R> getRecordType()

Subclasses must override this method if they use the generic type parameter for other types than Record

The record type produced by this table.

declaresTables

public boolean declaresTables()

Subclasses may override this

Specified by:

declaresTables in interface QueryPartInternal

equals

public boolean equals(java.lang.Object that)

Description copied from interface: QueryPart

Check whether this QueryPart can be considered equal to another QueryPart.

In general, QueryPart equality is defined in terms of QueryPart.toString() equality. In other words, two query parts are considered equal if their rendered SQL (with inlined bind variables) is equal. This means that the two query parts do not necessarily have to be of the same type.

Some QueryPart implementations may choose to override this behaviour for improved performance, as QueryPart.toString() is an expensive operation, if called many times.

Specified by:

equals in interface QueryPart

Parameters:

that - The other QueryPart

Returns:

Whether the two query parts are equal

recordType

public final RecordType<R> recordType()

Description copied from interface: Table

The record type produced by this table.

Specified by:

recordType in interface Table<R extends Record>

newRecord

public final R newRecord()

Description copied from interface: Table

Create a new Record of this table's type.

Specified by:

newRecord in interface Table<R extends Record>

See Also:

DSLContext.newRecord(Table)

fieldsRow

public final Row fieldsRow()

Description copied from interface: TableLike

Get this table's fields as a Row

Specified by:

fieldsRow in interface TableLike<R extends Record>

field

public final <T> Field<T> field(Field<T> field)

Description copied from interface: TableLike

Get a specific field from this Record.

Specified by:

field in interface TableLike<R extends Record>

See Also:

Row.field(Field)

field

public final Field<?> field(java.lang.String string)

Description copied from interface: TableLike

Get a specific field from this Record.

Specified by:

field in interface TableLike<R extends Record>

See Also:

Row.field(String)

field

public final <T> Field<T> field(java.lang.String name,
                                java.lang.Class<T> type)

Description copied from interface: TableLike

Get a specific field from this Record and coerce it to type.

Specified by:

field in interface TableLike<R extends Record>

See Also:

Row.field(String, Class)

field

public final <T> Field<T> field(java.lang.String name,
                                DataType<T> dataType)

Description copied from interface: TableLike

Get a specific field from this Record and coerce it to dataType.

Specified by:

field in interface TableLike<R extends Record>

See Also:

Row.field(String, DataType)

field

public final Field<?> field(int index)

Description copied from interface: TableLike

Get a specific field from this Record.

Specified by:

field in interface TableLike<R extends Record>

See Also:

Row.field(int)

field

public final <T> Field<T> field(int index,
                                java.lang.Class<T> type)

Description copied from interface: TableLike

Get a specific field from this Record and coerce it to type.

Specified by:

field in interface TableLike<R extends Record>

See Also:

Row.field(int, Class)

field

public final <T> Field<T> field(int index,
                                DataType<T> dataType)

Description copied from interface: TableLike

Get a specific field from this Record and coerce it to dataType.

Specified by:

field in interface TableLike<R extends Record>

See Also:

Row.field(int, DataType)

fields

public final Field<?>[] fields()

Description copied from interface: TableLike

Get all fields from this Record.

Specified by:

fields in interface TableLike<R extends Record>

See Also:

Row.fields()

asTable

public final Table<R> asTable()

Description copied from interface: 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 ...

Specified by:

asTable in interface TableLike<R extends Record>

asTable

public final Table<R> asTable(java.lang.String alias)

Description copied from interface: TableLike

The underlying aliased table representation of this object

Specified by:

asTable in interface TableLike<R extends Record>

See Also:

Table.as(String)

asTable

public final Table<R> asTable(java.lang.String alias,
                              java.lang.String... fieldAliases)

Description copied from interface: TableLike

The underlying aliased table representation of this object

Specified by:

asTable in interface TableLike<R extends Record>

See Also:

Table.as(String, String...)

getSchema

public final Schema getSchema()

Description copied from interface: Table

Get the table schema.

Specified by:

getSchema in interface Table<R extends Record>

getName

public final java.lang.String getName()

Description copied from interface: Table

The name of this table.

Specified by:

getName in interface Table<R extends Record>

getComment

public final java.lang.String getComment()

Description copied from interface: Table

The comment given to the table.

If this Table is a generated table from your database, it may provide its DDL comment through this method. All other table expressions return the empty string "" here, never null.

Specified by:

getComment in interface Table<R extends Record>

getIdentity

public Identity<R,? extends java.lang.Number> getIdentity()

Retrieve the table's IDENTITY information, if available.

With SQL:2003, the concept of IDENTITY columns was introduced in most RDBMS. These are special kinds of columns that have auto-increment functionality when INSERT statements are performed.

An IDENTITY column is usually part of the PRIMARY KEY or of a UNIQUE KEY in the table, although in some RDBMS, this is not required. There can only be at most one IDENTITY column.

Note: Unfortunately, this is not supported in the Oracle dialect, where identities simulated by triggers cannot be formally detected.

Subclasses should override this method

Specified by:

getIdentity in interface Table<R extends Record>

Returns:

The table's IDENTITY information, or null, if no such information is available.

getPrimaryKey

public UniqueKey<R> getPrimaryKey()

Retrieve the table's primary key

Subclasses may override this method

Specified by:

getPrimaryKey in interface Table<R extends Record>

Returns:

The primary key. This is never null for an updatable table.

getRecordVersion

public TableField<R,? extends java.lang.Number> getRecordVersion()

A "version" field holding record version information used for optimistic locking

jOOQ supports optimistic locking in UpdatableRecord.store() and UpdatableRecord.delete() if Settings.isExecuteWithOptimisticLocking() is enabled. Optimistic locking is performed in a single UPDATE or DELETE statement if tables provide a "version" or "timestamp" field, or in two steps using an additional SELECT .. FOR UPDATE statement otherwise.

This method is overridden in generated subclasses if their corresponding tables have been configured accordingly. A table may have both a "version" and a "timestamp" field.

Subclasses may override this method

Specified by:

getRecordVersion in interface Table<R extends Record>

Returns:

The "version" field, or null, if this table has no "version" field.

See Also:

Table.getRecordTimestamp(), UpdatableRecord.store(), UpdatableRecord.delete(), Settings.isExecuteWithOptimisticLocking()

getRecordTimestamp

public TableField<R,? extends java.util.Date> getRecordTimestamp()

A "timestamp" field holding record timestamp information used for optimistic locking

jOOQ supports optimistic locking in UpdatableRecord.store() and UpdatableRecord.delete() if Settings.isExecuteWithOptimisticLocking() is enabled. Optimistic locking is performed in a single UPDATE or DELETE statement if tables provide a "version" or "timestamp" field, or in two steps using an additional SELECT .. FOR UPDATE statement otherwise.

This method is overridden in generated subclasses if their corresponding tables have been configured accordingly. A table may have both a "version" and a "timestamp" field.

Subclasses may override this method

Specified by:

getRecordTimestamp in interface Table<R extends Record>

Returns:

The "timestamp" field, or null, if this table has no "timestamp" field.

See Also:

Table.getRecordVersion(), UpdatableRecord.store(), UpdatableRecord.delete(), Settings.isExecuteWithOptimisticLocking()

getKeys

public java.util.List<UniqueKey<R>> getKeys()

Retrieve all of the table's unique keys.

Subclasses should override this method

Specified by:

getKeys in interface Table<R extends Record>

Returns:

All keys. This is never null. This is never empty for a Table with a Table.getPrimaryKey(). This method returns an unmodifiable list.

getReferencesFrom

public final <O extends Record> java.util.List<ForeignKey<O,R>> getReferencesFrom(Table<O> other)

Get a list of FOREIGN KEY's of a specific table, referencing a this table.

Specified by:

getReferencesFrom in interface Table<R extends Record>

Type Parameters:

O - The other table's record type

Parameters:

other - The other table of the foreign key relationship

Returns:

Some other table's FOREIGN KEY's towards an this table. This is never null. This method returns an unmodifiable list.

getReferences

public java.util.List<ForeignKey<R,?>> getReferences()

Get the list of FOREIGN KEY's of this table

Subclasses should override this method

Specified by:

getReferences in interface Table<R extends Record>

Returns:

This table's FOREIGN KEY's. This is never null.

getReferencesTo

public final <O extends Record> java.util.List<ForeignKey<R,O>> getReferencesTo(Table<O> other)

Get a list of FOREIGN KEY's of this table, referencing a specific table.

Specified by:

getReferencesTo in interface Table<R extends Record>

Type Parameters:

O - The other table's record type

Parameters:

other - The other table of the foreign key relationship

Returns:

This table's FOREIGN KEY's towards an other table. This is never null.

createField

protected static final <R extends Record,T> TableField<R,T> createField(java.lang.String name,
                                                                        DataType<T> type,
                                                                        Table<R> table)

Subclasses may call this method to create TableField objects that are linked to this table.

Parameters:

name - The name of the field (case-sensitive!)

type - The data type of the field

createField

protected static final <R extends Record,T> TableField<R,T> createField(java.lang.String name,
                                                                        DataType<T> type,
                                                                        Table<R> table,
                                                                        java.lang.String comment)

Subclasses may call this method to create TableField objects that are linked to this table.

Parameters:

name - The name of the field (case-sensitive!)

type - The data type of the field

createField

protected static final <R extends Record,T,U> TableField<R,U> createField(java.lang.String name,
                                                                          DataType<T> type,
                                                                          Table<R> table,
                                                                          java.lang.String comment,
                                                                          Converter<T,U> converter)

Subclasses may call this method to create TableField objects that are linked to this table.

Parameters:

name - The name of the field (case-sensitive!)

type - The data type of the field

createField

protected static final <R extends Record,T,U> TableField<R,U> createField(java.lang.String name,
                                                                          DataType<T> type,
                                                                          Table<R> table,
                                                                          java.lang.String comment,
                                                                          Binding<T,U> binding)

Subclasses may call this method to create TableField objects that are linked to this table.

Parameters:

name - The name of the field (case-sensitive!)

type - The data type of the field

createField

protected static final <R extends Record,T,X,U> TableField<R,U> createField(java.lang.String name,
                                                                            DataType<T> type,
                                                                            Table<R> table,
                                                                            java.lang.String comment,
                                                                            Converter<X,U> converter,
                                                                            Binding<T,X> binding)

Subclasses may call this method to create TableField objects that are linked to this table.

Parameters:

name - The name of the field (case-sensitive!)

type - The data type of the field

createField

protected final <T> TableField<R,T> createField(java.lang.String name,
                                                DataType<T> type)

Subclasses may call this method to create TableField objects that are linked to this table.

Parameters:

name - The name of the field (case-sensitive!)

type - The data type of the field

createField

protected final <T> TableField<R,T> createField(java.lang.String name,
                                                DataType<T> type,
                                                java.lang.String comment)

Subclasses may call this method to create TableField objects that are linked to this table.

Parameters:

name - The name of the field (case-sensitive!)

type - The data type of the field

createField

protected final <T,U> TableField<R,U> createField(java.lang.String name,
                                                  DataType<T> type,
                                                  java.lang.String comment,
                                                  Converter<T,U> converter)

Subclasses may call this method to create TableField objects that are linked to this table.

Parameters:

name - The name of the field (case-sensitive!)

type - The data type of the field

createField

protected final <T,U> TableField<R,U> createField(java.lang.String name,
                                                  DataType<T> type,
                                                  java.lang.String comment,
                                                  Binding<T,U> binding)

Subclasses may call this method to create TableField objects that are linked to this table.

Parameters:

name - The name of the field (case-sensitive!)

type - The data type of the field

createField

protected final <T,X,U> TableField<R,U> createField(java.lang.String name,
                                                    DataType<T> type,
                                                    java.lang.String comment,
                                                    Converter<X,U> converter,
                                                    Binding<T,X> binding)

Subclasses may call this method to create TableField objects that are linked to this table.

Parameters:

name - The name of the field (case-sensitive!)

type - The data type of the field

useIndex

public final Table<R> useIndex(java.lang.String... indexes)

Description copied from interface: Table

Specify a MySQL style table hint for query optimisation.

Example:

 create.select()
       .from(BOOK.as("b").useIndex("MY_INDEX")
       .fetch();
 

Specified by:

useIndex in interface Table<R extends Record>

See Also:

http://dev.mysql.com/doc/refman/5.7/en/index-hints.html

useIndexForJoin

public final Table<R> useIndexForJoin(java.lang.String... indexes)

Description copied from interface: Table

Specify a MySQL style table hint for query optimisation.

Example:

 create.select()
       .from(BOOK.as("b").useIndexForJoin("MY_INDEX")
       .fetch();
 

Specified by:

useIndexForJoin in interface Table<R extends Record>

See Also:

http://dev.mysql.com/doc/refman/5.7/en/index-hints.html

useIndexForOrderBy

public final Table<R> useIndexForOrderBy(java.lang.String... indexes)

Description copied from interface: Table

Specify a MySQL style table hint for query optimisation.

Example:

 create.select()
       .from(BOOK.as("b").useIndexForOrderBy("MY_INDEX")
       .fetch();
 

Specified by:

useIndexForOrderBy in interface Table<R extends Record>

See Also:

http://dev.mysql.com/doc/refman/5.7/en/index-hints.html

useIndexForGroupBy

public final Table<R> useIndexForGroupBy(java.lang.String... indexes)

Description copied from interface: Table

Specify a MySQL style table hint for query optimisation.

Example:

 create.select()
       .from(BOOK.as("b").useIndexForGroupBy("MY_INDEX")
       .fetch();
 

Specified by:

useIndexForGroupBy in interface Table<R extends Record>

See Also:

http://dev.mysql.com/doc/refman/5.7/en/index-hints.html

ignoreIndex

public final Table<R> ignoreIndex(java.lang.String... indexes)

Description copied from interface: Table

Specify a MySQL style table hint for query optimisation.

Example:

 create.select()
       .from(BOOK.as("b").useIndex("MY_INDEX")
       .fetch();
 

Specified by:

ignoreIndex in interface Table<R extends Record>

See Also:

http://dev.mysql.com/doc/refman/5.7/en/index-hints.html

ignoreIndexForJoin

public final Table<R> ignoreIndexForJoin(java.lang.String... indexes)

Description copied from interface: Table

Specify a MySQL style table hint for query optimisation.

Example:

 create.select()
       .from(BOOK.as("b").useIndexForJoin("MY_INDEX")
       .fetch();
 

Specified by:

ignoreIndexForJoin in interface Table<R extends Record>

See Also:

http://dev.mysql.com/doc/refman/5.7/en/index-hints.html

ignoreIndexForOrderBy

public final Table<R> ignoreIndexForOrderBy(java.lang.String... indexes)

Description copied from interface: Table

Specify a MySQL style table hint for query optimisation.

Example:

 create.select()
       .from(BOOK.as("b").useIndexForOrderBy("MY_INDEX")
       .fetch();
 

Specified by:

ignoreIndexForOrderBy in interface Table<R extends Record>

See Also:

http://dev.mysql.com/doc/refman/5.7/en/index-hints.html

ignoreIndexForGroupBy

public final Table<R> ignoreIndexForGroupBy(java.lang.String... indexes)

Description copied from interface: Table

Specify a MySQL style table hint for query optimisation.

Example:

 create.select()
       .from(BOOK.as("b").useIndexForGroupBy("MY_INDEX")
       .fetch();
 

Specified by:

ignoreIndexForGroupBy in interface Table<R extends Record>

See Also:

http://dev.mysql.com/doc/refman/5.7/en/index-hints.html

forceIndex

public final Table<R> forceIndex(java.lang.String... indexes)

Description copied from interface: Table

Specify a MySQL style table hint for query optimisation.

Example:

 create.select()
       .from(BOOK.as("b").useIndex("MY_INDEX")
       .fetch();
 

Specified by:

forceIndex in interface Table<R extends Record>

See Also:

http://dev.mysql.com/doc/refman/5.7/en/index-hints.html

forceIndexForJoin

public final Table<R> forceIndexForJoin(java.lang.String... indexes)

Description copied from interface: Table

Specify a MySQL style table hint for query optimisation.

Example:

 create.select()
       .from(BOOK.as("b").useIndexForJoin("MY_INDEX")
       .fetch();
 

Specified by:

forceIndexForJoin in interface Table<R extends Record>

See Also:

http://dev.mysql.com/doc/refman/5.7/en/index-hints.html

forceIndexForOrderBy

public final Table<R> forceIndexForOrderBy(java.lang.String... indexes)

Description copied from interface: Table

Specify a MySQL style table hint for query optimisation.

Example:

 create.select()
       .from(BOOK.as("b").useIndexForOrderBy("MY_INDEX")
       .fetch();
 

Specified by:

forceIndexForOrderBy in interface Table<R extends Record>

See Also:

http://dev.mysql.com/doc/refman/5.7/en/index-hints.html

forceIndexForGroupBy

public final Table<R> forceIndexForGroupBy(java.lang.String... indexes)

Description copied from interface: Table

Specify a MySQL style table hint for query optimisation.

Example:

 create.select()
       .from(BOOK.as("b").useIndexForGroupBy("MY_INDEX")
       .fetch();
 

Specified by:

forceIndexForGroupBy in interface Table<R extends Record>

See Also:

http://dev.mysql.com/doc/refman/5.7/en/index-hints.html

with

public final Table<R> with(java.lang.String hint)

Description copied from interface: Table

Specify a SQL Server style table hint for query optimisation.

This makes sense only on an actual database table or view, not on other composed table sources.

Example:

 create.select()
       .from(BOOK.as("b").with("READUNCOMMITTED")
       .fetch();
 

For SQLDialect.ORACLE style hints, see SelectFromStep.hint(String) and SelectQuery.addHint(String)

Specified by:

with in interface Table<R extends Record>

See Also:

http://msdn.microsoft.com/en-us/library/ms187373.aspx, SelectFromStep.hint(String), SelectQuery.addHint(String)

pivot

public final PivotForStep pivot(Field<?>... aggregateFunctions)

Description copied from interface: Table

Create a new TABLE reference from this table, pivoting it into another form.

This has been observed to work with

• SQLDialect.ORACLE11G upwards
• SQLDialect.SQLSERVER (not yet officially supported)
• Other dialects by using some means of simulation (not yet officially supported)

Specified by:

pivot in interface Table<R extends Record>

Parameters:

aggregateFunctions - The aggregate functions used for pivoting.

Returns:

A DSL object to create the PIVOT expression

pivot

public final PivotForStep pivot(java.util.Collection<? extends Field<?>> aggregateFunctions)

Description copied from interface: Table

Create a new TABLE reference from this table, pivoting it into another form.

For more details, see Table.pivot(Field...)

Specified by:

pivot in interface Table<R extends Record>

Parameters:

aggregateFunctions - The aggregate functions used for pivoting.

Returns:

A DSL object to create the PIVOT expression

See Also:

Table.pivot(Field...)

versionsBetweenScn

public final VersionsBetweenAndStep<R,java.lang.Number> versionsBetweenScn(java.lang.Number scn)

Description copied from interface: Table

Create an SQLDialect.ORACLE flashback versions query clause from this table.

Specified by:

versionsBetweenScn in interface Table<R extends Record>

versionsBetweenScn

public final VersionsBetweenAndStep<R,java.lang.Number> versionsBetweenScn(Field<? extends java.lang.Number> scn)

Description copied from interface: Table

Create an SQLDialect.ORACLE flashback versions query clause from this table.

Specified by:

versionsBetweenScn in interface Table<R extends Record>

versionsBetweenScnMinvalue

public final VersionsBetweenAndStep<R,java.lang.Number> versionsBetweenScnMinvalue()

Description copied from interface: Table

Create an SQLDialect.ORACLE flashback versions query clause from this table.

Specified by:

versionsBetweenScnMinvalue in interface Table<R extends Record>

versionsBetweenTimestamp

public final VersionsBetweenAndStep<R,java.sql.Timestamp> versionsBetweenTimestamp(java.sql.Timestamp timestamp)

Description copied from interface: Table

Create an SQLDialect.ORACLE flashback versions query clause from this table.

Specified by:

versionsBetweenTimestamp in interface Table<R extends Record>

versionsBetweenTimestamp

public final VersionsBetweenAndStep<R,java.sql.Timestamp> versionsBetweenTimestamp(Field<java.sql.Timestamp> timestamp)

Description copied from interface: Table

Create an SQLDialect.ORACLE flashback versions query clause from this table.

Specified by:

versionsBetweenTimestamp in interface Table<R extends Record>

versionsBetweenTimestampMinvalue

public final VersionsBetweenAndStep<R,java.sql.Timestamp> versionsBetweenTimestampMinvalue()

Description copied from interface: Table

Create an SQLDialect.ORACLE flashback versions query clause from this table.

Specified by:

versionsBetweenTimestampMinvalue in interface Table<R extends Record>

asOfScn

public final Table<R> asOfScn(java.lang.Number scn)

Description copied from interface: Table

Create an SQLDialect.ORACLE flashback query clause from this table.

Specified by:

asOfScn in interface Table<R extends Record>

asOfScn

public final Table<R> asOfScn(Field<? extends java.lang.Number> scn)

Description copied from interface: Table

Create an SQLDialect.ORACLE flashback query clause from this table.

Specified by:

asOfScn in interface Table<R extends Record>

asOfTimestamp

public final Table<R> asOfTimestamp(java.sql.Timestamp timestamp)

Description copied from interface: Table

Create an SQLDialect.ORACLE flashback query clause from this table.

Specified by:

asOfTimestamp in interface Table<R extends Record>

asOfTimestamp

public final Table<R> asOfTimestamp(Field<java.sql.Timestamp> timestamp)

Description copied from interface: Table

Create an SQLDialect.ORACLE flashback query clause from this table.

Specified by:

asOfTimestamp in interface Table<R extends Record>

divideBy

public final DivideByOnStep divideBy(Table<?> divisor)

Description copied from interface: Table

Create a new TABLE reference from this table, applying relational division.

Relational division is the inverse of a cross join operation. The following is an approximate definition of a relational division:

 Assume the following cross join / cartesian product
 C = A × B

 Then it can be said that
 A = C ÷ B
 B = C ÷ A
 

With jOOQ, you can simplify using relational divisions by using the following syntax:

 C.divideBy(B).on(C.ID.equal(B.C_ID)).returning(C.TEXT)
 

The above roughly translates to

 SELECT DISTINCT C.TEXT FROM C "c1"
 WHERE NOT EXISTS (
   SELECT 1 FROM B
   WHERE NOT EXISTS (
     SELECT 1 FROM C "c2"
     WHERE "c2".TEXT = "c1".TEXT
     AND "c2".ID = B.C_ID
   )
 )
 

Or in plain text: Find those TEXT values in C whose ID's correspond to all ID's in B. Note that from the above SQL statement, it is immediately clear that proper indexing is of the essence. Be sure to have indexes on all columns referenced from the on(...) and returning(...) clauses.

For more information about relational division and some nice, real-life examples, see

• http ://en.wikipedia.org/wiki/Relational_algebra#Division
• http://www.simple-talk.com/sql/t-sql-programming/divided-we-stand-the- sql-of-relational-division/

This has been observed to work with all dialects

Specified by:

divideBy in interface Table<R extends Record>

join

public final TableOptionalOnStep join(TableLike<?> table,
                                      JoinType type)

Description copied from interface: Table

Join a table to this table using a JoinType

Depending on the JoinType, a subsequent TableOnStep.on(Condition...) or TableOnStep.using(Field...) clause is required. If it is required but omitted, a DSL.trueCondition(), i.e. 1 = 1 condition will be rendered

Specified by:

join in interface Table<R extends Record>

join

public final TableOnStep join(TableLike<?> table)

Description copied from interface: Table

INNER JOIN a table to this table.

Specified by:

join in interface Table<R extends Record>

join

public final TableOnStep join(java.lang.String sql)

Description copied from interface: Table

INNER JOIN a table to this table.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

join in interface Table<R extends Record>

See Also:

DSL.table(String)

join

public final TableOnStep join(java.lang.String sql,
                              java.lang.Object... bindings)

Description copied from interface: Table

INNER JOIN a table to this table.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

join in interface Table<R extends Record>

See Also:

DSL.table(String, Object...)

join

public final TableOnStep join(java.lang.String sql,
                              QueryPart... parts)

Description copied from interface: Table

INNER JOIN a table to this table.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

join in interface Table<R extends Record>

See Also:

DSL.table(String, QueryPart...)

leftOuterJoin

public final TablePartitionByStep leftOuterJoin(TableLike<?> table)

Description copied from interface: Table

LEFT OUTER JOIN a table to this table.

Specified by:

leftOuterJoin in interface Table<R extends Record>

leftOuterJoin

public final TablePartitionByStep leftOuterJoin(java.lang.String sql)

Description copied from interface: Table

LEFT OUTER JOIN a table to this table.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

leftOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String)

leftOuterJoin

public final TablePartitionByStep leftOuterJoin(java.lang.String sql,
                                                java.lang.Object... bindings)

Description copied from interface: Table

LEFT OUTER JOIN a table to this table.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

leftOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String, Object...)

leftOuterJoin

public final TablePartitionByStep leftOuterJoin(java.lang.String sql,
                                                QueryPart... parts)

Description copied from interface: Table

LEFT OUTER JOIN a table to this table.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

leftOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String, QueryPart...)

rightOuterJoin

public final TablePartitionByStep rightOuterJoin(TableLike<?> table)

Description copied from interface: Table

RIGHT OUTER JOIN a table to this table.

This is only possible where the underlying RDBMS supports it

Specified by:

rightOuterJoin in interface Table<R extends Record>

rightOuterJoin

public final TablePartitionByStep rightOuterJoin(java.lang.String sql)

Description copied from interface: Table

RIGHT OUTER JOIN a table to this table.

This is only possible where the underlying RDBMS supports it

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

rightOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String)

rightOuterJoin

public final TablePartitionByStep rightOuterJoin(java.lang.String sql,
                                                 java.lang.Object... bindings)

Description copied from interface: Table

RIGHT OUTER JOIN a table to this table.

This is only possible where the underlying RDBMS supports it

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

rightOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String, Object...)

rightOuterJoin

public final TablePartitionByStep rightOuterJoin(java.lang.String sql,
                                                 QueryPart... parts)

Description copied from interface: Table

RIGHT OUTER JOIN a table to this table.

This is only possible where the underlying RDBMS supports it

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

rightOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String, QueryPart...)

fullOuterJoin

public final TableOnStep fullOuterJoin(TableLike<?> table)

Description copied from interface: Table

FULL OUTER JOIN a table to this table.

This is only possible where the underlying RDBMS supports it

Specified by:

fullOuterJoin in interface Table<R extends Record>

fullOuterJoin

public final TableOnStep fullOuterJoin(java.lang.String sql)

Description copied from interface: Table

FULL OUTER JOIN a table to this table.

This is only possible where the underlying RDBMS supports it

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

fullOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String)

fullOuterJoin

public final TableOnStep fullOuterJoin(java.lang.String sql,
                                       java.lang.Object... bindings)

Description copied from interface: Table

FULL OUTER JOIN a table to this table.

This is only possible where the underlying RDBMS supports it

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

fullOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String, Object...)

fullOuterJoin

public final TableOnStep fullOuterJoin(java.lang.String sql,
                                       QueryPart... parts)

Description copied from interface: Table

FULL OUTER JOIN a table to this table.

This is only possible where the underlying RDBMS supports it

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

fullOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String, QueryPart...)

crossJoin

public final Table<Record> crossJoin(TableLike<?> table)

Description copied from interface: Table

CROSS JOIN a table to this table.

If this syntax is unavailable, it is simulated with a regular INNER JOIN. The following two constructs are equivalent:

 A cross join B
 A join B on 1 = 1
 

Specified by:

crossJoin in interface Table<R extends Record>

crossJoin

public final Table<Record> crossJoin(java.lang.String sql)

Description copied from interface: Table

CROSS JOIN a table to this table.

If this syntax is unavailable, it is simulated with a regular INNER JOIN. The following two constructs are equivalent:

 A cross join B
 A join B on 1 = 1
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

crossJoin in interface Table<R extends Record>

See Also:

DSL.table(String)

crossJoin

public final Table<Record> crossJoin(java.lang.String sql,
                                     java.lang.Object... bindings)

Description copied from interface: Table

CROSS JOIN a table to this table.

If this syntax is unavailable, it is simulated with a regular INNER JOIN. The following two constructs are equivalent:

 A cross join B
 A join B on 1 = 1
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

crossJoin in interface Table<R extends Record>

See Also:

DSL.table(String, Object...)

crossJoin

public final Table<Record> crossJoin(java.lang.String sql,
                                     QueryPart... parts)

Description copied from interface: Table

CROSS JOIN a table to this table.

If this syntax is unavailable, it is simulated with a regular INNER JOIN. The following two constructs are equivalent:

 A cross join B
 A join B on 1 = 1
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

crossJoin in interface Table<R extends Record>

See Also:

DSL.table(String, QueryPart...)

naturalJoin

public final Table<Record> naturalJoin(TableLike<?> table)

Description copied from interface: Table

NATURAL JOIN a table to this table.

If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.

Specified by:

naturalJoin in interface Table<R extends Record>

naturalJoin

public final Table<Record> naturalJoin(java.lang.String sql)

Description copied from interface: Table

NATURAL JOIN a table to this table.

If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

naturalJoin in interface Table<R extends Record>

See Also:

DSL.table(String)

naturalJoin

public final Table<Record> naturalJoin(java.lang.String sql,
                                       java.lang.Object... bindings)

Description copied from interface: Table

NATURAL JOIN a table to this table.

If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

naturalJoin in interface Table<R extends Record>

See Also:

DSL.table(String, Object...)

naturalJoin

public final Table<Record> naturalJoin(java.lang.String sql,
                                       QueryPart... parts)

Description copied from interface: Table

NATURAL JOIN a table to this table.

If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

naturalJoin in interface Table<R extends Record>

See Also:

DSL.table(String, QueryPart...)

naturalLeftOuterJoin

public final Table<Record> naturalLeftOuterJoin(TableLike<?> table)

Description copied from interface: Table

NATURAL LEFT OUTER JOIN a table to this table.

If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.

Specified by:

naturalLeftOuterJoin in interface Table<R extends Record>

naturalLeftOuterJoin

public final Table<Record> naturalLeftOuterJoin(java.lang.String sql)

Description copied from interface: Table

NATURAL LEFT OUTER JOIN a table to this table.

If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

naturalLeftOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String)

naturalLeftOuterJoin

public final Table<Record> naturalLeftOuterJoin(java.lang.String sql,
                                                java.lang.Object... bindings)

Description copied from interface: Table

NATURAL LEFT OUTER JOIN a table to this table.

If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

naturalLeftOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String, Object...)

naturalLeftOuterJoin

public final Table<Record> naturalLeftOuterJoin(java.lang.String sql,
                                                QueryPart... parts)

Description copied from interface: Table

NATURAL LEFT OUTER JOIN a table to this table.

If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

naturalLeftOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String, QueryPart...)

naturalRightOuterJoin

public final Table<Record> naturalRightOuterJoin(TableLike<?> table)

Description copied from interface: Table

NATURAL RIGHT OUTER JOIN a table to this table.

If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.

Specified by:

naturalRightOuterJoin in interface Table<R extends Record>

naturalRightOuterJoin

public final Table<Record> naturalRightOuterJoin(java.lang.String sql)

Description copied from interface: Table

NATURAL RIGHT OUTER JOIN a table to this table.

If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

naturalRightOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String)

naturalRightOuterJoin

public final Table<Record> naturalRightOuterJoin(java.lang.String sql,
                                                 java.lang.Object... bindings)

Description copied from interface: Table

NATURAL RIGHT OUTER JOIN a table to this table.

If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

naturalRightOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String, Object...)

naturalRightOuterJoin

public final Table<Record> naturalRightOuterJoin(java.lang.String sql,
                                                 QueryPart... parts)

Description copied from interface: Table

NATURAL RIGHT OUTER JOIN a table to this table.

If this is not supported by your RDBMS, then jOOQ will try to simulate this behaviour using the information provided in this query.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

naturalRightOuterJoin in interface Table<R extends Record>

See Also:

DSL.table(String, QueryPart...)

crossApply

public final Table<Record> crossApply(TableLike<?> table)

Description copied from interface: Table

CROSS APPLY a table to this table.

Specified by:

crossApply in interface Table<R extends Record>

crossApply

public final Table<Record> crossApply(java.lang.String sql)

Description copied from interface: Table

CROSS APPLY a table to this table.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

crossApply in interface Table<R extends Record>

See Also:

DSL.table(String)

crossApply

public final Table<Record> crossApply(java.lang.String sql,
                                      java.lang.Object... bindings)

Description copied from interface: Table

CROSS APPLY a table to this table.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

crossApply in interface Table<R extends Record>

See Also:

DSL.table(String, Object...)

crossApply

public final Table<Record> crossApply(java.lang.String sql,
                                      QueryPart... parts)

Description copied from interface: Table

CROSS APPLY a table to this table.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

crossApply in interface Table<R extends Record>

See Also:

DSL.table(String, QueryPart...)

outerApply

public final Table<Record> outerApply(TableLike<?> table)

Description copied from interface: Table

OUTER APPLY a table to this table.

Specified by:

outerApply in interface Table<R extends Record>

outerApply

public final Table<Record> outerApply(java.lang.String sql)

Description copied from interface: Table

OUTER APPLY a table to this table.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

outerApply in interface Table<R extends Record>

See Also:

DSL.table(String)

outerApply

public final Table<Record> outerApply(java.lang.String sql,
                                      java.lang.Object... bindings)

Description copied from interface: Table

OUTER APPLY a table to this table.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

outerApply in interface Table<R extends Record>

See Also:

DSL.table(String, Object...)

outerApply

public final Table<Record> outerApply(java.lang.String sql,
                                      QueryPart... parts)

Description copied from interface: Table

OUTER APPLY a table to this table.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Specified by:

outerApply in interface Table<R extends Record>

See Also:

DSL.table(String, QueryPart...)

hashCode

public int hashCode()

Description copied from interface: QueryPart

Generate a hash code from this QueryPart.

In general, QueryPart hash codes are the same as the hash codes generated from QueryPart.toString(). This guarantees consistent behaviour with QueryPart.equals(Object)

Some QueryPart implementations may choose to override this behaviour for improved performance, as QueryPart.toString() is an expensive operation, if called many times.

Specified by:

hashCode in interface QueryPart

Returns:

The QueryPart hash code

toSQL

@Deprecated
public void toSQL(RenderContext ctx)

Deprecated.

Description copied from interface: QueryPartInternal

Render this QueryPart to a SQL string contained in context.sql(). The context will contain additional information about how to render this QueryPart, e.g. whether this QueryPart should be rendered as a declaration or reference, whether this QueryPart's contained bind variables should be inlined or replaced by '?', etc.

Specified by:

toSQL in interface QueryPartInternal

bind

@Deprecated
public void bind(BindContext ctx)
                       throws DataAccessException

Deprecated.

Description copied from interface: QueryPartInternal

Bind all parameters of this QueryPart to a PreparedStatement

This method is for JOOQ INTERNAL USE only. Do not reference directly

Specified by:

bind in interface QueryPartInternal

Parameters:

ctx - The context holding the next bind index and other information for variable binding

Throws:

DataAccessException - If something went wrong while binding a variable

declaresFields

public boolean declaresFields()

Subclasses may override this

Specified by:

declaresFields in interface QueryPartInternal

declaresWindows

public boolean declaresWindows()

Subclasses may override this

Specified by:

declaresWindows in interface QueryPartInternal

declaresCTE

public boolean declaresCTE()

Subclasses may override this

Specified by:

declaresCTE in interface QueryPartInternal

toString

public java.lang.String toString()

Description copied from interface: QueryPart

Render a SQL string of this QueryPart

For improved debugging, this renders a SQL string of this QueryPart with inlined bind variables. If you wish to gain more control over the concrete SQL rendering of this QueryPart, use DSLContext.renderContext() to obtain a configurable render context for SQL rendering.

Specified by:

toString in interface QueryPart

Overrides:

toString in class java.lang.Object

Returns:

A SQL string representation of this QueryPart

create

protected final DSLContext create()

Internal convenience method

create

protected final DSLContext create(Configuration configuration)

Internal convenience method

create

protected final DSLContext create(Context<?> ctx)

Internal convenience method

translate

protected final DataAccessException translate(java.lang.String sql,
                                              java.sql.SQLException e)

Internal convenience method