Constant Field Values

org.tentackle.*

org.tentackle.sql.Backend

Modifier and Type	Constant Field	Value
public static final String	SQL_ALLSTAR	"*"
public static final String	SQL_ALTER_COLUMN	" ALTER COLUMN "
public static final String	SQL_ALTER_INDEX	"ALTER INDEX "
public static final String	SQL_ALTER_TABLE	"ALTER TABLE "
public static final String	SQL_AND	" AND "
public static final String	SQL_ANDNOT	" AND NOT "
public static final String	SQL_ARRAY_ALL	"ALL"
public static final String	SQL_ARRAY_ALL_PAR	"ALL(?)"
public static final String	SQL_ARRAY_ANY	"ANY"
public static final String	SQL_ARRAY_ANY_PAR	"ANY(?)"
public static final String	SQL_ARRAY_IN	"IN"
public static final String	SQL_ARRAY_IN_PAR	" IN(?)"
public static final String	SQL_ARRAY_NOT_IN	"NOT IN"
public static final String	SQL_ARRAY_NOT_IN_PAR	" NOT IN(?)"
public static final String	SQL_ARRAY_PAR	"(?)"
public static final String	SQL_COMMA	","
public static final String	SQL_COMMA_PAR	",?"
public static final String	SQL_DELETE	"DELETE "
public static final String	SQL_DELETE_FROM	"DELETE FROM "
public static final String	SQL_DOT_STAR	".*"
public static final String	SQL_EQUAL	"="
public static final String	SQL_EQUAL_PAR	"=?"
public static final String	SQL_EQUAL_PAR_COMMA	"=?,"
public static final String	SQL_EQUAL_ZERO	"=0"
public static final String	SQL_EXISTS	"EXISTS (SELECT 1 FROM "
public static final String	SQL_FROM	" FROM "
public static final String	SQL_GREATER	">"
public static final String	SQL_GREATER_PAR	">?"
public static final String	SQL_GREATEROREQUAL	">="
public static final String	SQL_GREATEROREQUAL_PAR	">=?"
public static final String	SQL_GROUPBY	" GROUP BY "
public static final String	SQL_IF_EXISTS	"IF EXISTS "
public static final String	SQL_INSERT_INTO	"INSERT INTO "
public static final String	SQL_INSERT_VALUES	") VALUES ("
public static final String	SQL_ISNOTNULL	" IS NOT NULL"
public static final String	SQL_ISNULL	" IS NULL"
public static final String	SQL_LEFT_PARENTHESIS	" ("
public static final String	SQL_LESS	"<"
public static final String	SQL_LESS_PAR	"<?"
public static final String	SQL_LESSOREQUAL	"<="
public static final String	SQL_LESSOREQUAL_PAR	"<=?"
public static final String	SQL_LIKE	" LIKE "
public static final String	SQL_LIKE_PAR	" LIKE ?"
public static final String	SQL_MAX	"MAX"
public static final String	SQL_MIN	"MIN"
public static final String	SQL_NOT	"NOT "
public static final String	SQL_NOTEQUAL	"<>"
public static final String	SQL_NOTEQUAL_PAR	"<>?"
public static final String	SQL_NOTEQUAL_ZERO	"<>0"
public static final String	SQL_NOTLIKE	" NOT LIKE "
public static final String	SQL_NOTLIKE_PAR	" NOT LIKE ?"
public static final String	SQL_OR	" OR "
public static final String	SQL_ORDERBY	" ORDER BY "
public static final String	SQL_ORNOT	" OR NOT "
public static final String	SQL_PAR	"?"
public static final String	SQL_PAR_COMMA	"?,"
public static final String	SQL_PLUS_ONE	"+1"
public static final String	SQL_RIGHT_PARENTHESIS	") "
public static final String	SQL_SELECT	"SELECT "
public static final String	SQL_SELECT_ALL_FROM	"SELECT * FROM "
public static final String	SQL_SET	" SET "
public static final String	SQL_SORTASC	" ASC"
public static final String	SQL_SORTDESC	" DESC"
public static final String	SQL_UPDATE	"UPDATE "
public static final String	SQL_WHERE	" WHERE "
public static final String	SQL_WHEREALL	" WHERE 1=1"
public static final String	SQL_WHEREAND	" WHERE 1=1 AND "
public static final String	SQL_WHERENOTHING	" WHERE 1=0"
public static final String	SQL_WHEREOR	" WHERE 1=1 OR "

org.tentackle.sql.backends.AbstractBackend

Modifier and Type	Constant Field	Value
protected static final String	TYPE_BIGINT	"BIGINT"
protected static final String	TYPE_BIT	"BIT"
protected static final String	TYPE_BLOB	"BLOB"
protected static final String	TYPE_BOOL	"BOOL"
protected static final String	TYPE_BOOLEAN	"BOOLEAN"
protected static final String	TYPE_BYTE	"BYTE"
protected static final String	TYPE_BYTEA	"BYTEA"
protected static final String	TYPE_CHAR_1	"CHAR(1)"
protected static final String	TYPE_CLOB	"CLOB"
protected static final String	TYPE_DATE	"DATE"
protected static final String	TYPE_DATETIME	"DATETIME"
protected static final String	TYPE_DATETIME_6	"DATETIME(6)"
protected static final String	TYPE_DATETIME_YEAR_TO_SECOND	"DATETIME YEAR TO SECOND"
protected static final String	TYPE_DECIMAL	"DECIMAL"
protected static final String	TYPE_DECIMAL_19	"DECIMAL(19)"
protected static final String	TYPE_DOUBLE	"DOUBLE"
protected static final String	TYPE_DOUBLE_PRECISION	"DOUBLE PRECISION"
protected static final String	TYPE_FLOAT	"FLOAT"
protected static final String	TYPE_FLOAT4	"FLOAT4"
protected static final String	TYPE_FLOAT8	"FLOAT8"
protected static final String	TYPE_INT	"INT"
protected static final String	TYPE_INT2	"INT2"
protected static final String	TYPE_INT4	"INT4"
protected static final String	TYPE_INT8	"INT8"
protected static final String	TYPE_INTEGER	"INTEGER"
protected static final String	TYPE_JSON	"JSON"
protected static final String	TYPE_JSONB	"JSONB"
protected static final String	TYPE_LONGBLOB	"LONGBLOB"
protected static final String	TYPE_LONGTEXT	"LONGTEXT"
protected static final String	TYPE_NCHAR_1	"NCHAR(1)"
protected static final String	TYPE_NUMBER	"NUMBER"
protected static final String	TYPE_NUMBER_1	"NUMBER(1)"
protected static final String	TYPE_NUMBER_10	"NUMBER(10)"
protected static final String	TYPE_NUMBER_19	"NUMBER(19)"
protected static final String	TYPE_NUMBER_5	"NUMBER(5)"
protected static final String	TYPE_NVARCHAR	"NVARCHAR"
protected static final String	TYPE_NVARCHAR_MAX	"NVARCHAR(MAX)"
protected static final String	TYPE_REAL	"REAL"
protected static final String	TYPE_SMALLFLOAT	"SMALLFLOAT"
protected static final String	TYPE_SMALLINT	"SMALLINT"
protected static final String	TYPE_TEXT	"TEXT"
protected static final String	TYPE_TIME	"TIME"
protected static final String	TYPE_TIME_6	"TIME(6)"
protected static final String	TYPE_TIMESTAMP	"TIMESTAMP"
protected static final String	TYPE_TINYINT	"TINYINT"
protected static final String	TYPE_UUID	"UUID"
protected static final String	TYPE_VARBINARY_MAX	"VARBINARY(MAX)"
protected static final String	TYPE_VARCHAR	"VARCHAR"
protected static final String	TYPE_XML	"XML"
protected static final String	TYPE_XMLTYPE	"XMLTYPE"

org.tentackle.sql.backends.AbstractSql2003Backend

Modifier and Type	Constant Field	Value
public static final String	SQL_WINDOW_1	"* FROM (SELECT F_O_O.*, ROW_NUMBER() OVER() AS R_O_W FROM (SELECT "
public static final String	SQL_WINDOW_2	") AS F_O_O) AS B_A_R WHERE "
public static final String	SQL_WINDOW_LIMIT	"R_O_W <= ?"
public static final String	SQL_WINDOW_OFFSET	"R_O_W > ?"

org.tentackle.sql.backends.AbstractSql2008Backend

Modifier and Type	Constant Field	Value
public static final String	SQL_FETCH_FIRST	" FETCH FIRST ? ROWS ONLY"
public static final String	SQL_OFFSET	" OFFSET ? ROWS"

org.tentackle.sql.backends.AbstractSql92Backend

Modifier and Type	Constant Field	Value
public static final String	SQL_COALESCE	"COALESCE"
public static final String	SQL_FOR_UPDATE	" FOR UPDATE"

org.tentackle.sql.backends.Firebird

Modifier and Type	Constant Field	Value
public static final String	SQL_WITH_LOCK	" WITH LOCK"

org.tentackle.sql.backends.H2

Modifier and Type	Constant Field	Value
public static final String	DEFAULT_SCHEMA	"public"
public static final String	SQL_FETCH_FIRST	" FETCH FIRST "
public static final String	SQL_FETCH_FIRST_PAR	" FETCH FIRST ? ROWS ONLY"
public static final String	SQL_OFFSET	" OFFSET "
public static final String	SQL_OFFSET_PAR	" OFFSET ? ROWS"

org.tentackle.sql.backends.Hana

Modifier and Type	Constant Field	Value
public static final int	MAX_LIMIT	2147483647
public static final String	SQL_LIMIT	" LIMIT "
public static final String	SQL_LIMIT_PAR	" LIMIT ?"
public static final String	SQL_OFFSET	" OFFSET "
public static final String	SQL_OFFSET_PAR	" OFFSET ?"

org.tentackle.sql.backends.Informix

Modifier and Type	Constant Field	Value
public static final String	SQL_FIRST	"FIRST "
public static final String	SQL_FIRST_PAR	"FIRST ? "
public static final String	SQL_NVL	"NVL"
public static final String	SQL_SKIP	"SKIP "
public static final String	SQL_SKIP_PAR	"SKIP ? "

org.tentackle.sql.backends.MsSql

Modifier and Type	Constant Field	Value
public static final String	SQL_TOP	"TOP "
public static final String	SQL_TOP_PAR	"TOP ? "

org.tentackle.sql.backends.MySql

Modifier and Type	Constant Field	Value
public static final int	MAX_LIMIT	2147483647
public static final String	SQL_LIMIT	" LIMIT "
public static final String	SQL_LIMIT_PAR	" LIMIT ?"
public static final String	SQL_OFFSET	" OFFSET "
public static final String	SQL_OFFSET_PAR	" OFFSET ?"

org.tentackle.sql.backends.Oracle8

Modifier and Type	Constant Field	Value
public static final String	SQL_NESTED_SELECT_1	"/*+ FIRST_ROWS */ * FROM (SELECT F_O_O.*, ROWNUM AS R_O_W FROM (SELECT "
public static final String	SQL_NESTED_SELECT_2	") F_O_O) WHERE "
public static final String	SQL_NESTED_SELECT_LIMIT	"R_O_W<=?"
public static final String	SQL_NESTED_SELECT_OFFSET	"R_O_W>?"
public static final String	SQL_NESTED_SELECT_ROWNUM	"ROWNUM"
public static final String	SQL_NESTED_SELECT_ROWNUM_ALIAS	"R_O_W"

org.tentackle.sql.backends.Postgres

Modifier and Type	Constant Field	Value
public static final String	DEFAULT_SCHEMA	"public"
public static final String	SQL_LIMIT	" LIMIT "
public static final String	SQL_LIMIT_PAR	" LIMIT ?"
public static final String	SQL_OFFSET	" OFFSET "
public static final String	SQL_OFFSET_PAR	" OFFSET ?"

org.tentackle.sql.datatypes.ByteArrayType

Modifier and Type	Constant Field	Value
public static final String	JAVA_TYPE	"byte[]"

org.tentackle.sql.datatypes.ConvertibleType

Modifier and Type	Constant Field	Value
public static final String	TYPE	"implementing Convertible"

org.tentackle.sql.datatypes.JsonType

Modifier and Type	Constant Field	Value
public static final String	VARIANT	"Json"

org.tentackle.sql.datatypes.LargeStringType

Modifier and Type	Constant Field	Value
public static final String	VARIANT	"LargeString"

org.tentackle.sql.datatypes.XMLType

Modifier and Type	Constant Field	Value
public static final String	VARIANT	"Sqlxml"

org.tentackle.sql.datatypes.ZonedDateTimeType

Modifier and Type	Constant Field	Value
public static final String	GMT	"GMT"