SqlFeature (SQL Processor, Core Module 2.3.1 API)

```
public interface SqlFeature
```
The optional features are used to alter the behavior of the SQL Processor. They can be activated in the process of SQL Processor initialization.
The features can be incorporated into the meta statements file in the form of name(OPT)=...;.
For example the SQL Processor supports the special searching feature based on text fragments. Lets have a table PERSON with two columns - ID and NAME.
In the meta statements file statements.qry there's the next definition:
```
 LIKE_STRING(OPT)=like;
 WILDCARD_CHARACTER(OPT)=%;
 SURROUND_QUERY_LIKE_FULL(BOPT)=true;
 SURROUND_QUERY_MIN_LEN(IOPT)=2;
 
 LIKE_PEOPLE(QRY)=
   select p.ID @id, p.NAME @name
   from PERSON p
   {= where
    {& id=:id}
    {& UPPER(name) like :+name}
   }
   {#1 order by ID}
   {#2 order by NAME}
 ;
 
```
The special searching capability is activated with the key SURROUND_QUERY_LIKE(BOPT)=true. In this case every query with the like keyword (defined with the key LIKE_STRING) is identified and any dynamic input value, which belongs to this query condition, is handled in a special way. The value for this input value is surrounded with wild-card character %. This character is defined with the key WILDCARD_CHARACTER. In the runtime to activate this feature, the input value has to have the minimal length = 2. This minimal length is defined with the key SURROUND_QUERY_MIN_LEN. In the case of SQL Processor initialization
```
 JdbcEngineFactory sqlFactory = new JdbcEngineFactory();
 sqlFactory.setMetaFilesNames("statements.qry"); // the meta statements file
 SqlEngine sqlEngine = sqlFactory.getSqlEngine("LIKE_PEOPLE");
 
 // for the case it runs on the top of the JDBC stack
 Connection connection = DriverManager.getConnection("jdbc:hsqldb:mem:sqlproc", "sa", "");
 SqlSession session = new JdbcSimpleSession(connection);
 
```
there's created an instance of SqlEngine with the name LIKE_PEOPLE.
Next there's an instance person of the class Person with the value an for the attribute name. The invocation
```
 Person person = new Person();
 person.setName("jan");
 List<Person> list = sqlEngine.query(session, Person.class, person, SqlOrder.getDescOrder(2));
 
```
produces the next SQL execution
```
 select p.ID id, p.NAME name from PERSON p where UPPER(name) like ? order by NAME DESC
 
```
In the result list there are all table rows with name, which contains the text fragment jan.
For more info please see the Tutorials.
Author:

Vladimir Hudec

Field Summary

Fields
Modifier and Type	Field and Description
`static String`	`DB2` The filter for DB2 Server devoted optional features.
`static String`	`DB2_DEFAULT_IDSEL` /** `DB2_DEFAULT_IDSEL` is the default value related to the key `IDSEL` in the case the filter value `DB2` is used for the `SqlProcessorLoader` instance creation.
`static String`	`DB2_DEFAULT_LIMIT_FROM_TO` `DB2_DEFAULT_LIMIT_FROM_TO` is the default value related to the key `LIMIT_FROM_TO` in the case the filter value `DB2` is used for the `SqlProcessorLoader` instance creation.
`static String`	`DB2_DEFAULT_LIMIT_TO` `DB2_DEFAULT_LIMIT_TO` is the default value related to the key `LIMIT_TO` in the case the filter value `DB2` is used for the `SqlProcessorLoader` instance creation.
`static String`	`DB2_DEFAULT_SEQ` `DB2_DEFAULT_SEQ` is the default value related to the key `SEQ` in the case the filter value `DB2` is used for the `SqlProcessorLoader` instance creation.
`static String`	`DEFAULT_LIKE_STRING` This is the default value related to the key `LIKE_STRING`.
`static Boolean`	`DEFAULT_LOG_SQL_COMMAND_FOR_EXCEPTION` This is the default value related to the key `LOG_SQL_COMMAND_FOR_EXCEPTION` .
`static String[]`	`DEFAULT_METHODS_ENUM_IN` This is the default value related to the key `METHODS_ENUM_IN`.
`static String[]`	`DEFAULT_METHODS_ENUM_OUT` This is the default value related to the key `METHODS_ENUM_OUT`.
`static String`	`DEFAULT_OPERATOR_ATTRIBUTE` This is the default value related to the key `OPERATOR_ATTRIBUTE`.
`static String`	`DEFAULT_OPERATOR_ATTRIBUTE_IN_MAP` This is the default value related to the key `OPERATOR_ATTRIBUTE_IN_MAP`.
`static String`	`DEFAULT_SEQ_NAME` `DEFAULT_SEQ_NAME` is the default sequence name.
`static Boolean`	`DEFAULT_SURROUND_QUERY_LIKE_PARTIAL` This is the default value related to the key `SURROUND_QUERY_LIKE_PARTIAL` .
`static Integer`	`DEFAULT_SURROUND_QUERY_MIN_LEN` This is the default value related to the key `SURROUND_QUERY_MIN_LEN`.
`static String`	`DEFAULT_VERSION_COLUMN` `DEFAULT_VERSION_COLUMN` is the default name of the column devoted to the optimistic locking.
`static String`	`DEFAULT_WILDCARD_CHARACTER` This is the default value related to the key `WILDCARD_CHARACTER` .
`static String`	`EMPTY_FOR_NULL` `EMPTY_FOR_NULL` is indicator that the NULL values are always empty.
`static String`	`EMPTY_USE_METHOD_IS_NULL` `EMPTY_USE_METHOD_IS_NULL` is indicator that the non-emptiness depends the special isNull method.
`static String`	`HSQLDB` The filter for HSQLDB devoted optional features.
`static String`	`HSQLDB_DEFAULT_IDSEL` `HSQLDB_DEFAULT_IDSEL` is the default value related to the key `IDSEL` in the case the filter value `HSQLDB` is used for the `SqlProcessorLoader` instance creation.
`static String`	`HSQLDB_DEFAULT_LIMIT_FROM_TO` `HSQLDB_DEFAULT_LIMIT_FROM_TO` is the default value related to the key `LIMIT_FROM_TO` in the case the filter value `HSQLDB` is used for the `SqlProcessorLoader` instance creation.
`static String`	`HSQLDB_DEFAULT_LIMIT_FROM_TO_ORDERED` `HSQLDB_DEFAULT_LIMIT_FROM_TO_ORDERED` is the default value related to the key `LIMIT_FROM_TO_ORDERED` in the case the filter value `HSQLDB` is used for the `SqlProcessorLoader` instance creation.
`static String`	`HSQLDB_DEFAULT_LIMIT_TO` `HSQLDB_DEFAULT_LIMIT_TO` is the default value related to the key `LIMIT_TO` in the case the filter value `HSQLDB` is used for the `SqlProcessorLoader` instance creation.
`static String`	`HSQLDB_DEFAULT_LIMIT_TO_ORDERED` `HSQLDB_DEFAULT_LIMIT_TO_ORDERED` is the default value related to the key `LIMIT_TO_ORDERED` in the case the filter value `HSQLDB` is used for the `SqlProcessorLoader` instance creation.
`static String`	`HSQLDB_DEFAULT_SEQ` `HSQLDB_DEFAULT_SEQ` is the default value related to the key `SEQ` in the case the filter value `HSQLDB` is used for the `SqlProcessorLoader` instance creation.
`static String`	`ID` `ID` is the key for the identity columns.
`static String`	`IDSEL` `IDSEL` is the key for the SQL query pattern used to obtain the value of identities after the INSERT command.
`static String`	`IDSEL_JDBC` `IDSEL_JDBC` is the special value related to the key `IDSEL` indicating that the generated identity value is determined using JDBC capabilities to return generated keys for SQL statement.
`static String`	`IGNORE_INPROPER_IN` `IGNORE_INPROPER_IN` is the key for special handling of input/output values.
`static String`	`IGNORE_INPROPER_OUT` `IGNORE_INPROPER_OUT` is the key for special handling of input/output values.
`static String`	`INFORMIX` The filter for Informix devoted optional features.
`static String`	`INFORMIX_DEFAULT_IDSEL` `INFORMIX_DEFAULT_IDSEL` is the default value related to the key `IDSEL` in the case the filter value `INFORMIX` is used for the `SqlProcessorLoader` instance creation.
`static String`	`INFORMIX_DEFAULT_IDSEL_Integer` `INFORMIX_DEFAULT_IDSEL_Integer` is the default value related to the key `IDSEL` in the case the filter value `INFORMIX` is used for the `SqlProcessorLoader` instance creation.
`static String`	`INFORMIX_DEFAULT_IDSEL_Long` `INFORMIX_DEFAULT_IDSEL_Long` is the default value related to the key `IDSEL` in the case the filter value `INFORMIX` is used for the `SqlProcessorLoader` instance creation.
`static String`	`INFORMIX_DEFAULT_LIMIT_FROM_TO` `INFORMIX_DEFAULT_LIMIT_FROM_TO` is the default value related to the key `LIMIT_FROM_TO` in the case the filter value `INFORMIX` is used for the `SqlProcessorLoader` instance creation.
`static String`	`INFORMIX_DEFAULT_LIMIT_TO` `INFORMIX_DEFAULT_LIMIT_TO` is the default value related to the key `LIMIT_TO` in the case the filter value `INFORMIX` is used for the `SqlProcessorLoader` instance creation.
`static String`	`INFORMIX_DEFAULT_SEQ` `INFORMIX_DEFAULT_SEQ` is the default value related to the key `SEQ` in the case the filter value `INFORMIX` is used for the `SqlProcessorLoader` instance creation.
`static String`	`JDBC` `JDBC` is the key for the raw JDBC stack usage.
`static String`	`LIKE_STRING` `LIKE_STRING` is the key for the SQL command `like`.
`static String`	`LIMIT_FROM_TO` `LIMIT_FROM_TO` is the key for the SQL query pattern used to limit the query results.
`static String`	`LIMIT_FROM_TO_ORDERED` `LIMIT_FROM_TO_ORDERED` is the key for the SQL query pattern used to limit the query results in the case the query output is sorted.
`static String`	`LIMIT_TO` `LIMIT_TO` is the key for the SQL query pattern used to limit the query results.
`static String`	`LIMIT_TO_ORDERED` `LIMIT_TO_ORDERED` is the key for the SQL query pattern used to limit the query results in the case the query output is sorted.
`static String`	`LOG_SQL_COMMAND_FOR_EXCEPTION` `LOG_SQL_COMMAND_FOR_EXCEPTION` is the indicator that in the case of an SQLException the related SQL command should be logged.
`static String`	`METHODS_ENUM_IN` `METHODS_ENUM_IN` lists the methods used in the translation from a Java type to a JDBC datatype for enumerations based input values.
`static String`	`METHODS_ENUM_OUT` `METHODS_ENUM_OUT` lists the methods used in the translation from a JDBC datatype to a Java type for enumerations based output values.
`static String`	`MSSQL` The filter for MS SQL Server devoted optional features.
`static String`	`MSSQL_DEFAULT_IDSEL` `MSSQL_DEFAULT_IDSEL` is the default value related to the key `IDSEL` in the case the filter value `MSSQL` is used for the `SqlProcessorLoader` instance creation.
`static String`	`MSSQL_DEFAULT_LIMIT_FROM_TO` Version for MS SQL Server 2012: `MSSQL_DEFAULT_LIMIT_FROM_TO` is the default value related to the key `LIMIT_FROM_TO` in the case the filter value `MSSQL` is used for the `SqlProcessorLoader` instance creation.
`static String`	`MSSQL_DEFAULT_LIMIT_TO` `MSSQL_DEFAULT_LIMIT_TO` is the default value related to the key `LIMIT_TO` in the case the filter value `MSSQL` is used for the `SqlProcessorLoader` instance creation.
`static String`	`MYSQL` The filter for MySQL devoted optional features.
`static String`	`MYSQL_DEFAULT_IDSEL` `MYSQL_DEFAULT_IDSEL` is the default value related to the key `IDSEL` in the case the filter value `MYSQL` is used for the `SqlProcessorLoader` instance creation.
`static String`	`MYSQL_DEFAULT_LIMIT_FROM_TO` `MYSQL_DEFAULT_LIMIT_FROM_TO` is the default value related to the key `LIMIT_FROM_TO` in the case the filter value `MYSQL` is used for the `SqlProcessorLoader` instance creation.
`static String`	`MYSQL_DEFAULT_LIMIT_TO` `MYSQL_DEFAULT_LIMIT_TO` is the default value related to the key `LIMIT_TO` in the case the filter value `MYSQL` is used for the `SqlProcessorLoader` instance creation.
`static String`	`OPERATOR_ATTRIBUTE` `OPERATOR_ATTRIBUTE` is the operator atribute name suffix.
`static String`	`OPERATOR_ATTRIBUTE_IN_MAP` `OPERATOR_ATTRIBUTE_IN_MAP` is the map name of the operators name suffix.
`static String`	`ORACLE` The filter for Oracle devoted optional features.
`static String`	`ORACLE_DEFAULT_LIMIT_FROM_TO` `ORACLE_DEFAULT_LIMIT_FROM_TO` is the default value related to the key `LIMIT_FROM_TO` in the case the filter value `ORACLE` is used for the `SqlProcessorLoader` instance creation.
`static String`	`ORACLE_DEFAULT_LIMIT_TO` `ORACLE_DEFAULT_LIMIT_TO` is the default value related to the key `LIMIT_TO` in the case the filter value `ORACLE` is used for the `SqlProcessorLoader` instance creation.
`static String`	`ORACLE_DEFAULT_SEQ` `ORACLE_DEFAULT_SEQ` is the default value related to the key `SEQ` in the case the filter value `ORACLE` is used for the `SqlProcessorLoader` instance creation.
`static String`	`POSTGRESQL` The filter for PostgreSQL devoted optional features.
`static String`	`POSTGRESQL_DEFAULT_LIMIT_FROM_TO` `POSTGRESQL_DEFAULT_LIMIT_FROM_TO` is the default value related to the key `LIMIT_FROM_TO` in the case the filter value `POSTGRESQL` is used for the `SqlProcessorLoader` instance creation.
`static String`	`POSTGRESQL_DEFAULT_LIMIT_TO` `POSTGRESQL_DEFAULT_LIMIT_TO` is the default value related to the key `LIMIT_TO` in the case the filter value `POSTGRESQL` is used for the `SqlProcessorLoader` instance creation.
`static String`	`POSTGRESQL_DEFAULT_SEQ` `POSTGRESQL_DEFAULT_SEQ` is the default value related to the key `SEQ` in the case the filter value `POSTGRESQL` is used for the `SqlProcessorLoader` instance creation.
`static String`	`REPLACE_LIKE_CHARS` `REPLACE_LIKE_CHARS` is the key for the special SQL Processor behavior related to the SQL command `like`.
`static String`	`REPLACE_LIKE_STRING` `REPLACE_LIKE_STRING` is the key for the special SQL Processor behavior related to the SQL command `like`.
`static String`	`SEQ` `SEQ` is the key for the SQL query pattern used for the sequences.
`static String`	`SURROUND_QUERY_LIKE_FULL` `SURROUND_QUERY_LIKE` is the key for the special SQL Processor behavior.
`static String`	`SURROUND_QUERY_LIKE_PARTIAL` `SURROUND_QUERY_LIKE_PARTIAL` is the key for the special SQL Processor behavior.
`static String`	`SURROUND_QUERY_MIN_LEN` `SURROUND_QUERY_MIN_LEN` is the minimal length of the string input values for the SQL `like` command to switch on the SQL Processor special behavior described above in the runtime.
`static String`	`WILDCARD_CHARACTER` `WILDCARD_CHARACTER` is the key for the wildcard character for the SQL `like` command.

- Field Detail
  - ORACLE
```
static final String ORACLE
```
    The filter for Oracle devoted optional features. It can be used for the construction of SqlProcessorLoader.
    
    See Also:
    Constant Field Values
  - HSQLDB
```
static final String HSQLDB
```
    The filter for HSQLDB devoted optional features. It can be used for the construction of SqlProcessorLoader.
    
    See Also:
    Constant Field Values
  - MYSQL
```
static final String MYSQL
```
    The filter for MySQL devoted optional features. It can be used for the construction of SqlProcessorLoader .
    
    See Also:
    Constant Field Values
  - POSTGRESQL
```
static final String POSTGRESQL
```
    The filter for PostgreSQL devoted optional features. It can be used for the construction of SqlProcessorLoader .
    
    See Also:
    Constant Field Values
  - INFORMIX
```
static final String INFORMIX
```
    The filter for Informix devoted optional features. It can be used for the construction of SqlProcessorLoader .
    
    See Also:
    Constant Field Values
  - MSSQL
```
static final String MSSQL
```
    The filter for MS SQL Server devoted optional features. It can be used for the construction of SqlProcessorLoader.
    
    See Also:
    Constant Field Values
  - DB2
```
static final String DB2
```
    The filter for DB2 Server devoted optional features. It can be used for the construction of SqlProcessorLoader.
    
    See Also:
    Constant Field Values
  - WILDCARD_CHARACTER
```
static final String WILDCARD_CHARACTER
```
    WILDCARD_CHARACTER is the key for the wildcard character for the SQL like command.
    
    See Also:
    Constant Field Values
  - DEFAULT_WILDCARD_CHARACTER
```
static final String DEFAULT_WILDCARD_CHARACTER
```
    This is the default value related to the key WILDCARD_CHARACTER .
    
    See Also:
    Constant Field Values
  - SURROUND_QUERY_LIKE_FULL
```
static final String SURROUND_QUERY_LIKE_FULL
```
    SURROUND_QUERY_LIKE is the key for the special SQL Processor behavior. In the case the value of this property is true, the SQL Processor sets the wildcard character as a prefix and postfix for all string values related to the SQL command like. These string values should have to have the minimal length greater or equal to SURROUND_QUERY_MIN_LEN. The default value related to this key is false.
    
    See Also:
    Constant Field Values
  - SURROUND_QUERY_LIKE_PARTIAL
```
static final String SURROUND_QUERY_LIKE_PARTIAL
```
    SURROUND_QUERY_LIKE_PARTIAL is the key for the special SQL Processor behavior. In the case the value of this property is true, the SQL Processor sets the wildcard character as a postfix for all string values related to the SQL command like. These string values should have to have the minimal length greater or equal to SURROUND_QUERY_MIN_LEN. The default value related to this key is false.
    
    See Also:
    Constant Field Values
  - DEFAULT_SURROUND_QUERY_LIKE_PARTIAL
```
static final Boolean DEFAULT_SURROUND_QUERY_LIKE_PARTIAL
```
    This is the default value related to the key SURROUND_QUERY_LIKE_PARTIAL .
  - SURROUND_QUERY_MIN_LEN
```
static final String SURROUND_QUERY_MIN_LEN
```
    SURROUND_QUERY_MIN_LEN is the minimal length of the string input values for the SQL like command to switch on the SQL Processor special behavior described above in the runtime.
    
    See Also:
    Constant Field Values
  - DEFAULT_SURROUND_QUERY_MIN_LEN
```
static final Integer DEFAULT_SURROUND_QUERY_MIN_LEN
```
    This is the default value related to the key SURROUND_QUERY_MIN_LEN.
  - LIKE_STRING
```
static final String LIKE_STRING
```
    LIKE_STRING is the key for the SQL command like. For example for the Informix database it can be matches.
    
    See Also:
    Constant Field Values
  - DEFAULT_LIKE_STRING
```
static final String DEFAULT_LIKE_STRING
```
    This is the default value related to the key LIKE_STRING.
    
    See Also:
    Constant Field Values
  - REPLACE_LIKE_STRING
```
static final String REPLACE_LIKE_STRING
```
    REPLACE_LIKE_STRING is the key for the special SQL Processor behavior related to the SQL command like. The supplied value is going to be used as the final LIKE_STRING.
    
    See Also:
    Constant Field Values
  - REPLACE_LIKE_CHARS
```
static final String REPLACE_LIKE_CHARS
```
    REPLACE_LIKE_CHARS is the key for the special SQL Processor behavior related to the SQL command like. The feature pattern is ['c1':'r1', 'c2':'r2', ...], where c1,c2,... is a set of characters to be replaced with the characters r1,r2,.... For example to use the wildcard characters * and ? instead of % _, use ['*':'%', '?':'_'].
    
    See Also:
    Constant Field Values
  - METHODS_ENUM_IN
```
static final String METHODS_ENUM_IN
```
    METHODS_ENUM_IN lists the methods used in the translation from a Java type to a JDBC datatype for enumerations based input values.
    
    See Also:
    Constant Field Values
  - DEFAULT_METHODS_ENUM_IN
```
static final String[] DEFAULT_METHODS_ENUM_IN
```
    This is the default value related to the key METHODS_ENUM_IN. It is list of the next methods:
    - getCode
    - getValue
    - getName
    - name
  - METHODS_ENUM_OUT
```
static final String METHODS_ENUM_OUT
```
    METHODS_ENUM_OUT lists the methods used in the translation from a JDBC datatype to a Java type for enumerations based output values.
    
    See Also:
    Constant Field Values
  - DEFAULT_METHODS_ENUM_OUT
```
static final String[] DEFAULT_METHODS_ENUM_OUT
```
    This is the default value related to the key METHODS_ENUM_OUT. It is list of the next methods:
    - fromCode
    - fromValue
    - valueOf
  - ID
```
static final String ID
```
    ID is the key for the identity columns. In the case it's values is defined, all columns with this name are implicitly treated as an identifier.
    
    See Also:
    Constant Field Values
  - IGNORE_INPROPER_IN
```
static final String IGNORE_INPROPER_IN
```
    IGNORE_INPROPER_IN is the key for special handling of input/output values. In the case it's value is defined as true, in the case of any problems with input values the SqlRuntimeException is not thrown, only the related error is logged.
    
    See Also:
    Constant Field Values
  - IGNORE_INPROPER_OUT
```
static final String IGNORE_INPROPER_OUT
```
    IGNORE_INPROPER_OUT is the key for special handling of input/output values. In the case it's value is defined as true, in the case of any problems with output values the SqlRuntimeException is not thrown, only the related error is logged.
    
    See Also:
    Constant Field Values
  - JDBC
```
static final String JDBC
```
    JDBC is the key for the raw JDBC stack usage. In this SQL Processor version the next stacks can be used:
    - raw JDBC
    - Hibernate
    - Spring DAO
    The default value related to this key is false.
    See Also:
    Constant Field Values
  - LIMIT_FROM_TO
```
static final String LIMIT_FROM_TO
```
    LIMIT_FROM_TO is the key for the SQL query pattern used to limit the query results. This pattern has to be combined with the original SQL query, the limit and the offset in the next way:
    - $S is the full original query
    - $s is the original query without the token select
    - $F is 1-based from rowid (=offset)
    - $f is 0-based from rowid (offset)
    - $M is the max number of returned rows
    - $m is the max rowid of returned rows
    See Also:
    Constant Field Values
  - LIMIT_FROM_TO_ORDERED
```
static final String LIMIT_FROM_TO_ORDERED
```
    LIMIT_FROM_TO_ORDERED is the key for the SQL query pattern used to limit the query results in the case the query output is sorted. Right now it's used only for HSQLDB.
    
    See Also:
    Constant Field Values
  - LIMIT_TO
```
static final String LIMIT_TO
```
    LIMIT_TO is the key for the SQL query pattern used to limit the query results. This pattern has to be combined with the original SQL query and the limit in the next way:
    - $S is the full original query
    - $s is the original query without the token select
    - $F is 1-based from rowid (=offset)
    - $f is 0-based from rowid (offset)
    See Also:
    Constant Field Values
  - LIMIT_TO_ORDERED
```
static final String LIMIT_TO_ORDERED
```
    LIMIT_TO_ORDERED is the key for the SQL query pattern used to limit the query results in the case the query output is sorted. Right now it's used only for HSQLDB.
    
    See Also:
    Constant Field Values
  - HSQLDB_DEFAULT_LIMIT_FROM_TO
```
static final String HSQLDB_DEFAULT_LIMIT_FROM_TO
```
    HSQLDB_DEFAULT_LIMIT_FROM_TO is the default value related to the key LIMIT_FROM_TO in the case the filter value HSQLDB is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - HSQLDB_DEFAULT_LIMIT_FROM_TO_ORDERED
```
static final String HSQLDB_DEFAULT_LIMIT_FROM_TO_ORDERED
```
    HSQLDB_DEFAULT_LIMIT_FROM_TO_ORDERED is the default value related to the key LIMIT_FROM_TO_ORDERED in the case the filter value HSQLDB is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - HSQLDB_DEFAULT_LIMIT_TO
```
static final String HSQLDB_DEFAULT_LIMIT_TO
```
    HSQLDB_DEFAULT_LIMIT_TO is the default value related to the key LIMIT_TO in the case the filter value HSQLDB is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - HSQLDB_DEFAULT_LIMIT_TO_ORDERED
```
static final String HSQLDB_DEFAULT_LIMIT_TO_ORDERED
```
    HSQLDB_DEFAULT_LIMIT_TO_ORDERED is the default value related to the key LIMIT_TO_ORDERED in the case the filter value HSQLDB is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - ORACLE_DEFAULT_LIMIT_FROM_TO
```
static final String ORACLE_DEFAULT_LIMIT_FROM_TO
```
    ORACLE_DEFAULT_LIMIT_FROM_TO is the default value related to the key LIMIT_FROM_TO in the case the filter value ORACLE is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - ORACLE_DEFAULT_LIMIT_TO
```
static final String ORACLE_DEFAULT_LIMIT_TO
```
    ORACLE_DEFAULT_LIMIT_TO is the default value related to the key LIMIT_TO in the case the filter value ORACLE is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - MYSQL_DEFAULT_LIMIT_FROM_TO
```
static final String MYSQL_DEFAULT_LIMIT_FROM_TO
```
    MYSQL_DEFAULT_LIMIT_FROM_TO is the default value related to the key LIMIT_FROM_TO in the case the filter value MYSQL is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - MYSQL_DEFAULT_LIMIT_TO
```
static final String MYSQL_DEFAULT_LIMIT_TO
```
    MYSQL_DEFAULT_LIMIT_TO is the default value related to the key LIMIT_TO in the case the filter value MYSQL is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - POSTGRESQL_DEFAULT_LIMIT_FROM_TO
```
static final String POSTGRESQL_DEFAULT_LIMIT_FROM_TO
```
    POSTGRESQL_DEFAULT_LIMIT_FROM_TO is the default value related to the key LIMIT_FROM_TO in the case the filter value POSTGRESQL is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - POSTGRESQL_DEFAULT_LIMIT_TO
```
static final String POSTGRESQL_DEFAULT_LIMIT_TO
```
    POSTGRESQL_DEFAULT_LIMIT_TO is the default value related to the key LIMIT_TO in the case the filter value POSTGRESQL is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - INFORMIX_DEFAULT_LIMIT_FROM_TO
```
static final String INFORMIX_DEFAULT_LIMIT_FROM_TO
```
    INFORMIX_DEFAULT_LIMIT_FROM_TO is the default value related to the key LIMIT_FROM_TO in the case the filter value INFORMIX is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - INFORMIX_DEFAULT_LIMIT_TO
```
static final String INFORMIX_DEFAULT_LIMIT_TO
```
    INFORMIX_DEFAULT_LIMIT_TO is the default value related to the key LIMIT_TO in the case the filter value INFORMIX is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - MSSQL_DEFAULT_LIMIT_FROM_TO
```
static final String MSSQL_DEFAULT_LIMIT_FROM_TO
```
    Version for MS SQL Server 2012: MSSQL_DEFAULT_LIMIT_FROM_TO is the default value related to the key LIMIT_FROM_TO in the case the filter value MSSQL is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - MSSQL_DEFAULT_LIMIT_TO
```
static final String MSSQL_DEFAULT_LIMIT_TO
```
    MSSQL_DEFAULT_LIMIT_TO is the default value related to the key LIMIT_TO in the case the filter value MSSQL is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - DB2_DEFAULT_LIMIT_FROM_TO
```
static final String DB2_DEFAULT_LIMIT_FROM_TO
```
    DB2_DEFAULT_LIMIT_FROM_TO is the default value related to the key LIMIT_FROM_TO in the case the filter value DB2 is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - DB2_DEFAULT_LIMIT_TO
```
static final String DB2_DEFAULT_LIMIT_TO
```
    DB2_DEFAULT_LIMIT_TO is the default value related to the key LIMIT_TO in the case the filter value DB2 is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - SEQ
```
static final String SEQ
```
    SEQ is the key for the SQL query pattern used for the sequences. This pattern can be combined with the sequence name used in the META SQL query in the next way:
    - $n is the name of the sequence from the META SQL query
    See Also:
    Constant Field Values
  - HSQLDB_DEFAULT_SEQ
```
static final String HSQLDB_DEFAULT_SEQ
```
    HSQLDB_DEFAULT_SEQ is the default value related to the key SEQ in the case the filter value HSQLDB is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - ORACLE_DEFAULT_SEQ
```
static final String ORACLE_DEFAULT_SEQ
```
    ORACLE_DEFAULT_SEQ is the default value related to the key SEQ in the case the filter value ORACLE is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - POSTGRESQL_DEFAULT_SEQ
```
static final String POSTGRESQL_DEFAULT_SEQ
```
    POSTGRESQL_DEFAULT_SEQ is the default value related to the key SEQ in the case the filter value POSTGRESQL is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - INFORMIX_DEFAULT_SEQ
```
static final String INFORMIX_DEFAULT_SEQ
```
    INFORMIX_DEFAULT_SEQ is the default value related to the key SEQ in the case the filter value INFORMIX is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - DB2_DEFAULT_SEQ
```
static final String DB2_DEFAULT_SEQ
```
    DB2_DEFAULT_SEQ is the default value related to the key SEQ in the case the filter value DB2 is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - DEFAULT_SEQ_NAME
```
static final String DEFAULT_SEQ_NAME
```
    DEFAULT_SEQ_NAME is the default sequence name.
    
    See Also:
    Constant Field Values
  - IDSEL
```
static final String IDSEL
```
    IDSEL is the key for the SQL query pattern used to obtain the value of identities after the INSERT command.
    
    See Also:
    Constant Field Values
  - IDSEL_JDBC
```
static final String IDSEL_JDBC
```
    IDSEL_JDBC is the special value related to the key IDSEL indicating that the generated identity value is determined using JDBC capabilities to return generated keys for SQL statement. This feature requires that both the database and the JDBC driver support it.
    
    See Also:
    Constant Field Values
  - HSQLDB_DEFAULT_IDSEL
```
static final String HSQLDB_DEFAULT_IDSEL
```
    HSQLDB_DEFAULT_IDSEL is the default value related to the key IDSEL in the case the filter value HSQLDB is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - MYSQL_DEFAULT_IDSEL
```
static final String MYSQL_DEFAULT_IDSEL
```
    MYSQL_DEFAULT_IDSEL is the default value related to the key IDSEL in the case the filter value MYSQL is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - INFORMIX_DEFAULT_IDSEL
```
static final String INFORMIX_DEFAULT_IDSEL
```
    INFORMIX_DEFAULT_IDSEL is the default value related to the key IDSEL in the case the filter value INFORMIX is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - INFORMIX_DEFAULT_IDSEL_Long
```
static final String INFORMIX_DEFAULT_IDSEL_Long
```
    INFORMIX_DEFAULT_IDSEL_Long is the default value related to the key IDSEL in the case the filter value INFORMIX is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - INFORMIX_DEFAULT_IDSEL_Integer
```
static final String INFORMIX_DEFAULT_IDSEL_Integer
```
    INFORMIX_DEFAULT_IDSEL_Integer is the default value related to the key IDSEL in the case the filter value INFORMIX is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - MSSQL_DEFAULT_IDSEL
```
static final String MSSQL_DEFAULT_IDSEL
```
    MSSQL_DEFAULT_IDSEL is the default value related to the key IDSEL in the case the filter value MSSQL is used for the SqlProcessorLoader instance creation.
    The default value is IDSEL_JDBC.
    
    See Also:
    Constant Field Values
  - DB2_DEFAULT_IDSEL
```
static final String DB2_DEFAULT_IDSEL
```
    /** DB2_DEFAULT_IDSEL is the default value related to the key IDSEL in the case the filter value DB2 is used for the SqlProcessorLoader instance creation.
    
    See Also:
    Constant Field Values
  - DEFAULT_VERSION_COLUMN
```
static final String DEFAULT_VERSION_COLUMN
```
    DEFAULT_VERSION_COLUMN is the default name of the column devoted to the optimistic locking.
    
    See Also:
    Constant Field Values
  - EMPTY_FOR_NULL
```
static final String EMPTY_FOR_NULL
```
    EMPTY_FOR_NULL is indicator that the NULL values are always empty. It has meaning for the UPDATE statements, where the standard handling is to treat any values as not empty.
    
    See Also:
    Constant Field Values
  - EMPTY_USE_METHOD_IS_NULL
```
static final String EMPTY_USE_METHOD_IS_NULL
```
    EMPTY_USE_METHOD_IS_NULL is indicator that the non-emptiness depends the special isNull method. It has meaning for the UPDATE statements, where the standard handling is to treat any values as not empty.
    
    See Also:
    Constant Field Values
  - OPERATOR_ATTRIBUTE
```
static final String OPERATOR_ATTRIBUTE
```
    OPERATOR_ATTRIBUTE is the operator atribute name suffix.
    
    See Also:
    Constant Field Values
  - DEFAULT_OPERATOR_ATTRIBUTE
```
static final String DEFAULT_OPERATOR_ATTRIBUTE
```
    This is the default value related to the key OPERATOR_ATTRIBUTE.
    
    See Also:
    Constant Field Values
  - OPERATOR_ATTRIBUTE_IN_MAP
```
static final String OPERATOR_ATTRIBUTE_IN_MAP
```
    OPERATOR_ATTRIBUTE_IN_MAP is the map name of the operators name suffix.
    
    See Also:
    Constant Field Values
  - DEFAULT_OPERATOR_ATTRIBUTE_IN_MAP
```
static final String DEFAULT_OPERATOR_ATTRIBUTE_IN_MAP
```
    This is the default value related to the key OPERATOR_ATTRIBUTE_IN_MAP.
    
    See Also:
    Constant Field Values
  - LOG_SQL_COMMAND_FOR_EXCEPTION
```
static final String LOG_SQL_COMMAND_FOR_EXCEPTION
```
    LOG_SQL_COMMAND_FOR_EXCEPTION is the indicator that in the case of an SQLException the related SQL command should be logged.
    
    See Also:
    Constant Field Values
  - DEFAULT_LOG_SQL_COMMAND_FOR_EXCEPTION
```
static final Boolean DEFAULT_LOG_SQL_COMMAND_FOR_EXCEPTION
```
    This is the default value related to the key LOG_SQL_COMMAND_FOR_EXCEPTION .

Interface SqlFeature

Field Summary

Field Detail

ORACLE

HSQLDB

MYSQL

POSTGRESQL

INFORMIX

MSSQL

DB2

WILDCARD_CHARACTER

DEFAULT_WILDCARD_CHARACTER

SURROUND_QUERY_LIKE_FULL

SURROUND_QUERY_LIKE_PARTIAL

DEFAULT_SURROUND_QUERY_LIKE_PARTIAL

SURROUND_QUERY_MIN_LEN

DEFAULT_SURROUND_QUERY_MIN_LEN

LIKE_STRING

DEFAULT_LIKE_STRING

REPLACE_LIKE_STRING

REPLACE_LIKE_CHARS

METHODS_ENUM_IN

DEFAULT_METHODS_ENUM_IN

METHODS_ENUM_OUT

DEFAULT_METHODS_ENUM_OUT

ID

IGNORE_INPROPER_IN

IGNORE_INPROPER_OUT

JDBC

LIMIT_FROM_TO

LIMIT_FROM_TO_ORDERED

LIMIT_TO

LIMIT_TO_ORDERED

HSQLDB_DEFAULT_LIMIT_FROM_TO

HSQLDB_DEFAULT_LIMIT_FROM_TO_ORDERED

HSQLDB_DEFAULT_LIMIT_TO

HSQLDB_DEFAULT_LIMIT_TO_ORDERED

ORACLE_DEFAULT_LIMIT_FROM_TO

ORACLE_DEFAULT_LIMIT_TO

MYSQL_DEFAULT_LIMIT_FROM_TO

MYSQL_DEFAULT_LIMIT_TO

POSTGRESQL_DEFAULT_LIMIT_FROM_TO

POSTGRESQL_DEFAULT_LIMIT_TO

INFORMIX_DEFAULT_LIMIT_FROM_TO

INFORMIX_DEFAULT_LIMIT_TO

MSSQL_DEFAULT_LIMIT_FROM_TO

MSSQL_DEFAULT_LIMIT_TO

DB2_DEFAULT_LIMIT_FROM_TO

DB2_DEFAULT_LIMIT_TO

SEQ

HSQLDB_DEFAULT_SEQ

ORACLE_DEFAULT_SEQ

POSTGRESQL_DEFAULT_SEQ

INFORMIX_DEFAULT_SEQ

DB2_DEFAULT_SEQ

DEFAULT_SEQ_NAME

IDSEL

IDSEL_JDBC

HSQLDB_DEFAULT_IDSEL

MYSQL_DEFAULT_IDSEL

INFORMIX_DEFAULT_IDSEL

INFORMIX_DEFAULT_IDSEL_Long

INFORMIX_DEFAULT_IDSEL_Integer

MSSQL_DEFAULT_IDSEL

DB2_DEFAULT_IDSEL

DEFAULT_VERSION_COLUMN

EMPTY_FOR_NULL

EMPTY_USE_METHOD_IS_NULL

OPERATOR_ATTRIBUTE

DEFAULT_OPERATOR_ATTRIBUTE

OPERATOR_ATTRIBUTE_IN_MAP

DEFAULT_OPERATOR_ATTRIBUTE_IN_MAP

LOG_SQL_COMMAND_FOR_EXCEPTION

DEFAULT_LOG_SQL_COMMAND_FOR_EXCEPTION