nl.nn.adapterframework.jdbc

Class JdbcTableMessageBrowser<M>

java.lang.Object

nl.nn.adapterframework.jndi.JndiBase

nl.nn.adapterframework.jdbc.JdbcFacade

nl.nn.adapterframework.jdbc.JdbcMessageBrowser<M>

nl.nn.adapterframework.jdbc.JdbcTableMessageBrowser<M>

All Implemented Interfaces:

HasPhysicalDestination, IConfigurable, IConfigurationAware, IMessageBrowser<M>, INamedObject, IScopeProvider, IXAEnabled, HasStatistics, 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 nl.nn.adapterframework.core.IMessageBrowser

IMessageBrowser.HideMethod, IMessageBrowser.SortOrder, IMessageBrowser.StorageType

Nested classes/interfaces inherited from interface nl.nn.adapterframework.statistics.HasStatistics

HasStatistics.Action

Field Summary

Fields

Modifier and Type	Field and Description
protected boolean	useIndexHint

Fields inherited from class nl.nn.adapterframework.jdbc.JdbcMessageBrowser

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

Fields inherited from class nl.nn.adapterframework.jndi.JndiBase

log

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
void	configure()
protected void	createQueryTexts(IDbmsSupport dbmsSupport)
protected String	createSelector()
protected String	getFromClause(boolean noAlias)
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)
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 nl.nn.adapterframework.jdbc.JdbcMessageBrowser

applyStandardParameters, applyStandardParameters, browseMessage, containsCorrelationId, containsMessageId, copyFacadeSettings, deleteMessage, getContext, getDatasource, getIterator, getIterator, getMessageCount, getWhereClause, setCommentField, setCorrelationIdField, setDateField, setExpiryDateField, setHostField, setIdField, setKeyField, setLabelField, setMessageField, setOrder, setPrefix, setSlotId, setSlotIdField, setType, setTypeField

Methods inherited from class nl.nn.adapterframework.jdbc.JdbcFacade

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

Methods inherited from class nl.nn.adapterframework.jndi.JndiBase

close, getContext, getJndiEnv, 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 nl.nn.adapterframework.core.IMessageBrowser

getHideMethod, getHideRegex, setHideMethod, setHideRegex

Methods inherited from interface nl.nn.adapterframework.core.IXAEnabled

isTransacted

Methods inherited from interface nl.nn.adapterframework.core.HasPhysicalDestination

getDomain

Methods inherited from interface nl.nn.adapterframework.core.INamedObject

getName

Methods inherited from interface nl.nn.adapterframework.core.IConfigurationAware

getApplicationContext, getName

Methods inherited from interface nl.nn.adapterframework.core.IScopeProvider

getConfigurationClassLoader

Methods inherited from interface org.springframework.context.ApplicationContextAware

setApplicationContext

Field Detail

useIndexHint

protected boolean useIndexHint

Constructor Detail

JdbcTableMessageBrowser

public JdbcTableMessageBrowser(JdbcTableListener<M> tableListener)

JdbcTableMessageBrowser

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

Method Detail

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.

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