nl.nn.adapterframework.jdbc.dbms

Class MariaDbDbmsSupport

java.lang.Object

nl.nn.adapterframework.jdbc.dbms.GenericDbmsSupport

nl.nn.adapterframework.jdbc.dbms.MySqlDbmsSupport

nl.nn.adapterframework.jdbc.dbms.MariaDbDbmsSupport

All Implemented Interfaces:

IDbmsSupport

public class MariaDbDbmsSupport
extends MySqlDbmsSupport

Support for MariaDB.

Field Summary

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
MariaDbDbmsSupport()
MariaDbDbmsSupport(boolean dbmsHasSkipLockedFunctionality)
MariaDbDbmsSupport(String productVersion)

Method Summary

Modifier and Type	Method and Description
Object	getBlobHandle(ResultSet rs, int column)
Object	getBlobHandle(ResultSet rs, String column)
Object	getClobHandle(ResultSet rs, int column)
Object	getClobHandle(ResultSet rs, String column)
Dbms	getDbms() Numeric value defining database type, defined in DbmsSupportFactory.
boolean	hasSkipLockedFunctionality()
String	prepareQueryTextForWorkQueuePeeking(int batchSize, String selectQuery, int wait)
String	prepareQueryTextForWorkQueueReading(int batchSize, String selectQuery, int wait)

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

alterAutoIncrement, getAutoIncrementKeyFieldType, getBlobFieldType, getCleanUpIbisstoreQuery, getClobFieldType, getDateAndOffset, getDatetimeLiteral, getInsertedAutoIncrementValueQuery, getSchema, getTimestampAsDate, hasIndexOnColumns, isStoredProcedureOutParametersSupported, isStoredProcedureResultSetSupported

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

applyBlobParameter, applyClobParameter, autoIncrementInsertValue, autoIncrementKeyMustBeInserted, autoIncrementUsesSequenceObject, convertQuery, createTranslator, doHasIndexOnColumns, doIsColumnPresent, doIsTablePresent, emptyBlobValue, emptyClobValue, getBlobHandle, getBlobInputStream, getBlobInputStream, getBlobOutputStream, getBlobOutputStream, getBlobOutputStream, getBlobOutputStream, getBooleanFieldType, getBooleanValue, getClobHandle, getClobReader, getClobReader, getClobWriter, getClobWriter, getClobWriter, getDbmsName, getFirstRecordQuery, getFromForTablelessSelect, getIbisStoreSummaryQuery, getLength, getNumericKeyFieldType, getRowNumber, getRowNumberShortName, getSchemaOwner, getSqlTranslator, getSysDate, getTableColumns, getTableColumns, getTableColumns, getTextFieldType, getTimestampFieldType, getUpdateBlobQuery, getUpdateClobQuery, hasIndexOnColumn, isBlobType, isClobType, isColumnPresent, isColumnPresent, isConstraintViolation, isIndexPresent, isParameterTypeMatchRequired, isQueryConversionRequired, isSequencePresent, isTablePresent, isTablePresent, mustInsertEmptyBlobBeforeData, mustInsertEmptyClobBeforeData, prepareQueryTextForNonLockingRead, prepareQueryTextForWorkQueuePeeking, prepareQueryTextForWorkQueueReading, provideFirstRowsHintAfterFirstKeyword, provideIndexHintAfterFirstKeyword, provideTrailingFirstRowsHint, splitQuery, updateBlob, updateBlob, updateClob, updateClob, warnConvertQuery

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface nl.nn.adapterframework.jdbc.dbms.IDbmsSupport

canFetchStatementParameterMetaData, isStoredProcedureRefCursorOutParameterSupported, isStoredProceduresSupported

Constructor Detail

MariaDbDbmsSupport

public MariaDbDbmsSupport()

MariaDbDbmsSupport

public MariaDbDbmsSupport(String productVersion)

MariaDbDbmsSupport

public MariaDbDbmsSupport(boolean dbmsHasSkipLockedFunctionality)

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 MySqlDbmsSupport

hasSkipLockedFunctionality

public boolean hasSkipLockedFunctionality()

Specified by:

hasSkipLockedFunctionality in interface IDbmsSupport

Overrides:

hasSkipLockedFunctionality in class MySqlDbmsSupport

prepareQueryTextForWorkQueueReading

public String prepareQueryTextForWorkQueueReading(int batchSize,
                                                  String selectQuery,
                                                  int wait)
                                           throws JdbcException

Specified by:

prepareQueryTextForWorkQueueReading in interface IDbmsSupport

Overrides:

prepareQueryTextForWorkQueueReading in class MySqlDbmsSupport

Throws:

JdbcException

prepareQueryTextForWorkQueuePeeking

public String prepareQueryTextForWorkQueuePeeking(int batchSize,
                                                  String selectQuery,
                                                  int wait)
                                           throws JdbcException

Specified by:

prepareQueryTextForWorkQueuePeeking in interface IDbmsSupport

Overrides:

prepareQueryTextForWorkQueuePeeking in class MySqlDbmsSupport

Throws:

JdbcException

getClobHandle

public Object getClobHandle(ResultSet rs,
                            int column)
                     throws SQLException,
                            JdbcException

Specified by:

getClobHandle in interface IDbmsSupport

Overrides:

getClobHandle in class GenericDbmsSupport

Throws:

SQLException

JdbcException

getClobHandle

public Object getClobHandle(ResultSet rs,
                            String column)
                     throws SQLException,
                            JdbcException

Specified by:

getClobHandle in interface IDbmsSupport

Overrides:

getClobHandle in class GenericDbmsSupport

Throws:

SQLException

JdbcException

getBlobHandle

public Object getBlobHandle(ResultSet rs,
                            int column)
                     throws SQLException,
                            JdbcException

Specified by:

getBlobHandle in interface IDbmsSupport

Overrides:

getBlobHandle in class GenericDbmsSupport

Throws:

SQLException

JdbcException

getBlobHandle

public Object getBlobHandle(ResultSet rs,
                            String column)
                     throws SQLException,
                            JdbcException

Specified by:

getBlobHandle in interface IDbmsSupport

Overrides:

getBlobHandle in class GenericDbmsSupport

Throws:

SQLException

JdbcException