Hi Tomek, Currently in remote connection SQL commands are not running under transaction, so you should use Java API to perform document changes.
For sure we are going to fix this issue in next releases. On Tue, Sep 9, 2014 at 4:25 PM, Tomasz Kułakow <[email protected]> wrote: > 1) Why transactions don't work when remote connection is in use? Tutorial > says its READ COMMITTED, so it should work. > > 2) How to check in console if something has changed in the database after > program execution? > > In console i checked > orientdb {db}> select from #12:0 > > ----+-----+--------+------- > # |@RID |@version|value > ----+-----+--------+------- > 0 |#12:0|21 |22 > ----+-----+--------+------- > > > > And in Java program i I do a transaction: > ODatabaseDocumentTx db = new ODatabaseDocumentTx("remote:localhost/db"). > open("admin", "admin"); > > db.begin(TXTYPE.OPTIMISTIC); > db.command(new OCommandSQL("UPDATE #12:0 set value='1'")).execute(); > db.rollback(); > > > in console again: > orientdb {db}> select from #12:0 > > ----+-----+--------+------- > # |@RID |@version|value > ----+-----+--------+------- > 0 |#12:0|21 |22 > ----+-----+--------+------- > > but after disconnect and connect again > > orientdb {db}> select from #12:0 > > ----+-----+--------+------- > # |@RID |@version|value > ----+-----+--------+------- > 0 |#12:0|22 |1 > ----+-----+--------+------- > > When using 'plocal' instead 'remote' transaction works, but still need to > disconnect console and connect again to check if something has changed. Why? > > Best regards > Tomek > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Best regards, Andrey Lomakin. Orient Technologies the Company behind OrientDB -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
