1 Reply Latest reply on Mar 19, 2010 4:03 AM by swiderski.maciej

    how to use external database

    roccolocko
    roccolocko Mar 17, 2010 6:23 PM

      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
          swiderski.maciej
          swiderski.maciej Mar 19, 2010 4:03 AM (in response to roccolocko)

          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

            • Actions