Re: Accessing to two (or more) relational databases at the same time
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 one database but not the other? Dan On 5 June 2015 at 20:36, Vladimir Nišević vnise...@gmail.com wrote: 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 transactions manually as needed. I can gladly share my code if you wish to review it or give me some feedback. BR,Vladimir Am 05.06.2015 um 18:24 schrieb Dan Haywood d...@haywood-associates.co.uk : 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ć vnise...@gmail.com wrote: Hi guys, we have a situation where we need to access to two(or more) oracle and one ms-sql database and read/write data from/to this databases at the same time. I see that datanucleus supports (to some degree) JDO data federation http://www.datanucleus.org/products/datanucleus/jdo/data_federation.html so this could be the way. My question is, how to integrate this feature into Isis config files and how to use it. It would be enough if I still use container (DomainObjectContainer) for single database, but I need to read/write data somehow to another databases as well - so this another DB's are kind of backend systems... Thanks Vladimir Nisevic
Re: Accessing to two (or more) relational databases at the same time
Hi, comments are inlined br,Vladimir Am 08.06.2015 um 08:22 schrieb Dan Haywood d...@haywood-associates.co.uk: 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 report exceptions 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 one database but not the other? Exactely! I can live with that, although it would be good to have automatic transaction begin/commit for other DB's like Isis does it. Dan On 5 June 2015 at 20:36, Vladimir Nišević vnise...@gmail.com wrote: 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 transactions manually as needed. I can gladly share my code if you wish to review it or give me some feedback. BR,Vladimir Am 05.06.2015 um 18:24 schrieb Dan Haywood d...@haywood-associates.co.uk : 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ć vnise...@gmail.com wrote: Hi guys, we have a situation where we need to access to two(or more) oracle and one ms-sql database and read/write data from/to this databases at the same time. I see that datanucleus supports (to some degree) JDO data federation http://www.datanucleus.org/products/datanucleus/jdo/data_federation.html so this could be the way. My question is, how to integrate this feature into Isis config files and how to use it. It would be enough if I still use container (DomainObjectContainer) for single database, but I need to read/write data somehow to another databases as well - so this another DB's are kind of backend systems... Thanks Vladimir Nisevic
Re: Accessing to two (or more) relational databases at the same time
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ć vnise...@gmail.com wrote: Hi guys, we have a situation where we need to access to two(or more) oracle and one ms-sql database and read/write data from/to this databases at the same time. I see that datanucleus supports (to some degree) JDO data federation http://www.datanucleus.org/products/datanucleus/jdo/data_federation.html so this could be the way. My question is, how to integrate this feature into Isis config files and how to use it. It would be enough if I still use container (DomainObjectContainer) for single database, but I need to read/write data somehow to another databases as well - so this another DB's are kind of backend systems... Thanks Vladimir Nisevic
Re: Accessing to two (or more) relational databases at the same time
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 transactions manually as needed. I can gladly share my code if you wish to review it or give me some feedback. BR,Vladimir Am 05.06.2015 um 18:24 schrieb Dan Haywood d...@haywood-associates.co.uk: 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ć vnise...@gmail.com wrote: Hi guys, we have a situation where we need to access to two(or more) oracle and one ms-sql database and read/write data from/to this databases at the same time. I see that datanucleus supports (to some degree) JDO data federation http://www.datanucleus.org/products/datanucleus/jdo/data_federation.html so this could be the way. My question is, how to integrate this feature into Isis config files and how to use it. It would be enough if I still use container (DomainObjectContainer) for single database, but I need to read/write data somehow to another databases as well - so this another DB's are kind of backend systems... Thanks Vladimir Nisevic