Constant Field Values

Contents

• org.sqlproc.*

org.sqlproc.*

org.sqlproc.engine.SqlEngineException

private static final long

serialVersionUID

3902062078303952832L

org.sqlproc.engine.SqlFeature

public static final String	DB2	"DB2"
public static final String	DB2_DEFAULT_IDSEL	"SELECT identity_val_local() FROM SYSIBM.DUAL"
public static final String	DB2_DEFAULT_LIMIT_FROM_TO	"select * from (select row_.*, rownumber() over() rownum_ from ($S) row_) where rownum_ <= $m and rownum_ > $F"
public static final String	DB2_DEFAULT_LIMIT_TO	"select * from (select row_.*, rownumber() over() rownum_ from ($S) row_) where rownum_ <= $m"
public static final String	DB2_DEFAULT_SEQ	"values nextval for $n"
public static final String	DEFAULT_LIKE_STRING	"like"
public static final String	DEFAULT_OPERATOR_ATTRIBUTE	"Op"
public static final String	DEFAULT_OPERATOR_ATTRIBUTE_IN_MAP	"operators"
public static final String	DEFAULT_SEQ_NAME	"SQLPROC_SEQUENCE"
public static final String	DEFAULT_VERSION_COLUMN	"version"
public static final String	DEFAULT_WILDCARD_CHARACTER	"%"
public static final String	EMPTY_FOR_NULL	"EMPTY_FOR_NULL"
public static final String	EMPTY_USE_METHOD_IS_NULL	"EMPTY_USE_METHOD_IS_NULL"
public static final String	HSQLDB	"HSQLDB"
public static final String	HSQLDB_DEFAULT_IDSEL	"call identity()"
public static final String	HSQLDB_DEFAULT_LIMIT_FROM_TO	"$S offset $F limit $M"
public static final String	HSQLDB_DEFAULT_LIMIT_FROM_TO_ORDERED	"$S offset $F limit $M using index"
public static final String	HSQLDB_DEFAULT_LIMIT_TO	"$S limit $M"
public static final String	HSQLDB_DEFAULT_LIMIT_TO_ORDERED	"$S limit $M using index"
public static final String	HSQLDB_DEFAULT_SEQ	"call next value for $n"
public static final String	ID	"ID"
public static final String	IDSEL	"IDSEL"
public static final String	IDSEL_JDBC	"JDBC"
public static final String	IGNORE_INPROPER_IN	"IGNORE_INPROPER_IN"
public static final String	IGNORE_INPROPER_OUT	"IGNORE_INPROPER_OUT"
public static final String	INFORMIX	"INFORMIX"
public static final String	INFORMIX_DEFAULT_IDSEL	"SELECT FIRST 1 dbinfo(\'bigserial\') FROM systables"
public static final String	INFORMIX_DEFAULT_LIMIT_FROM_TO	"select skip $F first $M $s"
public static final String	INFORMIX_DEFAULT_LIMIT_TO	"select first $M $s"
public static final String	INFORMIX_DEFAULT_SEQ	"SELECT FIRST 1 $n.NEXTVAL FROM systables"
public static final String	JDBC	"JDBC"
public static final String	LIKE_STRING	"LIKE_STRING"
public static final String	LIMIT_FROM_TO	"LIMIT_FROM_TO"
public static final String	LIMIT_FROM_TO_ORDERED	"LIMIT_FROM_TO_ORDERED"
public static final String	LIMIT_TO	"LIMIT_TO"
public static final String	LIMIT_TO_ORDERED	"LIMIT_TO_ORDERED"
public static final String	LOG_SQL_COMMAND_FOR_EXCEPTION	"LOG_SQL_COMMAND_FOR_EXCEPTION"
public static final String	METHODS_ENUM_IN	"METHODS_ENUM_IN"
public static final String	METHODS_ENUM_OUT	"METHODS_ENUM_OUT"
public static final String	MSSQL	"MSSQL"
public static final String	MSSQL_DEFAULT_IDSEL	"JDBC"
public static final String	MSSQL_DEFAULT_LIMIT_TO	"select top ($M) $s"
public static final String	MYSQL	"MYSQL"
public static final String	MYSQL_DEFAULT_IDSEL	"select last_insert_id()"
public static final String	MYSQL_DEFAULT_LIMIT_FROM_TO	"$S limit $F, $M"
public static final String	MYSQL_DEFAULT_LIMIT_TO	"$S limit $M"
public static final String	OPERATOR_ATTRIBUTE	"OPERATOR_ATTRIBUTE"
public static final String	OPERATOR_ATTRIBUTE_IN_MAP	"OPERATOR_ATTRIBUTE_IN_MAP"
public static final String	ORACLE	"ORACLE"
public static final String	ORACLE_DEFAULT_LIMIT_FROM_TO	"select * from ( select row_.*, rownum rownum_ from ($S) row_ where rownum <= $m) where rownum_ > $F"
public static final String	ORACLE_DEFAULT_LIMIT_TO	"select * from ($S) where rownum <= $m"
public static final String	ORACLE_DEFAULT_SEQ	"select $n.nextval from dual"
public static final String	POSTGRESQL	"POSTGRESQL"
public static final String	POSTGRESQL_DEFAULT_LIMIT_FROM_TO	"$S limit $M offset $F"
public static final String	POSTGRESQL_DEFAULT_LIMIT_TO	"$S limit $M"
public static final String	POSTGRESQL_DEFAULT_SEQ	"select nextval(\'$n\')"
public static final String	SEQ	"SEQ"
public static final String	SURROUND_QUERY_LIKE_FULL	"SURROUND_QUERY_LIKE_FULL"
public static final String	SURROUND_QUERY_LIKE_PARTIAL	"SURROUND_QUERY_LIKE_PARTIAL"
public static final String	SURROUND_QUERY_MIN_LEN	"SURROUND_QUERY_MIN_LEN"
public static final String	WILDCARD_CHARACTER	"WILDCARD_CHARACTER"

org.sqlproc.engine.SqlProcessorException

private static final long

serialVersionUID

-3445190167492657525L

org.sqlproc.engine.SqlRuntimeException

private static final long

serialVersionUID

-78058882111031689L

org.sqlproc.engine.impl.org.sqlproc.engine.impl.ParserUtils

static final String	SUPPVAL_DISCRIMINATOR_	"discr"
static final String	SUPPVAL_DTYPE_	"dtype="
static final String	SUPPVAL_GTYPE_	"gtype="
static final String	SUPPVAL_TYPE_	"type="

org.sqlproc.engine.impl.org.sqlproc.engine.impl.SqlMetaElement

public static final String	AND_PREFIX	"AND "
public static final char	CONST_PREFIX	36
public static final char	IDENT_PREFIX	58
public static final char	IDENT_SEPARATOR	95
public static final int	lCONST_PREFIX	1
public static final int	lIDENT_PREFIX	1
public static final String	OR_PREFIX	"OR "
public static final String	SET_PREFIX	"SET "
public static final String	VALUES_PREFIX	"VALUES"
public static final String	WHERE_PREFIX	"WHERE "

org.sqlproc.engine.plugin.Modifiers

public static final String	MODIFIER_ANY	"any"
public static final String	MODIFIER_ANYSET	"anyset"
public static final String	MODIFIER_CALL	"call"
public static final String	MODIFIER_DISCRIMINATOR	"discr"
public static final String	MODIFIER_EMPTY	"empty"
public static final String	MODIFIER_GTYPE	"gtype"
public static final String	MODIFIER_ID	"id"
public static final String	MODIFIER_IDENTITY_SELECT	"idsel"
public static final String	MODIFIER_NOTEMPTY	"notempty"
public static final String	MODIFIER_NOTNULL	"notnull"
public static final String	MODIFIER_NULL	"null"
public static final String	MODIFIER_SEQUENCE	"seq"
public static final String	MODIFIER_TYPE	"type"

org.sqlproc.engine.validation.SqlValidationException

private static final long

serialVersionUID

-37341245018301697L