Hi,

please consider the following example:


DROP TABLE TEST;

CREATE TABLE TEST(ID NUMERIC(15) NOT NULL);

insert into test values (1);

savepoint test_savepoint;

insert into test values (2);

rollback to savepoint test_savepoint;

select * from test;


If I execute it with the H2 console, I get the expected result: One row 
with value 1.

If I execute the same snippet with Execute Query (www.executequery.org), 
using org.h2.Driver from h2-1.3.176.jar (h2.1.4.191.jar resp.), then the 
result is empty.

I disabled auto-commit in both cases.

Do you have any idea why this difference occurs?

Thanks a lot!

Best, Niko Paltzer

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to