questions regarding transactions
От | Fabian Zeindl |
---|---|
Тема | questions regarding transactions |
Дата | |
Msg-id | 46953E79.5010204@xover.htu.tuwien.ac.at обсуждение исходный текст |
Ответы |
Re: questions regarding transactions
Re: questions regarding transactions Re: questions regarding transactions |
Список | pgsql-jdbc |
Hi, I'm using JDBC with transactions and I've got a couple of questions: 1) Am I supposed to do "myConn.rollback()" on error? What happens if I don't do it - will the transaction stay half-committed?! (I ask this, because rollback() can throw a SQLException, so it's not guaranteed to work, in my opinion). 2) When I use statements like (SELECT currval('somesequence')) in a jdbc-transaction, will it be atomic to? Will the sequence be decremented again when the transaction fails? Can I get wrong numbers, when there is another transaction which increments somesequence? 3) Is it sufficient to do setAutocommit(false) and set the transaction-level or do I have to call a statement like "START TRANSACTION" to properly start an transaction? (I found the latter example somewhere on the net.) Many thanks in advance and thank you for the wonderful driver fabian zeindl
Вложения
В списке pgsql-jdbc по дате отправления: