Announcement Announcement Module
Collapse
No announcement yet.
concurrent invokation of one select-statement against 6 databases with same schema Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • concurrent invokation of one select-statement against 6 databases with same schema

    We have 6 databases with exactly the same db-schema for different regions in our company. I want to create a web-service selecting a customer out of the 6 DBs. For this use-case i need to execute one select-statement (e.g. select * from customer where name = 'harald') against every DB. I don't want to do this in a sequence, i want them to process in parallel. The output of my WebService should list all customers named 'harald' of all DBs.

    How can i use Spring Batch "Asynchronous Chunk Processing" to achive my use-case? Is Spring Batch the right framework for my use-case?

    Thanks, Harald

  • #2
    Spring Batch is not really suited to the creation of simple services like I think you have in mind. It is better suited to repetitive processing of tasks or data, not a single query (or set of queries to be aggregated).

    I think Spring Integration might be closer to what you are looking for.

    Comment

    Working...
    X