1 Reply Latest reply on Mar 19, 2010 4:03 AM by Maciej Swiderski

    how to use external database

    Roberto Alonso Ramos Zapata Newbie

      hello, I see there is a query property on the sql adapter, but in the documentation I only see that it says that it use exactly like the hibernate adapter, so I don't know if what I want to do is posible, I want to get information from an external database that is useful for the process and I want to do it execting a query to a different datasource than jbpm datasource.

       

      is it possible?

        • 1. Re: how to use external database
          Maciej Swiderski Master

          Hi,

           

          I afraid that it is not possible out of the box because it uses the same hibernate Session instance as jBPM. Perhaps it is possible to inject another session to the process engine but then I am not sure how to tell jBPM runtime to when use which session instance.

           

          Try to earch the forum, I recall there was one post regarding hql queries with different db using spring...

           

          Cheers,

          Maciej