Prevent automatic table creation or drop when using `JdbcChannelMessageStore`

192 views Asked by At

We want to use a JdbcChannelMessageStore to have a persisted queue in our application.

However, the sql scripts which are included in spring-integration-jdbc causing automatic creation (and dropping ?) of the following DB objects:

  INT_MESSAGE_IX1 
  INT_CHANNEL_MSG_DATE_IDX 
  INT_CHANNEL_MSG_PRIORITY_IDX 
  INT_MESSAGE 
  INT_MESSAGE_GROUP 
  INT_GROUP_TO_MESSAGE 
  INT_LOCK 
  INT_CHANNEL_MESSAGE 
  INT_METADATA_STORE 
  INT_MESSAGE_SEQ 

This is not a behavior which we wont to have in production. There we have to control everything what happens on our data bases.

Is there a way to prevent the loading of those scripts?

Thanks a lot in advance for your reply.

1

There are 1 answers

0
Alex Frenkel On

Thanks to Gweltaz Niquel I have found out that the property spring.jpa.hibernate.ddl-auto is set by default to create-drop when an in-memory data base is used. And in fact I saw this behavior when using H2 DB.

For external data bases, the default setting is none

enter image description here