MsSqlServerDbmsSupport (Ibis AdapterFramework parent 7.9-20230322.102910 API)

java.lang.Object
- nl.nn.adapterframework.jdbc.dbms.GenericDbmsSupport
- - nl.nn.adapterframework.jdbc.dbms.MsSqlServerDbmsSupport

All Implemented Interfaces:: IDbmsSupport

public class MsSqlServerDbmsSupport
extends GenericDbmsSupport

Author:: Gerrit van Brakel

Field Summary

Fields
Modifier and Type	Field and Description
`protected static String`	`CURRENT_TIMESTAMP`
`protected static String`	`DEFAULT_BLOB_VALUE`
`protected static String`	`GET_DATE`
`protected static String`	`NEXT_VALUE_FOR`
`protected static String`	`SELECT_CURRENT_VALUE`
`protected static String`	`WITH_UPDLOCK_ROWLOCK`

Fields inherited from class nl.nn.adapterframework.jdbc.dbms.GenericDbmsSupport
KEYWORD_SELECT, log, sqlTranslators, TYPE_BLOB, TYPE_CLOB, TYPE_FUNCTION

Constructor Summary

Constructors
Constructor and Description

MsSqlServerDbmsSupport()

Constructors
Constructor and Description
`MsSqlServerDbmsSupport()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`boolean`	`autoIncrementKeyMustBeInserted()`
`String`	`emptyBlobValue()`
`String`	`getAutoIncrementKeyFieldType()`
`String`	`getBlobFieldType()`
`String`	`getBooleanFieldType()`
`String`	`getBooleanValue(boolean value)`
`String`	`getCleanUpIbisstoreQuery(String tableName, String keyField, String typeField, String expiryDateField, int maxRows)`
`String`	`getClobFieldType()`
`String`	`getDateAndOffset(String dateValue, int daysOffset)`
`String`	`getDatetimeLiteral(Date date)`
`Dbms`	`getDbms()` Numeric value defining database type, defined in `DbmsSupportFactory`.
`String`	`getFirstRecordQuery(String tableName)`
`String`	`getInsertedAutoIncrementValueQuery(String sequenceName)`
`String`	`getLength(String column)`
`String`	`getNumericKeyFieldType()`
`String`	`getRowNumber(String order, String sort)`
`String`	`getRowNumberShortName()`
`String`	`getSchema(Connection conn)`
`String`	`getSysDate()` SQL String returning current date and time of dbms.
`String`	`getTextFieldType()`
`String`	`getTimestampAsDate(String columnName)`
`String`	`getTimestampFieldType()`
`boolean`	`hasIndexOnColumns(Connection conn, String schemaOwner, String tableName, List<String> columns)`
`boolean`	`hasSkipLockedFunctionality()`
`boolean`	`isClobType(ResultSetMetaData rsmeta, int colNum)`
`boolean`	`isIndexPresent(Connection conn, String schemaOwner, String tableName, String indexName)`
`boolean`	`isSequencePresent(Connection conn, String schemaOwner, String tableName, String sequenceName)`
`String`	`prepareQueryTextForNonLockingRead(String selectQuery)` Modify the provided selectQuery in such a way that the resulting query will not be blocked by locks, and will avoid placing locks itself as much as possible.
`String`	`prepareQueryTextForWorkQueuePeeking(int batchSize, String selectQuery, int wait)`
`String`	`prepareQueryTextForWorkQueueReading(int batchSize, String selectQuery, int wait)`
`String`	`provideTrailingFirstRowsHint(int rowCount)`

Methods inherited from class nl.nn.adapterframework.jdbc.dbms.GenericDbmsSupport
applyBlobParameter, applyClobParameter, autoIncrementInsertValue, autoIncrementUsesSequenceObject, convertQuery, createTranslator, doHasIndexOnColumns, doIsColumnPresent, doIsTablePresent, emptyClobValue, getBlobHandle, getBlobHandle, getBlobHandle, getBlobInputStream, getBlobInputStream, getBlobOutputStream, getBlobOutputStream, getBlobOutputStream, getBlobOutputStream, getClobHandle, getClobHandle, getClobHandle, getClobReader, getClobReader, getClobWriter, getClobWriter, getClobWriter, getDbmsName, getFromForTablelessSelect, getIbisStoreSummaryQuery, getSchemaOwner, getTableColumns, getTableColumns, getTableColumns, getUpdateBlobQuery, getUpdateClobQuery, hasIndexOnColumn, isBlobType, isColumnPresent, isColumnPresent, isConstraintViolation, isParameterTypeMatchRequired, isQueryConversionRequired, isTablePresent, isTablePresent, mustInsertEmptyBlobBeforeData, mustInsertEmptyClobBeforeData, prepareQueryTextForWorkQueuePeeking, prepareQueryTextForWorkQueueReading, prepareSessionForNonLockingRead, provideFirstRowsHintAfterFirstKeyword, provideIndexHintAfterFirstKeyword, splitQuery, updateBlob, updateBlob, updateClob, updateClob, warnConvertQuery

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - NEXT_VALUE_FOR
```
protected static final String NEXT_VALUE_FOR
```
    See Also:
    
    Constant Field Values
  - SELECT_CURRENT_VALUE
```
protected static final String SELECT_CURRENT_VALUE
```
    See Also:
    
    Constant Field Values
  - DEFAULT_BLOB_VALUE
```
protected static final String DEFAULT_BLOB_VALUE
```
    See Also:
    
    Constant Field Values
  - WITH_UPDLOCK_ROWLOCK
```
protected static final String WITH_UPDLOCK_ROWLOCK
```
    See Also:
    
    Constant Field Values
  - GET_DATE
```
protected static final String GET_DATE
```
    See Also:
    
    Constant Field Values
  - CURRENT_TIMESTAMP
```
protected static final String CURRENT_TIMESTAMP
```
    See Also:
    
    Constant Field Values
- Constructor Detail
  - MsSqlServerDbmsSupport
```
public MsSqlServerDbmsSupport()
```
- Method Detail
  - getDbms
```
public Dbms getDbms()
```
    Description copied from interface: IDbmsSupport
    
    Numeric value defining database type, defined in DbmsSupportFactory.
    
    Specified by:
    
    getDbms in interface IDbmsSupport
    
    Overrides:
    
    getDbms in class GenericDbmsSupport
  - hasSkipLockedFunctionality
```
public boolean hasSkipLockedFunctionality()
```
    Specified by:
    
    hasSkipLockedFunctionality in interface IDbmsSupport
    
    Overrides:
    
    hasSkipLockedFunctionality in class GenericDbmsSupport
  - getSysDate
```
public String getSysDate()
```
    Description copied from interface: IDbmsSupport
    
    SQL String returning current date and time of dbms.
    
    Specified by:
    
    getSysDate in interface IDbmsSupport
    
    Overrides:
    
    getSysDate in class GenericDbmsSupport
  - getDateAndOffset
```
public String getDateAndOffset(String dateValue,
                               int daysOffset)
```
    Specified by:
    
    getDateAndOffset in interface IDbmsSupport
    
    Overrides:
    
    getDateAndOffset in class GenericDbmsSupport
  - getNumericKeyFieldType
```
public String getNumericKeyFieldType()
```
    Specified by:
    
    getNumericKeyFieldType in interface IDbmsSupport
    
    Overrides:
    
    getNumericKeyFieldType in class GenericDbmsSupport
  - getAutoIncrementKeyFieldType
```
public String getAutoIncrementKeyFieldType()
```
    Specified by:
    
    getAutoIncrementKeyFieldType in interface IDbmsSupport
    
    Overrides:
    
    getAutoIncrementKeyFieldType in class GenericDbmsSupport
  - autoIncrementKeyMustBeInserted
```
public boolean autoIncrementKeyMustBeInserted()
```
    Specified by:
    
    autoIncrementKeyMustBeInserted in interface IDbmsSupport
    
    Overrides:
    
    autoIncrementKeyMustBeInserted in class GenericDbmsSupport
  - getInsertedAutoIncrementValueQuery
```
public String getInsertedAutoIncrementValueQuery(String sequenceName)
```
    Specified by:
    
    getInsertedAutoIncrementValueQuery in interface IDbmsSupport
    
    Overrides:
    
    getInsertedAutoIncrementValueQuery in class GenericDbmsSupport
  - getTimestampFieldType
```
public String getTimestampFieldType()
```
    Specified by:
    
    getTimestampFieldType in interface IDbmsSupport
    
    Overrides:
    
    getTimestampFieldType in class GenericDbmsSupport
  - getDatetimeLiteral
```
public String getDatetimeLiteral(Date date)
```
    Specified by:
    
    getDatetimeLiteral in interface IDbmsSupport
    
    Overrides:
    
    getDatetimeLiteral in class GenericDbmsSupport
  - getTimestampAsDate
```
public String getTimestampAsDate(String columnName)
```
    Specified by:
    
    getTimestampAsDate in interface IDbmsSupport
    
    Overrides:
    
    getTimestampAsDate in class GenericDbmsSupport
  - getBlobFieldType
```
public String getBlobFieldType()
```
    Specified by:
    
    getBlobFieldType in interface IDbmsSupport
    
    Overrides:
    
    getBlobFieldType in class GenericDbmsSupport
  - emptyBlobValue
```
public String emptyBlobValue()
```
    Specified by:
    
    emptyBlobValue in interface IDbmsSupport
    
    Overrides:
    
    emptyBlobValue in class GenericDbmsSupport
  - getClobFieldType
```
public String getClobFieldType()
```
    Specified by:
    
    getClobFieldType in interface IDbmsSupport
    
    Overrides:
    
    getClobFieldType in class GenericDbmsSupport
  - isClobType
```
public boolean isClobType(ResultSetMetaData rsmeta,
                          int colNum)
                   throws SQLException
```
    Specified by:
    
    isClobType in interface IDbmsSupport
    
    Overrides:
    
    isClobType in class GenericDbmsSupport
    
    Throws:
    
    SQLException
  - getTextFieldType
```
public String getTextFieldType()
```
    Specified by:
    
    getTextFieldType in interface IDbmsSupport
    
    Overrides:
    
    getTextFieldType in class GenericDbmsSupport
  - prepareQueryTextForWorkQueueReading
```
public String prepareQueryTextForWorkQueueReading(int batchSize,
                                                  String selectQuery,
                                                  int wait)
                                           throws JdbcException
```
    Specified by:
    
    prepareQueryTextForWorkQueueReading in interface IDbmsSupport
    
    Overrides:
    
    prepareQueryTextForWorkQueueReading in class GenericDbmsSupport
    
    Throws:
    
    JdbcException
  - prepareQueryTextForWorkQueuePeeking
```
public String prepareQueryTextForWorkQueuePeeking(int batchSize,
                                                  String selectQuery,
                                                  int wait)
                                           throws JdbcException
```
    Specified by:
    
    prepareQueryTextForWorkQueuePeeking in interface IDbmsSupport
    
    Overrides:
    
    prepareQueryTextForWorkQueuePeeking in class GenericDbmsSupport
    
    Throws:
    
    JdbcException
  - getFirstRecordQuery
```
public String getFirstRecordQuery(String tableName)
                           throws JdbcException
```
    Specified by:
    
    getFirstRecordQuery in interface IDbmsSupport
    
    Overrides:
    
    getFirstRecordQuery in class GenericDbmsSupport
    
    Throws:
    
    JdbcException
  - prepareQueryTextForNonLockingRead
```
public String prepareQueryTextForNonLockingRead(String selectQuery)
                                         throws JdbcException
```
    Description copied from interface: IDbmsSupport
    
    Modify the provided selectQuery in such a way that the resulting query will not be blocked by locks, and will avoid placing locks itself as much as possible. Will always be executed together with IDbmsSupport.prepareSessionForNonLockingRead(Connection). Preferably, the effective isolation level is READ_COMMITTED (commited rows of other transactions may be read), but if placing locks can be avoid by an isolation level similar to READ_UNCOMMITTED, that is allowed too. Should return the query unmodified if no special action is required. For an example, see prepareQueryTextForNonLockingRead(String)
    
    Specified by:
    
    prepareQueryTextForNonLockingRead in interface IDbmsSupport
    
    Overrides:
    
    prepareQueryTextForNonLockingRead in class GenericDbmsSupport
    
    Throws:
    
    JdbcException
  - provideTrailingFirstRowsHint
```
public String provideTrailingFirstRowsHint(int rowCount)
```
    Specified by:
    
    provideTrailingFirstRowsHint in interface IDbmsSupport
    
    Overrides:
    
    provideTrailingFirstRowsHint in class GenericDbmsSupport
  - getSchema
```
public String getSchema(Connection conn)
                 throws JdbcException
```
    Specified by:
    
    getSchema in interface IDbmsSupport
    
    Overrides:
    
    getSchema in class GenericDbmsSupport
    
    Throws:
    
    JdbcException
  - getRowNumber
```
public String getRowNumber(String order,
                           String sort)
```
    Specified by:
    
    getRowNumber in interface IDbmsSupport
    
    Overrides:
    
    getRowNumber in class GenericDbmsSupport
  - getRowNumberShortName
```
public String getRowNumberShortName()
```
    Specified by:
    
    getRowNumberShortName in interface IDbmsSupport
    
    Overrides:
    
    getRowNumberShortName in class GenericDbmsSupport
  - getLength
```
public String getLength(String column)
```
    Specified by:
    
    getLength in interface IDbmsSupport
    
    Overrides:
    
    getLength in class GenericDbmsSupport
  - isIndexPresent
```
public boolean isIndexPresent(Connection conn,
                              String schemaOwner,
                              String tableName,
                              String indexName)
```
    Specified by:
    
    isIndexPresent in interface IDbmsSupport
    
    Overrides:
    
    isIndexPresent in class GenericDbmsSupport
  - isSequencePresent
```
public boolean isSequencePresent(Connection conn,
                                 String schemaOwner,
                                 String tableName,
                                 String sequenceName)
```
    Specified by:
    
    isSequencePresent in interface IDbmsSupport
    
    Overrides:
    
    isSequencePresent in class GenericDbmsSupport
  - hasIndexOnColumns
```
public boolean hasIndexOnColumns(Connection conn,
                                 String schemaOwner,
                                 String tableName,
                                 List<String> columns)
```
    Specified by:
    
    hasIndexOnColumns in interface IDbmsSupport
    
    Overrides:
    
    hasIndexOnColumns in class GenericDbmsSupport
  - getCleanUpIbisstoreQuery
```
public String getCleanUpIbisstoreQuery(String tableName,
                                       String keyField,
                                       String typeField,
                                       String expiryDateField,
                                       int maxRows)
```
    Specified by:
    
    getCleanUpIbisstoreQuery in interface IDbmsSupport
    
    Overrides:
    
    getCleanUpIbisstoreQuery in class GenericDbmsSupport
  - getBooleanFieldType
```
public String getBooleanFieldType()
```
    Specified by:
    
    getBooleanFieldType in interface IDbmsSupport
    
    Overrides:
    
    getBooleanFieldType in class GenericDbmsSupport
  - getBooleanValue
```
public String getBooleanValue(boolean value)
```
    Specified by:
    
    getBooleanValue in interface IDbmsSupport
    
    Overrides:
    
    getBooleanValue in class GenericDbmsSupport

Class MsSqlServerDbmsSupport

Field Summary

Fields inherited from class nl.nn.adapterframework.jdbc.dbms.GenericDbmsSupport

Constructor Summary

Method Summary

Methods inherited from class nl.nn.adapterframework.jdbc.dbms.GenericDbmsSupport

Methods inherited from class java.lang.Object

Field Detail

NEXT_VALUE_FOR

SELECT_CURRENT_VALUE

DEFAULT_BLOB_VALUE

WITH_UPDLOCK_ROWLOCK

GET_DATE

CURRENT_TIMESTAMP

Constructor Detail

MsSqlServerDbmsSupport

Method Detail

getDbms

hasSkipLockedFunctionality

getSysDate

getDateAndOffset

getNumericKeyFieldType

getAutoIncrementKeyFieldType

autoIncrementKeyMustBeInserted

getInsertedAutoIncrementValueQuery

getTimestampFieldType

getDatetimeLiteral

getTimestampAsDate

getBlobFieldType

emptyBlobValue

getClobFieldType

isClobType

getTextFieldType

prepareQueryTextForWorkQueueReading

prepareQueryTextForWorkQueuePeeking

getFirstRecordQuery

prepareQueryTextForNonLockingRead

provideTrailingFirstRowsHint

getSchema

getRowNumber

getRowNumberShortName

getLength

isIndexPresent

isSequencePresent

hasIndexOnColumns

getCleanUpIbisstoreQuery

getBooleanFieldType

getBooleanValue