Package org.frankframework.jdbc

Class JdbcTableMessageBrowser<M>

java.lang.Object

org.frankframework.jndi.JndiBase

org.frankframework.jdbc.JdbcFacade

org.frankframework.jdbc.AbstractJdbcMessageBrowser<M>

org.frankframework.jdbc.JdbcTableMessageBrowser<M>

All Implemented Interfaces:

HasApplicationContext, HasPhysicalDestination, IConfigurable, IMessageBrowser<M>, IScopeProvider, IXAEnabled, NameAware, org.springframework.context.Lifecycle

Direct Known Subclasses:

JdbcTransactionalStorage

public class JdbcTableMessageBrowser<M>
extends AbstractJdbcMessageBrowser<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.AbstractJdbcMessageBrowser

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

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()	Configure this component.
protected void	createQueryTexts(IDbmsSupport dbmsSupport)
protected String	createSelector()
protected String	getFromClause(boolean noAlias)
String	getIndexName()
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.AbstractJdbcMessageBrowser

applyStandardParameters, applyStandardParameters, browseMessage, containsCorrelationId, containsMessageId, copyFacadeSettings, deleteMessage, getCommentField, getContext, getCorrelationIdField, getDatasource, getDateField, getExpiryDateField, getHideMethod, getHideRegex, getHostField, getIdField, getIterator, getIterator, getKeyField, getLabelField, getLogPrefix, 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, getDatasourceName, getDbmsSupport, getDomain, getPassword, getUsername, isConnectionsArePooled, isRunning, isTransacted, setAuthAlias, setConnectionsArePooled, setDataSourceFactory, setDatasourceName, setDbmsSupportFactory, setJmsRealm, setPassword, setTransacted, setUsername, start, stop

Methods inherited from class org.frankframework.jndi.JndiBase

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

configure

public void configure()
               throws ConfigurationException

Description copied from interface: IConfigurable

Configure this component.

configure() is called once at startup of the framework in the configure method of the owner of this IConfigurable. Purpose of this method is to check whether the static configuration of the object is correct. As much as possible class-instantiating should take place in the configure(), to improve performance.

In the case of a container, this will propagate the configure signal to all components that apply.

Specified by:

configure in interface IConfigurable

Overrides:

configure in class AbstractJdbcMessageBrowser<M>

Throws:

ConfigurationException - in case it was not able to configure the component.

setOperationControls

protected void setOperationControls()

Overrides:

setOperationControls in class AbstractJdbcMessageBrowser<M>

retrieveObject

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

Specified by:

retrieveObject in class AbstractJdbcMessageBrowser<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 AbstractJdbcMessageBrowser<M>

createSelector

protected String createSelector()

Overrides:

createSelector in class AbstractJdbcMessageBrowser<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()