Stack Overflow
Stack Overflow

Questions tagged [spring-integration-jdbc]

13 questions
2
votes
1 answer

Spring integration jdbc poller thread hangs or polls in consistently

We have a very simple application where we have one spring integration inbound jdbc poller which polls data from db table and put those records in direct channel. From that channel we have service activator which takes those records and put it in…
Life long learner
  • 45
  • 7
2
votes
1 answer

Prevent automatic table creation or drop when using `JdbcChannelMessageStore`

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…
Alex Frenkel
  • 65
  • 7
2
votes
1 answer

How to ask spring to create corresponding schema for JdbcMetadataStore?

I want to use jdbc metadata store which described here: https://docs.spring.io/spring-integration/docs/5.2.0.BUILD-SNAPSHOT/reference/html/jdbc.html#jdbc-metadata-store quote: The org.springframework.integration.jdbc package has Database schema …
gstackoverflow
  • 36,709
  • 117
  • 359
  • 710
1
vote
1 answer

how can spring integration 5.5.x use mysql as message store

I'm using Mysql as message store DB, just tried to upgrade to spring integration 5.5.5, but found the schema changed, there requires a CONDITION column in INT_MESSAGE_GROUP table, although I can create the table by adding backtick around CONDITION,…
geeinhub
  • 25
  • 4
1
vote
1 answer

JdbcMetadataStore: initialize schema, but for Spring app NOT using Boot

Versions: Spring: 5.2.16.RELEASE Spring Integrations: 5.3.9.RELEASE PostgreSQL: 13.x I have implemented a pure Spring 5.x webapp; there is no Spring Boot. I am using the JdbcMetadataStore and require that the PostgreSQL database be initialized with…
Kode Charlie
  • 1,297
  • 16
  • 32
1
vote
1 answer

JDBCMetadataStore vs transaction manager

As per documentation, JDBCMetadataStore requires an instance of DataSourceTransactionManager and this makes sense. What if I'm using JPA as primary transaction manager in the application? How can I tell to JDBCMetadataStore which transaction manager…
André Diniz
  • 306
  • 3
  • 15
1
vote
0 answers

JMS message processing with spring integration in cloud environment

I'm currently trying to refactor the processing of JMS messages to work in a distributed/cloud environment. To allow a better retry and error handling the messages are first stored to the database with a JPA entity and then read by spring…
m-kay
  • 260
  • 1
  • 11
0
votes
1 answer

time to live of DefaultLockRepository has no effect for 2 threads in the same java process when using JdbcLockRegistry

The following code can reproduce the issue https://github.com/cuipengfei/Spikes/blob/master/jpa/spring-jdbc-distributed-lock-issue/ run the test cases in the above code to reproduce before running the test case, start pg db in docker: docker run -e…
Cui Pengfei 崔鹏飞
  • 8,017
  • 6
  • 46
  • 87
0
votes
1 answer

Spring Integration - JDBC Inbound Channel - Process a group of mutually related rows at one go

In our app, we have to employ Spring Integration JDBC Inbound Channel the way it will poll a DB table containing customer orders. We need to process all orders of a single customer in one go. So we have a table that contains order_number,…
uraman
  • 1
0
votes
1 answer

Spring JDBC Outbound Gateway To Return Original Payload

Using JdbcOutboundGateway, how do I get the reply to be original payload? Currently, the response payload is {UPDATED=1}. Neither reference document (Spring 5.2.x) nor the source code seems to offer an alternative. Should I extend the class and…
lafual
  • 683
  • 1
  • 7
  • 23
0
votes
0 answers

How to attribute more priority on a specific IntegrationFlow process when there are several IntegrationFlow with SpringIntegration

I want to attribute more resources (Thread priority) on a specific IntegrationFlow process when there are several IntegrationFlow instances running in a same SpringBoot application using SpringIntegration. I have two instances of IntegrationFlow…
MacFly3181
  • 91
  • 4
0
votes
3 answers

Spring Integration Mail: Send email after all database inserts

Hello I have an integration flow that splits a file line by line, transforms each line into a POJO and then inserts that POJO into a db via JDBC outbound gateway. I want to be able to send a single email once the process of the file has completed.…
Addison Joseph
  • 126
  • 2
  • 15