public class JdbcMessageStore extends AbstractMessageGroupStore implements MessageStore, org.springframework.beans.factory.InitializingBean
MessageStore using a relational database via JDBC. SQL scripts to create the necessary
tables are packaged as org/springframework/integration/jdbc/schema-*.sql, where * is the
target database type.
Notice: Starting with Spring Integration 5.0, this class will move to package:
org.springframework.integration.jdbc.store.
If you intend backing a MessageChannel using a JDBC-based Message Store,
please consider using the channel-specific JdbcChannelMessageStore instead.
This implementation is intended for correlation components (e.g. <aggregator>),
<delayer> and similar.
MessageGroupStore.MessageGroupCallback| Modifier and Type | Field and Description |
|---|---|
static String |
CREATED_DATE_KEY
The name of the message header that stores a timestamp for the time the message was inserted.
|
static String |
DEFAULT_TABLE_PREFIX
Default value for the table prefix property.
|
static String |
SAVED_KEY
The name of the message header that stores a flag to indicate that the message has been saved.
|
| Constructor and Description |
|---|
JdbcMessageStore()
Deprecated.
since 4.3.9 in favor of
JdbcMessageStore(DataSource) |
JdbcMessageStore(DataSource dataSource)
Create a
MessageStore with all mandatory properties. |
JdbcMessageStore(org.springframework.jdbc.core.JdbcOperations jdbcOperations)
Create a
MessageStore with all mandatory properties. |
| Modifier and Type | Method and Description |
|---|---|
<T> org.springframework.messaging.Message<T> |
addMessage(org.springframework.messaging.Message<T> message)
Put the provided Message into the MessageStore.
|
void |
addMessagesToGroup(Object groupId,
org.springframework.messaging.Message<?>... messages)
Store messages with an association to a group id.
|
void |
addWhiteListPatterns(String... patterns)
Add patterns for packages/classes that are allowed to be deserialized.
|
void |
afterPropertiesSet()
Deprecated.
since 4.3.9 in favor of initialization and assertions in constructors.
|
void |
completeGroup(Object groupId)
Completes this MessageGroup.
|
protected org.springframework.messaging.Message<?> |
doPollForMessage(String groupIdKey)
This method executes a call to the DB to get the oldest Message in the MessageGroup
Override this method if need to.
|
protected org.springframework.jdbc.core.JdbcOperations |
getJdbcOperations()
To be used to get a reference to JdbcOperations
in case this class is subclassed
|
org.springframework.messaging.Message<?> |
getMessage(UUID id) |
long |
getMessageCount()
Optional attribute giving the number of messages in the store.
|
int |
getMessageCountForAllMessageGroups()
Optional attribute giving the number of messages in the store over all groups.
|
MessageGroup |
getMessageGroup(Object groupId)
Return all Messages currently in the MessageStore that were stored using
BasicMessageGroupStore.addMessageToGroup(Object, Message) with this group id. |
int |
getMessageGroupCount()
Optional attribute giving the number of message groups.
|
Collection<org.springframework.messaging.Message<?>> |
getMessagesForGroup(Object groupId)
Retrieve messages for the provided group id.
|
org.springframework.messaging.Message<?> |
getOneMessageFromGroup(Object groupId)
Return the one
Message from MessageGroup. |
protected String |
getQuery(org.springframework.integration.jdbc.JdbcMessageStore.Query base)
Replace patterns in the input to produce a valid SQL query.
|
Iterator<MessageGroup> |
iterator() |
int |
messageGroupSize(Object groupId)
Returns the size of this MessageGroup.
|
org.springframework.messaging.Message<?> |
pollMessageFromGroup(Object groupId)
Polls Message from this
MessageGroup (in FIFO style if supported by the implementation)
while also removing the polled Message |
org.springframework.messaging.Message<?> |
removeMessage(UUID id)
Remove the Message with the given id from the MessageStore, if present, and return it.
|
MessageGroup |
removeMessageFromGroup(Object groupId,
org.springframework.messaging.Message<?> messageToRemove)
Deprecated.
|
void |
removeMessageGroup(Object groupId)
Remove the message group with this id.
|
void |
removeMessagesFromGroup(Object groupId,
Collection<org.springframework.messaging.Message<?>> messages)
Persist the deletion of messages from the group.
|
void |
setDataSource(DataSource dataSource)
Deprecated.
since 4.3.9 in favor of
JdbcMessageStore(DataSource) |
void |
setDeserializer(org.springframework.core.serializer.Deserializer<? extends org.springframework.messaging.Message<?>> deserializer)
A converter for deserializing byte arrays to messages.
|
void |
setJdbcTemplate(org.springframework.jdbc.core.JdbcOperations jdbcTemplate)
Deprecated.
since 4.3.9 in favor of
JdbcMessageStore(DataSource) |
void |
setLastReleasedSequenceNumberForGroup(Object groupId,
int sequenceNumber)
Allows you to set the sequence number of the last released Message.
|
void |
setLobHandler(org.springframework.jdbc.support.lob.LobHandler lobHandler)
Override the
LobHandler that is used to create and unpack large objects in SQL queries. |
void |
setRegion(String region)
A unique grouping identifier for all messages persisted with this store.
|
void |
setSerializer(org.springframework.core.serializer.Serializer<? super org.springframework.messaging.Message<?>> serializer)
A converter for serializing messages to byte arrays for storage.
|
void |
setTablePrefix(String tablePrefix)
Public setter for the table prefix property.
|
addMessageToGroup, copy, expireMessageGroups, getGroupMetadata, getMessageBuilderFactory, getMessageGroupFactory, isTimeoutOnIdle, registerMessageGroupExpiryCallback, removeMessagesFromGroup, setBeanFactory, setExpiryCallbacks, setLazyLoadMessageGroups, setTimeoutOnIdlegetRemoveBatchSize, setMessageGroupFactory, setRemoveBatchSizeclone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitforEach, spliteratorpublic static final String DEFAULT_TABLE_PREFIX
public static final String SAVED_KEY
public static final String CREATED_DATE_KEY
@Deprecated public JdbcMessageStore()
JdbcMessageStore(DataSource)public JdbcMessageStore(DataSource dataSource)
MessageStore with all mandatory properties.dataSource - a DataSourcepublic JdbcMessageStore(org.springframework.jdbc.core.JdbcOperations jdbcOperations)
MessageStore with all mandatory properties.jdbcOperations - a JdbcOperationspublic void setTablePrefix(String tablePrefix)
DEFAULT_TABLE_PREFIX.tablePrefix - the tablePrefix to setpublic void setRegion(String region)
DEFAULT.region - the region name to set@Deprecated public void setDataSource(DataSource dataSource)
JdbcMessageStore(DataSource)DataSource to use when interacting with the database.dataSource - a DataSource@Deprecated public void setJdbcTemplate(org.springframework.jdbc.core.JdbcOperations jdbcTemplate)
JdbcMessageStore(DataSource)JdbcOperations to use when interacting with the database.jdbcTemplate - a JdbcOperationspublic void setLobHandler(org.springframework.jdbc.support.lob.LobHandler lobHandler)
LobHandler that is used to create and unpack large objects in SQL queries. The default is
fine for almost all platforms, but some Oracle drivers require a native implementation.lobHandler - a LobHandlerpublic void setSerializer(org.springframework.core.serializer.Serializer<? super org.springframework.messaging.Message<?>> serializer)
serializer - the serializer to setpublic void setDeserializer(org.springframework.core.serializer.Deserializer<? extends org.springframework.messaging.Message<?>> deserializer)
deserializer - the deserializer to setpublic void addWhiteListPatterns(String... patterns)
com.foo.*, *.MyClass.patterns - the patterns.@Deprecated public void afterPropertiesSet() throws Exception
afterPropertiesSet in interface org.springframework.beans.factory.InitializingBeanException - the initialization exceptionpublic org.springframework.messaging.Message<?> removeMessage(UUID id)
MessageStoreremoveMessage in interface MessageStoreid - THe message identifier.@ManagedAttribute public long getMessageCount()
MessageStoregetMessageCount in interface MessageStorepublic org.springframework.messaging.Message<?> getMessage(UUID id)
getMessage in interface MessageStoreid - The message identifier.public <T> org.springframework.messaging.Message<T> addMessage(org.springframework.messaging.Message<T> message)
MessageStoreMessageStore.getMessage(UUID) and MessageStore.removeMessage(UUID) behave properly. Since messages are
immutable, putting the same message more than once is a no-op.addMessage in interface MessageStoreT - The payload type.message - The message.public void addMessagesToGroup(Object groupId, org.springframework.messaging.Message<?>... messages)
MessageGroupStoreaddMessagesToGroup in interface MessageGroupStoregroupId - The group id to store messages under.messages - The messages to add.@ManagedAttribute public int getMessageGroupCount()
MessageGroupStoregetMessageGroupCount in interface MessageGroupStoregetMessageGroupCount in class AbstractMessageGroupStore@ManagedAttribute public int getMessageCountForAllMessageGroups()
MessageGroupStoregetMessageCountForAllMessageGroups in interface MessageGroupStoregetMessageCountForAllMessageGroups in class AbstractMessageGroupStore@ManagedAttribute public int messageGroupSize(Object groupId)
BasicMessageGroupStoremessageGroupSize in interface BasicMessageGroupStoregroupId - The group identifier.public MessageGroup getMessageGroup(Object groupId)
BasicMessageGroupStoreBasicMessageGroupStore.addMessageToGroup(Object, Message) with this group id.getMessageGroup in interface BasicMessageGroupStoregroupId - The group identifier.@Deprecated public MessageGroup removeMessageFromGroup(Object groupId, org.springframework.messaging.Message<?> messageToRemove)
MessageGroupStoreremoveMessageFromGroup in interface MessageGroupStoregroupId - The groupId for the group containing the message.messageToRemove - The message to be removed.public void removeMessagesFromGroup(Object groupId, Collection<org.springframework.messaging.Message<?>> messages)
MessageGroupStoreremoveMessagesFromGroup in interface MessageGroupStoregroupId - The groupId for the group containing the message(s).messages - The messages to be removed.public void removeMessageGroup(Object groupId)
BasicMessageGroupStoreremoveMessageGroup in interface BasicMessageGroupStoregroupId - The id of the group to remove.public void completeGroup(Object groupId)
MessageGroupStorecompleteGroup in interface MessageGroupStoregroupId - The group identifier.public void setLastReleasedSequenceNumberForGroup(Object groupId, int sequenceNumber)
MessageGroupStoresetLastReleasedSequenceNumberForGroup in interface MessageGroupStoregroupId - The group identifier.sequenceNumber - The sequence number.public org.springframework.messaging.Message<?> pollMessageFromGroup(Object groupId)
BasicMessageGroupStoreMessageGroup (in FIFO style if supported by the implementation)
while also removing the polled MessagepollMessageFromGroup in interface BasicMessageGroupStoregroupId - The group identifier.public org.springframework.messaging.Message<?> getOneMessageFromGroup(Object groupId)
MessageGroupStoreMessage from MessageGroup.getOneMessageFromGroup in interface MessageGroupStoregroupId - The group identifier.Message.public Collection<org.springframework.messaging.Message<?>> getMessagesForGroup(Object groupId)
MessageGroupStoregetMessagesForGroup in interface MessageGroupStoregroupId - The group id to retrieve messages for.public Iterator<MessageGroup> iterator()
iterator in interface Iterable<MessageGroup>iterator in interface MessageGroupStoreMessageGroups.protected String getQuery(org.springframework.integration.jdbc.JdbcMessageStore.Query base)
base - the SQL query to be transformedprotected org.springframework.jdbc.core.JdbcOperations getJdbcOperations()
protected org.springframework.messaging.Message<?> doPollForMessage(String groupIdKey)
groupIdKey - String representation of message group ID