Package org.frankframework.jdbc

Class JdbcTableMessageBrowser<M>

java.lang.Object

org.frankframework.jndi.JndiBase

org.frankframework.jdbc.JdbcFacade

org.frankframework.jdbc.JdbcMessageBrowser<M>

org.frankframework.jdbc.JdbcTableMessageBrowser<M>

All Implemented Interfaces:

HasPhysicalDestination, IConfigurable, IConfigurationAware, IMessageBrowser<M>, INamedObject, IScopeProvider, IXAEnabled, org.springframework.beans.factory.Aware, org.springframework.context.ApplicationContextAware

Direct Known Subclasses:

JdbcTransactionalStorage

public class JdbcTableMessageBrowser<M>
extends JdbcMessageBrowser<M>

Nested Class Summary

Nested classes/interfaces inherited from interface org.frankframework.core.IMessageBrowser

IMessageBrowser.HideMethod, IMessageBrowser.SortOrder, IMessageBrowser.StorageType

Field Summary

Fields

Modifier and Type	Field	Description
protected boolean	useIndexHint

Fields inherited from class org.frankframework.jdbc.JdbcMessageBrowser

checkCorrelationIdQuery, checkMessageIdQuery, CONTROL_PROPERTY_PREFIX, deleteQuery, getMessageCountQuery, PROPERTY_ASSUME_PRIMARY_KEY_UNIQUE, PROPERTY_USE_PARAMETERS, selectContextQuery, selectDataQuery, selectKeyQueryIsDbmsSupported

Fields inherited from class org.frankframework.jndi.JndiBase

log

Constructor Summary

Constructors

Constructor	Description
JdbcTableMessageBrowser(JdbcTableListener<M> tableListener)
JdbcTableMessageBrowser(JdbcTableListener<M> tableListener, String statusValue, IMessageBrowser.StorageType storageType)

Method Summary

Modifier and Type	Method	Description
void	configure()
protected void	createQueryTexts(IDbmsSupport dbmsSupport)
protected String	createSelector()
protected String	getFromClause(boolean noAlias)
String	getIndexName()
protected String	getLogPrefix()
String	getPhysicalDestinationName()	Returns the name and location of the database that this objects operates on.
protected String	getSelectListQuery(IDbmsSupport dbmsSupport, Date startTime, Date endTime, IMessageBrowser.SortOrder order)
String	getTableName()
protected String	provideFirstRowsHintAfterFirstKeyword(IDbmsSupport dbmsSupport)
protected String	provideIndexHintAfterFirstKeyword(IDbmsSupport dbmsSupport)
protected String	provideTrailingFirstRowsHint(IDbmsSupport dbmsSupport)
protected RawMessageWrapper<M>	retrieveObject(String storageKey, ResultSet rs, int columnIndex)
void	setIndexName(String string)	Name of the index, to be used in hints for query optimizer too (only for Oracle).
protected void	setOperationControls()
void	setTableName(String tableName)	Name of the table messages are stored in.

Methods inherited from class org.frankframework.jdbc.JdbcMessageBrowser

applyStandardParameters, applyStandardParameters, browseMessage, containsCorrelationId, containsMessageId, copyFacadeSettings, deleteMessage, getCommentField, getContext, getCorrelationIdField, getDatasource, getDateField, getExpiryDateField, getHideMethod, getHideRegex, getHostField, getIdField, getIterator, getIterator, getKeyField, getLabelField, getMessageCount, getMessageField, getOrder, getPrefix, getSlotId, getSlotIdField, getType, getTypeField, getWhereClause, setCommentField, setCorrelationIdField, setDateField, setExpiryDateField, setHideMethod, setHideRegex, setHostField, setIdField, setKeyField, setLabelField, setMessageField, setOrder, setPrefix, setSlotId, setSlotIdField, setType, setTypeField

Methods inherited from class org.frankframework.jdbc.JdbcFacade

getAuthAlias, getConnection, getConnectionWithTimeout, getDataSourceFactory, getDatasourceInfo, getDatasourceName, getDbmsSupport, getDomain, getPassword, getUsername, isConnectionsArePooled, isTransacted, setAuthAlias, setConnectionsArePooled, setDataSourceFactory, setDatasourceName, setDbmsSupportFactory, setJmsRealm, setPassword, setTransacted, setUsername

Methods inherited from class org.frankframework.jndi.JndiBase

close, getApplicationContext, getAuthentication, getConfigurationClassLoader, getContext, getCredentials, getInitialContextFactoryName, getJmsRealmName, getJndiAuthAlias, getJndiContextPrefix, getJndiEnv, getJndiProperties, getName, getPrincipal, getProviderURL, getSecurityProtocol, getUrlPkgPrefixes, setApplicationContext, setAuthentication, setCredentials, setInitialContextFactoryName, setJndiAuthAlias, setJndiContextPrefix, setJndiProperties, setName, setPrincipal, setProviderURL, setSecurityProtocol, setUrlPkgPrefixes, toString

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.frankframework.core.IXAEnabled

isTransacted

Field Details

useIndexHint

protected boolean useIndexHint

Constructor Details

JdbcTableMessageBrowser

public JdbcTableMessageBrowser(JdbcTableListener<M> tableListener)

JdbcTableMessageBrowser

public JdbcTableMessageBrowser(JdbcTableListener<M> tableListener,
 String statusValue,
 IMessageBrowser.StorageType storageType)

Method Details

getLogPrefix

protected String getLogPrefix()

Overrides:

getLogPrefix in class JdbcMessageBrowser<M>

configure

public void configure()
               throws ConfigurationException

Specified by:

configure in interface IConfigurable

Overrides:

configure in class JdbcMessageBrowser<M>

Throws:

ConfigurationException

setOperationControls

protected void setOperationControls()

Overrides:

setOperationControls in class JdbcMessageBrowser<M>

retrieveObject

protected RawMessageWrapper<M> retrieveObject(String storageKey,
 ResultSet rs,
 int columnIndex)
                                       throws JdbcException,
SQLException

Specified by:

retrieveObject in class JdbcMessageBrowser<M>

Throws:

JdbcException

SQLException

createQueryTexts

protected void createQueryTexts(IDbmsSupport dbmsSupport)
                         throws ConfigurationException

Throws:

ConfigurationException

getFromClause

protected String getFromClause(boolean noAlias)

getSelectListQuery

protected String getSelectListQuery(IDbmsSupport dbmsSupport,
 Date startTime,
 Date endTime,
 IMessageBrowser.SortOrder order)

Specified by:

getSelectListQuery in class JdbcMessageBrowser<M>

createSelector

protected String createSelector()

Overrides:

createSelector in class JdbcMessageBrowser<M>

provideIndexHintAfterFirstKeyword

protected String provideIndexHintAfterFirstKeyword(IDbmsSupport dbmsSupport)

provideFirstRowsHintAfterFirstKeyword

protected String provideFirstRowsHintAfterFirstKeyword(IDbmsSupport dbmsSupport)

provideTrailingFirstRowsHint

protected String provideTrailingFirstRowsHint(IDbmsSupport dbmsSupport)

getPhysicalDestinationName

public String getPhysicalDestinationName()

Description copied from class: JdbcFacade

Returns the name and location of the database that this objects operates on. If no previous connection was made or it cannot determine the destination it returns 'unknown'

Specified by:

getPhysicalDestinationName in interface HasPhysicalDestination

Overrides:

getPhysicalDestinationName in class JdbcFacade

See Also:

• HasPhysicalDestination.getPhysicalDestinationName()

setTableName

public void setTableName(String tableName)

Name of the table messages are stored in.

Default value

IBISSTORE

setIndexName

public void setIndexName(String string)

Name of the index, to be used in hints for query optimizer too (only for Oracle).

Default value

IX_IBISSTORE

getTableName

public String getTableName()

getIndexName

public String getIndexName()