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.