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.

Reply via email to