Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    57

    Unanswered: Manage custom transactions in DB2?

    I would like to manage transaction explicitly in the application (using JDBC). I believe it is possible, isnt'it?
    If I understand correctly I must update the configuration setting autocommit on off. Can you tell me how can I set this configuration autocommit off? I believe this setting is established when the database is created, isnt'it?
    And the second question is the following:
    Can I use the sentence SAVE TRANSACTION? If not can you show me a similar sentence, please.
    Thanks in advanced.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    First of all, I would suggest that you read a book on JDBC. It should explain a lot of things to you and answer questions.

    Now to answer your question.

    KDBC has a Connection Class. It has to methods that you need:
    setAutoCommit(boolean) and
    commit().

    1) Use SetAutoCommit(false) to "Start a transaction"
    2) Use commit(). to "end the transaction" (you can setAutoCommit(true) optionally. If you do not, then your next transaction will start automatically after the commit()--you will not have to do step (1) again).

    HTH

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •