Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread 2 databases - single operation
Thu, Sep 13 2018 8:46 AMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

Hi All,

Suppose i need following using 2 databases:

Database1 = insert row
Database2 = update row + insert row

Different tables are used.
Is there any possibility to make those operations in a single commit -
or something that assures data are saved in a single operation?

Running EWB server.

Thanks in advance.
Hüseyin
Thu, Sep 13 2018 10:14 AMPermanent Link

Matthew Jones

Hüseyin Aliz wrote:

> Database1 = insert row
> Database2 = update row + insert row

If you mean a single database with two tables, then a transaction would do. But if you mean two different databases with unrelated tables, I don't think any database system will help with that.

--

Matthew Jones
Thu, Sep 13 2018 10:40 AMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

Hi Matthew,

It's 2 different databases with unrelated tables. Currently i am doing a
transaction/commit for each, seems to be ok for a quick test Smile

Regards,
Hüseyin

Den 13-09-2018 kl. 16:14 skrev Matthew Jones:
> Hüseyin Aliz wrote:
>
>> Database1 = insert row
>> Database2 = update row + insert row
> If you mean a single database with two tables, then a transaction would do. But if you mean two different databases with unrelated tables, I don't think any database system will help with that.
>
Image