- I1 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- I2 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- I4 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- I8 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- Identity<R extends Record,T> - Interface in org.jooq
-
An Identity is an object representing an IDENTITY
column as understood by the SQL:2003 standard.
- IDENTITY - Static variable in class org.jooq.util.h2.H2DataType
-
- ignored() - Method in interface org.jooq.Loader
-
The number of ignored rows
- ignoreNulls() - Method in interface org.jooq.WindowIgnoreNullsStep
-
Add an IGNORE NULLS clause to the window function.
- ignoreRows(int) - Method in interface org.jooq.LoaderCSVOptionsStep
-
Specify that a certain number of rows should be ignored from the CSV
file.
- IMAGE - Static variable in class org.jooq.util.ase.ASEDataType
-
- IMAGE - Static variable in class org.jooq.util.h2.H2DataType
-
- IMAGE - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- IMAGE - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- in(Collection<T>) - Method in interface org.jooq.Field
-
Create a condition to check this field against several values
SQL: this in (values...)
- in(T...) - Method in interface org.jooq.Field
-
Create a condition to check this field against several values
SQL: this in (values...)
- in(Field<?>...) - Method in interface org.jooq.Field
-
Create a condition to check this field against several values
SQL: this in (values...)
- in(Select<?>) - Method in interface org.jooq.Field
-
Create a condition to check this field against a subquery
Note that the subquery must return exactly one field.
- in(T...) - Method in interface org.jooq.PivotInStep
-
Specify the acceptable values for pivoting
- in(Field<?>...) - Method in interface org.jooq.PivotInStep
-
Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE.
- in(Collection<? extends Field<T>>) - Method in interface org.jooq.PivotInStep
-
Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE.
- in(Select<?>) - Method in interface org.jooq.Row
-
Compare this row value expression with a subselect for equality
Note that the subquery must return a table of the same degree as this row
value expression.
- in(Collection<? extends Row1<T1>>) - Method in interface org.jooq.Row1
-
Compare this row value expression with a set of row value expressions for
equality
Row IN predicates can be simulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4)) is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Row1<T1>...) - Method in interface org.jooq.Row1
-
Compare this row value expression with a set of row value expressions for
equality
Row IN predicates can be simulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4)) is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Collection<? extends Row2<T1, T2>>) - Method in interface org.jooq.Row2
-
Compare this row value expression with a set of row value expressions for
equality
Row IN predicates can be simulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4)) is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Row2<T1, T2>...) - Method in interface org.jooq.Row2
-
Compare this row value expression with a set of row value expressions for
equality
Row IN predicates can be simulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4)) is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Collection<? extends Row3<T1, T2, T3>>) - Method in interface org.jooq.Row3
-
Compare this row value expression with a set of row value expressions for equality
Row IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)),
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Row3<T1, T2, T3>...) - Method in interface org.jooq.Row3
-
Compare this row value expression with a set of row value expressions for equality
Row IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)),
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Collection<? extends Row4<T1, T2, T3, T4>>) - Method in interface org.jooq.Row4
-
Compare this row value expression with a set of row value expressions for equality
Row IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)),
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Row4<T1, T2, T3, T4>...) - Method in interface org.jooq.Row4
-
Compare this row value expression with a set of row value expressions for equality
Row IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)),
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Collection<? extends Row5<T1, T2, T3, T4, T5>>) - Method in interface org.jooq.Row5
-
Compare this row value expression with a set of row value expressions for equality
Row IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)),
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Row5<T1, T2, T3, T4, T5>...) - Method in interface org.jooq.Row5
-
Compare this row value expression with a set of row value expressions for equality
Row IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)),
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Collection<? extends Row6<T1, T2, T3, T4, T5, T6>>) - Method in interface org.jooq.Row6
-
Compare this row value expression with a set of row value expressions for equality
Row IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)),
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Row6<T1, T2, T3, T4, T5, T6>...) - Method in interface org.jooq.Row6
-
Compare this row value expression with a set of row value expressions for equality
Row IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)),
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Collection<? extends Row7<T1, T2, T3, T4, T5, T6, T7>>) - Method in interface org.jooq.Row7
-
Compare this row value expression with a set of row value expressions for equality
Row IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)),
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Row7<T1, T2, T3, T4, T5, T6, T7>...) - Method in interface org.jooq.Row7
-
Compare this row value expression with a set of row value expressions for equality
Row IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)),
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Collection<? extends Row8<T1, T2, T3, T4, T5, T6, T7, T8>>) - Method in interface org.jooq.Row8
-
Compare this row value expression with a set of row value expressions for equality
Row IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)),
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Row8<T1, T2, T3, T4, T5, T6, T7, T8>...) - Method in interface org.jooq.Row8
-
Compare this row value expression with a set of row value expressions for equality
Row IN predicates can be simulated in those databases that do not
support such predicates natively: (A, B) IN ((1, 2), (3, 4))
is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)),
which is equivalent to
(A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(Collection<? extends RowN>) - Method in interface org.jooq.RowN
-
Compare this row value expression with a set of row value expressions for
equality
Row IN predicates can be simulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4)) is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
- in(RowN...) - Method in interface org.jooq.RowN
-
Compare this row value expression with a set of row value expressions for
equality
Row IN predicates can be simulated in those databases that do not support
such predicates natively: (A, B) IN ((1, 2), (3, 4)) is
equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which
is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
- incr(Field<T>) - Static method in class org.jooq.util.cubrid.CUBRIDFactory
-
Use the CUBRID-specific INCR() function.
- INDEX_NOT_FOUND - Static variable in class org.jooq.tools.StringUtils
-
Represents a failed index search.
- info(Object) - Method in class org.jooq.tools.JooqLogger
-
- info(Object, Object) - Method in class org.jooq.tools.JooqLogger
-
- info(Object, Throwable) - Method in class org.jooq.tools.JooqLogger
-
- info(Object, Object, Throwable) - Method in class org.jooq.tools.JooqLogger
-
- IngresDataType<T> - Class in org.jooq.util.ingres
-
- INGRESDATE - Static variable in class org.jooq.util.ingres.IngresDataType
-
- IngresFactory - Class in org.jooq.util.ingres
-
- IngresFactory(Connection, SchemaMapping) - Constructor for class org.jooq.util.ingres.IngresFactory
-
- IngresFactory(Connection, Settings) - Constructor for class org.jooq.util.ingres.IngresFactory
-
Create a factory with connection and a settings configured
- IngresFactory(DataSource, Settings) - Constructor for class org.jooq.util.ingres.IngresFactory
-
Create a factory with a data source and a settings configured
- IngresFactory(Connection) - Constructor for class org.jooq.util.ingres.IngresFactory
-
Create a factory with connection
- IngresFactory(DataSource) - Constructor for class org.jooq.util.ingres.IngresFactory
-
Create a factory with a data source
- IngresFactory(Settings) - Constructor for class org.jooq.util.ingres.IngresFactory
-
Create a factory with settings configured
Without a connection, this factory cannot execute queries.
- IngresFactory() - Constructor for class org.jooq.util.ingres.IngresFactory
-
Create a connection-less factory
Without a connection, this factory cannot execute queries.
- INITIAL_READ_SIZE - Static variable in class org.jooq.tools.csv.CSVParser
-
- inline(T) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline(char) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline(Character) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline(CharSequence) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline(Object, Class<? extends T>) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline(Object, Field<T>) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline(Object, DataType<T>) - Static method in class org.jooq.impl.Factory
-
Create a bind value, that is always inlined.
- inline() - Method in interface org.jooq.RenderContext
-
Whether bind variables should be inlined, rather than rendered as
'?'
- inline(boolean) - Method in interface org.jooq.RenderContext
-
- input - Variable in class org.jooq.conf.MappedSchema
-
- input - Variable in class org.jooq.conf.MappedTable
-
- insert(P) - Method in interface org.jooq.DAO
-
Performs an INSERT statement for a given POJO
- insert(P...) - Method in interface org.jooq.DAO
-
Performs a batch INSERT statement for a given set of POJOs
- insert(Collection<P>) - Method in interface org.jooq.DAO
-
Performs a batch INSERT statement for a given set of POJOs
- insert(P) - Method in class org.jooq.impl.DAOImpl
-
- insert(P...) - Method in class org.jooq.impl.DAOImpl
-
- insert(Collection<P>) - Method in class org.jooq.impl.DAOImpl
-
- Insert<R extends Record> - Interface in org.jooq
-
A
Query that can insert data in the database.
- InsertFinalStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert's DSL API.
- insertInto(Table<R>) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL insert statement.
- insertInto(Table<R>, Field<?>...) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL insert statement.
- insertInto(Table<R>, Collection<? extends Field<?>>) - Method in interface org.jooq.FactoryOperations
-
Create a new DSL insert statement.
- insertInto(Table<R>, Select<?>) - Method in interface org.jooq.FactoryOperations
-
Deprecated.
- 2.0.3 - Use any of these methods instead:
- insertInto(Table<R>) - Method in class org.jooq.impl.Factory
-
Create a new DSL insert statement.
- insertInto(Table<R>, Field<?>...) - Method in class org.jooq.impl.Factory
-
Create a new DSL insert statement.
- insertInto(Table<R>, Collection<? extends Field<?>>) - Method in class org.jooq.impl.Factory
-
Create a new DSL insert statement.
- insertInto(Table<R>, Select<?>) - Method in class org.jooq.impl.Factory
-
Deprecated.
- insertInto(Table<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- insertInto(Table<R>, Field<?>...) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- insertInto(Table<R>, Collection<? extends Field<?>>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- insertInto(Table<R>, Select<?>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- InsertOnDuplicateSetMoreStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert's DSL API.
- InsertOnDuplicateSetStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert's DSL API.
- InsertOnDuplicateStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert's DSL API.
- insertQuery(Table<R>) - Method in interface org.jooq.FactoryOperations
-
- insertQuery(Table<R>) - Method in class org.jooq.impl.Factory
-
- insertQuery(Table<R>) - Method in class org.jooq.impl.FactoryProxy
-
Deprecated.
- InsertQuery<R extends Record> - Interface in org.jooq
-
A query for data insertion
- InsertResultStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert's DSL API.
- InsertReturningStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert's DSL API.
- InsertSetMoreStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert's alternative DSL API.
- InsertSetStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert's alternative DSL API.
- InsertValuesStep<R extends Record> - Interface in org.jooq
-
This type is used for the
Insert's DSL API.
- INT - Static variable in class org.jooq.util.ase.ASEDataType
-
- INT - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- INT - Static variable in class org.jooq.util.derby.DerbyDataType
-
- INT - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- INT - Static variable in class org.jooq.util.h2.H2DataType
-
- INT - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- INT - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- INT - Static variable in class org.jooq.util.oracle.OracleDataType
-
- INT - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INT - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- INT - Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- INT - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- INT2 - Static variable in class org.jooq.util.h2.H2DataType
-
- INT2 - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INT2 - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- INT4 - Static variable in class org.jooq.util.h2.H2DataType
-
- INT4 - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INT64 - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- INT8 - Static variable in class org.jooq.util.h2.H2DataType
-
- INT8 - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INT8 - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- INTEGER - Static variable in class org.jooq.impl.SQLDataType
-
- INTEGER - Static variable in class org.jooq.util.ase.ASEDataType
-
- INTEGER - Static variable in class org.jooq.util.cubrid.CUBRIDDataType
-
- INTEGER - Static variable in class org.jooq.util.db2.DB2DataType
-
- INTEGER - Static variable in class org.jooq.util.derby.DerbyDataType
-
- INTEGER - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- INTEGER - Static variable in class org.jooq.util.h2.H2DataType
-
- INTEGER - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- INTEGER - Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGER - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- INTEGER - Static variable in class org.jooq.util.oracle.OracleDataType
-
- INTEGER - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INTEGER - Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- INTEGER - Static variable in class org.jooq.util.sybase.SybaseDataType
-
- INTEGER1 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGER2 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGER4 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGER8 - Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGERUNSIGNED - Static variable in class org.jooq.impl.SQLDataType
-
- INTEGERUNSIGNED - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- internalAPI(Class<I>) - Method in interface org.jooq.Adapter
-
Deprecated.
- 2.5.0 [#1639] - This part of the internal API will be
removed in the near future. Do not reuse.
- intersect(Select<R>) - Method in interface org.jooq.Select
-
Combine with other selects
- Interval - Interface in org.jooq.types
-
A substitute for JDBC's missing java.sql.Interval data type.
- INTERVALDAYTOSECOND - Static variable in class org.jooq.impl.SQLDataType
-
The SQL standard INTERVAL DAY TO SECOND data type
- INTERVALDAYTOSECOND - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- INTERVALDAYTOSECOND - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- INTERVALDAYTOSECOND - Static variable in class org.jooq.util.oracle.OracleDataType
-
- INTERVALDAYTOSECOND - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INTERVALYEARTOMONTH - Static variable in class org.jooq.impl.SQLDataType
-
The SQL standard INTERVAL YEAR TO MONTH data type
- INTERVALYEARTOMONTH - Static variable in class org.jooq.util.firebird.FirebirdDataType
-
- INTERVALYEARTOMONTH - Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- INTERVALYEARTOMONTH - Static variable in class org.jooq.util.oracle.OracleDataType
-
- INTERVALYEARTOMONTH - Static variable in class org.jooq.util.postgres.PostgresDataType
-
- into(Class<? extends E>) - Method in interface org.jooq.Record
-
Map resulting records onto a custom type.
- into(E) - Method in interface org.jooq.Record
-
Map resulting records onto a custom type.
- into(Table<R>) - Method in interface org.jooq.Record
-
Map resulting records onto a custom record type.
- into(Class<? extends E>) - Method in interface org.jooq.Result
-
Map resulting records onto a custom type.
- into(Table<Z>) - Method in interface org.jooq.Result
-
Map resulting records onto a custom record.
- into(H) - Method in interface org.jooq.Result
-
Map results into a custom handler callback
- intoArray() - Method in interface org.jooq.Record
-
Convert this record into an array.
- intoArray() - Method in interface org.jooq.Result
-
Convert this result into an array of arrays
The resulting array has the same number of first-dimension elements as
this result has records.
- intoArray(int) - Method in interface org.jooq.Result
-
Return all values for a field index from the result.
- intoArray(int, Class<? extends T>) - Method in interface org.jooq.Result
-
Return all values for a field index from the result.
- intoArray(int, Converter<?, U>) - Method in interface org.jooq.Result
-
Return all values for a field index from the result.
- intoArray(String) - Method in interface org.jooq.Result
-
Return all values for a field name from the result.
- intoArray(String, Class<? extends T>) - Method in interface org.jooq.Result
-
Return all values for a field name from the result.
- intoArray(String, Converter<?, U>) - Method in interface org.jooq.Result
-
Return all values for a field name from the result.
- intoArray(Field<T>) - Method in interface org.jooq.Result
-
Return all values for a field from the result.
- intoArray(Field<?>, Class<? extends T>) - Method in interface org.jooq.Result
-
Return all values for a field from the result.
- intoArray(Field<T>, Converter<? super T, U>) - Method in interface org.jooq.Result
-
Return all values for a field from the result.
- intoGroups(Field<K>) - Method in interface org.jooq.Result
-
Return a
Map with one of the result's columns as key and a list
of corresponding records as value.
- intoGroups(Field<K>, Field<V>) - Method in interface org.jooq.Result
-
Return a
Map with one of the result's columns as key and another
one of the result's columns as value
Unlike
Result.intoMap(Field, Field), this method allows for non-unique
keys in the result set.
- intoGroups(Field<?>[]) - Method in interface org.jooq.Result
-
Return a
Map with the result grouped by the given keys.
- intoGroups(Field<K>, Class<? extends E>) - Method in interface org.jooq.Result
-
Return a
Map with results grouped by the given key and mapped
into the given entity type.
- intoGroups(Field<?>[], Class<? extends E>) - Method in interface org.jooq.Result
-
Return a
Map with results grouped by the given keys and mapped
into the given entity type.
- intoMap() - Method in interface org.jooq.Record
-
Return this record as a name/value map.
- intoMap(Field<K>) - Method in interface org.jooq.Result
-
Return a
Map with one of the result's columns as key and the
corresponding records as value.
- intoMap(Field<K>, Field<V>) - Method in interface org.jooq.Result
-
Return a
Map with one of the result's columns as key and another
one of the result's columns as value
An
InvalidResultException is thrown, if the key turns out to be
non-unique in the result set.
- intoMap(Field<?>[]) - Method in interface org.jooq.Result
-
Return a
Map with the given keys as a map key and the
corresponding record as value.
- intoMap(Field<K>, Class<? extends E>) - Method in interface org.jooq.Result
-
Return a
Map with results grouped by the given key and mapped
into the given entity type.
- intoMap(Field<?>[], Class<? extends E>) - Method in interface org.jooq.Result
-
Return a
Map with results grouped by the given keys and mapped
into the given entity type.
- intoMaps() - Method in interface org.jooq.Result
-
Return the generated result as a list of name/value maps.
- intoResultSet() - Method in interface org.jooq.Result
-
Generate an in-memory JDBC
ResultSet containing the data of this
Result.
- intoXML() - Method in interface org.jooq.Result
-
Get this result as XML
- INTUNSIGNED - Static variable in class org.jooq.util.mysql.MySQLDataType
-
- intValue() - Method in class org.jooq.tools.unsigned.UByte
-
- intValue() - Method in class org.jooq.tools.unsigned.UInteger
-
- intValue() - Method in class org.jooq.tools.unsigned.ULong
-
- intValue() - Method in class org.jooq.tools.unsigned.UShort
-
- intValue() - Method in class org.jooq.types.DayToSecond
-
- intValue() - Method in interface org.jooq.types.Interval
-
- intValue() - Method in class org.jooq.types.YearToMonth
-
- InvalidResultException - Exception in org.jooq.exception
-
An unexpected result was encountered after executing a
Query.
- InvalidResultException(String) - Constructor for exception org.jooq.exception.InvalidResultException
-
Constructor for InvalidResultException.
- isAllWhiteSpace(CharSequence) - Method in class org.jooq.tools.csv.CSVParser
-
precondition: sb.length() > 0
- isArray() - Method in interface org.jooq.DataType
-
Whether this data type is an array type.
- isArray() - Method in class org.jooq.impl.AbstractDataType
-
- isAttachRecords() - Method in class org.jooq.conf.Settings
-
Gets the value of the attachRecords property.
- isBinary() - Method in interface org.jooq.DataType
-
Whether this data type is any binary type.
- isBinary() - Method in class org.jooq.impl.AbstractDataType
-
- isBlank(String) - Static method in class org.jooq.tools.StringUtils
-
Checks if a String is whitespace, empty ("") or null.
- isClosed() - Method in interface org.jooq.Cursor
-
Check whether this Cursor has been explicitly or
"conveniently" closed.
- isCloseOnCompletion() - Method in class org.jooq.tools.jdbc.JDBC41Statement
-
- isDateTime() - Method in interface org.jooq.DataType
-
Whether this data type is any date or time type.
- isDateTime() - Method in class org.jooq.impl.AbstractDataType
-
- isDebugEnabled() - Method in class org.jooq.tools.JooqLogger
-
- isDefaulted() - Method in interface org.jooq.Parameter
-
Whether this parameter has a default value
Procedures and functions with defaulted parameters behave slightly
different from ones without defaulted parameters.
- isDistinctFrom(T) - Method in interface org.jooq.Field
-
Create a condition to check if this field is DISTINCT from
another value
If this is not supported by the underlying database, jOOQ will render
this instead:
CASE WHEN [this] IS NULL AND [value] IS NULL THEN FALSE
WHEN [this] IS NULL AND [value] IS NOT NULL THEN TRUE
WHEN [this] IS NOT NULL AND [value] IS NULL THEN TRUE
WHEN [this] = [value] THEN FALSE
ELSE TRUE
END
SQL: this is distinct from value
- isDistinctFrom(Field<T>) - Method in interface org.jooq.Field
-
Create a condition to check if this field is DISTINCT from
another field
If this is not supported by the underlying database, jOOQ will render
this instead:
CASE WHEN [this] IS NULL AND [field] IS NULL THEN FALSE
WHEN [this] IS NULL AND [field] IS NOT NULL THEN TRUE
WHEN [this] IS NOT NULL AND [field] IS NULL THEN TRUE
WHEN [this] = [field] THEN FALSE
ELSE TRUE
END
SQL: this is distinct from field
- isEmpty() - Method in interface org.jooq.Result
-
Whether there are any records contained in this Result
- isEmpty(String) - Static method in class org.jooq.tools.StringUtils
-
Checks if a String is empty ("") or null.
- isExecutable() - Method in interface org.jooq.Query
-
Whether this query is executable in its current state
DML queries may be incomplete in structure and thus not executable.
- isExecuteLogging() - Method in class org.jooq.conf.Settings
-
Gets the value of the executeLogging property.
- isExecuteWithOptimisticLocking() - Method in class org.jooq.conf.Settings
-
Gets the value of the executeWithOptimisticLocking property.
- isFalse() - Method in interface org.jooq.Field
-
Create a condition to check this field against known string literals for
false
SQL:
lcase(this) in ("0", "n", "no", "false", "off", "disabled")
- isInfoEnabled() - Method in class org.jooq.tools.JooqLogger
-
- isInline() - Method in interface org.jooq.Param
-
A flag on the bind value to force it to be inlined in rendered SQL
- isInterval() - Method in interface org.jooq.DataType
-
Whether this data type is any interval type.
- isInterval() - Method in class org.jooq.impl.AbstractDataType
-
- isLob() - Method in interface org.jooq.DataType
-
Whether this data type is best deserialised as a LOB.
- isLob() - Method in class org.jooq.impl.AbstractDataType
-
- isNextCharacterEscapable(String, boolean, int) - Method in class org.jooq.tools.csv.CSVParser
-
precondition: the current character is an escape
- isNotDistinctFrom(T) - Method in interface org.jooq.Field
-
Create a condition to check if this field is NOT DISTINCT
from another value
If this is not supported by the underlying database, jOOQ will render
this instead:
CASE WHEN [this] IS NULL AND [value] IS NULL THEN TRUE
WHEN [this] IS NULL AND [value] IS NOT NULL THEN FALSE
WHEN [this] IS NOT NULL AND [value] IS NULL THEN FALSE
WHEN [this] = [value] THEN TRUE
ELSE FALSE
END
SQL: this is not distinct from value
- isNotDistinctFrom(Field<T>) - Method in interface org.jooq.Field
-
Create a condition to check if this field is NOT DISTINCT
from another field
If this is not supported by the underlying database, jOOQ will render
this instead:
CASE WHEN [this] IS NULL AND [field] IS NULL THEN TRUE
WHEN [this] IS NULL AND [field] IS NOT NULL THEN FALSE
WHEN [this] IS NOT NULL AND [field] IS NULL THEN FALSE
WHEN [this] = [value] THEN TRUE
ELSE FALSE
END
SQL: this is not distinct from field
- isNotEmpty() - Method in interface org.jooq.Result
-
Whether there are any records contained in this Result
- isNotNull() - Method in interface org.jooq.Field
-
Create a condition to check this field against null.
- isNull() - Method in interface org.jooq.Field
-
Create a condition to check this field against null.
- isNullLiteral() - Method in interface org.jooq.Field
-
Whether this field represents a null literal.
- isNullLiteral() - Method in class org.jooq.impl.CustomField
-
Subclasses may further override this method
Whether this field represents a null literal.
- isNumeric() - Method in interface org.jooq.DataType
-
Whether this data type is any numeric data type.
- isNumeric() - Method in class org.jooq.impl.AbstractDataType
-
- isOverloaded() - Method in class org.jooq.impl.AbstractRoutine
-
- isPending() - Method in class org.jooq.tools.csv.CSVParser
-
- isRenderFormatted() - Method in class org.jooq.conf.Settings
-
Gets the value of the renderFormatted property.
- isRenderSchema() - Method in class org.jooq.conf.Settings
-
Gets the value of the renderSchema property.
- isString() - Method in interface org.jooq.DataType
-
Whether this data type is any character data type.
- isString() - Method in class org.jooq.impl.AbstractDataType
-
- isTemporal() - Method in interface org.jooq.DataType
-
Whether this data type is any date or time type.
- isTemporal() - Method in class org.jooq.impl.AbstractDataType
-
- isTraceEnabled() - Method in class org.jooq.tools.JooqLogger
-
- isTrue() - Method in interface org.jooq.Field
-
Create a condition to check this field against known string literals for
true
SQL:
lcase(this) in ("1", "y", "yes", "true", "on", "enabled")
- iterator() - Method in class org.jooq.impl.ArrayRecordImpl
-