public class PostgresqlDbmsSupport extends GenericDbmsSupport
KEYWORD_SELECT, log, sqlTranslators, TYPE_BLOB, TYPE_CLOB, TYPE_FUNCTION
Constructor and Description |
---|
PostgresqlDbmsSupport() |
autoIncrementInsertValue, autoIncrementKeyMustBeInserted, autoIncrementUsesSequenceObject, convertQuery, createTranslator, doHasIndexOnColumns, doIsColumnPresent, doIsTablePresent, emptyBlobValue, emptyClobValue, getBlobOutputStream, getBooleanFieldType, getBooleanValue, getCleanUpIbisstoreQuery, getDbmsName, getFirstRecordQuery, getFromForTablelessSelect, getIbisStoreSummaryQuery, getLength, getNumericKeyFieldType, getRowNumber, getRowNumberShortName, getSchemaOwner, getSysDate, getTableColumns, getTableColumns, getTextFieldType, getTimestampFieldType, getUpdateBlobQuery, getUpdateClobQuery, isBlobType, isColumnPresent, isConstraintViolation, isIndexPresent, isQueryConversionRequired, isSequencePresent, isTablePresent, mustInsertEmptyBlobBeforeData, mustInsertEmptyClobBeforeData, prepareQueryTextForNonLockingRead, prepareQueryTextForWorkQueuePeeking, prepareQueryTextForWorkQueueReading, prepareSessionForNonLockingRead, provideFirstRowsHintAfterFirstKeyword, provideIndexHintAfterFirstKeyword, provideTrailingFirstRowsHint, splitQuery, warnConvertQuery
public Dbms getDbms()
IDbmsSupport
DbmsSupportFactory
.getDbms
in interface IDbmsSupport
getDbms
in class GenericDbmsSupport
public boolean isParameterTypeMatchRequired()
isParameterTypeMatchRequired
in interface IDbmsSupport
isParameterTypeMatchRequired
in class GenericDbmsSupport
public boolean hasSkipLockedFunctionality()
hasSkipLockedFunctionality
in interface IDbmsSupport
hasSkipLockedFunctionality
in class GenericDbmsSupport
public String getDatetimeLiteral(Date date)
getDatetimeLiteral
in interface IDbmsSupport
getDatetimeLiteral
in class GenericDbmsSupport
public String getTimestampAsDate(String columnName)
getTimestampAsDate
in interface IDbmsSupport
getTimestampAsDate
in class GenericDbmsSupport
public String getDateAndOffset(String dateValue, int daysOffset)
getDateAndOffset
in interface IDbmsSupport
getDateAndOffset
in class GenericDbmsSupport
public String getClobFieldType()
getClobFieldType
in interface IDbmsSupport
getClobFieldType
in class GenericDbmsSupport
public boolean isClobType(ResultSetMetaData rsmeta, int colNum) throws SQLException
isClobType
in interface IDbmsSupport
isClobType
in class GenericDbmsSupport
SQLException
public Reader getClobReader(ResultSet rs, int column) throws SQLException, JdbcException
getClobReader
in interface IDbmsSupport
getClobReader
in class GenericDbmsSupport
SQLException
JdbcException
public Reader getClobReader(ResultSet rs, String column) throws SQLException, JdbcException
getClobReader
in interface IDbmsSupport
getClobReader
in class GenericDbmsSupport
SQLException
JdbcException
public Object getClobHandle(ResultSet rs, int column) throws SQLException, JdbcException
getClobHandle
in interface IDbmsSupport
getClobHandle
in class GenericDbmsSupport
SQLException
JdbcException
public Object getClobHandle(ResultSet rs, String column) throws SQLException, JdbcException
getClobHandle
in interface IDbmsSupport
getClobHandle
in class GenericDbmsSupport
SQLException
JdbcException
public Object getClobHandle(PreparedStatement stmt, int column) throws SQLException, JdbcException
getClobHandle
in interface IDbmsSupport
getClobHandle
in class GenericDbmsSupport
SQLException
JdbcException
public Writer getClobWriter(ResultSet rs, int column, Object clobHandle) throws SQLException, JdbcException
getClobWriter
in interface IDbmsSupport
getClobWriter
in class GenericDbmsSupport
SQLException
JdbcException
public Writer getClobWriter(ResultSet rs, String column, Object clobHandle) throws SQLException, JdbcException
getClobWriter
in interface IDbmsSupport
getClobWriter
in class GenericDbmsSupport
SQLException
JdbcException
public Writer getClobWriter(PreparedStatement stmt, int column, Object clobHandle) throws SQLException, JdbcException
getClobWriter
in interface IDbmsSupport
getClobWriter
in class GenericDbmsSupport
SQLException
JdbcException
public void updateClob(ResultSet rs, int column, Object clobHandle) throws SQLException, JdbcException
updateClob
in interface IDbmsSupport
updateClob
in class GenericDbmsSupport
SQLException
JdbcException
public void updateClob(ResultSet rs, String column, Object clobHandle) throws SQLException, JdbcException
updateClob
in interface IDbmsSupport
updateClob
in class GenericDbmsSupport
SQLException
JdbcException
public void applyClobParameter(PreparedStatement stmt, int column, Object clobHandle) throws SQLException, JdbcException
applyClobParameter
in interface IDbmsSupport
applyClobParameter
in class GenericDbmsSupport
SQLException
JdbcException
public String getBlobFieldType()
getBlobFieldType
in interface IDbmsSupport
getBlobFieldType
in class GenericDbmsSupport
public InputStream getBlobInputStream(ResultSet rs, int column) throws SQLException, JdbcException
getBlobInputStream
in interface IDbmsSupport
getBlobInputStream
in class GenericDbmsSupport
SQLException
JdbcException
public InputStream getBlobInputStream(ResultSet rs, String column) throws SQLException, JdbcException
getBlobInputStream
in interface IDbmsSupport
getBlobInputStream
in class GenericDbmsSupport
SQLException
JdbcException
public Object getBlobHandle(ResultSet rs, int column) throws SQLException, JdbcException
getBlobHandle
in interface IDbmsSupport
getBlobHandle
in class GenericDbmsSupport
SQLException
JdbcException
public Object getBlobHandle(ResultSet rs, String column) throws SQLException, JdbcException
getBlobHandle
in interface IDbmsSupport
getBlobHandle
in class GenericDbmsSupport
SQLException
JdbcException
public Object getBlobHandle(PreparedStatement stmt, int column) throws SQLException, JdbcException
getBlobHandle
in interface IDbmsSupport
getBlobHandle
in class GenericDbmsSupport
SQLException
JdbcException
public OutputStream getBlobOutputStream(ResultSet rs, int column, Object blobHandle) throws SQLException, JdbcException
getBlobOutputStream
in interface IDbmsSupport
getBlobOutputStream
in class GenericDbmsSupport
SQLException
JdbcException
public OutputStream getBlobOutputStream(ResultSet rs, String column, Object blobHandle) throws SQLException, JdbcException
getBlobOutputStream
in interface IDbmsSupport
getBlobOutputStream
in class GenericDbmsSupport
SQLException
JdbcException
public OutputStream getBlobOutputStream(PreparedStatement stmt, int column, Object blobHandle) throws SQLException, JdbcException
getBlobOutputStream
in interface IDbmsSupport
getBlobOutputStream
in class GenericDbmsSupport
SQLException
JdbcException
public void updateBlob(ResultSet rs, int column, Object blobHandle) throws SQLException, JdbcException
updateBlob
in interface IDbmsSupport
updateBlob
in class GenericDbmsSupport
SQLException
JdbcException
public void updateBlob(ResultSet rs, String column, Object blobHandle) throws SQLException, JdbcException
updateBlob
in interface IDbmsSupport
updateBlob
in class GenericDbmsSupport
SQLException
JdbcException
public void applyBlobParameter(PreparedStatement stmt, int column, Object blobHandle) throws SQLException, JdbcException
applyBlobParameter
in interface IDbmsSupport
applyBlobParameter
in class GenericDbmsSupport
SQLException
JdbcException
public String getSchema(Connection conn) throws JdbcException
getSchema
in interface IDbmsSupport
getSchema
in class GenericDbmsSupport
JdbcException
public ResultSet getTableColumns(Connection conn, String schemaName, String tableName, String columnNamePattern) throws JdbcException
getTableColumns
in interface IDbmsSupport
getTableColumns
in class GenericDbmsSupport
JdbcException
public boolean isTablePresent(Connection conn, String schemaName, String tableName) throws JdbcException
isTablePresent
in interface IDbmsSupport
isTablePresent
in class GenericDbmsSupport
JdbcException
public boolean isColumnPresent(Connection conn, String schemaName, String tableName, String columnName) throws JdbcException
isColumnPresent
in interface IDbmsSupport
isColumnPresent
in class GenericDbmsSupport
JdbcException
public boolean hasIndexOnColumn(Connection conn, String schemaOwner, String tableName, String columnName) throws JdbcException
hasIndexOnColumn
in interface IDbmsSupport
hasIndexOnColumn
in class GenericDbmsSupport
JdbcException
public boolean hasIndexOnColumns(Connection conn, String schemaOwner, String tableName, List<String> columns) throws JdbcException
hasIndexOnColumns
in interface IDbmsSupport
hasIndexOnColumns
in class GenericDbmsSupport
JdbcException
public String prepareQueryTextForWorkQueueReading(int batchSize, String selectQuery, int wait) throws JdbcException
prepareQueryTextForWorkQueueReading
in interface IDbmsSupport
prepareQueryTextForWorkQueueReading
in class GenericDbmsSupport
JdbcException
public String prepareQueryTextForWorkQueuePeeking(int batchSize, String selectQuery, int wait) throws JdbcException
prepareQueryTextForWorkQueuePeeking
in interface IDbmsSupport
prepareQueryTextForWorkQueuePeeking
in class GenericDbmsSupport
JdbcException
public int alterAutoIncrement(Connection connection, String tableName, int startWith) throws JdbcException
JdbcException
public String getInsertedAutoIncrementValueQuery(String sequenceName)
getInsertedAutoIncrementValueQuery
in interface IDbmsSupport
getInsertedAutoIncrementValueQuery
in class GenericDbmsSupport
public String getAutoIncrementKeyFieldType()
getAutoIncrementKeyFieldType
in interface IDbmsSupport
getAutoIncrementKeyFieldType
in class GenericDbmsSupport
Copyright © 2023 Frank!Framework. All rights reserved.