Re: Is statement.executeBacth() a transaction?



George wrote:
Thank you. As always, I got a bit more confused on the other by
clearing up one part. I originally thought all the statements in one
transaction are all executed or non executed in jdbc automatically. Am
I right? However, the second last paragraph in the article I linked
seems to say the opposite. It says one needs to rollback when
SQLExcption is thrown, which seems to indicate that one transaction
(one conn.commit()) might leave some statement executed and some
not.

Please do not top-post. (nor strictly bottom-post - correct is to post inline, trimming no-longer relevant content.)

That same article points out that all statements in a transaction are committed or rolled back together. That is, after all, the entire point of transactions.

"Seems to indicate" is a different proposition from "does indicate".

--
Lew
.



Relevant Pages

  • Re: It was love at first sight!
    ... "George D" sought to know more about the transaction: ... I gave the dealer a twenty, and he handed me back a five. ... 'enjoying my new discovery!' ...
    (rec.collecting.coins)
  • Re: Bankers Drafts ? any good
    ... It's for a few hundred quid. ... Clearing doesn't mean it can't be clawed back later if the ... transaction is fraudulent. ... Prev by Date: ...
    (uk.people.consumers.ebay)
  • Re: Paypal ?
    ... transaction from PayPal to my email address. ... the seller gets an email with the following subject header: ... Then that email has all the relevant details of the item and postal ... Many thanks for clearing that up. ...
    (uk.people.consumers.ebay)