DbmsFeatures (CUBA 7.2 API)

All Known Implementing Classes:

HsqlDbmsFeatures, MssqlDbmsFeatures, MysqlDbmsFeatures, OracleDbmsFeatures, PostgresDbmsFeatures
```
public interface DbmsFeatures
```
Interface defining methods of getting some DBMS-specific values. It must be implemented for each supported DBMS type and version.

See Also:

DbmsSpecificFactory

Method Summary

All Methods Instance Methods Abstract Methods Default Methods
Modifier and Type	Method and Description
`default boolean`	`emulateEqualsByLike()`
`java.lang.String`	`getDeleteTsColumn()`
`java.lang.String`	`getIdColumn()`
`java.util.Map<java.lang.String,java.lang.String>`	`getJpaParameters()`
`default java.lang.Integer`	`getMaxIdsBatchSize()`
`java.lang.String`	`getTimeStampType()`
`java.lang.String`	`getTransactionTimeoutStatement()`
`java.lang.String`	`getUniqueConstraintViolationPattern()`
`java.lang.String`	`getUuidTypeClassName()`
`boolean`	`isNullsLastSorting()`
`default boolean`	`isRequiresDbCatalogName()`
`boolean`	`isSchemaByUser()`
`boolean`	`supportsLobSortingAndFiltering()`
`default boolean`	`useOrderByForPaging()`

- Method Detail
  - getJpaParameters
```
java.util.Map<java.lang.String,java.lang.String> getJpaParameters()
```
    Returns:
    
    JPA implementation properties to set in persistence.xml
  - getIdColumn
```
java.lang.String getIdColumn()
```
    Returns:
    
    primary key column name
  - getDeleteTsColumn
```
java.lang.String getDeleteTsColumn()
```
    Returns:
    
    soft deletion column name
  - getTimeStampType
```
java.lang.String getTimeStampType()
```
    Returns:
    
    name of data type storing date and time
  - getUuidTypeClassName
```
@Nullable
java.lang.String getUuidTypeClassName()
```
    Returns:
    
    name of class representing UUID in JDBC driver, or null if no special class required
  - getTransactionTimeoutStatement
```
@Nullable
java.lang.String getTransactionTimeoutStatement()
```
    Returns:
    
    statement to issue for setting the current transaction timeout, or null if not required.
    The statement text should contain %d placeholder that will be replaced by timeout value in milliseconds.
  - getUniqueConstraintViolationPattern
```
java.lang.String getUniqueConstraintViolationPattern()
```
    Returns:
    
    regexp to extract a unique constraint name from an exception message
  - isNullsLastSorting
```
boolean isNullsLastSorting()
```
    Returns:
    
    default sort order of null values
  - isSchemaByUser
```
boolean isSchemaByUser()
```
    Returns:
    
    true if user name must be used when providing schema name for obtaining database metadata
  - isRequiresDbCatalogName
```
default boolean isRequiresDbCatalogName()
```
    Returns:
    
    true if catalog name must be used for obtaining database metadata
  - supportsLobSortingAndFiltering
```
boolean supportsLobSortingAndFiltering()
```
    Returns:
    
    true if the DBMS supports equals conditions in the filter and sort for LOB columns
  - emulateEqualsByLike
```
default boolean emulateEqualsByLike()
```
    Returns:
    
    true if equals for string properties in the property conditions of filter should be emulated by like expressions
  - useOrderByForPaging
```
default boolean useOrderByForPaging()
```
    Returns:
    
    true if the DBMS supports paging only with order by
  - getMaxIdsBatchSize
```
default java.lang.Integer getMaxIdsBatchSize()
```
    Returns:
    
    maximum number of values that can be used in the "IN" operator in a query. null is returned if there is no any limit

Interface DbmsFeatures

Method Summary

Method Detail

getJpaParameters

getIdColumn

getDeleteTsColumn

getTimeStampType

getUuidTypeClassName

getTransactionTimeoutStatement

getUniqueConstraintViolationPattern

isNullsLastSorting

isSchemaByUser

isRequiresDbCatalogName

supportsLobSortingAndFiltering

emulateEqualsByLike

useOrderByForPaging

getMaxIdsBatchSize