Re: Accessing to two (or more) relational databases at the same time

2015-06-08 Thread Vladimir Nišević
Hi, comments are inlined br,Vladimir > Am 08.06.2015 um 08:22 schrieb Dan Haywood : > > Sounds ok... though what approach are you taking for transaction management? > I manage transactions to other databases manually, in case of any exception, I use "process" entity stored in Isis RDB to repo

Re: Accessing to two (or more) relational databases at the same time

2015-06-07 Thread Dan Haywood
Sounds ok... though what approach are you taking for transaction management? Normally Isis does the xactn mgmt for free. I guess you are doing that stuff yourself? And (since we don't provide any hooks) presumably there is no 2PC/XA stuff, so there are possibilities of data being committed to on

Re: Accessing to two (or more) relational databases at the same time

2015-06-05 Thread Vladimir Nišević
Hi Dan, yes, I have created two domain services representing/managing connections to those two databases. On PostConstrunct of each of them I create two Datanucleus PersistenceManagerFactories and the domain service methods use appropriate Dao's creating the PersistenceManager and managing the t

Re: Accessing to two (or more) relational databases at the same time

2015-06-05 Thread Dan Haywood
Hi Vladimir, sorry no-one ever got back to you on this... did you come up with a solution? otherwise, I have some thoughts... Cheers Dan On 21 May 2015 at 05:51, Vladimir Nišević wrote: > Hi guys, we have a situation where we need to access to two(or more) oracle > and one ms-sql database an