Could it be that your connection has auto commit enabled? That's what it looks like...
Regards Knut On Dec 6, 2011, at 10:25, satio <[email protected]> wrote: > the commit never called because on second query is already error > (cause there is no table "products2"). > When error in second query, it already enter to Exception.. (commit > wouldn't executed). > > Correct me if i'm wrong. > satio > > On Dec 6, 3:13 pm, Noel Grandin <[email protected]> wrote: >> depends where the rollback occurred. If the rollback occurred after the >> commit, then it won't have any effect. >> >> >> >> >> >> >> >> satio wrote: >>> Hello.. >>> I tried using connection pool in my ram DB.. >>> if i dont't use beginTransaction, it seems no problem. >>> But when i use beginTransaction using connection pool in my ram DB, >>> i got a problem that the transaction didn't work at all. >> >>> Here my code to get connection pool in ram: >>> JdbcConnectionPool cpool = >>> JdbcConnectionPool.create("jdbc:h2:mem:db_ram", "", ""); >> >>> BEGIN TRANSACTION >>> try { >>> // insert record to ramDB >>> insert into Products(product_id, product_name) VALUES (1, >>> "SNACK"); --> table Products is exists >>> insert into Products2(product_id, product_name) VALUES (2, >>> "POTATO"); --> table Products2 isn't exists >> >>> COMMIT >>> } catch(Exception e) { >>> ROLLBACK >>> } >> >>> NB : assume above code is correct >> >>> The Result is : >>> The Product Name "SNACK" is inserted to ram DB --> (the rollback >>> didn't work at all) >> >>> Is beginTransaction not allowed in connection pool at memory >>> database?? >> >>> satio > > -- > You received this message because you are subscribed to the Google Groups "H2 > Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
