Index
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
- 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.
- 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 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.Oracle8
B
- Backend - Interface in org.tentackle.sql
-
A database backend.
Defines the backend specifics.
There is only one instance per database 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 database backend configuration errors.
- 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 constraint exception without a session with the specified detail message and cause.
- BackendFactory - Interface in org.tentackle.sql
-
The backend factory.
- BackendInfo - Class in org.tentackle.sql
-
Configuration info for a backend.
- 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.
- BackendInfoFactory - Interface in org.tentackle.sql
-
The backend info factory.
- BackendPreparedStatement - Interface in org.tentackle.sql
-
Just an interface to decouple dependency from PreparedStatementWrapper.
- 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
- buildSelectSql(StringBuilder, boolean, int, int) - Method in class org.tentackle.sql.backends.AbstractSql2008Backend
- 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.H2
- 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
- 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
- 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
- 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
- CASCADE - Enum constant in enum class org.tentackle.sql.metadata.ForeignKeyAction
-
When the primary key is updated, the foreign key (imported key) is changed to agree with it.
- 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 all passwords (stored in char[]-arrays) so that they are no more visible in memory.
- CLOB - Enum constant in enum class org.tentackle.sql.SqlType
-
Large Strings usually stored as CLOB.
- 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. - ColumnMetaData - Class in org.tentackle.sql.metadata
-
Meta data for a column
- ColumnMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.ColumnMetaData
-
Creates column meta data.
- 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.Oracle8
- columnTypeToString(SqlType, int, int) - Method in interface org.tentackle.sql.Backend
-
Converts an sqltype, 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
- 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.
- connect(String, Properties) - Method in class org.tentackle.sql.DynamicDriver
- CONVERTIBLE_TYPE - Static variable in interface org.tentackle.sql.DataTypeFactory
-
Type name for the wrapper type implementing
org.tentackle.misc.Convertible
. - 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 meta data instance.
- createColumnMetaData(TableMetaData) - Method in class org.tentackle.sql.backends.AbstractBackend
- 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
- createConnection(String, String, char[]) - Method in class org.tentackle.sql.backends.Oracle8
- 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 meta data instance.
- createIndexColumnMetaData(IndexMetaData) - Method in class org.tentackle.sql.backends.AbstractBackend
- createIndexColumnMetaData(IndexMetaData) - Method in class org.tentackle.sql.backends.Postgres
- createIndexMetaData(TableMetaData) - Method in interface org.tentackle.sql.Backend
-
Creates an index meta data instance.
- createIndexMetaData(TableMetaData) - Method in class org.tentackle.sql.backends.AbstractBackend
- 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
- createTableMetaData(ModelMetaData, String) - Method in interface org.tentackle.sql.Backend
-
Creates a meta data instance.
- createTableMetaData(ModelMetaData, String) - Method in class org.tentackle.sql.backends.AbstractBackend
D
- 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 moreSqlType
s, 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
- DEFAULT_SCHEMA - Static variable in class org.tentackle.sql.backends.H2
-
postgres' 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
- DefaultDataTypeFactory() - Constructor for class org.tentackle.sql.DefaultDataTypeFactory
-
Creates the datatype factory.
- 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.
- 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/li> 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
- 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 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.
- extractWhereClause(String, int) - Method in class org.tentackle.sql.backends.AbstractBackend
-
Extracts the where clause from a given sql.
- extractWhereClause(String, int) - Method in class org.tentackle.sql.backends.H2
- extractWhereClause(String, int) - Method in class org.tentackle.sql.backends.Informix
- extractWhereClause(String, int) - Method in class org.tentackle.sql.backends.MsSql
- extractWhereClause(String, int) - Method in class org.tentackle.sql.backends.MySql
- extractWhereClause(String, int) - Method in class org.tentackle.sql.backends.Oracle
- extractWhereClause(String, int) - Method in class org.tentackle.sql.backends.Oracle8
- extractWhereClause(String, int) - Method in class org.tentackle.sql.backends.Postgres
F
- 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
-
Enum for foreign key actions.
- 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 meta data.
- format(Date) - Method in class org.tentackle.sql.datatypes.DateType
- format(Time) - Method in class org.tentackle.sql.datatypes.TimeType
- format(Timestamp) - Method in class org.tentackle.sql.datatypes.TimestampType
- format(Instant) - Method in class org.tentackle.sql.datatypes.InstantType
-
Converts an instant to a string.
- 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.
G
- get(Class<T>) - Method in interface org.tentackle.sql.DataTypeFactory
-
Gets the datatype singleton.
- get(Class<T>, String) - Method in interface org.tentackle.sql.DataTypeFactory
-
Gets the datatype singleton.
- 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.
- 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 ifDataType.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.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.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.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.ZonedDateTimeType
- getAction() - Method in enum class org.tentackle.sql.metadata.ForeignKeyAction
-
Gets the action code.
- getAllBackends() - Method in interface org.tentackle.sql.BackendFactory
-
Creates a collection of 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
-
Creates a backend by name.
- getBackendByName(String) - Method in class org.tentackle.sql.DefaultBackendFactory
- getBackendByUrl(String) - Method in interface org.tentackle.sql.BackendFactory
-
Creates a backend by jdbc url.
- getBackendByUrl(String) - Method in class org.tentackle.sql.DefaultBackendFactory
- 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.Db2
- getBackendId(Connection) - Method in class org.tentackle.sql.backends.H2
- getBackendId(Connection) - Method in class org.tentackle.sql.backends.Informix
- 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
- getBackends(String) - Method in interface org.tentackle.sql.BackendFactory
-
Creates 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.
- getClazz() - Method in enum class org.tentackle.sql.SqlType
-
Gets the corresponding class.
- 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 asBMoney
. - 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
- 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 columnName of the column.
- getColumnName() - Method in class org.tentackle.sql.metadata.IndexColumnMetaData
-
Gets the column columnName.
- 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.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 model.
- getDefaultSize(SqlType) - Method in class org.tentackle.sql.backends.AbstractBackend
- 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.
- 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.H2
- 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.Oracle8
- getEmptyString() - Method in interface org.tentackle.sql.Backend
-
Gets the empty string.
Some dbms (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
- 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 column.
- 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 tablename including optional schema.
- getFullPrimaryKeyTableName() - Method in class org.tentackle.sql.metadata.ForeignKeyMetaData
-
Gets the full primary key tablename including optional schema.
- getFullTableName() - Method in class org.tentackle.sql.metadata.TableMetaData
-
Gets the database table name with optional schemaname prepended.
Always in lowercase. - getFunctionName() - Method in class org.tentackle.sql.metadata.IndexColumnMetaData
-
Gets the optional function name.
- 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.
- 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
-
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.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.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.
- 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 aBackendException
, 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.LocalDateTimeType
- 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.ZonedDateTimeType
- getMaxNameLength(SqlNameType) - Method in interface org.tentackle.sql.Backend
-
Gets the maximum allowed length for a name.
This method is used byBackend.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.H2
- 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
- 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
- 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.H2
- 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 schema-option was given inBackendInfo
. - 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
- 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.H2
- getMigrationStrategy(ColumnMetaData, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.MySql
- getMigrationStrategy(ColumnMetaData, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Postgres
- 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.
- getName() - Method in interface org.tentackle.sql.Backend
-
Gets the name of the backend.
- getName() - Method in class org.tentackle.sql.backends.Db2
- getName() - Method in class org.tentackle.sql.backends.H2
- 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.Oracle8
- getName() - Method in class org.tentackle.sql.backends.Postgres
- getName() - Method in class org.tentackle.sql.metadata.DatabaseMetaDataTableHeader
- 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 index.
- 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 column.
- 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.H2
- getReservedWords() - Method in class org.tentackle.sql.backends.Postgres
- 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.
Always in lowercase. - 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 begin 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.OffsetTimeType
- getSortableColumns() - Method in class org.tentackle.sql.datatypes.UUIDType
- getSortableColumns() - Method in class org.tentackle.sql.datatypes.ZonedDateTimeType
- getSql() - Method in enum class org.tentackle.sql.metadata.ForeignKeyAction
-
Gets the SQL code.
- 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.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.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.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.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
-
The 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 infos for given tablename.
May return more than one entry if the same tablename 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.
Always in lowercase. - 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
-
The table's name.
- getTypeName() - Method in class org.tentackle.sql.metadata.ColumnMetaData
-
Gets the backend-specific type columnName.
- 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.
- getVariant() - Method in class org.tentackle.sql.datatypes.AbstractDataType
- getVariant() - Method in class org.tentackle.sql.datatypes.LargeStringType
- 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.
- 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 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
-
Meta data for an index.
- IndexMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.IndexMetaData
-
Creates an index meta data 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 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.H2
- isAliasRequiredForSubSelect() - Method in class org.tentackle.sql.backends.Postgres
- isArrayOperatorSupported(String) - Method in interface org.tentackle.sql.Backend
-
Returns whether the backend supports 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
- isClobSupported() - Method in interface org.tentackle.sql.Backend
-
Returns whether the backend support 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: noCN_...
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 exception is a communication error.
- isCommunicationLinkException(SQLException) - Method in class org.tentackle.sql.backends.AbstractBackend
- 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
- 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
- isDeprecated() - Method in interface org.tentackle.sql.Backend
-
Returns whether this backend is deprecated and superseded by a newer implementation.
Deprecated backends are omitted fromBackendFactory.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 ascending or 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.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 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 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 extraConnection.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.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.MySql
- 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.
ImpliesDataType.isModelProvidingInnerType()
. - isJavaTypeGenerified() - Method in class org.tentackle.sql.datatypes.AbstractDataType
- isJavaTypeGenerified() - Method in class org.tentackle.sql.datatypes.BinaryType
- 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
- 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
- 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.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.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.Db2
- isMatchingUrl(String) - Method in class org.tentackle.sql.backends.H2
- 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.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 type is a mutable java object.
Mutable objects may change their state and must implementFreezable
. - 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.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 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
- 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.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.H2
- 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 tablename is reserved.
- isReservedTableName(String) - Method in interface org.tentackle.sql.Backend
-
Checks whether this 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.Oracle8
- isReservedWord(String) - Method in class org.tentackle.sql.backends.AbstractBackend
-
Checks whether given string is a reserved word.
- 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.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
-
True if 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
- 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.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
- isTransientTransactionException(SQLException) - Method in interface org.tentackle.sql.Backend
-
Determines whether 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.H2
- isTransientTransactionException(SQLException) - Method in class org.tentackle.sql.backends.MsSql
- 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.
- 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 a tentackle backend SqlTypes.
- jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.AbstractBackend
- jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.Db2
- jdbcTypeToSqlType(int, int, int) - Method in class org.tentackle.sql.backends.H2
- 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
- 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.
L
- LARGE_VARIANT - Static variable in interface org.tentackle.sql.DataTypeFactory
-
Large variant of a type.
For example, to distinguish standard VARCHAR Strings from CLOBs. - 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.
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
- 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 colunm's type matches given SqlType according to the backend.
- maxLinesInLiteral - Static variable in class org.tentackle.sql.datatypes.AbstractDataType
-
Maximum number of lines in literal.
> 0 if unlimited. - MetaDataUtilities - Class in org.tentackle.sql.metadata
-
Database metadata utility methods.
Replaceable by application specific implementation viaService
annotation. - MetaDataUtilities() - Constructor for class org.tentackle.sql.metadata.MetaDataUtilities
- MigrationStrategy - Enum Class in org.tentackle.sql
-
Defines the methods to use for migration.
- 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 a database meta instance.
- MsSql - Class in org.tentackle.sql.backends
-
Backend for MicrosoftSQL.
- 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
-
MySql does not return strings in single-quotes in default values.
- MySqlColumnMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.MySqlColumnMetaData
-
Creates column metadata.
N
- NAME - Enum constant in enum class org.tentackle.sql.MigrationStrategy
- NAME_AND_TYPE - Enum constant in enum class org.tentackle.sql.MigrationStrategy
- 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
-
Normalize the default string to compare.
- NOT_DEFERRABLE - Enum constant in enum class org.tentackle.sql.metadata.ForeignKeyAction
-
Indicates deferrability.
- NULL - Enum constant in enum class org.tentackle.sql.MigrationStrategy
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
-
Optimize SQL code.
Replace WHERE 1=1 AND/OR to 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.
- 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
-
Oracle column data.
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.
- org.tentackle.sql - module org.tentackle.sql
-
tentackle-sql module.
- org.tentackle.sql - package org.tentackle.sql
-
SQL backend layer.
- org.tentackle.sql.backends - package org.tentackle.sql.backends
-
Backend implementations.
- org.tentackle.sql.datatypes - package org.tentackle.sql.datatypes
-
DataType implementations.
- org.tentackle.sql.metadata - package org.tentackle.sql.metadata
-
SQL metadata support.
P
- parse(String) - Method in class org.tentackle.sql.datatypes.DateType
- parse(String) - Method in class org.tentackle.sql.datatypes.InstantType
-
Converts a string to an instant.
- 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
- parse(String) - Method in class org.tentackle.sql.datatypes.TimeType
- 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.
- 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
-
Postgres column data.
- PostgresColumnMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.PostgresColumnMetaData
-
Creates column meta data.
- PostgresIndexColumnMetaData - Class in org.tentackle.sql.metadata
-
Index column metadata for postgres.
Strips optional typecasts. - PostgresIndexColumnMetaData(IndexMetaData) - Constructor for class org.tentackle.sql.metadata.PostgresIndexColumnMetaData
-
Creates an index column.
- PostgresIndexMetaData - Class in org.tentackle.sql.metadata
-
Postgres index meta data.
- PostgresIndexMetaData(TableMetaData) - Constructor for class org.tentackle.sql.metadata.PostgresIndexMetaData
-
Creates an index meta data object.
- PostgresScriptRunner - Class in org.tentackle.sql.backends
-
Script runner for postgres.
- PostgresScriptRunner(Backend, Connection) - Constructor for class org.tentackle.sql.backends.PostgresScriptRunner
-
Creates a script runner.
R
- RESERVED_WORDS_H2 - Static variable in class org.tentackle.sql.backends.H2
-
array of additional reserved words.
- 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 if it has been imported by another table as a foreign key.
- results() - Method in record class org.tentackle.sql.ScriptRunnerResult
-
Returns the value of the
results
record component. - 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.
- ScriptRunnerResult - Record Class in org.tentackle.sql
-
The result of a statement executed by a
ScriptRunner
. - ScriptRunnerResult(String, int, String, int, Object...) - Constructor for record class org.tentackle.sql.ScriptRunnerResult
-
Creates an instance of a
ScriptRunnerResult
record class. - 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.LargeStringType
- set(Backend, PreparedStatement, int, String, boolean, Integer) - Method in class org.tentackle.sql.datatypes.StringType
- 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<? extends Serializable>, 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, T, boolean, Integer) - Method in interface org.tentackle.sql.DataType
-
Sets the object into a prepared statement.
Must be implemented ifDataType.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 ifDataType.isPredefined()
returns false. - set(Backend, PreparedStatement, int, T, int, boolean, Integer) - Method in class org.tentackle.sql.datatypes.AbstractDataType
- set(DataType<T>, 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<T>, 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
- setBackendKeepAliveEnabled(boolean) - Method in class org.tentackle.sql.BackendInfo
-
Sets whether a keep-alive SELECT should be sent periodically on idle connections.
When true andbackendTimeout
is set, a dummy select will be sent to the backend, when the connection is idle for more thanbackendTimeout
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.TableMetaData
-
Sets the comment.
- 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 default time zone of the virtual machine that is running the application. - 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 default time zone of the virtual machine that is running the application. - setDefaultValue(String) - Method in class org.tentackle.sql.metadata.ColumnMetaData
-
Sets the default value.
- 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 database 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...
Notice, that those temporary DDL changes should better use the temporary prefix (seeBackend.isTemporaryName(String)
) in order 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.
- 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. - setLargeString(int, String) - Method in interface org.tentackle.sql.BackendPreparedStatement
-
Sets a very large string.
This is usually converted to SQLCLOB
. - setLargeString(int, String, boolean) - Method in interface org.tentackle.sql.BackendPreparedStatement
-
Sets a very large string.
This is usually converted to SQLCLOB
. - 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.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. - 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 index.
- 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. - 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.
- 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
- 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.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
- 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 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 column from the database metadata result.
- 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 dDatatype 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_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
-
LIMIT 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 string.
- 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.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.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
-
MAX function name.
- SQL_NESTED_SELECT_1 - Static variable in class org.tentackle.sql.backends.Oracle8
-
window function part 1.
- SQL_NESTED_SELECT_2 - Static variable in class org.tentackle.sql.backends.Oracle8
-
window function part 2.
- SQL_NESTED_SELECT_LIMIT - Static variable in class org.tentackle.sql.backends.Oracle8
-
condition for limit and offset.
- SQL_NESTED_SELECT_OFFSET - Static variable in class org.tentackle.sql.backends.Oracle8
-
condition for limit and offset.
- SQL_NESTED_SELECT_ROWNUM - Static variable in class org.tentackle.sql.backends.Oracle8
-
condition for limit and offset.
- 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.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.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 string.
- 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 string.
- 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 will be replaced by...
- 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 will be replaced by...
- SQL_WINDOW_1 - Static variable in class org.tentackle.sql.backends.AbstractSql2003Backend
-
window function part 1.
- SQL_WINDOW_2 - Static variable in class org.tentackle.sql.backends.AbstractSql2003Backend
-
window function part 2.
- SQL_WINDOW_LIMIT - Static variable in class org.tentackle.sql.backends.AbstractSql2003Backend
-
condition for limit and offset.
- SQL_WINDOW_OFFSET - Static variable in class org.tentackle.sql.backends.AbstractSql2003Backend
-
condition for limit and offset.
- 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.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 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.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.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
- 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
- sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.H2
- 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
- sqlAlterColumnType(String, String, String, SqlType, int, int, boolean, Object) - Method in class org.tentackle.sql.backends.Postgres
- 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
- 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 all. - sqlAsBeforeTableAlias() - Method in class org.tentackle.sql.backends.AbstractBackend
- SQLCode(String, int) - Constructor for record class org.tentackle.sql.DefaultScriptRunner.SQLCode
-
Creates an instance of a
SQLCode
record class. - sqlComment(String) - Method in interface org.tentackle.sql.Backend
-
Create comment sql code that is 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.H2
- 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.
- 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) - 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) - 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
- 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.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.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.H2
- 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.
- 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.Informix
- 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
- 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.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
-
Generate SQL-code for joining a table to 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
-
Generate SQL-code for joining a table to 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
-
SQL name type.
- 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.H2
- 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.
- 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.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.Db2
- 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
-
Generate 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.Oracle8
- 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.Db2
- sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.H2
- sqlTypeToString(SqlType, int) - Method in class org.tentackle.sql.backends.Informix
- 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.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
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.
- 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 meta instance.
- 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 an 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 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 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
- TYPE_BIGINT - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_BIT - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_BLOB - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_BOOL - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_BOOLEAN - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_BYTE - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_BYTEA - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_CHAR_1 - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_CLOB - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_DATE - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_DATETIME - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_DATETIME_YEAR_TO_SECOND - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_DECIMAL - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_DECIMAL_19 - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_DOUBLE - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_DOUBLE_PRECISION - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_FLOAT - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_FLOAT4 - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_FLOAT8 - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_INT - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_INT2 - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_INT4 - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_INT8 - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_INTEGER - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_NCHAR_1 - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_NUMBER - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_NUMBER_1 - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_NUMBER_10 - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_NUMBER_19 - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_NUMBER_5 - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_NVARCHAR - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_NVARCHAR_MAX - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_REAL - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_SMALLFLOAT - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_SMALLINT - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_TEXT - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_TIME - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_TIMESTAMP - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_TINYINT - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_UUID - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_VARBINARY_MAX - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_VARCHAR - Static variable in class org.tentackle.sql.backends.AbstractBackend
- TYPE_WARNING - Enum constant in enum class org.tentackle.sql.MigrationStrategy
U
- unload(Driver) - Static method in class org.tentackle.sql.DynamicDriver
-
Unloads the driver.
- 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.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.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(int, int) - 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(int, int) - Method in class org.tentackle.sql.backends.AbstractBackend
- validateVersion(int, int) - Method in class org.tentackle.sql.backends.Oracle
- 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.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.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.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.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.Oracle8
- VARCHAR - Enum constant in enum class org.tentackle.sql.SqlType
-
String.
W
- warnings() - Method in record class org.tentackle.sql.ScriptRunnerResult
-
Returns the value of the
warnings
record component.
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 an ZonedDateTime value.
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form