org.springframework.integration.jdbc
Class JdbcMessageStore

java.lang.Object
  org.springframework.integration.store.AbstractMessageGroupStore
      org.springframework.integration.jdbc.JdbcMessageStore

All Implemented Interfaces:

java.lang.Iterable<MessageGroup>, MessageGroupStore, MessageStore

public class JdbcMessageStore
extends AbstractMessageGroupStore
implements MessageStore

Implementation of 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.

Since:

2.0

Author:

Dave Syer

Field Summary

static java.lang.String	CREATED_DATE_KEY The name of the message header that stores a timestamp for the time the message was inserted.
static int	DEFAULT_LONG_STRING_LENGTH
static java.lang.String	DEFAULT_TABLE_PREFIX Default value for the table prefix property.
static java.lang.String	SAVED_KEY The name of the message header that stores a flag to indicate that the message has been saved.

Constructor Summary

JdbcMessageStore()
Convenient constructor for configuration use.

JdbcMessageStore(javax.sql.DataSource dataSource)
Create a MessageStore with all mandatory properties.

Method Summary

<T> Message<T>	addMessage(Message<T> message) Put the provided Message into the MessageStore.
void	addMessageToGroup(java.lang.Object correlationKey, Message<?> message) Store a message with an association to a correlation key.
void	afterPropertiesSet() Check mandatory properties (data source and incrementer).
Message<?>	getMessage(java.util.UUID id) Return the Message with the given id, or null if no Message with that id exists in the MessageStore.
MessageGroup	getMessageGroup(java.lang.Object correlationKey) Return all Messages currently in the MessageStore that were stored using #addMessageToGroup(Object, Collection) with this correlation id.
protected java.lang.String	getQuery(java.lang.String base) Replace patterns in the input to produce a valid SQL query.
java.util.Iterator<MessageGroup>	iterator()
void	markMessageGroup(MessageGroup group) Persist the mark on all the messages from the group.
Message<?>	removeMessage(java.util.UUID id) Remove the Message with the given id from the MessageStore, if present, and return it.
void	removeMessageGroup(java.lang.Object correlationKey) Remove the message group with this correlation key.
void	setDataSource(javax.sql.DataSource dataSource) The JDBC DataSource to use when interacting with the database.
void	setJdbcTemplate(org.springframework.jdbc.core.JdbcOperations jdbcTemplate) The JdbcOperations to use when interacting with the database.
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(java.lang.String region) A unique grouping identifier for all messages persisted with this store.
void	setTablePrefix(java.lang.String tablePrefix) Public setter for the table prefix property.

Methods inherited from class org.springframework.integration.store.AbstractMessageGroupStore

expireMessageGroups, registerMessageGroupExpiryCallback, setExpiryCallbacks

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_TABLE_PREFIX

public static final java.lang.String DEFAULT_TABLE_PREFIX

Default value for the table prefix property.

See Also:

Constant Field Values

DEFAULT_LONG_STRING_LENGTH

public static final int DEFAULT_LONG_STRING_LENGTH

See Also:

Constant Field Values

SAVED_KEY

public static final java.lang.String SAVED_KEY

The name of the message header that stores a flag to indicate that the message has been saved. This is an optimization for the put method.

CREATED_DATE_KEY

public static final java.lang.String CREATED_DATE_KEY

The name of the message header that stores a timestamp for the time the message was inserted.

Constructor Detail

JdbcMessageStore

public JdbcMessageStore()

Convenient constructor for configuration use.

JdbcMessageStore

public JdbcMessageStore(javax.sql.DataSource dataSource)

Create a MessageStore with all mandatory properties.

Parameters:

dataSource - a DataSource

Method Detail

getQuery

protected java.lang.String getQuery(java.lang.String base)

Replace patterns in the input to produce a valid SQL query. This implementation replaces the table prefix.

Parameters:

base - the SQL query to be transformed

Returns:

a transformed query with replacements

setTablePrefix

public void setTablePrefix(java.lang.String tablePrefix)

Public setter for the table prefix property. This will be prefixed to all the table names before queries are executed. Defaults to DEFAULT_TABLE_PREFIX.

Parameters:

tablePrefix - the tablePrefix to set

setRegion

public void setRegion(java.lang.String region)

A unique grouping identifier for all messages persisted with this store. Using multiple regions allows the store to be partitioned (if necessary) for different purposes. Defaults to DEFAULT.

Parameters:

region - the region name to set

setDataSource

public void setDataSource(javax.sql.DataSource dataSource)

The JDBC DataSource to use when interacting with the database. Either this property can be set or the jdbcTemplate.

Parameters:

dataSource - a DataSource

setJdbcTemplate

public void setJdbcTemplate(org.springframework.jdbc.core.JdbcOperations jdbcTemplate)

The JdbcOperations to use when interacting with the database. Either this property can be set or the dataSource.

Parameters:

dataSource - a DataSource

setLobHandler

public void setLobHandler(org.springframework.jdbc.support.lob.LobHandler lobHandler)

Override the 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.

Parameters:

lobHandler - a LobHandler

afterPropertiesSet

public void afterPropertiesSet()
                        throws java.lang.Exception

Check mandatory properties (data source and incrementer).

Throws:

java.lang.Exception

removeMessage

public Message<?> removeMessage(java.util.UUID id)

Description copied from interface: MessageStore

Remove the Message with the given id from the MessageStore, if present, and return it. If no Message with that id is present in the store, this will return null.

Specified by:

removeMessage in interface MessageStore

getMessage

public Message<?> getMessage(java.util.UUID id)

Description copied from interface: MessageStore

Return the Message with the given id, or null if no Message with that id exists in the MessageStore.

Specified by:

getMessage in interface MessageStore

addMessage

public <T> Message<T> addMessage(Message<T> message)

Description copied from interface: MessageStore

Put the provided Message into the MessageStore. The store may need to mutate the message internally, and if it does then the return value can be different than the input. The id of the return value will be used as an index so that the MessageStore.getMessage(UUID) and MessageStore.removeMessage(UUID) behave properly. Since messages are immutable, putting the same message more than once is a no-op.

Specified by:

addMessage in interface MessageStore

Returns:

the message that was stored

addMessageToGroup

public void addMessageToGroup(java.lang.Object correlationKey,
                              Message<?> message)

Description copied from interface: MessageGroupStore

Store a message with an association to a correlation key. This can be used to group messages together instead of storing them just under their id.

Specified by:

addMessageToGroup in interface MessageGroupStore

Parameters:

correlationKey - the correlation id to store the message under

message - a message

getMessageGroup

public MessageGroup getMessageGroup(java.lang.Object correlationKey)

Description copied from interface: MessageGroupStore

Return all Messages currently in the MessageStore that were stored using #addMessageToGroup(Object, Collection) with this correlation id.

Specified by:

getMessageGroup in interface MessageGroupStore

Returns:

a group of messages, empty if none exists for this key

markMessageGroup

public void markMessageGroup(MessageGroup group)

Description copied from interface: MessageGroupStore

Persist the mark on all the messages from the group. The group is modified in the process as all its unmarked messages become marked.

Specified by:

markMessageGroup in interface MessageGroupStore

Parameters:

group - a MessageGroup with no unmarked messages

removeMessageGroup

public void removeMessageGroup(java.lang.Object correlationKey)

Description copied from interface: MessageGroupStore

Remove the message group with this correlation key.

Specified by:

removeMessageGroup in interface MessageGroupStore

Parameters:

correlationKey - the correlation id to remove

iterator

public java.util.Iterator<MessageGroup> iterator()

Specified by:

iterator in interface java.lang.Iterable<MessageGroup>

Specified by:

iterator in class AbstractMessageGroupStore