0 Replies Latest reply on Jul 2, 2015 12:19 PM by udaykiran.reddy

    Help Needed on FUSE ESB with ORM framework

    udaykiran.reddy
    udaykiran.reddy Jul 2, 2015 12:19 PM

      We are evaluating JBoss Fuse ESB 6.1 (Fabric Container) for one of requirements, so can you please help on this:

       

      Requirement : Connect to database and retrieve the records (from joining different tables, basically inner join query)

       

      We want to know what is the best approach recommended in connecting the database and executing the complex inner join query’s (retrieving the database records) to use inside Fuse ESB (with camel component)?

       

      1. Should we use plain JDBC calls ?
      2. Or we should we go with ORM framework? Which one is best among below list?

       

      ORM Frameworks: Hibernate, JPA, OpenJPA, MyBatis and etc. Which one Redhat (Fuse ESB 6.1) suggest ? What are the pros and cons of it.

       

      Thanks in Advance.

      -- Uday