Class JdbcChannelMessageStore

All Implemented Interfaces:
InitializingBean, BasicMessageGroupStore, ChannelMessageStore, PriorityCapableChannelMessageStore

@ManagedResource public class JdbcChannelMessageStore extends Object implements PriorityCapableChannelMessageStore, InitializingBean

Channel-specific implementation of BasicMessageGroupStore using a relational database via JDBC. This message store shall be used for message channels only.

As such, the JdbcChannelMessageStore uses database specific SQL queries.

Contrary to the JdbcMessageStore, this implementation uses a single database table, optimized to operate like a queue. The SQL scripts for creating the table are packaged under org/springframework/integration/jdbc/schema-*.sql, where * denotes the target database type.

Gunnar Hillert, Artem Bilan, Gary Russell, Meherzad Lahewala, Trung Pham
  • Field Details


      public static final String DEFAULT_REGION
      Default region property, used to partition the message store. For example, a separate Spring Integration application with overlapping channel names may use the same message store by providing a distinct region name.
      See Also:

      public static final String DEFAULT_TABLE_PREFIX
      Default value for the table prefix property.
      See Also:
  • Constructor Details

  • Method Details

    • setDataSource

      public void setDataSource(DataSource dataSource)
      The JDBC DataSource to use when interacting with the database. The passed-in DataSource is used to instantiate a JdbcTemplate with JdbcTemplate.setFetchSize(int) set to 1 and with JdbcTemplate.setMaxRows(int) set to 1.
      dataSource - a DataSource
    • setDeserializer

      public void setDeserializer(Deserializer<? extends Message<?>> deserializer)
      A converter for deserializing byte arrays to messages.
      deserializer - the deserializer to set
    • addAllowedPatterns

      public void addAllowedPatterns(String... patterns)
      Add patterns for packages/classes that are allowed to be deserialized. A class can be fully qualified or a wildcard '*' is allowed at the beginning or end of the class name. Examples:*, *.MyClass.
      patterns - the patterns.
    • setJdbcTemplate

      public void setJdbcTemplate(JdbcTemplate jdbcTemplate)
      The JdbcOperations to use when interacting with the database. Either this property can be set or the dataSource. Please consider passing in a JdbcTemplate with a fetchSize property of 1. This is particularly important for Oracle to ensure First In, First Out (FIFO) message retrieval characteristics.
      jdbcTemplate - a JdbcOperations
    • setLobHandler

      public void setLobHandler(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.
      lobHandler - a LobHandler
    • setMessageRowMapper

      public void setMessageRowMapper(MessageRowMapper messageRowMapper)
      Allow for passing in a custom MessageRowMapper. The MessageRowMapper is used to convert the selected database row representing the persisted message into the actual Message object.
      messageRowMapper - Must not be null
    • setPreparedStatementSetter

      public void setPreparedStatementSetter(ChannelMessageStorePreparedStatementSetter preparedStatementSetter)
      Set a ChannelMessageStorePreparedStatementSetter to insert message into the database.
      preparedStatementSetter - ChannelMessageStorePreparedStatementSetter to use. Must not be null
    • setChannelMessageStoreQueryProvider

      public void setChannelMessageStoreQueryProvider(ChannelMessageStoreQueryProvider channelMessageStoreQueryProvider)
      Set the database specific ChannelMessageStoreQueryProvider to use. The JdbcChannelMessageStore provides the SQL queries to retrieve messages from the database. See the JavaDocs ChannelMessageStoreQueryProvider (all known implementing classes) to see those implementations provided by the framework.

      You can provide your own query implementations, if you need to support additional databases and/or need to fine-tune the queries for your requirements.

      channelMessageStoreQueryProvider - Must not be null.
    • setRegion

      public void setRegion(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_REGION.
      region - the region name to set
    • getRegion

      public String getRegion()
      Returns the current region that was set or DEFAULT_REGION, which is the default.
      the set region name
    • setSerializer

      public void setSerializer(Serializer<? super Message<?>> serializer)
      A converter for serializing messages to byte arrays for storage.
      serializer - The serializer to set
    • setTablePrefix

      public void setTablePrefix(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.
      tablePrefix - the tablePrefix to set
    • setUsingIdCache

      public void setUsingIdCache(boolean usingIdCache)

      Consider using this property when polling the database transactionally using multiple parallel threads, meaning when the configured poller is configured using a task executor.

      The issue is that the pollMessageFromGroup(Object) looks for the oldest entry for a giving channel (groupKey) and region (setRegion(String)). If you do that with multiple threads and you are using transactions, other threads may be waiting for that same locked row.

      If using the provided OracleChannelMessageStoreQueryProvider, don't set usingIdCache to true, as the Oracle query will ignore locked rows.

      Using the id cache, the JdbcChannelMessageStore will store each message id in an in-memory collection for the duration of processing. With that, any polling threads will explicitly exclude those messages from being polled.

      For this to work, you must setup the corresponding TransactionSynchronizationFactory:

       <int:transaction-synchronization-factory id="syncFactory">
           <int:after-commit   expression="@jdbcChannelMessageStore.removeFromIdCache(" />
           <int:after-rollback expression="@jdbcChannelMessageStore.removeFromIdCache(" />
      This TransactionSynchronizationFactory is then referenced in the transaction configuration of the poller:
       <int:poller fixed-delay="300" receive-timeout="500"
           max-messages-per-poll="1" task-executor="pool">
           <int:transactional propagation="REQUIRED" synchronization-factory="syncFactory"
               isolation="READ_COMMITTED" transaction-manager="transactionManager" />
      usingIdCache - When true the id cache will be used.
    • setPriorityEnabled

      public void setPriorityEnabled(boolean priorityEnabled)
      Enable a priority handling in this store.
      priorityEnabled - the priority handling enabled or not.
    • isPriorityEnabled

      public boolean isPriorityEnabled()
      Specified by:
      isPriorityEnabled in interface PriorityCapableChannelMessageStore
      true if message priority is enabled in this channel message store.
    • setMessageGroupFactory

      public void setMessageGroupFactory(MessageGroupFactory messageGroupFactory)
      Specify the MessageGroupFactory to create MessageGroup object where it is necessary. Defaults to SimpleMessageGroupFactory.
      messageGroupFactory - the MessageGroupFactory to use.
    • getMessageGroupFactory

      protected MessageGroupFactory getMessageGroupFactory()
      the MessageGroupFactory
    • afterPropertiesSet

      public void afterPropertiesSet()
      Check mandatory properties (DataSource and setChannelMessageStoreQueryProvider(ChannelMessageStoreQueryProvider)). If no MessageRowMapper and ChannelMessageStorePreparedStatementSetter was explicitly set using setMessageRowMapper(MessageRowMapper) and setPreparedStatementSetter(ChannelMessageStorePreparedStatementSetter) respectively, the default MessageRowMapper and ChannelMessageStorePreparedStatementSetter will be instantiate using the specified deserializer and lobHandler. Also, if the jdbcTemplate's fetchSize property (JdbcTemplate.getFetchSize()) is not 1, a warning will be logged. When using the JdbcChannelMessageStore with Oracle, the fetchSize value of 1 is needed to ensure FIFO characteristics of polled messages. Please see the Oracle ChannelMessageStoreQueryProvider for more details.
      Specified by:
      afterPropertiesSet in interface InitializingBean
    • addMessageToGroup

      public MessageGroup addMessageToGroup(Object groupId, Message<?> message)
      Store a message in the database. The groupId identifies the channel for which the message is to be stored. Keep in mind that the actual groupId (Channel Identifier) is converted to a String-based UUID identifier.
      Specified by:
      addMessageToGroup in interface BasicMessageGroupStore
      groupId - the group id to store the message under
      message - a message
      The message group.
    • getMessageGroup

      public MessageGroup getMessageGroup(Object groupId)
      Not fully used. Only wraps the provided group id.
      Specified by:
      getMessageGroup in interface BasicMessageGroupStore
      groupId - The group identifier.
      A group of messages, empty if none exists for this key.
    • getMessageGroupCount

      @ManagedAttribute public int getMessageGroupCount()
      Return the number of message groups in the store for configured region.
      The message group count.
    • getQuery

      protected String getQuery( queryName, Supplier<String> queryProvider)
      Replace patterns in the input to produce a valid SQL query. This implementation lazily initializes a simple map-based cache, only replacing the table prefix on the first access to a named query. Subsequent accesses will be resolved from the cache.
      queryName - The JdbcChannelMessageStore.Query to be transformed.
      queryProvider - a supplier to provide the query template.
      A transformed query with replacements.
    • messageGroupSize

      @ManagedAttribute public int messageGroupSize(Object groupId)
      Return the number of messages persisted for the specified channel id (groupId) and the specified region (setRegion(String)).
      Specified by:
      messageGroupSize in interface BasicMessageGroupStore
      groupId - The group identifier.
      The message group size.
    • removeMessageGroup

      public void removeMessageGroup(Object groupId)
      Description copied from interface: BasicMessageGroupStore
      Remove the message group with this id.
      Specified by:
      removeMessageGroup in interface BasicMessageGroupStore
      groupId - The id of the group to remove.
    • pollMessageFromGroup

      public Message<?> pollMessageFromGroup(Object groupId)
      Poll the database for a new message that is persisted for the given group id which represents the channel identifier.
      Specified by:
      pollMessageFromGroup in interface BasicMessageGroupStore
      groupId - The group identifier.
      The message.
    • doPollForMessage

      protected Message<?> doPollForMessage(String groupIdKey)
      This method executes a call to the DB to get the oldest Message in the MessageGroup which in the context of the JdbcChannelMessageStore means the channel identifier.
      groupIdKey - String representation of message group (Channel) ID
      a message; could be null if query produced no Messages
    • removeFromIdCache

      public void removeFromIdCache(String messageId)
      Remove a Message Id from the idCache. Should be used in conjunction with the Spring Integration Transaction Synchronization feature to remove a message from the Message Id cache once a transaction either succeeded or rolled back. Only applicable if setUsingIdCache(boolean) is set totrue.
      messageId - The message identifier.
    • getSizeOfIdCache

      @ManagedMetric public int getSizeOfIdCache()
      Return the size of the Message Id Cache, which caches Message Ids for those messages that are currently being processed.
      The size of the Message Id Cache