Index (Tentackle SQL 25.20.0.0 API)

A B C D E F G H I J L M N O P R S T U V W X Z
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form

A

AbstractBackend - Class in org.tentackle.sql.backends: Abstract parent class for backends.
AbstractBackend() - Constructor for class org.tentackle.sql.backends.AbstractBackend: Parent constructor.
AbstractDataType<T> - Class in org.tentackle.sql.datatypes: Implements some common methods for data types.
AbstractDataType() - Constructor for class org.tentackle.sql.datatypes.AbstractDataType: Parent constructor.
AbstractDateTimeType<T> - Class in org.tentackle.sql.datatypes: Base class for date- or time-related data types.
AbstractDateTimeType() - Constructor for class org.tentackle.sql.datatypes.AbstractDateTimeType: Parent constructor.
AbstractNumberType<T> - Class in org.tentackle.sql.datatypes: Base class for number data types.
AbstractNumberType() - Constructor for class org.tentackle.sql.datatypes.AbstractNumberType: Parent constructor.
AbstractSql2003Backend - Class in org.tentackle.sql.backends: Common to all SQL2003 backends.
AbstractSql2003Backend() - Constructor for class org.tentackle.sql.backends.AbstractSql2003Backend: Parent constructor.
AbstractSql2008Backend - Class in org.tentackle.sql.backends: Common to all SQL2008 backends.
AbstractSql2008Backend() - Constructor for class org.tentackle.sql.backends.AbstractSql2008Backend: Parent constructor.
AbstractSql92Backend - Class in org.tentackle.sql.backends: Common to all SQL92 backends.
AbstractSql92Backend() - Constructor for class org.tentackle.sql.backends.AbstractSql92Backend: Parent constructor.
acceptsURL(String) - Method in class org.tentackle.sql.DynamicDriver
addExecutionListener(Consumer) - Method in class org.tentackle.sql.DefaultScriptRunner
addExecutionListener(Consumer) - Method in interface org.tentackle.sql.ScriptRunner: Adds a listener to be notified when each statement is submitted to the backend.
addForeignKeyColumn(ForeignKeyColumnMetaData) - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Adds a column to the foreign key.
addIndexColumnFromMetaData(ResultSet) - Method in class org.tentackle.sql.metadata.IndexMetaData: Adds an index column from the database metadata result.
addResultListener(Consumer) - Method in class org.tentackle.sql.DefaultScriptRunner
addResultListener(Consumer) - Method in interface org.tentackle.sql.ScriptRunner: Adds a listener to be notified when each statement is successfully executed.
addResultSetListener(BiConsumer) - Method in class org.tentackle.sql.DefaultScriptRunner
addResultSetListener(BiConsumer) - Method in interface org.tentackle.sql.ScriptRunner: Adds a listener to be notified when each result set has been processed.
Since the result set is positioned after the end of the last row, the listener must invoke ResultSet.beforeFirst() to process it again.
addTableMetaData(TableMetaData) - Method in class org.tentackle.sql.metadata.ModelMetaData: Adds a table to this model.
If schemas are set, only tables belonging to one of given schemas will be appended.
assertColumnCountNotBackendSpecific(Backend) - Method in class org.tentackle.sql.datatypes.AbstractDataType: Checks that this type has a fixed number of columns or the backend is specified.
assertValidName(SqlNameType, String) - Method in interface org.tentackle.sql.Backend: Asserts that the given string is a valid name and usage.
assertValidName(SqlNameType, String) - Method in class org.tentackle.sql.backends.AbstractBackend
assertValidName(SqlNameType, String) - Method in class org.tentackle.sql.backends.Firebird
assertValidName(SqlNameType, String) - Method in class org.tentackle.sql.backends.Oracle8

B

Backend - Interface in org.tentackle.sql: A database backend.
Defines the backend specifics.
There is only one instance per backend type.
Implementations must not maintain any state except for the whole of all connections to the specific kind of database.
BackendException - Exception Class in org.tentackle.sql: Runtime exception thrown for backend-related errors, such as configuration errors, invalid names, unsupported database versions or failed scripts.
BackendException() - Constructor for exception class org.tentackle.sql.BackendException: Constructs a new database backend exception with null as its detail message.
BackendException(String) - Constructor for exception class org.tentackle.sql.BackendException: Constructs a new database backend exception for the specified detail message.
BackendException(String, Throwable) - Constructor for exception class org.tentackle.sql.BackendException: Constructs a new database backend exception with the specified detail message and cause.
BackendFactory - Interface in org.tentackle.sql: The backend factory.
Provides the backend singletons, one per backend type, discovered as Backend services.
BackendInfo - Class in org.tentackle.sql: Configuration info for a backend.
Describes a concrete connection target, as opposed to the Backend, which describes a kind of database.
BackendInfo(String) - Constructor for class org.tentackle.sql.BackendInfo: Creates a backend-info from a backend name.
The info cannot be used to connect.
BackendInfo(String, String, char[], String[]) - Constructor for class org.tentackle.sql.BackendInfo: Creates a backend-info.
This info is able to create a connection.
BackendInfo(EncryptedProperties) - Constructor for class org.tentackle.sql.BackendInfo: Creates a backend-info from backend properties.
The info is able to create a connection.
BackendInfo(Backend) - Constructor for class org.tentackle.sql.BackendInfo: Creates a backend-info from a backend.
The info cannot be used to connect.
BackendInfo(BackendInfo, String, char[]) - Constructor for class org.tentackle.sql.BackendInfo: Creates a backend-info from another one with a different user and password.
All other settings, including the keep-alive configuration, are copied.
BackendInfoFactory - Interface in org.tentackle.sql: The backend info factory.
BackendPreparedStatement - Interface in org.tentackle.sql: Backend-facing view of a prepared statement.
Implemented by the PreparedStatementWrapper of the persistence layer, so that backends and data types can set parameters without depending on it.
BackendVersionInfo - Record Class in org.tentackle.sql: The version of a backend's database, as reported by its JDBC driver metadata.
BackendVersionInfo(int, int) - Constructor for record class org.tentackle.sql.BackendVersionInfo: Creates an instance of a BackendVersionInfo record class.
BigDecimalType - Class in org.tentackle.sql.datatypes: Datatype for BigDecimal.
BigDecimalType() - Constructor for class org.tentackle.sql.datatypes.BigDecimalType: Creates the datatype for BigDecimal.
BIGINT - Enum constant in enum class org.tentackle.sql.SqlType: Long and long.
BinaryType - Class in org.tentackle.sql.datatypes: Datatype for Binary.
BinaryType() - Constructor for class org.tentackle.sql.datatypes.BinaryType: Creates the datatype for Binary.
BIT - Enum constant in enum class org.tentackle.sql.SqlType: Boolean and boolean.
BLOB - Enum constant in enum class org.tentackle.sql.SqlType: Arbitrary data usually stored as BLOB.
BMoneyType - Class in org.tentackle.sql.datatypes: Datatype for BMoney.
Stored as two columns: the value in double precision the scale This type is sortable by the first column.
BMoneyType() - Constructor for class org.tentackle.sql.datatypes.BMoneyType: Creates the datatype for BMoney.
BooleanPrimitiveType - Class in org.tentackle.sql.datatypes: Datatype for the primitive type boolean.
BooleanPrimitiveType() - Constructor for class org.tentackle.sql.datatypes.BooleanPrimitiveType: Creates the datatype for the primitive type boolean.
BooleanType - Class in org.tentackle.sql.datatypes: Datatype for Boolean.
BooleanType() - Constructor for class org.tentackle.sql.datatypes.BooleanType: Creates the datatype for Boolean.
buildSelectSql(StringBuilder, boolean, int, int) - Method in interface org.tentackle.sql.Backend: Creates a select statement string from an inner SQL string.
buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.AbstractSql2003Backend: Creates a select statement string from an inner SQL string.
buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.AbstractSql2008Backend: Creates a select statement string from an inner SQL string.
buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.AbstractSql92Backend
buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.Firebird: Creates a select statement string from an inner SQL string.
buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.H2: Creates a select statement string from an inner SQL string.
buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.Hana
buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.Informix
buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.MsSql: Creates a select statement string from an inner SQL string.
buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.MySql
buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.Oracle: Creates a select statement string from an inner SQL string.
buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.Oracle8
buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.Postgres
buildSelectSql(String, boolean, int, int) - Method in interface org.tentackle.sql.Backend: Creates a select statement string from an inner SQL string.
buildSelectSql(String, boolean, int, int) - Method in class org.tentackle.sql.backends.AbstractBackend
ByteArrayType - Class in org.tentackle.sql.datatypes: Datatype for byte[].
ByteArrayType() - Constructor for class org.tentackle.sql.datatypes.ByteArrayType: Creates the datatype for byte[].
BytePrimitiveType - Class in org.tentackle.sql.datatypes: Datatype for the primitive type byte.
BytePrimitiveType() - Constructor for class org.tentackle.sql.datatypes.BytePrimitiveType: Creates the datatype for the primitive type byte.
ByteType - Class in org.tentackle.sql.datatypes: Datatype for Byte.
ByteType() - Constructor for class org.tentackle.sql.datatypes.ByteType: Creates the datatype for Byte.

C

cancel() - Method in class org.tentackle.sql.DefaultScriptRunner
cancel() - Method in interface org.tentackle.sql.ScriptRunner: Cancels the script execution.
CASCADE - Enum constant in enum class org.tentackle.sql.metadata.ForeignKeyAction: When the primary key is updated or deleted, the foreign key (imported key) is changed or deleted accordingly.
CHAR - Enum constant in enum class org.tentackle.sql.SqlType: Character and char.
CharacterPrimitiveType - Class in org.tentackle.sql.datatypes: Datatype for the primitive type char.
CharacterPrimitiveType() - Constructor for class org.tentackle.sql.datatypes.CharacterPrimitiveType: Creates the datatype for the primitive type char.
CharacterType - Class in org.tentackle.sql.datatypes: Datatype for Character.
CharacterType() - Constructor for class org.tentackle.sql.datatypes.CharacterType: Creates the datatype for Character.
clearPassword() - Method in class org.tentackle.sql.BackendInfo: Clears the password (stored in a char[]-array) so that it is no longer visible in memory.
CLOB - Enum constant in enum class org.tentackle.sql.SqlType: Large Strings usually stored as CLOB.
CockroachDb - Class in org.tentackle.sql.backends: Backend for CockroachDB.
CockroachDb() - Constructor for class org.tentackle.sql.backends.CockroachDb: Creates the CockroachDB backend.
COLUMN_NAME - Enum constant in enum class org.tentackle.sql.SqlNameType: name of a column.
columnCount() - Method in record class org.tentackle.sql.ScriptRunnerResult: Returns the value of the columnCount record component.
ColumnExpression(String, String, String) - Constructor for record class org.tentackle.sql.metadata.OracleIndexColumnMetaData.ColumnExpression: Creates an instance of a ColumnExpression record class.
ColumnMetaData - Class in org.tentackle.sql.metadata: Metadata for a column.
ColumnMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.ColumnMetaData: Creates column metadata.
columnName() - Method in record class org.tentackle.sql.metadata.OracleIndexColumnMetaData.ColumnExpression: Returns the value of the columnName record component.
columnNames() - Method in record class org.tentackle.sql.ScriptRunnerResult: Returns the value of the columnNames record component.
columnTypeNullDefaultToString(String, SqlType, int, int, boolean, Object) - Method in interface org.tentackle.sql.Backend: Converts an SqlType, size, scale, nullable, and default value to a database type declaration.
columnTypeNullDefaultToString(String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.AbstractBackend
columnTypeNullDefaultToString(String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Firebird
columnTypeNullDefaultToString(String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Hana
columnTypeNullDefaultToString(String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.MySql
columnTypeNullDefaultToString(String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Oracle8
columnTypes() - Method in record class org.tentackle.sql.ScriptRunnerResult: Returns the value of the columnTypes record component.
columnTypeToString(SqlType, int, int) - Method in interface org.tentackle.sql.Backend: Converts the given SQL type, size, and scale to a database type declaration.
columnTypeToString(SqlType, int, int) - Method in class org.tentackle.sql.backends.AbstractBackend
COMMENT - Enum constant in enum class org.tentackle.sql.MigrationStrategy: use Backend.sqlAlterColumnComment(String, String, String).
compareTo(ForeignKeyColumnMetaData) - Method in class org.tentackle.sql.metadata.ForeignKeyColumnMetaData
compareTo(IndexColumnMetaData) - Method in class org.tentackle.sql.metadata.IndexColumnMetaData
connect() - Method in class org.tentackle.sql.BackendInfo: Creates a connection.
Must not be invoked for remote infos.
connect(String, Properties) - Method in class org.tentackle.sql.DynamicDriver
connectXA() - Method in class org.tentackle.sql.BackendInfo: Creates an XA connection.
XA connections take part in global transactions coordinated by a transaction manager.
ConvertibleType - Class in org.tentackle.sql.datatypes: Virtual type for application-specific wrapper classes implementing org.tentackle.misc.Convertible.
ConvertibleType() - Constructor for class org.tentackle.sql.datatypes.ConvertibleType: Creates the convertible pseudo type.
create(String) - Method in interface org.tentackle.sql.BackendInfoFactory: Creates a backend info from a backend name.
The info cannot be used to connect.
create(String) - Method in class org.tentackle.sql.DefaultBackendInfoFactory
create(String, String, char[], String[]) - Method in interface org.tentackle.sql.BackendInfoFactory: Creates a backend info.
This info is able to create a connection.
create(String, String, char[], String[]) - Method in class org.tentackle.sql.DefaultBackendInfoFactory
create(EncryptedProperties) - Method in interface org.tentackle.sql.BackendInfoFactory: Creates a backend info from backend properties.
The info is able to create a connection.
create(EncryptedProperties) - Method in class org.tentackle.sql.DefaultBackendInfoFactory
create(Backend) - Method in interface org.tentackle.sql.BackendInfoFactory: Creates a backend info from a backend.
The info cannot be used to connect.
create(Backend) - Method in class org.tentackle.sql.DefaultBackendInfoFactory
create(BackendInfo, String, char[]) - Method in interface org.tentackle.sql.BackendInfoFactory: Creates a backend info from another one with a different user and password.
create(BackendInfo, String, char[]) - Method in class org.tentackle.sql.DefaultBackendInfoFactory
createColumnMetaData(TableMetaData) - Method in interface org.tentackle.sql.Backend: Creates a column metadata instance.
createColumnMetaData(TableMetaData) - Method in class org.tentackle.sql.backends.AbstractBackend
createColumnMetaData(TableMetaData) - Method in class org.tentackle.sql.backends.Firebird
createColumnMetaData(TableMetaData) - Method in class org.tentackle.sql.backends.MySql
createColumnMetaData(TableMetaData) - Method in class org.tentackle.sql.backends.Oracle8
createColumnMetaData(TableMetaData) - Method in class org.tentackle.sql.backends.Postgres
createColumnNames(Backend, String) - Method in interface org.tentackle.sql.DataType: Creates a list of column names.
createColumnNames(Backend, String) - Method in class org.tentackle.sql.datatypes.AbstractDataType
createColumnNamesAsString(Backend, String, String) - Method in interface org.tentackle.sql.DataType: Creates a list of column names as a concatenated string.
The string can be used in SQL INSERT and UPDATE statements.
createColumnNamesAsString(Backend, String, String) - Method in class org.tentackle.sql.datatypes.AbstractDataType
createConnection(String, String, char[]) - Method in interface org.tentackle.sql.Backend: Creates a jdbc connection.
createConnection(String, String, char[]) - Method in class org.tentackle.sql.backends.AbstractBackend
createConnection(String, String, char[]) - Method in class org.tentackle.sql.backends.Informix: Creates a jdbc connection.
createConnection(String, String, char[]) - Method in class org.tentackle.sql.backends.Oracle8
createFromAction(int) - Static method in enum class org.tentackle.sql.metadata.Deferrability: Creates a deferrability from a JDBC DatabaseMetaData deferrability code.
createFromAction(int) - Static method in enum class org.tentackle.sql.metadata.ForeignKeyAction: Creates a foreign key action from an action code.
createIndexColumnMetaData(IndexMetaData) - Method in interface org.tentackle.sql.Backend: Creates an index column metadata instance.
createIndexColumnMetaData(IndexMetaData) - Method in class org.tentackle.sql.backends.AbstractBackend
createIndexColumnMetaData(IndexMetaData) - Method in class org.tentackle.sql.backends.Oracle
createIndexColumnMetaData(IndexMetaData) - Method in class org.tentackle.sql.backends.Postgres
createIndexMetaData(TableMetaData) - Method in interface org.tentackle.sql.Backend: Creates an index metadata instance.
createIndexMetaData(TableMetaData) - Method in class org.tentackle.sql.backends.AbstractBackend
createIndexMetaData(TableMetaData) - Method in class org.tentackle.sql.backends.Oracle
createIndexMetaData(TableMetaData) - Method in class org.tentackle.sql.backends.Postgres
createPassword(char[]) - Method in class org.tentackle.sql.backends.AbstractBackend: Creates a password string from a password char array.
Unfortunately, DriverManager.getConnection(String, String, String) requires the password as a string.
createScriptRunner(Connection) - Method in interface org.tentackle.sql.Backend: Creates a script runner instance.
createScriptRunner(Connection) - Method in class org.tentackle.sql.backends.AbstractBackend
createScriptRunner(Connection) - Method in class org.tentackle.sql.backends.Postgres
createStatement(Connection) - Method in class org.tentackle.sql.DefaultScriptRunner: Creates the statement.
createTableMetaData(ModelMetaData, String) - Method in interface org.tentackle.sql.Backend: Creates a metadata instance.
createTableMetaData(ModelMetaData, String) - Method in class org.tentackle.sql.backends.AbstractBackend
createXADataSource(String, String, char[]) - Method in interface org.tentackle.sql.Backend: Creates a data source for XA connections.
The data source is configured with the given jdbc url and credentials.
createXADataSource(String, String, char[]) - Method in class org.tentackle.sql.backends.AbstractBackend

D

data() - Method in record class org.tentackle.sql.ScriptRunnerResult: Returns the value of the data record component.
DatabaseMetaDataTableHeader - Class in org.tentackle.sql.metadata: Describes the table name and some major properties for an existing database table.
DatabaseMetaDataTableHeader(DatabaseMetaData, String, String, String, String, String) - Constructor for class org.tentackle.sql.metadata.DatabaseMetaDataTableHeader: Creates a table header.
DataType<T> - Interface in org.tentackle.sql: The data type.
Describes a type from the model perspective and maps it to one or more SqlTypes, each corresponding to a database column.
DataTypeFactory - Interface in org.tentackle.sql: Loads all data types and creates singletons of each type.
DATE - Enum constant in enum class org.tentackle.sql.SqlType: Date.
dateString(Date) - Static method in class org.tentackle.sql.backends.Oracle8: Converts a date to a string.
DateType - Class in org.tentackle.sql.datatypes: Datatype for Date.
DateType() - Constructor for class org.tentackle.sql.datatypes.DateType: Creates the datatype for Date.
Db2 - Class in org.tentackle.sql.backends: Backend for DB2.
Db2() - Constructor for class org.tentackle.sql.backends.Db2: Creates the DB2 backend.
DECIMAL - Enum constant in enum class org.tentackle.sql.SqlType: BigDecimal and DMoney.
DEFAULT - Enum constant in enum class org.tentackle.sql.MigrationStrategy: use Backend.sqlAlterColumnDefault(String, String, SqlType, Object).
DEFAULT_SCHEMA - Static variable in class org.tentackle.sql.backends.H2: H2's default schema.
DEFAULT_SCHEMA - Static variable in class org.tentackle.sql.backends.Postgres: postgres' default schema.
DefaultBackendFactory - Class in org.tentackle.sql: Default implementation of a backend factory.
DefaultBackendFactory() - Constructor for class org.tentackle.sql.DefaultBackendFactory: Creates a backend factory.
Collects all Backend services.
DefaultBackendInfoFactory - Class in org.tentackle.sql: Default implementation of a backend info factory.
DefaultBackendInfoFactory() - Constructor for class org.tentackle.sql.DefaultBackendInfoFactory: Creates a backend info factory.
DefaultDataTypeFactory - Class in org.tentackle.sql: Default implementation of DataTypeFactory.
DefaultDataTypeFactory() - Constructor for class org.tentackle.sql.DefaultDataTypeFactory: Creates the datatype factory.
If more than one datatype is registered for the same type and variant, the first one found wins, which allows the application to override the predefined types.
DefaultScriptRunner - Class in org.tentackle.sql: Default implementation of a script runner.
DefaultScriptRunner(Backend, Connection) - Constructor for class org.tentackle.sql.DefaultScriptRunner: Creates a script runner.
DefaultScriptRunner.SQLCode - Record Class in org.tentackle.sql: The next SQL code to execute as a statement.
Deferrability - Enum Class in org.tentackle.sql.metadata: The deferrability of a unique or foreign key constraint.
DEFERRABLE_DEFERRED - Enum constant in enum class org.tentackle.sql.metadata.Deferrability: The constraint is deferrable and checked at the end of the transaction by default.
DEFERRABLE_IMMEDIATE - Enum constant in enum class org.tentackle.sql.metadata.Deferrability: The constraint is deferrable and checked immediately by default, unless a transaction explicitly defers it via SET CONSTRAINTS ... DEFERRED.
determineNextSqlCode(String, int) - Method in class org.tentackle.sql.DefaultScriptRunner: Determines the next SQL code to execute.
determinePosixEscapeSyntaxSupported() - Method in class org.tentackle.sql.backends.PostgresScriptRunner
determinePosixEscapeSyntaxSupported() - Method in class org.tentackle.sql.DefaultScriptRunner: Determines whether POSIX escape syntax is supported by the backend and/or connection.
DMoneyType - Class in org.tentackle.sql.datatypes: Datatype for DMoney.
Stored as two columns: the value as a decimal without scale the scale This type is not sortable by the database in a meaningful manner.
DMoneyType() - Constructor for class org.tentackle.sql.datatypes.DMoneyType: Creates the datatype for DMoney.
DOUBLE - Enum constant in enum class org.tentackle.sql.SqlType: Double and double.
DoublePrimitiveType - Class in org.tentackle.sql.datatypes: Datatype for the primitive type double.
DoublePrimitiveType() - Constructor for class org.tentackle.sql.datatypes.DoublePrimitiveType: Creates the datatype for the primitive type double.
DoubleType - Class in org.tentackle.sql.datatypes: Datatype for Double.
DoubleType() - Constructor for class org.tentackle.sql.datatypes.DoubleType: Creates the datatype for Double.
DynamicDriver - Class in org.tentackle.sql: Loads a JDBC driver dynamically at runtime via a URL.
Because DriverManager will refuse to use a driver not loaded by the system-classloader, we must wrap the URL-loaded driver by such a class.

E

enrichIndexDeferrability(TableMetaData, Map, DatabaseMetaData) - Method in interface org.tentackle.sql.Backend: Enriches previously read index metadata with the deferrability of the unique constraint backing each deferrable unique index, if any.
The standard JDBC DatabaseMetaData.getIndexInfo() result has no deferrability column (unlike getImportedKeys()), so backends that support Backend.isSetConstraintsDeferredSupported() must look this up via their own system catalogs.
enrichIndexDeferrability(TableMetaData, Map, DatabaseMetaData) - Method in class org.tentackle.sql.backends.AbstractBackend
enrichIndexDeferrability(TableMetaData, Map, DatabaseMetaData) - Method in class org.tentackle.sql.backends.CockroachDb
enrichIndexDeferrability(TableMetaData, Map, DatabaseMetaData) - Method in class org.tentackle.sql.backends.Oracle8
enrichIndexDeferrability(TableMetaData, Map, DatabaseMetaData) - Method in class org.tentackle.sql.backends.Postgres
equals(Object) - Method in record class org.tentackle.sql.BackendVersionInfo: Indicates whether some other object is "equal to" this one.
equals(Object) - Method in class org.tentackle.sql.datatypes.AbstractDataType
equals(Object) - Method in record class org.tentackle.sql.DefaultScriptRunner.SQLCode: Indicates whether some other object is "equal to" this one.
equals(Object) - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData
equals(Object) - Method in class org.tentackle.sql.metadata.IndexMetaData
equals(Object) - Method in record class org.tentackle.sql.metadata.OracleIndexColumnMetaData.ColumnExpression: Indicates whether some other object is "equal to" this one.
equals(Object) - Method in class org.tentackle.sql.metadata.TableMetaData
equals(Object) - Method in record class org.tentackle.sql.ScriptRunnerResult: Indicates whether some other object is "equal to" this one.
executionListeners - Variable in class org.tentackle.sql.DefaultScriptRunner: the listeners invoked with the SQL code of each statement before it is executed.
extractForeignKeyName(ResultSet) - Static method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Extracts the foreign key name from a row of the database metadata result.
The name is converted to lowercase, and the optional schema prefix is cut off.

F

filterCondition() - Method in record class org.tentackle.sql.metadata.OracleIndexColumnMetaData.ColumnExpression: Returns the value of the filterCondition record component.
Firebird - Class in org.tentackle.sql.backends: Backend for Firebird.
Firebird() - Constructor for class org.tentackle.sql.backends.Firebird: Creates the Firebird backend.
FirebirdColumnMetaData - Class in org.tentackle.sql.metadata: Column metadata for Firebird.
FirebirdColumnMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.FirebirdColumnMetaData: Creates column metadata.
fireExecutionListeners(String) - Method in class org.tentackle.sql.DefaultScriptRunner: Fires execution listeners.
fireResultListeners(ScriptRunnerResult) - Method in class org.tentackle.sql.DefaultScriptRunner: Fires result listeners.
fireResultSetListeners(String, ResultSet) - Method in class org.tentackle.sql.DefaultScriptRunner: Fires result set listeners.
FLOAT - Enum constant in enum class org.tentackle.sql.SqlType: Float and float.
FloatPrimitiveType - Class in org.tentackle.sql.datatypes: Datatype for the primitive type float.
FloatPrimitiveType() - Constructor for class org.tentackle.sql.datatypes.FloatPrimitiveType: Creates the datatype for the primitive type float.
FloatType - Class in org.tentackle.sql.datatypes: Datatype for Float.
FloatType() - Constructor for class org.tentackle.sql.datatypes.FloatType: Creates the datatype for Float.
FOREIGN_KEY_NAME - Enum constant in enum class org.tentackle.sql.SqlNameType: name of a foreign key.
ForeignKeyAction - Enum Class in org.tentackle.sql.metadata: The referential actions of a foreign key.
Maps the importedKey... codes of DatabaseMetaData.getImportedKeys(String, String, String) to their SQL clauses.
ForeignKeyColumnMetaData - Class in org.tentackle.sql.metadata: Metadata for a column of a foreign key.
ForeignKeyColumnMetaData(ForeignKeyMetaData) - Constructor for class org.tentackle.sql.metadata.ForeignKeyColumnMetaData: Creates a foreign key column.
ForeignKeyMetaData - Class in org.tentackle.sql.metadata: Metadata for foreign keys.
ForeignKeyMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.ForeignKeyMetaData: Creates foreign key metadata.
format(Date) - Method in class org.tentackle.sql.datatypes.DateType: Formats a date as yyyy-MM-dd.
format(Time) - Method in class org.tentackle.sql.datatypes.TimeType: Formats a time as HH:mm:ss.
format(Timestamp) - Method in class org.tentackle.sql.datatypes.TimestampType: Formats a timestamp as yyyy-MM-dd HH:mm:ss, with .SSS appended if it has milliseconds.
format(Instant) - Method in class org.tentackle.sql.datatypes.InstantType: Converts an instant to a string.
The format is yyyy-MM-dd HH:mm:ss[.SSS|.nnnnnnnnn] in the system's default timezone.
format(LocalDate) - Method in class org.tentackle.sql.datatypes.LocalDateType: Converts a date object to a string.
format(LocalDateTime) - Method in class org.tentackle.sql.datatypes.LocalDateTimeType: Converts a date time object to a string.
format(LocalTime) - Method in class org.tentackle.sql.datatypes.LocalTimeType: Converts a time object to a string.
format(OffsetDateTime) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType: Converts an offset date time object to a string.
format(OffsetTime) - Method in class org.tentackle.sql.datatypes.OffsetTimeType: Converts an offset time object to a string.
format(ZonedDateTime) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType: Converts a zoned date time object to a string.
FULL - Enum constant in enum class org.tentackle.sql.JoinType: full outer join.
functionName() - Method in record class org.tentackle.sql.metadata.OracleIndexColumnMetaData.ColumnExpression: Returns the value of the functionName record component.

G

get(Class) - Method in interface org.tentackle.sql.DataTypeFactory: Gets the datatype singleton.
get(Class, String) - Method in interface org.tentackle.sql.DataTypeFactory: Gets the datatype singleton.
The type is looked up by the simple name of the class.
get(String) - Method in interface org.tentackle.sql.DataTypeFactory: Gets the datatype singleton.
get(String, String) - Method in interface org.tentackle.sql.DataTypeFactory: Gets the datatype singleton.
If there is no datatype for the given java type name and the variant is empty, the name is looked up as a model type (such as JSON or XML).
get(String, String) - Method in class org.tentackle.sql.DefaultDataTypeFactory
get(Backend, ResultSet, int[], boolean, Integer) - Method in interface org.tentackle.sql.DataType: Gets the object from a result set.
Must be implemented if DataType.isPredefined() returns false.
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.BigDecimalType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.BinaryType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.BMoneyType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.BooleanType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.ByteArrayType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.ByteType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.CharacterType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.ConvertibleType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.DateType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.DMoneyType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.DoubleType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.FloatType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.I18NTextType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.InstantType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.IntegerType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.JsonType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.LargeStringType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.LocalDateTimeType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.LocalDateType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.LocalTimeType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.LongType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.ShortType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.StringType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.TBinaryType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.TimestampType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.TimeType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.UUIDType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.XMLType
get(Backend, ResultSet, int[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
getAction() - Method in enum class org.tentackle.sql.metadata.Deferrability: Gets the JDBC DatabaseMetaData deferrability code.
getAction() - Method in enum class org.tentackle.sql.metadata.ForeignKeyAction: Gets the action code.
getAllBackends() - Method in interface org.tentackle.sql.BackendFactory: Gets all backends.
Skips backends marked as deprecated.
getAllBackends() - Method in class org.tentackle.sql.DefaultBackendFactory
getAllTablesInDatabase() - Method in class org.tentackle.sql.metadata.ModelMetaData: Gets the header info of all tables in the database.
getBackend() - Method in class org.tentackle.sql.BackendInfo: Gets the backend.
getBackend() - Method in class org.tentackle.sql.DefaultScriptRunner
getBackend() - Method in class org.tentackle.sql.metadata.ModelMetaData: Gets the backend.
getBackend() - Method in interface org.tentackle.sql.ScriptRunner: Gets the backend for this script runner.
getBackendByName(String) - Method in interface org.tentackle.sql.BackendFactory: Gets a backend by name.
getBackendByName(String) - Method in class org.tentackle.sql.DefaultBackendFactory
getBackendByUrl(String) - Method in interface org.tentackle.sql.BackendFactory: Gets a backend by jdbc url.
If more than one backend matches the URL, the first in the order of the backend names wins.
getBackendByUrl(String) - Method in class org.tentackle.sql.DefaultBackendFactory
getBackendFromJNDI(String, DataSource) - Method in class org.tentackle.sql.BackendInfo: Gets the backend from a JNDI datasource.
getBackendId(Connection) - Method in interface org.tentackle.sql.Backend: Determines the unique id or name used by the backend for a given connection.
getBackendId(Connection) - Method in class org.tentackle.sql.backends.CockroachDb
getBackendId(Connection) - Method in class org.tentackle.sql.backends.Db2
getBackendId(Connection) - Method in class org.tentackle.sql.backends.Firebird
getBackendId(Connection) - Method in class org.tentackle.sql.backends.H2
getBackendId(Connection) - Method in class org.tentackle.sql.backends.Hana
getBackendId(Connection) - Method in class org.tentackle.sql.backends.Informix: Determines the unique id or name used by the backend for a given connection.
getBackendId(Connection) - Method in class org.tentackle.sql.backends.MsSql
getBackendId(Connection) - Method in class org.tentackle.sql.backends.MySql
getBackendId(Connection) - Method in class org.tentackle.sql.backends.Oracle8
getBackendId(Connection) - Method in class org.tentackle.sql.backends.Postgres
getBackendIdentity() - Method in class org.tentackle.sql.BackendInfo: Gets the optional fixed identity to link different URLs to the same physical backend.
getBackends(String) - Method in interface org.tentackle.sql.BackendFactory: Gets a collection of backends via a comma-separated list of backend names.
There are some special names as well: all: all non-deprecated backends none: does not match any backend deprecated: all deprecated backends The returned list contains each backend only once.
getBackends(String) - Method in class org.tentackle.sql.DefaultBackendFactory
getBackendTimeout() - Method in class org.tentackle.sql.BackendInfo: Gets the optional database connection inactivity timeout.
getBlockCommentBegin() - Method in interface org.tentackle.sql.Backend: Gets the string to begin a block comment in generated code.
getBlockCommentBegin() - Method in class org.tentackle.sql.backends.AbstractBackend
getBlockCommentBegins() - Method in interface org.tentackle.sql.Backend: Gets all strings that begin a block comment.
getBlockCommentBegins() - Method in class org.tentackle.sql.backends.AbstractBackend
getBlockCommentEnd() - Method in interface org.tentackle.sql.Backend: Gets the string to end a block comment in generated code.
getBlockCommentEnd() - Method in class org.tentackle.sql.backends.AbstractBackend
getBlockCommentEnds() - Method in interface org.tentackle.sql.Backend: Gets all strings that end a block comment.
getBlockCommentEnds() - Method in class org.tentackle.sql.backends.AbstractBackend
getCatalog() - Method in class org.tentackle.sql.metadata.DatabaseMetaDataTableHeader: The optional catalog.
getCoalesceKeyword() - Method in interface org.tentackle.sql.Backend: Gets the keyword for the COALESCE function.
getCoalesceKeyword() - Method in class org.tentackle.sql.backends.AbstractBackend
getCoalesceKeyword() - Method in class org.tentackle.sql.backends.AbstractSql92Backend
getCoalesceKeyword() - Method in class org.tentackle.sql.backends.Informix
getColumnAlias(int) - Method in interface org.tentackle.sql.DataType: Gets the alias name of a column.
getColumnAlias(int) - Method in class org.tentackle.sql.datatypes.AbstractDataType
getColumnAlias(int) - Method in class org.tentackle.sql.datatypes.BMoneyType
getColumnAlias(int) - Method in class org.tentackle.sql.datatypes.DMoneyType
getColumnAlias(int) - Method in class org.tentackle.sql.datatypes.I18NTextType
getColumnAlias(int) - Method in class org.tentackle.sql.datatypes.InstantType
getColumnAlias(int) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
getColumnAlias(int) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
getColumnAlias(int) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
getColumnByName(String) - Method in class org.tentackle.sql.metadata.TableMetaData: Gets a column by its column name.
getColumnCount(Backend) - Method in interface org.tentackle.sql.DataType: Gets the number of database columns.
A tentackle type may be mapped to more than one column for multi-column types such as BMoney.
getColumnCount(Backend) - Method in class org.tentackle.sql.datatypes.AbstractDataType
getColumnCount(Backend) - Method in class org.tentackle.sql.datatypes.BMoneyType
getColumnCount(Backend) - Method in class org.tentackle.sql.datatypes.DMoneyType
getColumnCount(Backend) - Method in class org.tentackle.sql.datatypes.I18NTextType
getColumnCount(Backend) - Method in class org.tentackle.sql.datatypes.InstantType
getColumnCount(Backend) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
getColumnCount(Backend) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
getColumnCount(Backend) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
getColumnExpression(int) - Method in class org.tentackle.sql.metadata.OracleIndexMetaData: Gets the expression of an index column.
getColumnGetter(int, String) - Method in interface org.tentackle.sql.DataType: Returns the java code to get the value of a column.
getColumnGetter(int, String) - Method in class org.tentackle.sql.datatypes.AbstractDataType
getColumnGetter(int, String) - Method in class org.tentackle.sql.datatypes.BMoneyType
getColumnGetter(int, String) - Method in class org.tentackle.sql.datatypes.DMoneyType
getColumnGetter(int, String) - Method in class org.tentackle.sql.datatypes.I18NTextType
getColumnGetter(int, String) - Method in class org.tentackle.sql.datatypes.InstantType
getColumnGetter(int, String) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
getColumnGetter(int, String) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
getColumnGetter(int, String) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
getColumnName() - Method in class org.tentackle.sql.metadata.ColumnMetaData: Gets the name of the column.
getColumnName() - Method in class org.tentackle.sql.metadata.IndexColumnMetaData: Gets the column name.
getColumnName() - Method in class org.tentackle.sql.metadata.OracleIndexColumnMetaData
getColumnName() - Method in class org.tentackle.sql.metadata.PostgresIndexColumnMetaData
getColumns() - Method in class org.tentackle.sql.metadata.IndexMetaData: Gets the columns.
getColumns() - Method in class org.tentackle.sql.metadata.TableMetaData: Gets the metadata for columns.
getColumnSuffix(Backend, int) - Method in interface org.tentackle.sql.DataType: Gets the optional suffix.
Suffixes usually begin with an underscore.
getColumnSuffix(Backend, int) - Method in class org.tentackle.sql.datatypes.AbstractDataType: Predefined DataTypes must not override this method!
getColumnValue(Backend, int, Instant) - Method in class org.tentackle.sql.datatypes.InstantType
getColumnValue(Backend, int, OffsetDateTime) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
getColumnValue(Backend, int, OffsetTime) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
getColumnValue(Backend, int, ZonedDateTime) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
getColumnValue(Backend, int, BMoney) - Method in class org.tentackle.sql.datatypes.BMoneyType
getColumnValue(Backend, int, DMoney) - Method in class org.tentackle.sql.datatypes.DMoneyType
getColumnValue(Backend, int, I18NText) - Method in class org.tentackle.sql.datatypes.I18NTextType
getColumnValue(Backend, int, T) - Method in interface org.tentackle.sql.DataType: Gets the value of a column.
getColumnValue(Backend, int, T) - Method in class org.tentackle.sql.datatypes.AbstractDataType
getComment() - Method in class org.tentackle.sql.metadata.ColumnMetaData: Gets the comment.
getComment() - Method in class org.tentackle.sql.metadata.DatabaseMetaDataTableHeader: The optional comment.
getComment() - Method in class org.tentackle.sql.metadata.IndexMetaData: Gets the comment.
getComment() - Method in class org.tentackle.sql.metadata.TableMetaData: Gets the comment.
getCommentSuffix(Backend, int) - Method in interface org.tentackle.sql.DataType: Gets the optional comment suffix.
If present, it will be appended to the comment.
getCommentSuffix(Backend, int) - Method in class org.tentackle.sql.datatypes.AbstractDataType
getCommentSuffix(Backend, int) - Method in class org.tentackle.sql.datatypes.BMoneyType
getCommentSuffix(Backend, int) - Method in class org.tentackle.sql.datatypes.DMoneyType
getCommentSuffix(Backend, int) - Method in class org.tentackle.sql.datatypes.I18NTextType
getCommentSuffix(Backend, int) - Method in class org.tentackle.sql.datatypes.InstantType
getCommentSuffix(Backend, int) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
getCommentSuffix(Backend, int) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
getCommentSuffix(Backend, int) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
getConnection() - Method in class org.tentackle.sql.DefaultScriptRunner
getConnection() - Method in interface org.tentackle.sql.ScriptRunner: Gets the connection for this script runner.
getConvertibleType() - Method in interface org.tentackle.sql.DataTypeFactory: Gets the special convertible type singleton.
getConvertibleType() - Method in class org.tentackle.sql.DefaultDataTypeFactory
getDataTypeConstant() - Method in interface org.tentackle.sql.DataType: Gets the name of the datatype constant.
getDataTypeConstant() - Method in class org.tentackle.sql.datatypes.AbstractDataType
getDefaultSchema() - Method in interface org.tentackle.sql.Backend: Gets the default schema name.
Some backends store the objects in a default schema if no explicit schema is given.
getDefaultSchema() - Method in class org.tentackle.sql.backends.AbstractBackend
getDefaultSchema() - Method in class org.tentackle.sql.backends.H2
getDefaultSchema() - Method in class org.tentackle.sql.backends.Postgres
getDefaultSize(SqlType) - Method in interface org.tentackle.sql.Backend: Gets the default size if no size given in the model.
getDefaultSize(SqlType) - Method in class org.tentackle.sql.backends.AbstractBackend
getDefaultSize(SqlType) - Method in class org.tentackle.sql.backends.Firebird
getDefaultSize(SqlType) - Method in class org.tentackle.sql.backends.H2
getDefaultSize(SqlType) - Method in class org.tentackle.sql.backends.MySql
getDefaultSize(SqlType) - Method in class org.tentackle.sql.backends.Postgres
getDefaultValue() - Method in class org.tentackle.sql.metadata.ColumnMetaData: Gets the column's default.
getDefaultValue() - Method in enum class org.tentackle.sql.SqlType: Gets the default value.
getDeferrability() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Gets the deferrability.
getDeferrability() - Method in class org.tentackle.sql.metadata.IndexMetaData: Gets the deferrability of the unique constraint backing this index, if any.
Not populated from the standard JDBC index metadata (which has no such column) but by Backend.enrichIndexDeferrability(TableMetaData, Map, DatabaseMetaData), and only for backends supporting Backend.isSetConstraintsDeferredSupported().
getDeleteRule() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Gets the delete-rule.
getDriverClassName() - Method in interface org.tentackle.sql.Backend: Gets the JDBC driver class name.
getDriverClassName() - Method in class org.tentackle.sql.backends.Db2
getDriverClassName() - Method in class org.tentackle.sql.backends.Firebird
getDriverClassName() - Method in class org.tentackle.sql.backends.H2
getDriverClassName() - Method in class org.tentackle.sql.backends.Hana
getDriverClassName() - Method in class org.tentackle.sql.backends.Informix
getDriverClassName() - Method in class org.tentackle.sql.backends.MariaDb
getDriverClassName() - Method in class org.tentackle.sql.backends.MsSql
getDriverClassName() - Method in class org.tentackle.sql.backends.MySql
getDriverClassName() - Method in class org.tentackle.sql.backends.Oracle8
getDriverClassName() - Method in class org.tentackle.sql.backends.Postgres
getDummySelect() - Method in interface org.tentackle.sql.Backend: Gets the dummy select to keep/test connections alive.
Most databases just require a "SELECT 1".
getDummySelect() - Method in class org.tentackle.sql.backends.AbstractBackend
getDummySelect() - Method in class org.tentackle.sql.backends.Firebird
getDummySelect() - Method in class org.tentackle.sql.backends.Hana
getDummySelect() - Method in class org.tentackle.sql.backends.Oracle8
getEmptyString() - Method in interface org.tentackle.sql.Backend: Gets the empty string.
Some databases (most famous: Oracle) handle empty strings as null.
getEmptyString() - Method in class org.tentackle.sql.backends.AbstractBackend
getEmptyString() - Method in class org.tentackle.sql.backends.Oracle8
getExecutionTimeout() - Method in class org.tentackle.sql.DefaultScriptRunner
getExecutionTimeout() - Method in interface org.tentackle.sql.ScriptRunner: Gets the execution timeout in seconds.
getFilterCondition() - Method in class org.tentackle.sql.metadata.IndexMetaData: Gets the filter condition.
getForeignKeyColumn() - Method in class org.tentackle.sql.metadata.ForeignKeyColumnMetaData: Gets the referencing column.
getForeignKeyColumns() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Gets the columns.
getForeignKeyMetaData() - Method in class org.tentackle.sql.metadata.ForeignKeyColumnMetaData: Gets the foreign key.
getForeignKeyName() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Gets the name of the foreign key.
getForeignKeys() - Method in class org.tentackle.sql.metadata.TableMetaData: Gets the foreign keys.
getForeignKeySchema() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Gets the schema of the referencing table.
getForeignKeyTable() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Gets the referencing table.
getFullForeignKeyTableName() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Gets the full foreign key table name including optional schema.
getFullPrimaryKeyTableName() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Gets the full primary key table name including optional schema.
getFullTableName() - Method in class org.tentackle.sql.metadata.TableMetaData: Gets the database table name with optional schema name prepended.
The name is returned as reported by the database, which may be uppercase (Oracle, for example).
getFunctionName() - Method in class org.tentackle.sql.metadata.IndexColumnMetaData: Gets the optional function name.
getFunctionName() - Method in class org.tentackle.sql.metadata.OracleIndexColumnMetaData
getIndexes() - Method in class org.tentackle.sql.metadata.TableMetaData: Gets the metadata for indexes.
getIndexMetaData() - Method in class org.tentackle.sql.metadata.IndexColumnMetaData: Gets the index.
getIndexMetaDataCommentColumnName() - Method in interface org.tentackle.sql.Backend: Gets the column name for the comment within an index metadata result set.
getIndexMetaDataCommentColumnName() - Method in class org.tentackle.sql.backends.AbstractBackend
getIndexMetaDataCommentColumnName() - Method in class org.tentackle.sql.backends.Postgres
getIndexName() - Method in class org.tentackle.sql.metadata.IndexMetaData: Gets the index name.
getInstance() - Static method in interface org.tentackle.sql.BackendFactory: The singleton.
getInstance() - Static method in interface org.tentackle.sql.BackendInfoFactory: The singleton.
getInstance() - Static method in interface org.tentackle.sql.DataTypeFactory: The singleton.
getInstance() - Static method in class org.tentackle.sql.metadata.MetaDataUtilities: Gets the singleton.
getJavaType() - Method in interface org.tentackle.sql.DataType: Gets the name of the Java type.
getJavaType() - Method in class org.tentackle.sql.datatypes.BigDecimalType
getJavaType() - Method in class org.tentackle.sql.datatypes.BinaryType
getJavaType() - Method in class org.tentackle.sql.datatypes.BMoneyType
getJavaType() - Method in class org.tentackle.sql.datatypes.BooleanPrimitiveType
getJavaType() - Method in class org.tentackle.sql.datatypes.BooleanType
getJavaType() - Method in class org.tentackle.sql.datatypes.ByteArrayType
getJavaType() - Method in class org.tentackle.sql.datatypes.BytePrimitiveType
getJavaType() - Method in class org.tentackle.sql.datatypes.ByteType
getJavaType() - Method in class org.tentackle.sql.datatypes.CharacterPrimitiveType
getJavaType() - Method in class org.tentackle.sql.datatypes.CharacterType
getJavaType() - Method in class org.tentackle.sql.datatypes.ConvertibleType
getJavaType() - Method in class org.tentackle.sql.datatypes.DateType
getJavaType() - Method in class org.tentackle.sql.datatypes.DMoneyType
getJavaType() - Method in class org.tentackle.sql.datatypes.DoublePrimitiveType
getJavaType() - Method in class org.tentackle.sql.datatypes.DoubleType
getJavaType() - Method in class org.tentackle.sql.datatypes.FloatPrimitiveType
getJavaType() - Method in class org.tentackle.sql.datatypes.FloatType
getJavaType() - Method in class org.tentackle.sql.datatypes.I18NTextType
getJavaType() - Method in class org.tentackle.sql.datatypes.InstantType
getJavaType() - Method in class org.tentackle.sql.datatypes.IntegerPrimitiveType
getJavaType() - Method in class org.tentackle.sql.datatypes.IntegerType
getJavaType() - Method in class org.tentackle.sql.datatypes.LocalDateTimeType
getJavaType() - Method in class org.tentackle.sql.datatypes.LocalDateType
getJavaType() - Method in class org.tentackle.sql.datatypes.LocalTimeType
getJavaType() - Method in class org.tentackle.sql.datatypes.LongPrimitiveType
getJavaType() - Method in class org.tentackle.sql.datatypes.LongType
getJavaType() - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
getJavaType() - Method in class org.tentackle.sql.datatypes.OffsetTimeType
getJavaType() - Method in class org.tentackle.sql.datatypes.ShortPrimitiveType
getJavaType() - Method in class org.tentackle.sql.datatypes.ShortType
getJavaType() - Method in class org.tentackle.sql.datatypes.StringType
getJavaType() - Method in class org.tentackle.sql.datatypes.TBinaryType
getJavaType() - Method in class org.tentackle.sql.datatypes.TimestampType
getJavaType() - Method in class org.tentackle.sql.datatypes.TimeType
getJavaType() - Method in class org.tentackle.sql.datatypes.UUIDType
getJavaType() - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
getJndiDataSource() - Method in class org.tentackle.sql.BackendInfo: Gets the JNDI source.
getJson(ResultSet, int) - Method in interface org.tentackle.sql.Backend: Gets a JSON parameter from a result set.
getJson(ResultSet, int) - Method in class org.tentackle.sql.backends.AbstractBackend
getMajorVersion() - Method in class org.tentackle.sql.DynamicDriver
getMappedNullValue(Backend, int) - Method in interface org.tentackle.sql.DataType: Gets the mapped non-null value that represents the model's null value.
The method throws a BackendException, if !
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.AbstractDataType
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.CharacterType
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.DateType
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.InstantType
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.JsonType
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.LocalDateTimeType
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.LocalDateType
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.StringType
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.TimestampType
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.UUIDType
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.XMLType
getMappedNullValue(Backend, int) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
getMaxNameLength(SqlNameType) - Method in interface org.tentackle.sql.Backend: Gets the maximum allowed length for a name.
This method is used by Backend.assertValidName(SqlNameType, String).
getMaxNameLength(SqlNameType) - Method in class org.tentackle.sql.backends.AbstractBackend
getMaxNameLength(SqlNameType) - Method in class org.tentackle.sql.backends.Db2
getMaxNameLength(SqlNameType) - Method in class org.tentackle.sql.backends.Firebird
getMaxNameLength(SqlNameType) - Method in class org.tentackle.sql.backends.H2
getMaxNameLength(SqlNameType) - Method in class org.tentackle.sql.backends.Hana
getMaxNameLength(SqlNameType) - Method in class org.tentackle.sql.backends.Informix
getMaxNameLength(SqlNameType) - Method in class org.tentackle.sql.backends.MySql
getMaxNameLength(SqlNameType) - Method in class org.tentackle.sql.backends.Oracle8
getMaxNameLength(SqlNameType) - Method in class org.tentackle.sql.backends.Postgres
getMaxRows() - Method in class org.tentackle.sql.DefaultScriptRunner
getMaxRows() - Method in interface org.tentackle.sql.ScriptRunner: Gets the maximum number of rows to be returned by each statement within the script.
getMaxScale(SqlType, int) - Method in interface org.tentackle.sql.Backend: Returns the maximum scale for a given SQL type and size.
getMaxScale(SqlType, int) - Method in class org.tentackle.sql.backends.AbstractBackend
getMaxScale(SqlType, int) - Method in class org.tentackle.sql.backends.MySql
getMaxSize(Backend, Integer) - Method in class org.tentackle.sql.datatypes.I18NTextType: Calculates the maximum size of the 1st VARCHAR column.
getMaxSize(SqlType) - Method in interface org.tentackle.sql.Backend: Returns the maximum size for a given SQL type.
getMaxSize(SqlType) - Method in class org.tentackle.sql.backends.AbstractBackend
getMaxSize(SqlType) - Method in class org.tentackle.sql.backends.Db2
getMaxSize(SqlType) - Method in class org.tentackle.sql.backends.Firebird
getMaxSize(SqlType) - Method in class org.tentackle.sql.backends.H2
getMaxSize(SqlType) - Method in class org.tentackle.sql.backends.Hana
getMaxSize(SqlType) - Method in class org.tentackle.sql.backends.Informix
getMaxSize(SqlType) - Method in class org.tentackle.sql.backends.MsSql
getMaxSize(SqlType) - Method in class org.tentackle.sql.backends.MySql
getMaxSize(SqlType) - Method in class org.tentackle.sql.backends.Oracle8
getMaxSize(SqlType) - Method in class org.tentackle.sql.backends.Postgres
getMetaData() - Method in class org.tentackle.sql.metadata.DatabaseMetaDataTableHeader: Gets the metadata root object this table header was retrieved from.
getMetaData() - Method in class org.tentackle.sql.metadata.ModelMetaData: Gets the JDBC-connection's metadata.
May be more than one if different schemas and the schema option were given in BackendInfo.
getMetaData(BackendInfo) - Method in interface org.tentackle.sql.Backend: Gets the metadata from the backend.
getMetaData(BackendInfo) - Method in class org.tentackle.sql.backends.AbstractBackend
getMetaData(BackendInfo) - Method in class org.tentackle.sql.backends.MySql: Gets the metadata from the backend.
getMethodTypeName() - Method in interface org.tentackle.sql.DataType: Gets the type name used to build method names, such as the getters and setters of the JDBC wrappers.
Usually the java type, but must be a valid java identifier (e.g.
getMethodTypeName() - Method in class org.tentackle.sql.datatypes.AbstractDataType
getMethodTypeName() - Method in class org.tentackle.sql.datatypes.ByteArrayType: Gets the type name used to build method names, such as the getters and setters of the JDBC wrappers.
Usually the java type, but must be a valid java identifier (e.g.
getMigrationStrategy(ColumnMetaData, String, String, SqlType, int, int, boolean, Object) - Method in interface org.tentackle.sql.Backend: Determines the best migration strategy.
getMigrationStrategy(ColumnMetaData, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.AbstractBackend
getMigrationStrategy(ColumnMetaData, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Hana: Determines the best migration strategy.
getMigrationStrategy(ColumnMetaData, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.MySql: Determines the best migration strategy.
getMigrationStrategy(ColumnMetaData, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Postgres: Determines the best migration strategy.
getMinorVersion() - Method in class org.tentackle.sql.DynamicDriver
getModelMetaData() - Method in class org.tentackle.sql.metadata.TableMetaData: Gets the model this table belongs to.
getModelMetaData(DatabaseMetaData[], String[], String...) - Method in interface org.tentackle.sql.Backend: Retrieves the metadata.
getModelMetaData(DatabaseMetaData[], String[], String...) - Method in class org.tentackle.sql.backends.AbstractBackend
getModelTableName() - Method in class org.tentackle.sql.metadata.TableMetaData: Gets the table name used in the model.
getModelType() - Method in interface org.tentackle.sql.DataType: Gets the model type string.
This is usually identical to the java type, but some variants (such as JSON or XML) may differ.
getModelType() - Method in class org.tentackle.sql.datatypes.AbstractDataType
getModelType() - Method in class org.tentackle.sql.datatypes.JsonType
getModelType() - Method in class org.tentackle.sql.datatypes.XMLType
getName() - Method in interface org.tentackle.sql.Backend: Gets the name of the backend.
getName() - Method in class org.tentackle.sql.backends.CockroachDb
getName() - Method in class org.tentackle.sql.backends.Db2
getName() - Method in class org.tentackle.sql.backends.Firebird
getName() - Method in class org.tentackle.sql.backends.H2
getName() - Method in class org.tentackle.sql.backends.Hana
getName() - Method in class org.tentackle.sql.backends.Informix
getName() - Method in class org.tentackle.sql.backends.MariaDb
getName() - Method in class org.tentackle.sql.backends.MsSql
getName() - Method in class org.tentackle.sql.backends.MySql
getName() - Method in class org.tentackle.sql.backends.Oracle
getName() - Method in class org.tentackle.sql.backends.Oracle21
getName() - Method in class org.tentackle.sql.backends.Oracle23
getName() - Method in class org.tentackle.sql.backends.Oracle8
getName() - Method in class org.tentackle.sql.backends.Postgres
getName() - Method in class org.tentackle.sql.metadata.DatabaseMetaDataTableHeader: Gets the table's name.
getParentLogger() - Method in class org.tentackle.sql.DynamicDriver
getPassword() - Method in class org.tentackle.sql.BackendInfo: Gets the connection password.
getPosition() - Method in class org.tentackle.sql.metadata.ForeignKeyColumnMetaData: Gets the ordinal position within the foreign key.
getPosition() - Method in class org.tentackle.sql.metadata.IndexColumnMetaData: Gets the ordinal position within the index.
getPrimaryKeyColumn() - Method in class org.tentackle.sql.metadata.ForeignKeyColumnMetaData: Gets the primary key column.
getPrimaryKeySchema() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Gets the schema of the referenced table.
getPrimaryKeyTable() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Gets the referenced table.
getPropertyInfo(String, Properties) - Method in class org.tentackle.sql.DynamicDriver
getReservedWords() - Method in interface org.tentackle.sql.Backend: Gets the list of reserved words for this backend.
getReservedWords() - Method in class org.tentackle.sql.backends.AbstractSql2003Backend
getReservedWords() - Method in class org.tentackle.sql.backends.AbstractSql92Backend
getReservedWords() - Method in class org.tentackle.sql.backends.Firebird
getReservedWords() - Method in class org.tentackle.sql.backends.H2
getReservedWords() - Method in class org.tentackle.sql.backends.Hana
getReservedWords() - Method in class org.tentackle.sql.backends.MySql
getReservedWords() - Method in class org.tentackle.sql.backends.Postgres
getResults() - Method in exception class org.tentackle.sql.ScriptRunnerException: Gets the results collected so far.
getScale() - Method in class org.tentackle.sql.metadata.ColumnMetaData: Gets the numeric scale.
getScale(Backend, int, Integer) - Method in interface org.tentackle.sql.DataType: Gets the column scale.
The scale may be differently aligned according to the backend.
getScale(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.AbstractDataType
getScale(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.BMoneyType
getScale(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.DMoneyType
getScale(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.I18NTextType
getScale(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.InstantType
getScale(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
getScale(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
getScale(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
getSchema() - Method in class org.tentackle.sql.metadata.DatabaseMetaDataTableHeader: The optional schema.
getSchemaName() - Method in class org.tentackle.sql.metadata.TableMetaData: Gets the database schema name.
The name is returned as reported by the database, which may be uppercase (Oracle, for example).
getSchemas() - Method in class org.tentackle.sql.BackendInfo: Gets the schemas.
getSchemas() - Method in class org.tentackle.sql.metadata.ModelMetaData: Gets the valid schemas.
getSingleLineComment() - Method in interface org.tentackle.sql.Backend: Gets the string to begin a single line comment in generated code.
getSingleLineComment() - Method in class org.tentackle.sql.backends.AbstractBackend
getSingleLineComments() - Method in interface org.tentackle.sql.Backend: Gets all strings that start a single line comment.
getSingleLineComments() - Method in class org.tentackle.sql.backends.AbstractBackend
getSize() - Method in class org.tentackle.sql.metadata.ColumnMetaData: Gets the column's size.
getSize(Backend, int, Integer) - Method in interface org.tentackle.sql.DataType: Gets the column size.
Sizes may be differently aligned according to the backend.
getSize(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.AbstractDataType
getSize(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.BMoneyType
getSize(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.DMoneyType
getSize(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.I18NTextType
getSize(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.InstantType
getSize(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
getSize(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
getSize(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.UUIDType
getSize(Backend, int, Integer) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
getSortableColumns() - Method in interface org.tentackle.sql.DataType: Gets the indexes to the sortable columns.
The number and order of the indexes is reflected in the generated order-by SQL clause.
getSortableColumns() - Method in class org.tentackle.sql.datatypes.AbstractDataType
getSortableColumns() - Method in class org.tentackle.sql.datatypes.DMoneyType
getSortableColumns() - Method in class org.tentackle.sql.datatypes.InstantType
getSortableColumns() - Method in class org.tentackle.sql.datatypes.JsonType: Gets the indexes to the sortable columns.
The number and order of the indexes is reflected in the generated order-by SQL clause.
getSortableColumns() - Method in class org.tentackle.sql.datatypes.OffsetTimeType
getSortableColumns() - Method in class org.tentackle.sql.datatypes.UUIDType
getSortableColumns() - Method in class org.tentackle.sql.datatypes.XMLType: Gets the indexes to the sortable columns.
The number and order of the indexes is reflected in the generated order-by SQL clause.
getSortableColumns() - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
getSql() - Method in enum class org.tentackle.sql.metadata.Deferrability: Gets the DDL clause to append to a CREATE/ADD CONSTRAINT statement.
getSql() - Method in enum class org.tentackle.sql.metadata.ForeignKeyAction: Gets the SQL code.
getSql() - Method in exception class org.tentackle.sql.ScriptRunnerException: Gets the SQL code that failed.
getSqlType(Backend, int) - Method in interface org.tentackle.sql.DataType: Gets the SQL type.
For predefined types, the type must be the same for all backends and the backend argument may be null.
Application-specific types, however, can use different SQL types for different backends, and for those types the backend argument is always valid.
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.BigDecimalType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.BinaryType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.BMoneyType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.BooleanType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.ByteArrayType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.ByteType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.CharacterType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.ConvertibleType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.DateType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.DMoneyType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.DoubleType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.FloatType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.I18NTextType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.InstantType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.IntegerType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.JsonType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.LargeStringType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.LocalDateTimeType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.LocalDateType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.LocalTimeType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.LongType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.ShortType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.StringType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.TBinaryType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.TimestampType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.TimeType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.UUIDType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.XMLType
getSqlType(Backend, int) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
getStatementSeparator() - Method in interface org.tentackle.sql.Backend: The SQL statement separator used in generated code.
getStatementSeparator() - Method in class org.tentackle.sql.backends.AbstractBackend
getStatementSeparators() - Method in interface org.tentackle.sql.Backend: Gets all SQL statement separators.
getStatementSeparators() - Method in class org.tentackle.sql.backends.AbstractBackend
getTableHeaders(DatabaseMetaData) - Method in interface org.tentackle.sql.Backend: Gets all table headers for a given metadata.
getTableHeaders(DatabaseMetaData) - Method in class org.tentackle.sql.backends.AbstractBackend
getTableInDatabase(String) - Method in class org.tentackle.sql.metadata.ModelMetaData: Gets the header info for the given table name.
May return more than one entry if the same table name is used in more than one schema.
getTableMetaData() - Method in class org.tentackle.sql.metadata.ColumnMetaData: Gets the table metadata.
getTableMetaData() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Gets the table this foreign key belongs to.
getTableMetaData() - Method in class org.tentackle.sql.metadata.IndexMetaData: Gets the table.
getTableMetaData(ModelMetaData, String) - Method in interface org.tentackle.sql.Backend: Gets the table metadata for a given table name.
getTableMetaData(ModelMetaData, String) - Method in class org.tentackle.sql.backends.AbstractBackend
getTableName() - Method in class org.tentackle.sql.metadata.TableMetaData: Gets the database table name.
The name is returned as reported by the database, which may be uppercase (Oracle, for example).
getTables() - Method in class org.tentackle.sql.metadata.ModelMetaData: Gets the tables of this model.
getType() - Method in class org.tentackle.sql.metadata.ColumnMetaData: Gets the column's type.
getType() - Method in class org.tentackle.sql.metadata.DatabaseMetaDataTableHeader: Gets the table type.
getTypeName() - Method in class org.tentackle.sql.metadata.ColumnMetaData: Gets the backend-specific type name.
getUpdateCount() - Method in record class org.tentackle.sql.ScriptRunnerResult: Gets the update count.
getUpdateRule() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Gets the update-rule.
getUrl() - Method in class org.tentackle.sql.BackendInfo: Gets the connection url.
getUser() - Method in class org.tentackle.sql.BackendInfo: Gets the username to connect.
getVariant() - Method in interface org.tentackle.sql.DataType: Gets the optional variant of the type.
If a variant is not empty, it replaces the java type suffix for setters and getters.
getVariant() - Method in class org.tentackle.sql.datatypes.AbstractDataType
getVariant() - Method in class org.tentackle.sql.datatypes.JsonType
getVariant() - Method in class org.tentackle.sql.datatypes.LargeStringType
getVariant() - Method in class org.tentackle.sql.datatypes.XMLType
getXADataSourceClassName() - Method in interface org.tentackle.sql.Backend: Gets the name of the JDBC driver's XADataSource class.
Required for connections taking part in global (XA) transactions.
getXADataSourceClassName() - Method in class org.tentackle.sql.backends.AbstractBackend
getXADataSourceClassName() - Method in class org.tentackle.sql.backends.CockroachDb
getXADataSourceClassName() - Method in class org.tentackle.sql.backends.H2
getXADataSourceClassName() - Method in class org.tentackle.sql.backends.MariaDb
getXADataSourceClassName() - Method in class org.tentackle.sql.backends.MsSql
getXADataSourceClassName() - Method in class org.tentackle.sql.backends.MySql
getXADataSourceClassName() - Method in class org.tentackle.sql.backends.Oracle8
getXADataSourceClassName() - Method in class org.tentackle.sql.backends.Postgres
GMT - Static variable in class org.tentackle.sql.datatypes.ZonedDateTimeType: GMT timezone name.

H

H2 - Class in org.tentackle.sql.backends: Backend for the H2 Database.
H2() - Constructor for class org.tentackle.sql.backends.H2: Creates the H2 backend.
Hana - Class in org.tentackle.sql.backends: Backend for SAP HANA.
Hana() - Constructor for class org.tentackle.sql.backends.Hana: Creates the HANA backend.
hashCode() - Method in record class org.tentackle.sql.BackendVersionInfo: Returns a hash code value for this object.
hashCode() - Method in class org.tentackle.sql.datatypes.AbstractDataType
hashCode() - Method in record class org.tentackle.sql.DefaultScriptRunner.SQLCode: Returns a hash code value for this object.
hashCode() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData
hashCode() - Method in class org.tentackle.sql.metadata.IndexMetaData
hashCode() - Method in record class org.tentackle.sql.metadata.OracleIndexColumnMetaData.ColumnExpression: Returns a hash code value for this object.
hashCode() - Method in class org.tentackle.sql.metadata.TableMetaData
hashCode() - Method in record class org.tentackle.sql.ScriptRunnerResult: Returns a hash code value for this object.

I

I18NTextType - Class in org.tentackle.sql.datatypes: Datatype for I18NText.
Stored as one or two columns, depending on the backend.
I18NTextType() - Constructor for class org.tentackle.sql.datatypes.I18NTextType: Creates the datatype for I18NText.
INDEX_NAME - Enum constant in enum class org.tentackle.sql.SqlNameType: name of an index.
IndexColumnMetaData - Class in org.tentackle.sql.metadata: Metadata for a column of an index.
IndexColumnMetaData(IndexMetaData) - Constructor for class org.tentackle.sql.metadata.IndexColumnMetaData: Creates an index column.
IndexMetaData - Class in org.tentackle.sql.metadata: Metadata for an index.
IndexMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.IndexMetaData: Creates an index metadata object.
Informix - Class in org.tentackle.sql.backends: Backend for Informix.
Informix() - Constructor for class org.tentackle.sql.backends.Informix: Creates the Informix backend.
INITIALLY_DEFERRED - Enum constant in enum class org.tentackle.sql.metadata.ForeignKeyAction: Indicates deferrability.
INITIALLY_IMMEDIATE - Enum constant in enum class org.tentackle.sql.metadata.ForeignKeyAction: Indicates deferrability.
INNER - Enum constant in enum class org.tentackle.sql.JoinType: inner join.
InstantType - Class in org.tentackle.sql.datatypes: Datatype for Instant.
InstantType() - Constructor for class org.tentackle.sql.datatypes.InstantType: Creates the datatype for Instant.
INTEGER - Enum constant in enum class org.tentackle.sql.SqlType: Integer and int.
IntegerPrimitiveType - Class in org.tentackle.sql.datatypes: Datatype for the primitive type int.
IntegerPrimitiveType() - Constructor for class org.tentackle.sql.datatypes.IntegerPrimitiveType: Creates the datatype for the primitive type int.
IntegerType - Class in org.tentackle.sql.datatypes: Datatype for Integer.
IntegerType() - Constructor for class org.tentackle.sql.datatypes.IntegerType: Creates the datatype for Integer.
isAliasRequiredForSubSelect() - Method in interface org.tentackle.sql.Backend: Returns whether the backend requires an alias for a sub-select.
isAliasRequiredForSubSelect() - Method in class org.tentackle.sql.backends.AbstractBackend
isAliasRequiredForSubSelect() - Method in class org.tentackle.sql.backends.Firebird
isAliasRequiredForSubSelect() - Method in class org.tentackle.sql.backends.H2
isAliasRequiredForSubSelect() - Method in class org.tentackle.sql.backends.Hana
isAliasRequiredForSubSelect() - Method in class org.tentackle.sql.backends.MySql
isAliasRequiredForSubSelect() - Method in class org.tentackle.sql.backends.Postgres
isArrayOperatorSupported(String) - Method in interface org.tentackle.sql.Backend: Returns whether the backend supports the given array operator.
isArrayOperatorSupported(String) - Method in class org.tentackle.sql.backends.AbstractBackend
isArrayOperatorSupported(String) - Method in class org.tentackle.sql.backends.H2
isArrayOperatorSupported(String) - Method in class org.tentackle.sql.backends.Postgres
isBackendKeepAliveEnabled() - Method in class org.tentackle.sql.BackendInfo: Returns whether dummy selects should be sent periodically or only on re-use of an idle connection.
isBool() - Method in interface org.tentackle.sql.DataType: Returns whether this is a boolean or Boolean type.
isBool() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isBool() - Method in class org.tentackle.sql.datatypes.BooleanType
isCanceled() - Method in class org.tentackle.sql.DefaultScriptRunner
isCanceled() - Method in interface org.tentackle.sql.ScriptRunner: Returns whether the script execution was canceled.
isClobSupported() - Method in interface org.tentackle.sql.Backend: Returns whether the backend supports CLOB types.
If not, it will be emulated as VARCHAR with the maximum possible size.
isClobSupported() - Method in class org.tentackle.sql.backends.AbstractBackend
isClobSupported() - Method in class org.tentackle.sql.backends.Postgres
isColumnCountBackendSpecific() - Method in interface org.tentackle.sql.DataType: Returns whether the number of columns is backend-specific.
For such types the following restrictions apply: no CN_... will be generated for the individual columns, just the column basename they cannot be used as wurblet arguments (to generate the WHERE-clause) the application cannot refer to a column in a backend-agnostic way
isColumnCountBackendSpecific() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isColumnCountBackendSpecific() - Method in class org.tentackle.sql.datatypes.I18NTextType
isCommunicationLinkException(SQLException) - Method in interface org.tentackle.sql.Backend: Determines whether the exception is a communication error.
isCommunicationLinkException(SQLException) - Method in class org.tentackle.sql.backends.AbstractBackend
isCommunicationLinkException(SQLException) - Method in class org.tentackle.sql.backends.Hana
isComparable() - Method in interface org.tentackle.sql.DataType: Returns whether this type can be compared, e.g., for equality or ordering.
Some types have no backend-provided comparator at all, for example, XML or JSON documents: comparing or ordering by such a column is meaningless, and such types cannot be part of an index or used as a query/sort argument.
isComparable() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isComparable() - Method in class org.tentackle.sql.datatypes.JsonType: Returns whether this type can be compared, e.g., for equality or ordering.
Some types have no backend-provided comparator at all, for example, XML or JSON documents: comparing or ordering by such a column is meaningless, and such types cannot be part of an index or used as a query/sort argument.
isComparable() - Method in class org.tentackle.sql.datatypes.XMLType: Returns whether this type can be compared, e.g., for equality or ordering.
Some types have no backend-provided comparator at all, for example, XML or JSON documents: comparing or ordering by such a column is meaningless, and such types cannot be part of an index or used as a query/sort argument.
isConnectable() - Method in class org.tentackle.sql.BackendInfo: Returns whether backend info can be used to connect.
isConstraintException(SQLException) - Method in interface org.tentackle.sql.Backend: Determines whether exception is a constraint violation.
isConstraintException(SQLException) - Method in class org.tentackle.sql.backends.AbstractBackend
isConstraintException(SQLException) - Method in class org.tentackle.sql.backends.Hana
isDatabaseInMemory(String) - Method in interface org.tentackle.sql.Backend: Returns whether the URL denotes an in-memory database.
Used by test suites to decide whether to populate the database before running the tests.
isDatabaseInMemory(String) - Method in class org.tentackle.sql.backends.AbstractBackend
isDatabaseInMemory(String) - Method in class org.tentackle.sql.backends.H2
isDateOrTime() - Method in interface org.tentackle.sql.DataType: Returns whether this is a date and/or time type.
isDateOrTime() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isDateOrTime() - Method in class org.tentackle.sql.datatypes.AbstractDateTimeType
isDefaultEqual(ColumnMetaData, SqlType, Object) - Method in interface org.tentackle.sql.Backend: Checks whether the column's default corresponds to the model's default value.
isDefaultEqual(ColumnMetaData, SqlType, Object) - Method in class org.tentackle.sql.backends.AbstractBackend
isDefaultEqual(ColumnMetaData, SqlType, Object) - Method in class org.tentackle.sql.backends.MySql
isDefaultEqual(ColumnMetaData, SqlType, Object) - Method in class org.tentackle.sql.backends.Oracle23
isDefaultEqual(ColumnMetaData, SqlType, Object) - Method in class org.tentackle.sql.backends.Oracle8
isDeferrable() - Method in enum class org.tentackle.sql.metadata.Deferrability: Returns whether this deferrability requires the constraint to be declared DEFERRABLE.
isDeprecated() - Method in interface org.tentackle.sql.Backend: Returns whether this backend is deprecated and superseded by a newer implementation.
Deprecated backends are omitted from BackendFactory.getAllBackends().
isDeprecated() - Method in class org.tentackle.sql.backends.AbstractBackend
isDeprecated() - Method in class org.tentackle.sql.backends.Oracle
isDeprecated() - Method in class org.tentackle.sql.backends.Oracle8
isDescending() - Method in class org.tentackle.sql.metadata.IndexColumnMetaData: Returns whether the column is sorted in descending order.
isDowncastNecessary() - Method in interface org.tentackle.sql.DataType: For certain numeric types, a downcast is necessary when assigning literals.
isDowncastNecessary() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isDowncastNecessary() - Method in class org.tentackle.sql.datatypes.ByteType
isDowncastNecessary() - Method in class org.tentackle.sql.datatypes.ShortType
isDropIfExistsEnabled() - Method in interface org.tentackle.sql.Backend: Returns whether backend should add IF EXISTS for generated DROPs.
isDropIfExistsEnabled() - Method in class org.tentackle.sql.backends.AbstractBackend
isDropIfExistsSupported() - Method in class org.tentackle.sql.backends.AbstractBackend: Adds "IF EXISTS" to drop clauses, if supported by the backend.
Makes migration a little more robust in case the same SQL scripts are applied to different databases than those used to generate the migration scripts for.
isDropIfExistsSupported() - Method in class org.tentackle.sql.backends.Db2
isDropIfExistsSupported() - Method in class org.tentackle.sql.backends.H2
isDropIfExistsSupported() - Method in class org.tentackle.sql.backends.Informix
isDropIfExistsSupported() - Method in class org.tentackle.sql.backends.MariaDb
isDropIfExistsSupported() - Method in class org.tentackle.sql.backends.MsSql
isDropIfExistsSupported() - Method in class org.tentackle.sql.backends.Oracle23
isDropIfExistsSupported() - Method in class org.tentackle.sql.backends.Postgres
isEscapeProcessingEnabled() - Method in class org.tentackle.sql.DefaultScriptRunner
isEscapeProcessingEnabled() - Method in interface org.tentackle.sql.ScriptRunner: Returns whether JDBC escape processing is enabled.
isExceptionErrorCodeMatching(SQLException, int...) - Method in class org.tentackle.sql.backends.AbstractBackend: Checks if the exception's error code equals the given number(s).
isExceptionStateMatching(SQLException, String...) - Method in class org.tentackle.sql.backends.AbstractBackend: Checks if the exception's state equals given string(s).
isExceptionStateStartingWith(SQLException, String...) - Method in class org.tentackle.sql.backends.AbstractBackend: Checks if the exception's state starts with a given string(s).
isExpressionReferringToTableBeingUpdatedSupported() - Method in interface org.tentackle.sql.Backend: Determines whether the backend allows expressions referring to tables being updated.
isExpressionReferringToTableBeingUpdatedSupported() - Method in class org.tentackle.sql.backends.AbstractBackend
isExpressionReferringToTableBeingUpdatedSupported() - Method in class org.tentackle.sql.backends.MySql
isExtraCommitRequired() - Method in interface org.tentackle.sql.Backend: According to the JDBC-specs Connection.setAutoCommit(boolean)(true) should commit, but some backends require an extra Connection.commit().
isExtraCommitRequired() - Method in class org.tentackle.sql.backends.AbstractBackend
isExtraCommitRequired() - Method in class org.tentackle.sql.backends.Oracle8
isFilteredIndexSupported() - Method in interface org.tentackle.sql.Backend: Returns whether backend supports filtered indexes.
isFilteredIndexSupported() - Method in class org.tentackle.sql.backends.AbstractBackend
isFilteredIndexSupported() - Method in class org.tentackle.sql.backends.MsSql
isFilteredIndexSupported() - Method in class org.tentackle.sql.backends.Oracle
isFilteredIndexSupported() - Method in class org.tentackle.sql.backends.Postgres
isFunctionBasedIndexSupported() - Method in interface org.tentackle.sql.Backend: Returns whether function-based indexes are supported.
isFunctionBasedIndexSupported() - Method in class org.tentackle.sql.backends.AbstractBackend
isFunctionBasedIndexSupported() - Method in class org.tentackle.sql.backends.Db2
isFunctionBasedIndexSupported() - Method in class org.tentackle.sql.backends.MariaDb
isFunctionBasedIndexSupported() - Method in class org.tentackle.sql.backends.MySql
isFunctionBasedIndexSupported() - Method in class org.tentackle.sql.backends.Oracle
isFunctionBasedIndexSupported() - Method in class org.tentackle.sql.backends.Postgres
isGMT(String) - Static method in class org.tentackle.sql.datatypes.ZonedDateTimeType: Returns whether the given zoneId string corresponds to GMT.
isJavaTypeGenerified() - Method in interface org.tentackle.sql.DataType: Returns whether the inner type describes a generified java type.
Implies DataType.isModelProvidingInnerType().
isJavaTypeGenerified() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isJavaTypeGenerified() - Method in class org.tentackle.sql.datatypes.BinaryType
isJavaTypeGenerified() - Method in class org.tentackle.sql.datatypes.TBinaryType
isJsonSupported() - Method in interface org.tentackle.sql.Backend: Returns whether the backend stores JSON in a native JSON column.
If not, JSON content is emulated as CLOB/VARCHAR.
isJsonSupported() - Method in class org.tentackle.sql.backends.AbstractBackend
isJsonSupported() - Method in class org.tentackle.sql.backends.H2
isJsonSupported() - Method in class org.tentackle.sql.backends.MariaDb
isJsonSupported() - Method in class org.tentackle.sql.backends.MySql
isJsonSupported() - Method in class org.tentackle.sql.backends.Oracle21
isJsonSupported() - Method in class org.tentackle.sql.backends.Postgres
isLeadingSelectMissing(StringBuilder) - Method in class org.tentackle.sql.backends.AbstractSql92Backend: Determines whether AbstractSql92Backend.buildSelectSql(StringBuilder, boolean, int, int) must prepend a "SELECT ".
isLiteralSupported(Integer) - Method in interface org.tentackle.sql.DataType: Returns whether this type can be used literally in a query String.
isLiteralSupported(Integer) - Method in class org.tentackle.sql.datatypes.AbstractDataType
isLiteralSupported(Integer) - Method in class org.tentackle.sql.datatypes.I18NTextType
isLobDeclaration(SqlType, int) - Method in class org.tentackle.sql.backends.MySql: Returns whether the given type is declared as a TEXT-, BLOB- or JSON-type.
The default of such columns must be an expression.
isMapNullSupported() - Method in interface org.tentackle.sql.DataType: Returns whether this type supports mapping null values to some well-defined constant.
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.CharacterPrimitiveType: Returns whether this type supports mapping null values to some well-defined constant.
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.CharacterType
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.DateType
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.InstantType
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.JsonType: Returns whether this type supports mapping null values to some well-defined constant.
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.LocalDateTimeType
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.LocalDateType
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.StringType
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.TimestampType
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.UUIDType
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.XMLType: Returns whether this type supports mapping null values to some well-defined constant.
isMapNullSupported() - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
isMatchingName(String) - Method in interface org.tentackle.sql.Backend: Checks whether the backend belongs to the given name.
isMatchingName(String) - Method in class org.tentackle.sql.backends.AbstractBackend
isMatchingUrl(String) - Method in interface org.tentackle.sql.Backend: Checks whether the backend belongs to the given jdbc url.
If multiple backend implementations are provided for the same database type, only one backend should match the URL.
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.CockroachDb
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.Db2
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.Firebird
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.H2
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.Hana
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.Informix
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.MariaDb
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.MsSql
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.MySql
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.Oracle21
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.Oracle23
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.Oracle8
isMatchingUrl(String) - Method in class org.tentackle.sql.backends.Postgres
isModelProvidingInnerType() - Method in interface org.tentackle.sql.DataType: Returns whether the model provides an inner type.
isModelProvidingInnerType() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isModelProvidingInnerType() - Method in class org.tentackle.sql.datatypes.ConvertibleType
isMutable() - Method in interface org.tentackle.sql.DataType: Returns whether the type is a mutable java object.
Mutable objects may change their state and must implement Freezable.
isMutable() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isMutable() - Method in class org.tentackle.sql.datatypes.BinaryType
isMutable() - Method in class org.tentackle.sql.datatypes.DateType
isMutable() - Method in class org.tentackle.sql.datatypes.TBinaryType
isMutable() - Method in class org.tentackle.sql.datatypes.TimestampType
isMutable() - Method in class org.tentackle.sql.datatypes.TimeType
isNullable() - Method in class org.tentackle.sql.metadata.ColumnMetaData: Returns whether column is nullable.
isNumeric() - Method in interface org.tentackle.sql.DataType: Returns whether this is a numeric type.
isNumeric() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isNumeric() - Method in class org.tentackle.sql.datatypes.AbstractNumberType
isNumeric() - Method in class org.tentackle.sql.datatypes.BMoneyType
isNumeric() - Method in class org.tentackle.sql.datatypes.DMoneyType
isPosixEscapeSyntaxSupported() - Method in interface org.tentackle.sql.Backend: Returns whether the backend supports POSIX-style escapes via backslash.
isPosixEscapeSyntaxSupported() - Method in class org.tentackle.sql.backends.AbstractBackend
isPosixEscapeSyntaxSupported() - Method in class org.tentackle.sql.backends.MySql
isPredefined() - Method in interface org.tentackle.sql.DataType: Returns whether this is a predefined type.
isPredefined() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isPredefined() - Method in class org.tentackle.sql.datatypes.I18NTextType
isPredefined() - Method in class org.tentackle.sql.datatypes.UUIDType
isPrimaryIdKey() - Method in class org.tentackle.sql.metadata.IndexMetaData: Returns whether this is the primary key for the object id.
isPrimitive() - Method in interface org.tentackle.sql.DataType: Returns whether the type is a primitive.
isPrimitive() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isPrimitive() - Method in class org.tentackle.sql.datatypes.BooleanPrimitiveType
isPrimitive() - Method in class org.tentackle.sql.datatypes.BytePrimitiveType
isPrimitive() - Method in class org.tentackle.sql.datatypes.CharacterPrimitiveType
isPrimitive() - Method in class org.tentackle.sql.datatypes.DoublePrimitiveType
isPrimitive() - Method in class org.tentackle.sql.datatypes.FloatPrimitiveType
isPrimitive() - Method in class org.tentackle.sql.datatypes.IntegerPrimitiveType
isPrimitive() - Method in class org.tentackle.sql.datatypes.LongPrimitiveType
isPrimitive() - Method in class org.tentackle.sql.datatypes.ShortPrimitiveType
isReadOnly() - Method in class org.tentackle.sql.DefaultScriptRunner
isReadOnly() - Method in interface org.tentackle.sql.ScriptRunner: Returns whether the connection is used in read-only mode.
isReleaseSavepointSupported() - Method in interface org.tentackle.sql.Backend: Returns whether the backend supports releasing savepoints explicitly.
isReleaseSavepointSupported() - Method in class org.tentackle.sql.backends.AbstractBackend
isReleaseSavepointSupported() - Method in class org.tentackle.sql.backends.Firebird
isReleaseSavepointSupported() - Method in class org.tentackle.sql.backends.H2
isReleaseSavepointSupported() - Method in class org.tentackle.sql.backends.MySql
isReleaseSavepointSupported() - Method in class org.tentackle.sql.backends.Postgres
isRemote() - Method in class org.tentackle.sql.BackendInfo: Returns whether this backend is remote.
isReserved() - Method in class org.tentackle.sql.metadata.DatabaseMetaDataTableHeader: Returns whether this is a reserved table.
isReservedSchemaName(String) - Method in interface org.tentackle.sql.Backend: Checks whether this is a reserved schema name for this backend.
isReservedSchemaName(String) - Method in class org.tentackle.sql.backends.AbstractBackend
isReservedSchemaName(String) - Method in class org.tentackle.sql.backends.CockroachDb
isReservedSchemaName(String) - Method in class org.tentackle.sql.backends.H2
isReservedSchemaName(String) - Method in class org.tentackle.sql.backends.Hana
isReservedSchemaName(String) - Method in class org.tentackle.sql.backends.MySql
isReservedSchemaName(String) - Method in class org.tentackle.sql.backends.Oracle8
isReservedSchemaName(String) - Method in class org.tentackle.sql.backends.Postgres
isReservedTable(String) - Method in class org.tentackle.sql.metadata.MetaDataUtilities: Returns whether the given table name is reserved by Tentackle.
The check is case-insensitive and ignores the schema.
isReservedTableName(String) - Method in interface org.tentackle.sql.Backend: Checks whether this is a reserved table name for this backend.
Applies only to tables.
isReservedTableName(String) - Method in class org.tentackle.sql.backends.AbstractBackend
isReservedTableName(String) - Method in class org.tentackle.sql.backends.Firebird
isReservedTableName(String) - Method in class org.tentackle.sql.backends.Oracle8
isReservedWord(String) - Method in class org.tentackle.sql.backends.AbstractBackend: Checks whether the given string is a reserved word.
isResultSet() - Method in record class org.tentackle.sql.ScriptRunnerResult: Returns whether a result set was returned.
isSchemaSupported() - Method in interface org.tentackle.sql.Backend: Returns whether the backend supports schemas.
isSchemaSupported() - Method in class org.tentackle.sql.backends.AbstractBackend
isSchemaSupported() - Method in class org.tentackle.sql.backends.Firebird
isSchemaSupported() - Method in class org.tentackle.sql.backends.Informix
isSchemaSupported() - Method in class org.tentackle.sql.backends.MySql
isSchemaSupported() - Method in class org.tentackle.sql.backends.Oracle8
isSequenceSupported() - Method in interface org.tentackle.sql.Backend: Returns whether the backend provides locking-free sequences.
Sequences must not take part in transactions, i.e., no read- or write-locks!
isSequenceSupported() - Method in class org.tentackle.sql.backends.AbstractSql2003Backend
isSequenceSupported() - Method in class org.tentackle.sql.backends.AbstractSql92Backend
isSequenceSupported() - Method in class org.tentackle.sql.backends.H2
isSequenceSupported() - Method in class org.tentackle.sql.backends.Informix
isSequenceSupported() - Method in class org.tentackle.sql.backends.MariaDb
isSequenceSupported() - Method in class org.tentackle.sql.backends.Postgres
isSetConstraintsDeferredSupported() - Method in interface org.tentackle.sql.Backend: Returns whether the backend supports deferring constraint checks to the end of a transaction, i.e.
isSetConstraintsDeferredSupported() - Method in class org.tentackle.sql.backends.AbstractBackend
isSetConstraintsDeferredSupported() - Method in class org.tentackle.sql.backends.CockroachDb
isSetConstraintsDeferredSupported() - Method in class org.tentackle.sql.backends.Oracle8
isSetConstraintsDeferredSupported() - Method in class org.tentackle.sql.backends.Postgres
isSqlxmlSupported() - Method in interface org.tentackle.sql.Backend: Returns whether the backend supports the JDBC SQLXML binding natively, i.e., a native XML column type plus a driver implementing createSQLXML/setSQLXML/getSQLXML.
If not, XML content is emulated as CLOB/VARCHAR.
isSqlxmlSupported() - Method in class org.tentackle.sql.backends.AbstractBackend
isSqlxmlSupported() - Method in class org.tentackle.sql.backends.CockroachDb
isSqlxmlSupported() - Method in class org.tentackle.sql.backends.Db2
isSqlxmlSupported() - Method in class org.tentackle.sql.backends.H2
isSqlxmlSupported() - Method in class org.tentackle.sql.backends.MsSql
isSqlxmlSupported() - Method in class org.tentackle.sql.backends.Oracle8: Returns whether the backend supports the JDBC SQLXML binding natively, i.e., a native XML column type plus a driver implementing createSQLXML/setSQLXML/getSQLXML.
If not, XML content is emulated as CLOB/VARCHAR.
isSqlxmlSupported() - Method in class org.tentackle.sql.backends.Postgres
isTemporaryName(String) - Method in interface org.tentackle.sql.Backend: Checks whether this is a temporary name.
Returns whether an entity-, attribute- or index-name is temporary and should not be taken into account for migration or even used in the model.
Depending on the backend, temporary names start with an underscore or some other lead string.
isTemporaryName(String) - Method in class org.tentackle.sql.backends.AbstractBackend
isTemporaryName(String) - Method in class org.tentackle.sql.backends.Firebird
isTemporaryName(String) - Method in class org.tentackle.sql.backends.Oracle8
isTimezoneApplicable() - Method in interface org.tentackle.sql.DataType: Returns whether a Calendar-timezone can be applied to this date and/or time-related type.
Only for types where methods with Calendar argument are provided in ResultSet and PreparedStatement.
isTimezoneApplicable() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isTimezoneApplicable() - Method in class org.tentackle.sql.datatypes.DateType
isTimezoneApplicable() - Method in class org.tentackle.sql.datatypes.TimestampType
isTimezoneApplicable() - Method in class org.tentackle.sql.datatypes.TimeType
isTransactional() - Method in class org.tentackle.sql.DefaultScriptRunner
isTransactional() - Method in interface org.tentackle.sql.ScriptRunner: Returns whether the script is executed within a transaction.
isTransientTransactionException(SQLException) - Method in interface org.tentackle.sql.Backend: Determines whether the exception is transient and retrying the transaction may succeed.
Typical transient exceptions are thrown when a deadlock is detected or when serialized transaction isolation is used.
isTransientTransactionException(SQLException) - Method in class org.tentackle.sql.backends.AbstractBackend
isTransientTransactionException(SQLException) - Method in class org.tentackle.sql.backends.Db2
isTransientTransactionException(SQLException) - Method in class org.tentackle.sql.backends.Firebird
isTransientTransactionException(SQLException) - Method in class org.tentackle.sql.backends.H2
isTransientTransactionException(SQLException) - Method in class org.tentackle.sql.backends.Hana
isTransientTransactionException(SQLException) - Method in class org.tentackle.sql.backends.MsSql
isTransientTransactionException(SQLException) - Method in class org.tentackle.sql.backends.MySql
isTransientTransactionException(SQLException) - Method in class org.tentackle.sql.backends.Oracle8
isTransientTransactionException(SQLException) - Method in class org.tentackle.sql.backends.Postgres
isTxRequiredForFetchsize() - Method in interface org.tentackle.sql.Backend: Checks for the (Postgres) bug that fetch-size is ignored if not within a new transaction.
isTxRequiredForFetchsize() - Method in class org.tentackle.sql.backends.AbstractBackend
isTxRequiredForFetchsize() - Method in class org.tentackle.sql.backends.Postgres
isUnique() - Method in class org.tentackle.sql.metadata.IndexMetaData: Returns whether index is unique.
isUserTable() - Method in class org.tentackle.sql.metadata.DatabaseMetaDataTableHeader: Returns whether this is a user-defined table.
isUTCSupported() - Method in interface org.tentackle.sql.DataType: Returns whether this type supports the UTC option.
isUTCSupported() - Method in class org.tentackle.sql.datatypes.AbstractDataType
isUTCSupported() - Method in class org.tentackle.sql.datatypes.TimestampType
isUUIDSupported() - Method in interface org.tentackle.sql.Backend: Returns whether the backend supports the UUID natively via JDBC setObject/getObject.
isUUIDSupported() - Method in class org.tentackle.sql.backends.AbstractBackend
isUUIDSupported() - Method in class org.tentackle.sql.backends.H2
isUUIDSupported() - Method in class org.tentackle.sql.backends.Postgres

J

JAVA_OBJECT - Enum constant in enum class org.tentackle.sql.SqlType: Application-specific.
JAVA_TYPE - Static variable in class org.tentackle.sql.datatypes.ByteArrayType: The java type.
jdbcCompliant() - Method in class org.tentackle.sql.DynamicDriver
jdbcTypeToSqlType(int, int, int) - Method in interface org.tentackle.sql.Backend: Converts the JDBC data type integer to Tentackle SqlTypes.
jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.AbstractBackend
jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.CockroachDb
jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.Db2
jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.Firebird
jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.H2
jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.Hana
jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.Informix
jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.MsSql
jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.MySql
jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.Oracle8
jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.Postgres
jdbcTypeToSqlType(int, String, int, int) - Method in interface org.tentackle.sql.Backend: Converts the JDBC data type integer plus the backend-specific type name to Tentackle SqlTypes.
jdbcTypeToSqlType(int, String, int, int) - Method in class org.tentackle.sql.backends.AbstractBackend
jdbcTypeToSqlType(int, String, int, int) - Method in class org.tentackle.sql.backends.H2
jdbcTypeToSqlType(int, String, int, int) - Method in class org.tentackle.sql.backends.Oracle21
jdbcTypeToSqlType(int, String, int, int) - Method in class org.tentackle.sql.backends.Postgres
jdbcTypeToString(int) - Method in class org.tentackle.sql.metadata.MetaDataUtilities: Converts a JDBC type to a string.
JoinType - Enum Class in org.tentackle.sql: Join type.
The JoinType.toString() method returns the SQL keyword, such as LEFT JOIN.
JSON - Enum constant in enum class org.tentackle.sql.SqlType: JSON content, usually stored in a native JSON column or emulated as CLOB.
JsonType - Class in org.tentackle.sql.datatypes: Datatype for the JSON variant of String.
JsonType() - Constructor for class org.tentackle.sql.datatypes.JsonType: Creates the datatype for the JSON variant of String.

L

LargeStringType - Class in org.tentackle.sql.datatypes: Datatype for the large variant of String.
LargeStringType() - Constructor for class org.tentackle.sql.datatypes.LargeStringType: Creates the datatype for the large variant of String.
LEFT - Enum constant in enum class org.tentackle.sql.JoinType: left outer join.
load(String) - Static method in class org.tentackle.sql.DynamicDriver: Loads a JDBC driver dynamically and registers it at the DriverManager.
The name consists of the driver's classname, followed by a colon, followed by the URL to load it.
Example:
LocalDateTimeType - Class in org.tentackle.sql.datatypes: Datatype for LocalDateTime.
LocalDateTimeType() - Constructor for class org.tentackle.sql.datatypes.LocalDateTimeType: Creates the datatype for LocalDateTime.
LocalDateType - Class in org.tentackle.sql.datatypes: Datatype for LocalDate.
LocalDateType() - Constructor for class org.tentackle.sql.datatypes.LocalDateType: Creates the datatype for LocalDate.
LocalTimeType - Class in org.tentackle.sql.datatypes: Datatype for LocalTime.
LocalTimeType() - Constructor for class org.tentackle.sql.datatypes.LocalTimeType: Creates the datatype for LocalTime.
LongPrimitiveType - Class in org.tentackle.sql.datatypes: Datatype for the primitive type long.
LongPrimitiveType() - Constructor for class org.tentackle.sql.datatypes.LongPrimitiveType: Creates the datatype for the primitive type long.
LongType - Class in org.tentackle.sql.datatypes: Datatype for Long.
LongType() - Constructor for class org.tentackle.sql.datatypes.LongType: Creates the datatype for Long.

M

majorVersion() - Method in record class org.tentackle.sql.BackendVersionInfo: Returns the value of the majorVersion record component.
MariaDb - Class in org.tentackle.sql.backends: Backend for MariaDB.
MariaDb() - Constructor for class org.tentackle.sql.backends.MariaDb: Creates the MariaDb backend.
matchesSqlType(SqlType) - Method in class org.tentackle.sql.metadata.ColumnMetaData: Checks whether the column type matches the given SqlType according to the backend.
MAX_LIMIT - Static variable in class org.tentackle.sql.backends.Hana: the limit used to emulate an OFFSET without a LIMIT (HANA requires both).
MAX_LIMIT - Static variable in class org.tentackle.sql.backends.MySql: the limit used to emulate an OFFSET without a LIMIT (mysql requires both).
maxLinesInLiteral - Static variable in class org.tentackle.sql.datatypes.AbstractDataType: Maximum number of lines in literal.
Unlimited if ≤ 0 (default).
MetaDataUtilities - Class in org.tentackle.sql.metadata: Database metadata utility methods.
Replaceable by application-specific implementation via Service annotation.
MetaDataUtilities() - Constructor for class org.tentackle.sql.metadata.MetaDataUtilities: Creates the utilities.
Builds the map of JDBC type names.
MigrationStrategy - Enum Class in org.tentackle.sql: Defines the methods to use for migration.
millis() - Method in record class org.tentackle.sql.ScriptRunnerResult: Returns the value of the millis record component.
minorVersion() - Method in record class org.tentackle.sql.BackendVersionInfo: Returns the value of the minorVersion record component.
ModelMetaData - Class in org.tentackle.sql.metadata: The whole metadata for the connected database.
ModelMetaData(Backend, DatabaseMetaData[], String[]) - Constructor for class org.tentackle.sql.metadata.ModelMetaData: Creates the model metadata.
MsSql - Class in org.tentackle.sql.backends: Backend for Microsoft SQL Server.
MsSql() - Constructor for class org.tentackle.sql.backends.MsSql: Creates the MS-Sql backend.
MySql - Class in org.tentackle.sql.backends: Backend for MySQL.
MySql() - Constructor for class org.tentackle.sql.backends.MySql: Creates the MySql backend.
MySqlColumnMetaData - Class in org.tentackle.sql.metadata: Column metadata for MySQL.
MySQL does not return string defaults in single quotes.
MySqlColumnMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.MySqlColumnMetaData: Creates column metadata.

N

NAME - Enum constant in enum class org.tentackle.sql.MigrationStrategy: use Backend.sqlRenameColumn(String, String, String).
NAME_AND_TYPE - Enum constant in enum class org.tentackle.sql.MigrationStrategy: use Backend.sqlRenameAndAlterColumnType(String, String, String, String, SqlType, int, int, boolean, Object).
nextOffset() - Method in record class org.tentackle.sql.DefaultScriptRunner.SQLCode: Returns the value of the nextOffset record component.
NIL - Static variable in class org.tentackle.sql.datatypes.UUIDType: the NIL value.
NIL_STR - Static variable in class org.tentackle.sql.datatypes.UUIDType: the NIL string.
NO_ACTION - Enum constant in enum class org.tentackle.sql.metadata.ForeignKeyAction: If the primary key has been imported, it cannot be updated or deleted.
NonStandardCommons - Class in org.tentackle.sql: Holds non-SQL-standard common features supported by most backends.
normalizeDefault(String) - Method in class org.tentackle.sql.backends.AbstractBackend: Normalizes the default string to compare.
NOT_DEFERRABLE - Enum constant in enum class org.tentackle.sql.metadata.Deferrability: The constraint is not deferrable: it is always checked immediately, regardless of SET CONSTRAINTS ... DEFERRED.
NOT_DEFERRABLE - Enum constant in enum class org.tentackle.sql.metadata.ForeignKeyAction: Indicates deferrability.
NULL - Enum constant in enum class org.tentackle.sql.MigrationStrategy: use Backend.sqlAlterColumnNullConstraint(String, String, boolean).

O

offset() - Method in record class org.tentackle.sql.ScriptRunnerResult: Returns the value of the offset record component.
OffsetDateTimeType - Class in org.tentackle.sql.datatypes: Datatype for OffsetDateTime.
OffsetDateTimeType() - Constructor for class org.tentackle.sql.datatypes.OffsetDateTimeType: Creates the datatype for OffsetDateTime.
offsetOf(OffsetDateTime) - Static method in class org.tentackle.sql.datatypes.OffsetDateTimeType: Derives the timezone offset from an OffsetDateTime value.
offsetOf(OffsetTime) - Static method in class org.tentackle.sql.datatypes.OffsetTimeType: Derives the timezone offset from an OffsetTime value.
OffsetTimeType - Class in org.tentackle.sql.datatypes: Datatype for OffsetTime.
OffsetTimeType() - Constructor for class org.tentackle.sql.datatypes.OffsetTimeType: Creates the datatype for OffsetTime.
optimizeSql(String) - Method in interface org.tentackle.sql.Backend: Optimizes SQL code.
Replaces WHERE 1=1 AND/OR with WHERE.
optimizeSql(String) - Method in class org.tentackle.sql.backends.AbstractBackend
Oracle - Class in org.tentackle.sql.backends: Backend for Oracle versions 12 or newer.
Oracle() - Constructor for class org.tentackle.sql.backends.Oracle: Creates the Oracle backend.
Oracle21 - Class in org.tentackle.sql.backends: Backend for Oracle versions 21c or newer.
Requires a URL with type postfix "|Oracle21", since the same URL as Oracle matches.
Oracle21() - Constructor for class org.tentackle.sql.backends.Oracle21: Creates the Oracle21 backend.
Oracle23 - Class in org.tentackle.sql.backends: Backend for Oracle versions 23c or newer.
Requires a URL with type postfix "|Oracle23", since the same URL as Oracle matches.
Oracle23() - Constructor for class org.tentackle.sql.backends.Oracle23: Creates the Oracle23 backend.
Oracle8 - Class in org.tentackle.sql.backends: Backend for older Oracle versions 8 to 11.
Requires a URL with type postfix "|Oracle8".
Oracle8() - Constructor for class org.tentackle.sql.backends.Oracle8: Creates the backend for Oracle 8.
OracleColumnMetaData - Class in org.tentackle.sql.metadata: Column metadata for Oracle.
Oracle returns the default value exactly as specified in the ALTER TABLE statement.
OracleColumnMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.OracleColumnMetaData: Creates column metadata.
OracleIndexColumnMetaData - Class in org.tentackle.sql.metadata: Index column metadata for oracle.
Resolves the system-generated virtual columns oracle creates for filtered, function-based and descending indexes back to the model's view of the index, i.e. a column name, an optional function name and — for filtered indexes — the filter condition hidden in a CASE WHEN ... THEN ... END expression.
OracleIndexColumnMetaData(IndexMetaData) - Constructor for class org.tentackle.sql.metadata.OracleIndexColumnMetaData: Creates an index column.
OracleIndexColumnMetaData.ColumnExpression - Record Class in org.tentackle.sql.metadata: A parsed index column expression.
OracleIndexMetaData - Class in org.tentackle.sql.metadata: Oracle index metadata.
Oracle implements filtered indexes, function-based indexes and descending indexes all the same way: as an index over a hidden, system-generated virtual column.
OracleIndexMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.OracleIndexMetaData: Creates an index metadata object.
org.tentackle.sql - module org.tentackle.sql: tentackle-sql module.
org.tentackle.sql - package org.tentackle.sql: The SQL backend layer.
org.tentackle.sql.backends - package org.tentackle.sql.backends: The Backend implementations.
org.tentackle.sql.datatypes - package org.tentackle.sql.datatypes: The predefined DataType implementations.
org.tentackle.sql.metadata - package org.tentackle.sql.metadata: The metadata of a live database schema.

P

parse(String) - Method in class org.tentackle.sql.datatypes.DateType: Parses a string in the format yyyy-MM-dd.
parse(String) - Method in class org.tentackle.sql.datatypes.InstantType: Converts a string to an instant.
The format is yyyy-MM-dd HH:mm:ss[.SSS|.nnnnnnnnn] in the system's default timezone.
parse(String) - Method in class org.tentackle.sql.datatypes.LocalDateTimeType: Converts a string to a local date time.
parse(String) - Method in class org.tentackle.sql.datatypes.LocalDateType: Converts a string to a local date.
parse(String) - Method in class org.tentackle.sql.datatypes.LocalTimeType: Converts a string to a local time.
parse(String) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType: Converts a string to an offset date time.
parse(String) - Method in class org.tentackle.sql.datatypes.OffsetTimeType: Converts a string to an offset time.
parse(String) - Method in class org.tentackle.sql.datatypes.TimestampType: Parses a string in the format yyyy-MM-dd HH:mm:ss[.SSS].
parse(String) - Method in class org.tentackle.sql.datatypes.TimeType: Parses a string in the format HH:mm:ss.
parse(String) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType: Converts a string to a zoned date time.
parse(String) - Method in enum class org.tentackle.sql.SqlType: Parses the string and converts to a java-value.
parseColumnExpression(String) - Static method in class org.tentackle.sql.metadata.OracleIndexColumnMetaData: Parses an index column expression as stored in ALL_IND_EXPRESSIONS.
Understands the CASE WHEN <condition> THEN <expression> END form created for filtered indexes, the FUNC(<column>) form of function-based indexes and the plain "COLUMN" form of descending indexes.
parsePassword(String) - Static method in class org.tentackle.sql.BackendInfo: Converts a string to a password char array.
parseSchemas(String) - Static method in class org.tentackle.sql.BackendInfo: Parses the Constants.BACKEND_SCHEMAS option.
Postgres - Class in org.tentackle.sql.backends: Backend for Postgres.
Postgres() - Constructor for class org.tentackle.sql.backends.Postgres: Creates the postgres backend.
PostgresColumnMetaData - Class in org.tentackle.sql.metadata: Column metadata for PostgreSQL.
Strips the ::type cast PostgreSQL appends to default values.
PostgresColumnMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.PostgresColumnMetaData: Creates column metadata.
PostgresIndexColumnMetaData - Class in org.tentackle.sql.metadata: Index column metadata for PostgreSQL.
Strips optional typecasts and enclosing parentheses from the column expression.
PostgresIndexColumnMetaData(IndexMetaData) - Constructor for class org.tentackle.sql.metadata.PostgresIndexColumnMetaData: Creates an index column.
PostgresIndexMetaData - Class in org.tentackle.sql.metadata: PostgreSQL index metadata.
Strips the type casts PostgreSQL adds to the values of a filter condition.
PostgresIndexMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.PostgresIndexMetaData: Creates an index metadata object.
PostgresScriptRunner - Class in org.tentackle.sql.backends: Script runner for PostgreSQL.
Determines the support for POSIX escapes from the server setting standard_conforming_strings.
PostgresScriptRunner(Backend, Connection) - Constructor for class org.tentackle.sql.backends.PostgresScriptRunner: Creates a script runner.

R

reduceSql(String) - Method in interface org.tentackle.sql.Backend: Reduces a WHERE-clause holding empty sub-expressions.
reduceSql(String) - Method in class org.tentackle.sql.backends.AbstractBackend
reduceSql(StringBuilder) - Method in interface org.tentackle.sql.Backend: Reduces a WHERE-clause holding empty sub-expressions.
Wurblets generating a finder with optional conditions (see ?<boolean> wurblet arguments) simply skip the SQL text of conditions that are not applicable.
reduceSql(StringBuilder) - Method in class org.tentackle.sql.backends.AbstractBackend
removeLeadingSelect(StringBuilder) - Method in class org.tentackle.sql.backends.AbstractSql92Backend: Removes the leading SELECT, if present.
Used by backends that must insert paging keywords right after the SELECT or wrap the whole select into an enclosing one.
replaceDatabaseInUrl(String, String) - Method in class org.tentackle.sql.backends.MySql: Replaces the database name in a JDBC url.
The database name is the path component of jdbc:mysql://host:port/database?parameters.
RESERVED_WORDS_FIREBIRD - Static variable in class org.tentackle.sql.backends.Firebird: array of additional reserved words (those not already covered by SQL92 and SQL2003).
RESERVED_WORDS_H2 - Static variable in class org.tentackle.sql.backends.H2: array of additional reserved words.
RESERVED_WORDS_HANA - Static variable in class org.tentackle.sql.backends.Hana: array of additional reserved words (those not already covered by SQL92 and SQL2003).
RESERVED_WORDS_MYSQL - Static variable in class org.tentackle.sql.backends.MySql: array of additional reserved words (those not already covered by SQL92).
RESERVED_WORDS_PG - Static variable in class org.tentackle.sql.backends.Postgres: array of additional reserved words.
RESERVED_WORDS_SQL2003 - Static variable in class org.tentackle.sql.backends.AbstractSql2003Backend: array of additional reserved words.
RESERVED_WORDS_SQL92 - Static variable in class org.tentackle.sql.backends.AbstractSql92Backend: array of reserved words.
RESTRICT - Enum constant in enum class org.tentackle.sql.metadata.ForeignKeyAction: The primary key may not be updated or deleted if it has been imported by another table as a foreign key.
resultListeners - Variable in class org.tentackle.sql.DefaultScriptRunner: the listeners invoked with the result of each statement.
resultSetListeners - Variable in class org.tentackle.sql.DefaultScriptRunner: the listeners invoked with the SQL code and the open result set of each query.
resultToString() - Method in record class org.tentackle.sql.ScriptRunnerResult: Converts the results to a string.
RIGHT - Enum constant in enum class org.tentackle.sql.JoinType: right outer join.
run(String) - Method in class org.tentackle.sql.DefaultScriptRunner
run(String) - Method in interface org.tentackle.sql.ScriptRunner: Runs the SQL script.

S

ScriptRunner - Interface in org.tentackle.sql: SQL script runner.
Splits a script into statements according to the backend's statement separator and comment syntax, and executes them one by one.
ScriptRunnerException - Exception Class in org.tentackle.sql: Runtime exception thrown when a ScriptRunner encounters an error.
ScriptRunnerException(String, String, List, Throwable) - Constructor for exception class org.tentackle.sql.ScriptRunnerException: Creates a new ScriptRunnerException.
ScriptRunnerException(String, Throwable) - Constructor for exception class org.tentackle.sql.ScriptRunnerException: Constructor used by TRIP deserialization.
The SQL code and the results are not transferred and remain null.
ScriptRunnerResult - Record Class in org.tentackle.sql: The result of a statement executed by a ScriptRunner.
Results with warnings only (no SQL code) report the warnings of the connection or a failure while terminating the script.
ScriptRunnerResult(String) - Constructor for record class org.tentackle.sql.ScriptRunnerResult: Constructor for warnings only.
ScriptRunnerResult(String, int, String, long, int) - Constructor for record class org.tentackle.sql.ScriptRunnerResult: Constructor for update count only.
ScriptRunnerResult(String, int, String, long, int, int[], String[], Object...) - Constructor for record class org.tentackle.sql.ScriptRunnerResult: Creates an instance of a ScriptRunnerResult record class.
set(Backend, PreparedStatement, int, byte[], boolean, Integer) - Method in class org.tentackle.sql.datatypes.ByteArrayType
set(Backend, PreparedStatement, int, Boolean, boolean, Integer) - Method in class org.tentackle.sql.datatypes.BooleanType
set(Backend, PreparedStatement, int, Byte, boolean, Integer) - Method in class org.tentackle.sql.datatypes.ByteType
set(Backend, PreparedStatement, int, Character, boolean, Integer) - Method in class org.tentackle.sql.datatypes.CharacterType
set(Backend, PreparedStatement, int, Double, boolean, Integer) - Method in class org.tentackle.sql.datatypes.DoubleType
set(Backend, PreparedStatement, int, Float, boolean, Integer) - Method in class org.tentackle.sql.datatypes.FloatType
set(Backend, PreparedStatement, int, Integer, boolean, Integer) - Method in class org.tentackle.sql.datatypes.IntegerType
set(Backend, PreparedStatement, int, Long, boolean, Integer) - Method in class org.tentackle.sql.datatypes.LongType
set(Backend, PreparedStatement, int, Object, boolean, Integer) - Method in class org.tentackle.sql.datatypes.ConvertibleType
set(Backend, PreparedStatement, int, Short, boolean, Integer) - Method in class org.tentackle.sql.datatypes.ShortType
set(Backend, PreparedStatement, int, String, boolean, Integer) - Method in class org.tentackle.sql.datatypes.JsonType
set(Backend, PreparedStatement, int, String, boolean, Integer) - Method in class org.tentackle.sql.datatypes.LargeStringType
set(Backend, PreparedStatement, int, String, boolean, Integer) - Method in class org.tentackle.sql.datatypes.StringType
set(Backend, PreparedStatement, int, String, boolean, Integer) - Method in class org.tentackle.sql.datatypes.XMLType
set(Backend, PreparedStatement, int, BigDecimal, boolean, Integer) - Method in class org.tentackle.sql.datatypes.BigDecimalType
set(Backend, PreparedStatement, int, Date, boolean, Integer) - Method in class org.tentackle.sql.datatypes.DateType
set(Backend, PreparedStatement, int, Time, boolean, Integer) - Method in class org.tentackle.sql.datatypes.TimeType
set(Backend, PreparedStatement, int, Timestamp, boolean, Integer) - Method in class org.tentackle.sql.datatypes.TimestampType
set(Backend, PreparedStatement, int, Instant, boolean, Integer) - Method in class org.tentackle.sql.datatypes.InstantType
set(Backend, PreparedStatement, int, Instant, int, boolean, Integer) - Method in class org.tentackle.sql.datatypes.InstantType
set(Backend, PreparedStatement, int, LocalDate, boolean, Integer) - Method in class org.tentackle.sql.datatypes.LocalDateType
set(Backend, PreparedStatement, int, LocalDateTime, boolean, Integer) - Method in class org.tentackle.sql.datatypes.LocalDateTimeType
set(Backend, PreparedStatement, int, LocalTime, boolean, Integer) - Method in class org.tentackle.sql.datatypes.LocalTimeType
set(Backend, PreparedStatement, int, OffsetDateTime, boolean, Integer) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
set(Backend, PreparedStatement, int, OffsetDateTime, int, boolean, Integer) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
set(Backend, PreparedStatement, int, OffsetTime, boolean, Integer) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
set(Backend, PreparedStatement, int, OffsetTime, int, boolean, Integer) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
set(Backend, PreparedStatement, int, ZonedDateTime, boolean, Integer) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
set(Backend, PreparedStatement, int, ZonedDateTime, int, boolean, Integer) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
set(Backend, PreparedStatement, int, UUID, boolean, Integer) - Method in class org.tentackle.sql.datatypes.UUIDType
set(Backend, PreparedStatement, int, Binary, boolean, Integer) - Method in class org.tentackle.sql.datatypes.BinaryType
set(Backend, PreparedStatement, int, BMoney, boolean, Integer) - Method in class org.tentackle.sql.datatypes.BMoneyType
set(Backend, PreparedStatement, int, BMoney, int, boolean, Integer) - Method in class org.tentackle.sql.datatypes.BMoneyType
set(Backend, PreparedStatement, int, DMoney, boolean, Integer) - Method in class org.tentackle.sql.datatypes.DMoneyType
set(Backend, PreparedStatement, int, DMoney, int, boolean, Integer) - Method in class org.tentackle.sql.datatypes.DMoneyType
set(Backend, PreparedStatement, int, I18NText, boolean, Integer) - Method in class org.tentackle.sql.datatypes.I18NTextType
set(Backend, PreparedStatement, int, I18NText, int, boolean, Integer) - Method in class org.tentackle.sql.datatypes.I18NTextType
set(Backend, PreparedStatement, int, TBinary, boolean, Integer) - Method in class org.tentackle.sql.datatypes.TBinaryType
set(Backend, PreparedStatement, int, T, boolean, Integer) - Method in interface org.tentackle.sql.DataType: Sets the object into a prepared statement.
Must be implemented if DataType.isPredefined() returns false.
set(Backend, PreparedStatement, int, T, int, boolean, Integer) - Method in interface org.tentackle.sql.DataType: Sets a column of an object into a prepared statement.
Must be implemented if DataType.isPredefined() returns false.
set(Backend, PreparedStatement, int, T, int, boolean, Integer) - Method in class org.tentackle.sql.datatypes.AbstractDataType
set(DataType, int, T, boolean, Integer) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the object into the statement via its DataType.
This method is provided for application-specific types.
set(DataType, int, T, int, boolean, Integer) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets a column of an object into a prepared statement via its DataType.
This method is provided for application-specific types.
set(SqlType, int, Object) - Method in interface org.tentackle.sql.BackendPreparedStatement: Generic setter for objects via known SqlType.
SET_DEFAULT - Enum constant in enum class org.tentackle.sql.metadata.ForeignKeyAction: If the primary key is updated or deleted, the foreign key (imported key) is set to the default value.
SET_NULL - Enum constant in enum class org.tentackle.sql.metadata.ForeignKeyAction: When the primary key is updated or deleted, the foreign key (imported key) is changed to NULL.
setArray(int, Class, int, Collection, String) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets an array parameter.
Used for array operators such as IN, ANY or ALL.
setArray(PreparedStatement, int, SqlType, Collection, String) - Method in interface org.tentackle.sql.Backend: Sets an array parameter in a prepared statement.
setArray(PreparedStatement, int, SqlType, Collection, String) - Method in class org.tentackle.sql.backends.AbstractBackend
setBackendIdentity(int) - Method in class org.tentackle.sql.BackendInfo: Sets the optional fixed identity to link different URLs to the same physical backend.
setBackendKeepAliveEnabled(boolean) - Method in class org.tentackle.sql.BackendInfo: Sets whether a keep-alive SELECT should be sent periodically on idle connections.
When true and backendTimeout is set, a dummy SELECT will be sent to the backend, when the connection is idle for more than backendTimeout minutes.
setBackendTimeout(int) - Method in class org.tentackle.sql.BackendInfo: Sets the database connection inactivity timeout.
Some databases close connections if being idle for a certain time, which cannot be deactivated, especially in clouds.
When this timeout is set, a dummy SELECT will be sent to the backend to make sure that the connection hasn't been closed in the meantime and/or to keep it alive periodically.
setBigDecimal(int, BigDecimal) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.math.BigDecimal value.
setBoolean(int, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java boolean value.
setBoolean(int, Boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java Boolean value.
setByte(int, byte) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java byte value.
setByte(int, Byte) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java Byte value.
setChar(int, char) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java char value.
setCharacter(int, Character) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java Character value.
setCharacter(int, Character, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java Character value.
setColumnName(String) - Method in class org.tentackle.sql.metadata.ColumnMetaData: Sets the column name.
setComment(String) - Method in class org.tentackle.sql.metadata.ColumnMetaData: Sets the comment.
setComment(String) - Method in class org.tentackle.sql.metadata.IndexMetaData: Sets the comment.
setComment(String) - Method in class org.tentackle.sql.metadata.TableMetaData: Sets the comment.
setDataSourceProperty(Object, String, String...) - Method in class org.tentackle.sql.backends.AbstractBackend: Sets a string property of a data source via reflection.
The setter's name is not standardized among the JDBC drivers (e.g.
setDate(int, Date) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.
setDate(int, Date, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.
setDate(int, Date, Calendar) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.sql.Date value using the time zone of the given calendar.
setDate(int, Date, Calendar, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.sql.Date value using the time zone of the given calendar.
setDefaultValue(String) - Method in class org.tentackle.sql.metadata.ColumnMetaData: Sets the default value.
setDeferrability(Deferrability) - Method in class org.tentackle.sql.metadata.IndexMetaData: Sets the deferrability of the unique constraint backing this index.
setDouble(int, double) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java double value.
setDouble(int, Double) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java Double value.
setDropIfExistsEnabled(boolean) - Method in interface org.tentackle.sql.Backend: Some databases support drop index/constraint/column IF EXISTS.
This may be useful if migration scripts are generated against non-production databases that contain test indexes etc...
Please notice that those temporary DDL changes should better use the temporary prefix (see Backend.isTemporaryName(String)) to be ignored by the migrator.
setDropIfExistsEnabled(boolean) - Method in class org.tentackle.sql.backends.AbstractBackend
setEscapeProcessingEnabled(boolean) - Method in class org.tentackle.sql.DefaultScriptRunner
setEscapeProcessingEnabled(boolean) - Method in interface org.tentackle.sql.ScriptRunner: Enables or disables JDBC escape processing.
setExecutionTimeout(int) - Method in class org.tentackle.sql.DefaultScriptRunner
setExecutionTimeout(int) - Method in interface org.tentackle.sql.ScriptRunner: Sets the execution timeout for each statement in seconds.
The timeout must be set before executing the script!
setFilterCondition(String) - Method in class org.tentackle.sql.metadata.IndexMetaData: Sets the filter condition.
setFloat(int, float) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java float value.
setFloat(int, Float) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java Float value.
setForeignKeyColumn(String) - Method in class org.tentackle.sql.metadata.ForeignKeyColumnMetaData: Sets the referencing column.
setForeignKeyTable(String) - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Updates the foreign table name.
This is necessary if a table was renamed.
setIndexName(String) - Method in class org.tentackle.sql.metadata.IndexMetaData: Sets the index name.
setInstant(int, Instant) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.time.Instant value.
setInstant(int, Instant, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.time.Instant value.
setInt(int, int) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java int value.
setInteger(int, Integer) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java Integer value.
setJson(int, String) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets a string holding a JSON document.
This is usually converted to a native JSON column, or emulated as CLOB/VARCHAR.
setJson(int, String, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets a string holding a JSON document.
This is usually converted to a native JSON column, or emulated as CLOB/VARCHAR.
setJson(PreparedStatement, int, String) - Method in interface org.tentackle.sql.Backend: Sets a JSON parameter in a prepared statement.
setJson(PreparedStatement, int, String) - Method in class org.tentackle.sql.backends.AbstractBackend
setJson(PreparedStatement, int, String) - Method in class org.tentackle.sql.backends.H2
setJson(PreparedStatement, int, String) - Method in class org.tentackle.sql.backends.Postgres
setLargeString(int, String) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets a very large string.
This is usually converted to SQL CLOB.
setLargeString(int, String, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets a very large string.
This is usually converted to SQL CLOB.
setLeadingSelectParameters(BackendPreparedStatement, int, int) - Method in interface org.tentackle.sql.Backend: Sets optional parameters before applying the original parameters.
setLeadingSelectParameters(BackendPreparedStatement, int, int) - Method in class org.tentackle.sql.backends.AbstractSql2003Backend
setLeadingSelectParameters(BackendPreparedStatement, int, int) - Method in class org.tentackle.sql.backends.AbstractSql92Backend
setLeadingSelectParameters(BackendPreparedStatement, int, int) - Method in class org.tentackle.sql.backends.H2
setLeadingSelectParameters(BackendPreparedStatement, int, int) - Method in class org.tentackle.sql.backends.Hana
setLeadingSelectParameters(BackendPreparedStatement, int, int) - Method in class org.tentackle.sql.backends.Informix
setLeadingSelectParameters(BackendPreparedStatement, int, int) - Method in class org.tentackle.sql.backends.MsSql
setLeadingSelectParameters(BackendPreparedStatement, int, int) - Method in class org.tentackle.sql.backends.MySql
setLeadingSelectParameters(BackendPreparedStatement, int, int) - Method in class org.tentackle.sql.backends.Postgres
setLocalDate(int, LocalDate) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.time.LocalDate value using the default time zone of the virtual machine that is running the application.
setLocalDate(int, LocalDate, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.time.LocalDate value using the default time zone of the virtual machine that is running the application.
setLocalDateTime(int, LocalDateTime) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.time.LocalDateTime value.
setLocalDateTime(int, LocalDateTime, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.time.LocalDateTime value.
setLocalTime(int, LocalTime) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.time.LocalTime value.
setLong(int, long) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java long value.
setLong(int, Long) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java Long value.
setMaxRows(int) - Method in class org.tentackle.sql.DefaultScriptRunner
setMaxRows(int) - Method in interface org.tentackle.sql.ScriptRunner: Sets the maximum number of rows to be returned by each statement within the script.
The limit must be set before executing the script!
setNull(int, int) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to SQL NULL.
setNullable(boolean) - Method in class org.tentackle.sql.metadata.ColumnMetaData: Sets whether column is nullable.
setOffsetDateTime(int, OffsetDateTime) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.time.OffsetDateTime value.
setOffsetDateTime(int, OffsetDateTime, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.time.OffsetDateTime value.
setOffsetTime(int, OffsetTime) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.time.OffsetTime value.
setPosition(int) - Method in class org.tentackle.sql.metadata.ForeignKeyColumnMetaData: Sets the ordinal position within the foreign key.
setPrimaryKeyColumn(String) - Method in class org.tentackle.sql.metadata.ForeignKeyColumnMetaData: Sets the primary key column.
setPrimaryKeyTable(String) - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Updates the primary table name.
This is necessary if a table was renamed.
setReadOnly(boolean) - Method in class org.tentackle.sql.DefaultScriptRunner
setReadOnly(boolean) - Method in interface org.tentackle.sql.ScriptRunner: Sets the connection to read-only mode during execution.
If the connection is already in read-only mode, this method has no effect, even if readOnly is false.
setScale(int) - Method in class org.tentackle.sql.metadata.ColumnMetaData: Sets the scale.
setShort(int, short) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java short value.
setShort(int, Short) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java Short value.
setSize(int) - Method in class org.tentackle.sql.metadata.ColumnMetaData: Sets the size.
setSqlxml(int, String) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets a string bridged through the JDBC SQLXML interface.
This is usually converted to a native XML column, or emulated as CLOB/VARCHAR.
setSqlxml(int, String, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets a string bridged through the JDBC SQLXML interface.
This is usually converted to a native XML column, or emulated as CLOB/VARCHAR.
setString(int, String) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java String value.
setString(int, String, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given Java String value.
setTime(int, Time) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.sql.Time value.
setTime(int, Time, Calendar) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.sql.Time value.
setTimestamp(int, Timestamp) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.sql.Timestamp value.
setTimestamp(int, Timestamp, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.sql.Timestamp value.
setTimestamp(int, Timestamp, Calendar) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.sql.Timestamp value.
setTimestamp(int, Timestamp, Calendar, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.sql.Timestamp value.
setTrailingSelectParameters(BackendPreparedStatement, int, int, int) - Method in interface org.tentackle.sql.Backend: Sets optional parameters after applying the original parameters.
setTrailingSelectParameters(BackendPreparedStatement, int, int, int) - Method in class org.tentackle.sql.backends.AbstractSql2003Backend: Sets optional parameters after applying the original parameters.
setTrailingSelectParameters(BackendPreparedStatement, int, int, int) - Method in class org.tentackle.sql.backends.AbstractSql2008Backend: Sets optional parameters after applying the original parameters.
setTrailingSelectParameters(BackendPreparedStatement, int, int, int) - Method in class org.tentackle.sql.backends.AbstractSql92Backend
setTrailingSelectParameters(BackendPreparedStatement, int, int, int) - Method in class org.tentackle.sql.backends.H2
setTrailingSelectParameters(BackendPreparedStatement, int, int, int) - Method in class org.tentackle.sql.backends.Hana
setTrailingSelectParameters(BackendPreparedStatement, int, int, int) - Method in class org.tentackle.sql.backends.Informix
setTrailingSelectParameters(BackendPreparedStatement, int, int, int) - Method in class org.tentackle.sql.backends.MsSql
setTrailingSelectParameters(BackendPreparedStatement, int, int, int) - Method in class org.tentackle.sql.backends.MySql
setTrailingSelectParameters(BackendPreparedStatement, int, int, int) - Method in class org.tentackle.sql.backends.Postgres
setTransactional(boolean) - Method in class org.tentackle.sql.DefaultScriptRunner
setTransactional(boolean) - Method in interface org.tentackle.sql.ScriptRunner: Requests that the script should be executed within a transaction.
If there is already a transaction running, this method has no effect, even if transactional is false.
setType(int) - Method in class org.tentackle.sql.metadata.ColumnMetaData: Sets the type.
setTypeName(String) - Method in class org.tentackle.sql.metadata.ColumnMetaData: Sets the type name.
setUnique(boolean) - Method in class org.tentackle.sql.metadata.IndexMetaData: Sets whether the index is unique.
setupColumnFromMetaData(ResultSet) - Method in class org.tentackle.sql.metadata.ColumnMetaData: Sets up the column from the database metadata result.
setupForeignKeyColumnFromMetaData(ResultSet) - Method in class org.tentackle.sql.metadata.ForeignKeyColumnMetaData: Sets up the foreign key column from the database metadata result.
setupForeignKeyFromMetaData(ResultSet) - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Sets up the foreign key from the database metadata result.
setupIndexColumnFromMetaData(ResultSet) - Method in class org.tentackle.sql.metadata.IndexColumnMetaData: Sets up the index column from the database metadata result.
setupIndexFromMetaData(ResultSet) - Method in class org.tentackle.sql.metadata.IndexMetaData: Sets up the index from the database metadata result.
setupTableFromMetaData(DatabaseMetaData, String[], String, String) - Method in class org.tentackle.sql.metadata.TableMetaData: Sets up the table, its columns, indexes and foreign keys from the database metadata.
setZonedDateTime(int, ZonedDateTime) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.time.ZonedDateTime value.
setZonedDateTime(int, ZonedDateTime, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement: Sets the designated parameter to the given java.time.ZonedDateTime value.
ShortPrimitiveType - Class in org.tentackle.sql.datatypes: Datatype for the primitive type short.
ShortPrimitiveType() - Constructor for class org.tentackle.sql.datatypes.ShortPrimitiveType: Creates the datatype for the primitive type short.
ShortType - Class in org.tentackle.sql.datatypes: Datatype for Short.
ShortType() - Constructor for class org.tentackle.sql.datatypes.ShortType: Creates the datatype for Short.
SMALLINT - Enum constant in enum class org.tentackle.sql.SqlType: Short and short.
sql() - Method in record class org.tentackle.sql.DefaultScriptRunner.SQLCode: Returns the value of the sql record component.
sql() - Method in record class org.tentackle.sql.ScriptRunnerResult: Returns the value of the sql record component.
SQL_ALLSTAR - Static variable in interface org.tentackle.sql.Backend: '*' all string.
SQL_ALTER_COLUMN - Static variable in interface org.tentackle.sql.Backend: SQL ALTER COLUMN fragment.
SQL_ALTER_INDEX - Static variable in interface org.tentackle.sql.Backend: SQL ALTER INDEX intro.
SQL_ALTER_TABLE - Static variable in interface org.tentackle.sql.Backend: SQL ALTER TABLE intro.
SQL_AND - Static variable in interface org.tentackle.sql.Backend: AND string.
SQL_ANDNOT - Static variable in interface org.tentackle.sql.Backend: AND NOT string.
SQL_ARRAY_ALL - Static variable in interface org.tentackle.sql.Backend: ALL array operator string.
SQL_ARRAY_ALL_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter ALL array operator string.
SQL_ARRAY_ANY - Static variable in interface org.tentackle.sql.Backend: ANY array operator string.
SQL_ARRAY_ANY_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter ANY array operator string.
SQL_ARRAY_IN - Static variable in interface org.tentackle.sql.Backend: IN array operator string.
SQL_ARRAY_IN_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter IN array operator string.
SQL_ARRAY_NOT_IN - Static variable in interface org.tentackle.sql.Backend: NOT IN array operator string.
SQL_ARRAY_NOT_IN_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter NOT IN array operator string.
SQL_ARRAY_PAR - Static variable in interface org.tentackle.sql.Backend: Array parameter (?).
SQL_COALESCE - Static variable in class org.tentackle.sql.backends.AbstractSql92Backend: COALESCE keyword.
SQL_COMMA - Static variable in interface org.tentackle.sql.Backend: comma separator.
SQL_COMMA_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter ,?
SQL_DELETE - Static variable in interface org.tentackle.sql.Backend: DELETE string.
SQL_DELETE_FROM - Static variable in interface org.tentackle.sql.Backend: DELETE FROM string.
SQL_DOT_STAR - Static variable in interface org.tentackle.sql.Backend: dot all columns.
SQL_EQUAL - Static variable in interface org.tentackle.sql.Backend: = operator string.
SQL_EQUAL_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter =?
SQL_EQUAL_PAR_COMMA - Static variable in interface org.tentackle.sql.Backend: Parameter =?
SQL_EQUAL_ZERO - Static variable in interface org.tentackle.sql.Backend: =0 string.
SQL_EXISTS - Static variable in interface org.tentackle.sql.Backend: SQL EXISTS clause with SELECT 1 and opening left parenthesis.
SQL_FETCH_FIRST - Static variable in class org.tentackle.sql.backends.AbstractSql2008Backend: FETCH FIRST string.
SQL_FETCH_FIRST - Static variable in class org.tentackle.sql.backends.H2: FETCH FIRST string.
SQL_FETCH_FIRST_PAR - Static variable in class org.tentackle.sql.backends.H2: FETCH FIRST ?
SQL_FIRST - Static variable in class org.tentackle.sql.backends.Informix: FIRST string.
SQL_FIRST_PAR - Static variable in class org.tentackle.sql.backends.Informix: FIRST ?
SQL_FOR_UPDATE - Static variable in class org.tentackle.sql.backends.AbstractSql92Backend: FOR UPDATE string.
SQL_FROM - Static variable in interface org.tentackle.sql.Backend: FROM string.
SQL_GREATER - Static variable in interface org.tentackle.sql.Backend: > operator string.
SQL_GREATER_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter >?
SQL_GREATEROREQUAL - Static variable in interface org.tentackle.sql.Backend: >= operator string.
SQL_GREATEROREQUAL_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter >=?
SQL_GROUPBY - Static variable in interface org.tentackle.sql.Backend: GROUP BY string.
SQL_IF_EXISTS - Static variable in interface org.tentackle.sql.Backend: SQL IF EXISTS fragment.
SQL_INSERT_INTO - Static variable in interface org.tentackle.sql.Backend: INSERT INTO string.
SQL_INSERT_VALUES - Static variable in interface org.tentackle.sql.Backend: (VALUES) string for insert.
SQL_ISNOTNULL - Static variable in interface org.tentackle.sql.Backend: IS NOT NULL string.
SQL_ISNULL - Static variable in interface org.tentackle.sql.Backend: IS NULL string.
SQL_LEFT_PARENTHESIS - Static variable in interface org.tentackle.sql.Backend: opening bracket.
SQL_LESS - Static variable in interface org.tentackle.sql.Backend: < operator string.
SQL_LESS_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter <?
SQL_LESSOREQUAL - Static variable in interface org.tentackle.sql.Backend: <= operator string.
SQL_LESSOREQUAL_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter <=?
SQL_LIKE - Static variable in interface org.tentackle.sql.Backend: LIKE operator string.
SQL_LIKE_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter LIKE ?
SQL_LIMIT - Static variable in class org.tentackle.sql.backends.Hana: LIMIT string.
SQL_LIMIT - Static variable in class org.tentackle.sql.backends.MySql: LIMIT string.
SQL_LIMIT - Static variable in class org.tentackle.sql.backends.Postgres: LIMIT string.
SQL_LIMIT_PAR - Static variable in class org.tentackle.sql.backends.Hana: LIMIT ?
SQL_LIMIT_PAR - Static variable in class org.tentackle.sql.backends.MySql: LIMIT ?
SQL_LIMIT_PAR - Static variable in class org.tentackle.sql.backends.Postgres: LIMIT ?
SQL_MAX - Static variable in interface org.tentackle.sql.Backend: MAX function name.
SQL_MIN - Static variable in interface org.tentackle.sql.Backend: MIN function name.
SQL_NESTED_SELECT_1 - Static variable in class org.tentackle.sql.backends.Oracle8: nested select part 1: inserted after the leading SELECT.
SQL_NESTED_SELECT_2 - Static variable in class org.tentackle.sql.backends.Oracle8: nested select part 2: appended to the original select.
SQL_NESTED_SELECT_LIMIT - Static variable in class org.tentackle.sql.backends.Oracle8: condition for the limit (upper row number bound).
SQL_NESTED_SELECT_OFFSET - Static variable in class org.tentackle.sql.backends.Oracle8: condition for the offset (lower row number bound).
SQL_NESTED_SELECT_ROWNUM - Static variable in class org.tentackle.sql.backends.Oracle8: the ROWNUM pseudo column.
SQL_NESTED_SELECT_ROWNUM_ALIAS - Static variable in class org.tentackle.sql.backends.Oracle8: the alias of the row number of the nested select.
SQL_NOT - Static variable in interface org.tentackle.sql.Backend: NOT string.
SQL_NOTEQUAL - Static variable in interface org.tentackle.sql.Backend: <> operator string.
SQL_NOTEQUAL_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter <>?
SQL_NOTEQUAL_ZERO - Static variable in interface org.tentackle.sql.Backend: <>0 string.
SQL_NOTLIKE - Static variable in interface org.tentackle.sql.Backend: NOT LIKE operator string.
SQL_NOTLIKE_PAR - Static variable in interface org.tentackle.sql.Backend: Parameter NOT LIKE ?
SQL_NVL - Static variable in class org.tentackle.sql.backends.Informix: NVL keyword.
SQL_OFFSET - Static variable in class org.tentackle.sql.backends.AbstractSql2008Backend: OFFSET string.
SQL_OFFSET - Static variable in class org.tentackle.sql.backends.H2: OFFSET string.
SQL_OFFSET - Static variable in class org.tentackle.sql.backends.Hana: OFFSET string.
SQL_OFFSET - Static variable in class org.tentackle.sql.backends.MySql: OFFSET string.
SQL_OFFSET - Static variable in class org.tentackle.sql.backends.Postgres: OFFSET string.
SQL_OFFSET_PAR - Static variable in class org.tentackle.sql.backends.H2: OFFSET ?
SQL_OFFSET_PAR - Static variable in class org.tentackle.sql.backends.Hana: OFFSET ?
SQL_OFFSET_PAR - Static variable in class org.tentackle.sql.backends.MySql: OFFSET ?
SQL_OFFSET_PAR - Static variable in class org.tentackle.sql.backends.Postgres: OFFSET ?
SQL_OR - Static variable in interface org.tentackle.sql.Backend: OR string.
SQL_ORDERBY - Static variable in interface org.tentackle.sql.Backend: ORDER BY string.
SQL_ORNOT - Static variable in interface org.tentackle.sql.Backend: OR NOT string.
SQL_PAR - Static variable in interface org.tentackle.sql.Backend: ?
SQL_PAR_COMMA - Static variable in interface org.tentackle.sql.Backend: Parameter ?
SQL_PLUS_ONE - Static variable in interface org.tentackle.sql.Backend: +1 string.
SQL_RIGHT_PARENTHESIS - Static variable in interface org.tentackle.sql.Backend: closing bracket.
SQL_SELECT - Static variable in interface org.tentackle.sql.Backend: SELECT string.
SQL_SELECT_ALL_FROM - Static variable in interface org.tentackle.sql.Backend: SELECT * FROM string.
SQL_SET - Static variable in interface org.tentackle.sql.Backend: SET string.
SQL_SKIP - Static variable in class org.tentackle.sql.backends.Informix: SKIP string.
SQL_SKIP_PAR - Static variable in class org.tentackle.sql.backends.Informix: SKIP ?
SQL_SORTASC - Static variable in interface org.tentackle.sql.Backend: sort ASC string.
SQL_SORTDESC - Static variable in interface org.tentackle.sql.Backend: sort DESC string.
SQL_TOP - Static variable in class org.tentackle.sql.backends.MsSql: TOP string.
SQL_TOP_PAR - Static variable in class org.tentackle.sql.backends.MsSql: TOP ?
SQL_UPDATE - Static variable in interface org.tentackle.sql.Backend: UPDATE string.
SQL_WHERE - Static variable in interface org.tentackle.sql.Backend: WHERE string.
SQL_WHEREALL - Static variable in interface org.tentackle.sql.Backend: "WHERE 1=1" allows AND to be added.
SQL_WHEREAND - Static variable in interface org.tentackle.sql.Backend: SQL_WHEREALL + AND, replaced by Backend.SQL_WHERE in Backend.optimizeSql(String).
SQL_WHERENOTHING - Static variable in interface org.tentackle.sql.Backend: "WHERE 1=0" to select nothing.
SQL_WHEREOR - Static variable in interface org.tentackle.sql.Backend: SQL_WHEREALL + OR, replaced by Backend.SQL_WHERE in Backend.optimizeSql(String).
SQL_WINDOW_1 - Static variable in class org.tentackle.sql.backends.AbstractSql2003Backend: window function part 1: inserted after the leading SELECT.
SQL_WINDOW_2 - Static variable in class org.tentackle.sql.backends.AbstractSql2003Backend: window function part 2: appended to the original select.
SQL_WINDOW_LIMIT - Static variable in class org.tentackle.sql.backends.AbstractSql2003Backend: condition for the limit (upper row number bound).
SQL_WINDOW_OFFSET - Static variable in class org.tentackle.sql.backends.AbstractSql2003Backend: condition for the offset (lower row number bound).
SQL_WITH_LOCK - Static variable in class org.tentackle.sql.backends.Firebird: the locking clause: FOR UPDATE alone just declares an updatable cursor, but locks nothing.
sqlAddColumn(String, String, String, SqlType, int, int, boolean, Object) - Method in interface org.tentackle.sql.Backend: Generates SQL code to add a column.
sqlAddColumn(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlAddColumn(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Db2
sqlAddColumn(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Firebird
sqlAddColumn(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Hana
sqlAddColumn(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Informix
sqlAddColumn(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.MySql
sqlAddColumn(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Oracle8
sqlAlterColumnComment(String, String, String) - Method in interface org.tentackle.sql.Backend: Generates SQL code to alter the comment for an attribute.
sqlAlterColumnComment(String, String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlAlterColumnComment(String, String, String) - Method in class org.tentackle.sql.backends.MySql
sqlAlterColumnDefault(String, String, SqlType, Object) - Method in interface org.tentackle.sql.Backend: Generates SQL code to change the default value of a column.
sqlAlterColumnDefault(String, String, SqlType, Object) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlAlterColumnDefault(String, String, SqlType, Object) - Method in class org.tentackle.sql.backends.Hana
sqlAlterColumnDefault(String, String, SqlType, Object) - Method in class org.tentackle.sql.backends.Informix
sqlAlterColumnDefault(String, String, SqlType, Object) - Method in class org.tentackle.sql.backends.Oracle8
sqlAlterColumnNullConstraint(String, String, boolean) - Method in interface org.tentackle.sql.Backend: Generates SQL code to change the null-constraint of a column.
sqlAlterColumnNullConstraint(String, String, boolean) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlAlterColumnNullConstraint(String, String, boolean) - Method in class org.tentackle.sql.backends.Firebird
sqlAlterColumnNullConstraint(String, String, boolean) - Method in class org.tentackle.sql.backends.H2
sqlAlterColumnNullConstraint(String, String, boolean) - Method in class org.tentackle.sql.backends.Oracle8
sqlAlterColumnNullConstraint(String, String, boolean) - Method in class org.tentackle.sql.backends.Postgres
sqlAlterColumnNullConstraint(String, String, SqlType, int, int, boolean, Object) - Method in interface org.tentackle.sql.Backend: Generates SQL code to change the null-constraint of a column, given its full declaration.
Some backends (MySQL, for example) cannot change a single property of a column: the whole declaration must be repeated.
sqlAlterColumnNullConstraint(String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlAlterColumnNullConstraint(String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Hana
sqlAlterColumnNullConstraint(String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.MySql
sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) - Method in interface org.tentackle.sql.Backend: Generates SQL code to change the datatype of a column.
sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Db2: Generates SQL code to change the datatype of a column.
sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Firebird: Generates SQL code to change the datatype of a column.
sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.H2: Generates SQL code to change the datatype of a column.
sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Hana: Generates SQL code to change the datatype of a column.
sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Informix
sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.MySql
sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Oracle8: Generates SQL code to change the datatype of a column.
sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Postgres: Generates SQL code to change the datatype of a column.
sqlAlterIndexComment(String, String, String) - Method in interface org.tentackle.sql.Backend: Generates SQL code to alter the comment for an index.
sqlAlterIndexComment(String, String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlAlterTableComment(String, String) - Method in interface org.tentackle.sql.Backend: Generates SQL code to alter the comment for a table.
sqlAlterTableComment(String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlAlterTableComment(String, String) - Method in class org.tentackle.sql.backends.MySql
sqlAsBeforeTableAlias() - Method in interface org.tentackle.sql.Backend: Gets the string before the table alias.
In most databases the " AS " is optional and some don't accept it at all.
sqlAsBeforeTableAlias() - Method in class org.tentackle.sql.backends.AbstractBackend
SQLCode(String, int) - Constructor for record class org.tentackle.sql.DefaultScriptRunner.SQLCode: Creates the SQL code.
Leading whitespace is removed from the SQL statement.
sqlComment(String) - Method in interface org.tentackle.sql.Backend: Creates SQL code interpreted as a comment by the backend.
sqlComment(String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlCreateColumn(String, String, SqlType, int, int, boolean, Object, boolean, boolean) - Method in interface org.tentackle.sql.Backend: Generates the attribute definition of a CREATE TABLE statement.
sqlCreateColumn(String, String, SqlType, int, int, boolean, Object, boolean, boolean) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlCreateColumn(String, String, SqlType, int, int, boolean, Object, boolean, boolean) - Method in class org.tentackle.sql.backends.Db2
sqlCreateColumn(String, String, SqlType, int, int, boolean, Object, boolean, boolean) - Method in class org.tentackle.sql.backends.MySql
sqlCreateColumnComment(String, String, String) - Method in interface org.tentackle.sql.Backend: Generates SQL code to create the comment for an attribute.
sqlCreateColumnComment(String, String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlCreateColumnComment(String, String, String) - Method in class org.tentackle.sql.backends.Db2
sqlCreateColumnComment(String, String, String) - Method in class org.tentackle.sql.backends.Firebird
sqlCreateColumnComment(String, String, String) - Method in class org.tentackle.sql.backends.H2
sqlCreateColumnComment(String, String, String) - Method in class org.tentackle.sql.backends.Hana
sqlCreateColumnComment(String, String, String) - Method in class org.tentackle.sql.backends.Oracle8
sqlCreateColumnComment(String, String, String) - Method in class org.tentackle.sql.backends.Postgres
sqlCreateCommentOnColumn(Backend, String, String, String) - Static method in class org.tentackle.sql.NonStandardCommons: Creates a COMMENT ON COLUMN statement.
sqlCreateCommentOnIndex(Backend, String, String, String) - Static method in class org.tentackle.sql.NonStandardCommons: Creates a COMMENT ON INDEX statement.
sqlCreateCommentOnSequence(Backend, String, String) - Static method in class org.tentackle.sql.NonStandardCommons: Creates a COMMENT ON SEQUENCE statement.
sqlCreateCommentOnTable(Backend, String, String) - Static method in class org.tentackle.sql.NonStandardCommons: Creates a COMMENT ON TABLE statement.
sqlCreateForeignKey(String, String, String, String, String, boolean, Deferrability) - Method in interface org.tentackle.sql.Backend: Generates the ALTER TABLE statement to add a foreign key constraint.
sqlCreateForeignKey(String, String, String, String, String, boolean, Deferrability) - Method in class org.tentackle.sql.backends.AbstractSql92Backend
sqlCreateIndex(String, String, boolean, String, String...) - Method in interface org.tentackle.sql.Backend: Generates the CREATE INDEX statement.
sqlCreateIndex(String, String, boolean, String, String...) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlCreateIndex(String, String, boolean, String, String...) - Method in class org.tentackle.sql.backends.Firebird: Generates the CREATE INDEX statement.
sqlCreateIndex(String, String, boolean, String, String...) - Method in class org.tentackle.sql.backends.MySql
sqlCreateIndex(String, String, boolean, String, String...) - Method in class org.tentackle.sql.backends.Oracle: Generates the CREATE INDEX statement.
sqlCreateIndexComment(String, String, String) - Method in interface org.tentackle.sql.Backend: Generates SQL code to create the comment for an index.
sqlCreateIndexComment(String, String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlCreateIndexComment(String, String, String) - Method in class org.tentackle.sql.backends.CockroachDb
sqlCreateIndexComment(String, String, String) - Method in class org.tentackle.sql.backends.Db2
sqlCreateIndexComment(String, String, String) - Method in class org.tentackle.sql.backends.Firebird
sqlCreateIndexComment(String, String, String) - Method in class org.tentackle.sql.backends.H2
sqlCreateIndexComment(String, String, String) - Method in class org.tentackle.sql.backends.Postgres
sqlCreateSchema(String) - Method in interface org.tentackle.sql.Backend: Creates the SQL string to create a schema.
sqlCreateSchema(String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlCreateSequence(String, Long, Long) - Method in interface org.tentackle.sql.Backend: Creates the SQL string to create a sequence.
sqlCreateSequence(String, Long, Long) - Method in class org.tentackle.sql.backends.AbstractSql2003Backend
sqlCreateSequence(String, Long, Long) - Method in class org.tentackle.sql.backends.AbstractSql92Backend
sqlCreateSequence(String, Long, Long) - Method in class org.tentackle.sql.backends.Firebird
sqlCreateSequence(String, Long, Long) - Method in class org.tentackle.sql.backends.H2
sqlCreateSequence(String, Long, Long) - Method in class org.tentackle.sql.backends.Informix
sqlCreateSequence(String, Long, Long) - Method in class org.tentackle.sql.backends.MariaDb
sqlCreateSequence(String, Long, Long) - Method in class org.tentackle.sql.backends.Postgres
sqlCreateSequence(String, Long, Long) - Static method in class org.tentackle.sql.NonStandardCommons: Creates the SQL string to create a sequence.
sqlCreateSequenceComment(String, String) - Method in interface org.tentackle.sql.Backend: Creates the SQL string to comment a sequence.
sqlCreateSequenceComment(String, String) - Method in class org.tentackle.sql.backends.AbstractSql92Backend
sqlCreateSequenceComment(String, String) - Method in class org.tentackle.sql.backends.CockroachDb
sqlCreateSequenceComment(String, String) - Method in class org.tentackle.sql.backends.Firebird
sqlCreateSequenceComment(String, String) - Method in class org.tentackle.sql.backends.H2
sqlCreateSequenceComment(String, String) - Method in class org.tentackle.sql.backends.Postgres
sqlCreateTableAttributeWithoutComment(String, SqlType, int, int, boolean, Object, boolean, boolean) - Method in class org.tentackle.sql.backends.AbstractBackend: Generates the attribute definition of a CREATE TABLE statement.
sqlCreateTableClosing(String, String) - Method in interface org.tentackle.sql.Backend: Generates the last line of a CREATE TABLE statement.
sqlCreateTableClosing(String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlCreateTableClosing(String, String) - Method in class org.tentackle.sql.backends.MySql
sqlCreateTableComment(String, String) - Method in interface org.tentackle.sql.Backend: Generates SQL code to create the comment for a table.
sqlCreateTableComment(String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlCreateTableComment(String, String) - Method in class org.tentackle.sql.backends.Db2
sqlCreateTableComment(String, String) - Method in class org.tentackle.sql.backends.Firebird
sqlCreateTableComment(String, String) - Method in class org.tentackle.sql.backends.H2
sqlCreateTableComment(String, String) - Method in class org.tentackle.sql.backends.Hana
sqlCreateTableComment(String, String) - Method in class org.tentackle.sql.backends.Oracle8
sqlCreateTableComment(String, String) - Method in class org.tentackle.sql.backends.Postgres
sqlCreateTableIntro(String, String) - Method in interface org.tentackle.sql.Backend: Generates the first line of a CREATE TABLE statement.
sqlCreateTableIntro(String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlCreateTableIntro(String, String) - Method in class org.tentackle.sql.backends.Db2
sqlCreateTableIntroWithoutComment(String) - Method in class org.tentackle.sql.backends.AbstractBackend: Generates the first line of a CREATE TABLE statement.
sqlCreateUniqueConstraint(String, String, Deferrability, String...) - Method in interface org.tentackle.sql.Backend: Generates the ALTER TABLE statement to add a unique constraint.
Used instead of Backend.sqlCreateIndex(String, String, boolean, String, String...) whenever the index is unique and deferrable (see Backend.isSetConstraintsDeferredSupported()), since deferrability applies to constraints, not to plain indexes.
sqlCreateUniqueConstraint(String, String, Deferrability, String...) - Method in class org.tentackle.sql.backends.AbstractSql92Backend
sqlDropColumn(String, String) - Method in interface org.tentackle.sql.Backend: Generates SQL code to drop a column.
sqlDropColumn(String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlDropColumn(String, String) - Method in class org.tentackle.sql.backends.Firebird
sqlDropColumn(String, String) - Method in class org.tentackle.sql.backends.Hana
sqlDropColumn(String, String) - Method in class org.tentackle.sql.backends.Informix
sqlDropConstraint(String, String) - Method in interface org.tentackle.sql.Backend: Generates the ALTER TABLE statement to drop a named constraint (unique or foreign key).
sqlDropConstraint(String, String) - Method in class org.tentackle.sql.backends.AbstractSql92Backend
sqlDropForeignKey(String, String) - Method in interface org.tentackle.sql.Backend: Generates the SQL statement to drop a foreign key constraint.
sqlDropForeignKey(String, String) - Method in class org.tentackle.sql.backends.AbstractSql92Backend
sqlDropForeignKey(String, String) - Method in class org.tentackle.sql.backends.MySql
sqlDropIndex(String, String, String) - Method in interface org.tentackle.sql.Backend: Generates the DROP INDEX statement.
sqlDropIndex(String, String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlDropIndex(String, String, String) - Method in class org.tentackle.sql.backends.CockroachDb
sqlDropIndex(String, String, String) - Method in class org.tentackle.sql.backends.MySql
sqlDropTable(String, String) - Method in interface org.tentackle.sql.Backend: Generates the DROP TABLE statement.
sqlDropTable(String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlFunction(String, String) - Method in interface org.tentackle.sql.Backend: Creates an SQL function expression.
sqlFunction(String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlJoin(JoinType, String, String, String) - Method in interface org.tentackle.sql.Backend: Creates a join clause.
sqlJoin(JoinType, String, String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlJoinSelects(JoinType, boolean, StringBuilder, String, String, String, String) - Method in interface org.tentackle.sql.Backend: Generates SQL code for joining a table with an existing SELECT.
sqlJoinSelects(JoinType, boolean, StringBuilder, String, String, String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlJoinSelects(JoinType, boolean, String, String, String, String, String) - Method in interface org.tentackle.sql.Backend: Generates SQL code for joining a table with an existing SELECT.
sqlJoinSelects(JoinType, boolean, String, String, String, String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
SqlNameType - Enum Class in org.tentackle.sql: The kind of an SQL identifier.
Used to validate names (see Backend.assertValidName(SqlNameType, String)) and to determine their maximum length (see Backend.getMaxNameLength(SqlNameType)).
sqlNextFromSequence(String) - Method in interface org.tentackle.sql.Backend: Creates the SQL string to retrieve the next id from a sequence.
sqlNextFromSequence(String) - Method in class org.tentackle.sql.backends.AbstractSql2003Backend
sqlNextFromSequence(String) - Method in class org.tentackle.sql.backends.AbstractSql92Backend
sqlNextFromSequence(String) - Method in class org.tentackle.sql.backends.Firebird
sqlNextFromSequence(String) - Method in class org.tentackle.sql.backends.H2
sqlNextFromSequence(String) - Method in class org.tentackle.sql.backends.Hana
sqlNextFromSequence(String) - Method in class org.tentackle.sql.backends.Informix
sqlNextFromSequence(String) - Method in class org.tentackle.sql.backends.MariaDb
sqlNextFromSequence(String) - Method in class org.tentackle.sql.backends.Oracle8
sqlNextFromSequence(String) - Method in class org.tentackle.sql.backends.Postgres
sqlRenameAndAlterColumnType(String, String, String, String, SqlType, int, int, boolean, Object) - Method in interface org.tentackle.sql.Backend: Generates SQL code to rename a column and alter its type, null constraint, default and comment in one go.
Used if Backend.sqlRenameColumn(String, String, String) returns null.
sqlRenameAndAlterColumnType(String, String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlRenameAndAlterColumnType(String, String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.MySql
sqlRenameColumn(String, String, String) - Method in interface org.tentackle.sql.Backend: Generates SQL code to rename a column.
sqlRenameColumn(String, String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlRenameColumn(String, String, String) - Method in class org.tentackle.sql.backends.Firebird
sqlRenameColumn(String, String, String) - Method in class org.tentackle.sql.backends.Hana
sqlRenameColumn(String, String, String) - Method in class org.tentackle.sql.backends.Informix
sqlRenameColumn(String, String, String) - Method in class org.tentackle.sql.backends.MySql
sqlRenameIndex(String, String, String) - Method in interface org.tentackle.sql.Backend: Generates SQL code to rename an index.
sqlRenameIndex(String, String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlRenameIndex(String, String, String) - Method in class org.tentackle.sql.backends.CockroachDb
sqlRenameIndex(String, String, String) - Method in class org.tentackle.sql.backends.Db2
sqlRenameIndex(String, String, String) - Method in class org.tentackle.sql.backends.Firebird
sqlRenameIndex(String, String, String) - Method in class org.tentackle.sql.backends.Hana
sqlRenameIndex(String, String, String) - Method in class org.tentackle.sql.backends.Informix
sqlRenameIndex(String, String, String) - Method in class org.tentackle.sql.backends.MsSql
sqlRenameIndex(String, String, String) - Method in class org.tentackle.sql.backends.MySql
sqlRenameTable(String, String) - Method in interface org.tentackle.sql.Backend: Generates SQL code to rename a table.
sqlRenameTable(String, String) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlRenameTable(String, String) - Method in class org.tentackle.sql.backends.Firebird
sqlRenameTable(String, String) - Method in class org.tentackle.sql.backends.Hana
sqlSetConstraintsDeferred(boolean) - Method in interface org.tentackle.sql.Backend: Generates the statement to defer or immediately check deferrable constraints for the rest of the current transaction.
Only called if Backend.isSetConstraintsDeferredSupported() returns true.
sqlSetConstraintsDeferred(boolean) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlSetConstraintsDeferred(boolean) - Method in class org.tentackle.sql.backends.CockroachDb
sqlSetConstraintsDeferred(boolean) - Method in class org.tentackle.sql.backends.Oracle8
sqlSetConstraintsDeferred(boolean) - Method in class org.tentackle.sql.backends.Postgres
SqlType - Enum Class in org.tentackle.sql: The SQL types used when talking to the database backend.
sqlTypeToString(SqlType, int) - Method in interface org.tentackle.sql.Backend: Converts the java SQL type to the database type name.
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.AbstractBackend
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.CockroachDb
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.Db2
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.Firebird
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.H2
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.Hana
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.Informix
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.MariaDb
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.MsSql
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.MySql
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.Oracle21
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.Oracle23
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.Oracle8
sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.Postgres
sqlUpdateToNotNull(String, String, SqlType, Object, boolean) - Method in interface org.tentackle.sql.Backend: Generates code to update a column to a non-null value.
sqlUpdateToNotNull(String, String, SqlType, Object, boolean) - Method in class org.tentackle.sql.backends.AbstractBackend
StringType - Class in org.tentackle.sql.datatypes: Datatype for String.
StringType() - Constructor for class org.tentackle.sql.datatypes.StringType: Creates the datatype for String.

T

TABLE_ALIAS - Enum constant in enum class org.tentackle.sql.SqlNameType: name of a table alias.
TABLE_NAME - Enum constant in enum class org.tentackle.sql.SqlNameType: name of a table.
tableIndexName(String, String) - Method in class org.tentackle.sql.backends.CockroachDb: Creates the qualified name of an index.
Unlike postgres, the index names are unique per table only, not per schema.
TableMetaData - Class in org.tentackle.sql.metadata: Database metadata for a table that is part of the model.
TableMetaData(ModelMetaData, String) - Constructor for class org.tentackle.sql.metadata.TableMetaData: Creates a table metadata instance.
TBinaryType - Class in org.tentackle.sql.datatypes: Datatype for TBinary.
TBinaryType() - Constructor for class org.tentackle.sql.datatypes.TBinaryType: Creates the datatype for TBinary.
TIME - Enum constant in enum class org.tentackle.sql.SqlType: Time.
timeOf(OffsetTime) - Static method in class org.tentackle.sql.datatypes.OffsetTimeType: Derives the time from an OffsetTime value.
TIMESTAMP - Enum constant in enum class org.tentackle.sql.SqlType: Timestamp.
timestampOf(OffsetDateTime) - Static method in class org.tentackle.sql.datatypes.OffsetDateTimeType: Derives the timestamp from an OffsetDateTime value.
timestampOf(ZonedDateTime) - Static method in class org.tentackle.sql.datatypes.ZonedDateTimeType: Derives the timestamp from a ZonedDateTime value.
timestampString(Timestamp) - Static method in class org.tentackle.sql.backends.Oracle8: Converts a timestamp to a string.
TimestampType - Class in org.tentackle.sql.datatypes: Datatype for Timestamp.
TimestampType() - Constructor for class org.tentackle.sql.datatypes.TimestampType: Creates the datatype for Timestamp.
timeString(Time) - Static method in class org.tentackle.sql.backends.Oracle8: Converts a time to a string.
TimeType - Class in org.tentackle.sql.datatypes: Datatype for Time.
TimeType() - Constructor for class org.tentackle.sql.datatypes.TimeType: Creates the datatype for Time.
TINYINT - Enum constant in enum class org.tentackle.sql.SqlType: Byte and byte.
toInternalType(String) - Method in interface org.tentackle.sql.Backend: Converts a backend-specific type name to an internal name used by driver-specific methods.
toInternalType(String) - Method in class org.tentackle.sql.backends.AbstractBackend
toInternalType(String) - Method in class org.tentackle.sql.backends.Postgres
toLiteral(String, Integer) - Method in interface org.tentackle.sql.DataType: Takes the string representation of a value and converts it to an SQL literal.
Some types need single quotes, for example.
toLiteral(String, Integer) - Method in class org.tentackle.sql.datatypes.AbstractDataType
toLiteral(String, Integer) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
toLiteral(String, Integer) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
toLiteral(String, Integer) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
toNonPrimitive() - Method in interface org.tentackle.sql.DataType: Gets the non-primitive type if this is a primitive.
toNonPrimitive() - Method in class org.tentackle.sql.datatypes.AbstractDataType
toNonPrimitive() - Method in class org.tentackle.sql.datatypes.BooleanPrimitiveType
toNonPrimitive() - Method in class org.tentackle.sql.datatypes.BytePrimitiveType
toNonPrimitive() - Method in class org.tentackle.sql.datatypes.CharacterPrimitiveType
toNonPrimitive() - Method in class org.tentackle.sql.datatypes.DoublePrimitiveType
toNonPrimitive() - Method in class org.tentackle.sql.datatypes.FloatPrimitiveType
toNonPrimitive() - Method in class org.tentackle.sql.datatypes.IntegerPrimitiveType
toNonPrimitive() - Method in class org.tentackle.sql.datatypes.LongPrimitiveType
toNonPrimitive() - Method in class org.tentackle.sql.datatypes.ShortPrimitiveType
toPrimitive() - Method in interface org.tentackle.sql.DataType: Gets the primitive type if this is a non-primitive.
toPrimitive() - Method in class org.tentackle.sql.datatypes.AbstractDataType
toPrimitive() - Method in class org.tentackle.sql.datatypes.BooleanType
toPrimitive() - Method in class org.tentackle.sql.datatypes.ByteType
toPrimitive() - Method in class org.tentackle.sql.datatypes.CharacterType
toPrimitive() - Method in class org.tentackle.sql.datatypes.DoubleType
toPrimitive() - Method in class org.tentackle.sql.datatypes.FloatType
toPrimitive() - Method in class org.tentackle.sql.datatypes.IntegerType
toPrimitive() - Method in class org.tentackle.sql.datatypes.LongType
toPrimitive() - Method in class org.tentackle.sql.datatypes.ShortType
toQuotedString(String) - Method in interface org.tentackle.sql.Backend: Converts a string to a string enclosed in single quotes.
toQuotedString(String) - Method in class org.tentackle.sql.backends.AbstractBackend
toString() - Method in class org.tentackle.sql.BackendInfo
toString() - Method in class org.tentackle.sql.backends.AbstractBackend
toString() - Method in record class org.tentackle.sql.BackendVersionInfo: Returns a string representation of this record class.
toString() - Method in class org.tentackle.sql.datatypes.AbstractDataType
toString() - Method in record class org.tentackle.sql.DefaultScriptRunner.SQLCode: Returns a string representation of this record class.
toString() - Method in enum class org.tentackle.sql.JoinType
toString() - Method in class org.tentackle.sql.metadata.ColumnMetaData
toString() - Method in class org.tentackle.sql.metadata.DatabaseMetaDataTableHeader
toString() - Method in enum class org.tentackle.sql.metadata.ForeignKeyAction
toString() - Method in class org.tentackle.sql.metadata.ForeignKeyColumnMetaData
toString() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData
toString() - Method in class org.tentackle.sql.metadata.IndexColumnMetaData
toString() - Method in class org.tentackle.sql.metadata.IndexMetaData
toString() - Method in class org.tentackle.sql.metadata.ModelMetaData
toString() - Method in record class org.tentackle.sql.metadata.OracleIndexColumnMetaData.ColumnExpression: Returns a string representation of this record class.
toString() - Method in class org.tentackle.sql.metadata.TableMetaData
toString() - Method in record class org.tentackle.sql.ScriptRunnerResult: Returns a string representation of this record class.
toString() - Method in enum class org.tentackle.sql.SqlNameType
toString(Date) - Method in class org.tentackle.sql.datatypes.DateType
toString(Time) - Method in class org.tentackle.sql.datatypes.TimeType
toString(Timestamp) - Method in class org.tentackle.sql.datatypes.TimestampType
toString(Instant) - Method in class org.tentackle.sql.datatypes.InstantType
toString(LocalDate) - Method in class org.tentackle.sql.datatypes.LocalDateType
toString(LocalDateTime) - Method in class org.tentackle.sql.datatypes.LocalDateTimeType
toString(LocalTime) - Method in class org.tentackle.sql.datatypes.LocalTimeType
toString(OffsetDateTime) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
toString(OffsetTime) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
toString(ZonedDateTime) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
toString(T) - Method in interface org.tentackle.sql.DataType: Takes an object and converts it to a string that can in turn be parsed with DataType.valueOf(String).
The method is used to print a literal (for example, the default value of a dumped attribute).
toString(T) - Method in class org.tentackle.sql.datatypes.AbstractDataType
TYPE - Enum constant in enum class org.tentackle.sql.MigrationStrategy: use Backend.sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object).
TYPE - Static variable in class org.tentackle.sql.datatypes.ConvertibleType: Type name for the wrapper type implementing org.tentackle.misc.Convertible.
TYPE_BIGINT - Static variable in class org.tentackle.sql.backends.AbstractBackend: BIGINT column type.
TYPE_BIT - Static variable in class org.tentackle.sql.backends.AbstractBackend: BIT column type.
TYPE_BLOB - Static variable in class org.tentackle.sql.backends.AbstractBackend: BLOB column type.
TYPE_BOOL - Static variable in class org.tentackle.sql.backends.AbstractBackend: BOOL column type.
TYPE_BOOLEAN - Static variable in class org.tentackle.sql.backends.AbstractBackend: BOOLEAN column type.
TYPE_BYTE - Static variable in class org.tentackle.sql.backends.AbstractBackend: BYTE column type.
TYPE_BYTEA - Static variable in class org.tentackle.sql.backends.AbstractBackend: BYTEA column type.
TYPE_CHAR_1 - Static variable in class org.tentackle.sql.backends.AbstractBackend: CHAR(1) column type.
TYPE_CLOB - Static variable in class org.tentackle.sql.backends.AbstractBackend: CLOB column type.
TYPE_DATE - Static variable in class org.tentackle.sql.backends.AbstractBackend: DATE column type.
TYPE_DATETIME - Static variable in class org.tentackle.sql.backends.AbstractBackend: DATETIME column type.
TYPE_DATETIME_6 - Static variable in class org.tentackle.sql.backends.AbstractBackend: DATETIME(6) column type.
TYPE_DATETIME_YEAR_TO_SECOND - Static variable in class org.tentackle.sql.backends.AbstractBackend: DATETIME YEAR TO SECOND column type.
TYPE_DECIMAL - Static variable in class org.tentackle.sql.backends.AbstractBackend: DECIMAL column type.
TYPE_DECIMAL_19 - Static variable in class org.tentackle.sql.backends.AbstractBackend: DECIMAL(19) column type.
TYPE_DOUBLE - Static variable in class org.tentackle.sql.backends.AbstractBackend: DOUBLE column type.
TYPE_DOUBLE_PRECISION - Static variable in class org.tentackle.sql.backends.AbstractBackend: DOUBLE PRECISION column type.
TYPE_FLOAT - Static variable in class org.tentackle.sql.backends.AbstractBackend: FLOAT column type.
TYPE_FLOAT4 - Static variable in class org.tentackle.sql.backends.AbstractBackend: FLOAT4 column type.
TYPE_FLOAT8 - Static variable in class org.tentackle.sql.backends.AbstractBackend: FLOAT8 column type.
TYPE_INT - Static variable in class org.tentackle.sql.backends.AbstractBackend: INT column type.
TYPE_INT2 - Static variable in class org.tentackle.sql.backends.AbstractBackend: INT2 column type.
TYPE_INT4 - Static variable in class org.tentackle.sql.backends.AbstractBackend: INT4 column type.
TYPE_INT8 - Static variable in class org.tentackle.sql.backends.AbstractBackend: INT8 column type.
TYPE_INTEGER - Static variable in class org.tentackle.sql.backends.AbstractBackend: INTEGER column type.
TYPE_JSON - Static variable in class org.tentackle.sql.backends.AbstractBackend: JSON column type.
TYPE_JSONB - Static variable in class org.tentackle.sql.backends.AbstractBackend: JSONB column type.
TYPE_LONGBLOB - Static variable in class org.tentackle.sql.backends.AbstractBackend: LONGBLOB column type.
TYPE_LONGTEXT - Static variable in class org.tentackle.sql.backends.AbstractBackend: LONGTEXT column type.
TYPE_NCHAR_1 - Static variable in class org.tentackle.sql.backends.AbstractBackend: NCHAR(1) column type.
TYPE_NUMBER - Static variable in class org.tentackle.sql.backends.AbstractBackend: NUMBER column type.
TYPE_NUMBER_1 - Static variable in class org.tentackle.sql.backends.AbstractBackend: NUMBER(1) column type.
TYPE_NUMBER_10 - Static variable in class org.tentackle.sql.backends.AbstractBackend: NUMBER(10) column type.
TYPE_NUMBER_19 - Static variable in class org.tentackle.sql.backends.AbstractBackend: NUMBER(19) column type.
TYPE_NUMBER_5 - Static variable in class org.tentackle.sql.backends.AbstractBackend: NUMBER(5) column type.
TYPE_NVARCHAR - Static variable in class org.tentackle.sql.backends.AbstractBackend: NVARCHAR column type.
TYPE_NVARCHAR_MAX - Static variable in class org.tentackle.sql.backends.AbstractBackend: NVARCHAR(MAX) column type.
TYPE_REAL - Static variable in class org.tentackle.sql.backends.AbstractBackend: REAL column type.
TYPE_SMALLFLOAT - Static variable in class org.tentackle.sql.backends.AbstractBackend: SMALLFLOAT column type.
TYPE_SMALLINT - Static variable in class org.tentackle.sql.backends.AbstractBackend: SMALLINT column type.
TYPE_TEXT - Static variable in class org.tentackle.sql.backends.AbstractBackend: TEXT column type.
TYPE_TIME - Static variable in class org.tentackle.sql.backends.AbstractBackend: TIME column type.
TYPE_TIME_6 - Static variable in class org.tentackle.sql.backends.AbstractBackend: TIME(6) column type.
TYPE_TIMESTAMP - Static variable in class org.tentackle.sql.backends.AbstractBackend: TIMESTAMP column type.
TYPE_TINYINT - Static variable in class org.tentackle.sql.backends.AbstractBackend: TINYINT column type.
TYPE_UUID - Static variable in class org.tentackle.sql.backends.AbstractBackend: UUID column type.
TYPE_VARBINARY_MAX - Static variable in class org.tentackle.sql.backends.AbstractBackend: VARBINARY(MAX) column type.
TYPE_VARCHAR - Static variable in class org.tentackle.sql.backends.AbstractBackend: VARCHAR column type.
TYPE_WARNING - Enum constant in enum class org.tentackle.sql.MigrationStrategy: emit the Backend.sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) statement commented out, for manual review.
TYPE_XML - Static variable in class org.tentackle.sql.backends.AbstractBackend: XML column type.
TYPE_XMLTYPE - Static variable in class org.tentackle.sql.backends.AbstractBackend: XMLTYPE column type.

U

unload(Driver) - Static method in class org.tentackle.sql.DynamicDriver: Unloads the driver.
Deregisters the driver from the DriverManager.
UUID - Enum constant in enum class org.tentackle.sql.SqlType: UUID.
UUIDType - Class in org.tentackle.sql.datatypes: Datatype for UUID.
UUIDType() - Constructor for class org.tentackle.sql.datatypes.UUIDType: Creates the datatype for UUID.

V

validate() - Method in class org.tentackle.sql.metadata.ColumnMetaData: Validates and post-processes the column data.
validate() - Method in class org.tentackle.sql.metadata.FirebirdColumnMetaData
validate() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData: Validates and post-processes the foreign key data.
validate() - Method in class org.tentackle.sql.metadata.IndexColumnMetaData: Validates and post-processes the index column data.
validate() - Method in class org.tentackle.sql.metadata.IndexMetaData: Validates and post-processes the index data.
validate() - Method in class org.tentackle.sql.metadata.MySqlColumnMetaData
validate() - Method in class org.tentackle.sql.metadata.OracleColumnMetaData
validate() - Method in class org.tentackle.sql.metadata.OracleIndexColumnMetaData
validate() - Method in class org.tentackle.sql.metadata.PostgresColumnMetaData
validate() - Method in class org.tentackle.sql.metadata.PostgresIndexMetaData
validate() - Method in class org.tentackle.sql.metadata.TableMetaData: Validates and post-processes the table data.
validateVersion(BackendVersionInfo) - Method in interface org.tentackle.sql.Backend: Verifies that the major and minor version of the connection's metadata is compatible with this backend.
If the latest backend is not compatible, the URL may be post-fixed with a backend type for an older version, for example:
validateVersion(BackendVersionInfo) - Method in class org.tentackle.sql.backends.AbstractBackend
validateVersion(BackendVersionInfo) - Method in class org.tentackle.sql.backends.Firebird
validateVersion(BackendVersionInfo) - Method in class org.tentackle.sql.backends.Hana
validateVersion(BackendVersionInfo) - Method in class org.tentackle.sql.backends.MariaDb
validateVersion(BackendVersionInfo) - Method in class org.tentackle.sql.backends.MySql
validateVersion(BackendVersionInfo) - Method in class org.tentackle.sql.backends.Oracle
validateVersion(BackendVersionInfo) - Method in class org.tentackle.sql.backends.Oracle21
validateVersion(BackendVersionInfo) - Method in class org.tentackle.sql.backends.Oracle23
valueOf(String) - Method in interface org.tentackle.sql.DataType: Parses a string and converts to the value of this type.
The method is used to parse a literal (for example, the default value defined in the model).
valueOf(String) - Method in class org.tentackle.sql.datatypes.BigDecimalType
valueOf(String) - Method in class org.tentackle.sql.datatypes.BinaryType
valueOf(String) - Method in class org.tentackle.sql.datatypes.BMoneyType
valueOf(String) - Method in class org.tentackle.sql.datatypes.BooleanType
valueOf(String) - Method in class org.tentackle.sql.datatypes.ByteArrayType
valueOf(String) - Method in class org.tentackle.sql.datatypes.ByteType
valueOf(String) - Method in class org.tentackle.sql.datatypes.CharacterType
valueOf(String) - Method in class org.tentackle.sql.datatypes.ConvertibleType
valueOf(String) - Method in class org.tentackle.sql.datatypes.DateType
valueOf(String) - Method in class org.tentackle.sql.datatypes.DMoneyType
valueOf(String) - Method in class org.tentackle.sql.datatypes.DoubleType
valueOf(String) - Method in class org.tentackle.sql.datatypes.FloatType
valueOf(String) - Method in class org.tentackle.sql.datatypes.I18NTextType
valueOf(String) - Method in class org.tentackle.sql.datatypes.InstantType
valueOf(String) - Method in class org.tentackle.sql.datatypes.IntegerType
valueOf(String) - Method in class org.tentackle.sql.datatypes.LocalDateTimeType
valueOf(String) - Method in class org.tentackle.sql.datatypes.LocalDateType
valueOf(String) - Method in class org.tentackle.sql.datatypes.LocalTimeType
valueOf(String) - Method in class org.tentackle.sql.datatypes.LongType
valueOf(String) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
valueOf(String) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
valueOf(String) - Method in class org.tentackle.sql.datatypes.ShortType
valueOf(String) - Method in class org.tentackle.sql.datatypes.StringType
valueOf(String) - Method in class org.tentackle.sql.datatypes.TBinaryType
valueOf(String) - Method in class org.tentackle.sql.datatypes.TimestampType
valueOf(String) - Method in class org.tentackle.sql.datatypes.TimeType
valueOf(String) - Method in class org.tentackle.sql.datatypes.UUIDType
valueOf(String) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
valueOf(String) - Static method in enum class org.tentackle.sql.JoinType: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.tentackle.sql.metadata.Deferrability: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.tentackle.sql.metadata.ForeignKeyAction: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.tentackle.sql.MigrationStrategy: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.tentackle.sql.SqlNameType: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.tentackle.sql.SqlType: Returns the enum constant of this class with the specified name.
valueOfLiteralToCode(String, Integer) - Method in interface org.tentackle.sql.DataType: Creates the java code to apply the valueOf method to a String.
valueOfLiteralToCode(String, Integer) - Method in class org.tentackle.sql.datatypes.AbstractDataType
valueOfLiteralToCode(String, Integer) - Method in class org.tentackle.sql.datatypes.AbstractDateTimeType
valueOfLiteralToCode(String, Integer) - Method in class org.tentackle.sql.datatypes.AbstractNumberType
valueOfLiteralToCode(String, Integer) - Method in class org.tentackle.sql.datatypes.CharacterType
valueOfLiteralToCode(String, Integer) - Method in class org.tentackle.sql.datatypes.I18NTextType
valueOfLiteralToCode(String, Integer) - Method in class org.tentackle.sql.datatypes.InstantType
valueOfLiteralToCode(String, Integer) - Method in class org.tentackle.sql.datatypes.LongType
valueOfLiteralToCode(String, Integer) - Method in class org.tentackle.sql.datatypes.OffsetDateTimeType
valueOfLiteralToCode(String, Integer) - Method in class org.tentackle.sql.datatypes.OffsetTimeType
valueOfLiteralToCode(String, Integer) - Method in class org.tentackle.sql.datatypes.StringType
valueOfLiteralToCode(String, Integer) - Method in class org.tentackle.sql.datatypes.UUIDType
valueOfLiteralToCode(String, Integer) - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
values() - Static method in enum class org.tentackle.sql.JoinType: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.tentackle.sql.metadata.Deferrability: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.tentackle.sql.metadata.ForeignKeyAction: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.tentackle.sql.MigrationStrategy: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.tentackle.sql.SqlNameType: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.tentackle.sql.SqlType: Returns an array containing the constants of this enum class, in the order they are declared.
valueStringToCode(String) - Method in class org.tentackle.sql.datatypes.AbstractDataType: Transforms the value string of an object to java code.
valueToLiteral(SqlType, Object) - Method in interface org.tentackle.sql.Backend: Converts a type and value to a literal string.
valueToLiteral(SqlType, Object) - Method in class org.tentackle.sql.backends.AbstractBackend
valueToLiteral(SqlType, Object) - Method in class org.tentackle.sql.backends.Firebird
valueToLiteral(SqlType, Object) - Method in class org.tentackle.sql.backends.Hana
valueToLiteral(SqlType, Object) - Method in class org.tentackle.sql.backends.Oracle23
valueToLiteral(SqlType, Object) - Method in class org.tentackle.sql.backends.Oracle8
VARCHAR - Enum constant in enum class org.tentackle.sql.SqlType: String.
VARIANT - Static variable in class org.tentackle.sql.datatypes.JsonType: JSON variant.
Distinguishes a String bound to a native JSON column from a plain VARCHAR or CLOB-backed one.
VARIANT - Static variable in class org.tentackle.sql.datatypes.LargeStringType: Large string variant.
For example, to distinguish standard VARCHAR Strings from CLOBs.
VARIANT - Static variable in class org.tentackle.sql.datatypes.XMLType: XML variant.
Distinguishes a String bridged through the JDBC SQLXML interface to a native XML column from a plain VARCHAR or CLOB-backed one.

W

warnings() - Method in record class org.tentackle.sql.ScriptRunnerResult: Returns the value of the warnings record component.

X

XML - Enum constant in enum class org.tentackle.sql.SqlType: XML content, usually stored in a native XML column or emulated as CLOB.
XMLType - Class in org.tentackle.sql.datatypes: Datatype for the XML variant of String.
XMLType() - Constructor for class org.tentackle.sql.datatypes.XMLType: Creates the datatype for the XML variant of String.

Z

ZonedDateTimeType - Class in org.tentackle.sql.datatypes: Datatype for ZonedDateTime.
ZonedDateTimeType() - Constructor for class org.tentackle.sql.datatypes.ZonedDateTimeType: Creates the datatype for ZonedDateTime.
zoneOf(ZonedDateTime) - Static method in class org.tentackle.sql.datatypes.ZonedDateTimeType: Derives the timezone name from a ZonedDateTime value.

A B C D E F G H I J L M N O P R S T U V W X Z
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form