You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@isis.apache.org by Dan Haywood <da...@haywood-associates.co.uk> on 2015/06/05 18:24:14 UTC
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ć <vn...@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
Posted by Vladimir Nišević <vn...@gmail.com>.
Hi, comments are inlined
br,Vladimir
> Am 08.06.2015 um 08:22 schrieb Dan Haywood <da...@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ć <vn...@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 <dan@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ć <vn...@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
Posted by Dan Haywood <da...@haywood-associates.co.uk>.
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ć <vn...@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 <dan@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ć <vn...@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
Posted by Vladimir Nišević <vn...@gmail.com>.
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 <da...@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ć <vn...@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
>>