Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2006
    Posts
    5

    Unanswered: Nested transactions and JDBC

    Hi,

    I would like to implement nested transactions with JDBC. I've checked the "savepoints" interface, but it seems that "nested" applies only to rollback functionality. Why is that? I would like to be able to commit the inner transaction, and after a while also the outer.

    How can i achieve this functionality with JDBC (3.0) and Oracle (10.1.2)?

    Thanks!
    Michael.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How can i achieve this functionality with JDBC (3.0) and Oracle (10.1.2)?
    You may be able to do so by using AUTONOMOUS TRANSACTION, but my gut says that a design that depends upon inner & outer transaction is flawed.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2006
    Posts
    5
    Can i use "AUTONOMOUS TRANSACTIONS" through JDBC?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Oracle does not know & does not care about how the client connects to it.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2006
    Posts
    5
    Yeah,

    But how do i "tell" Oracle that i want to open AUTONOMOUS TRANSACTION??
    Is there some "alter" (or other) command which turns my transaction into "AUTONOMOUS"?

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Are you unwilling or incapable of using GOOGLE?
    Results 1 - 10 of about 12,200 for Oracle "autonomous transaction"
    When all else fails RTFM found at http://tahiti.oracle.com
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jun 2006
    Posts
    5
    Ok

    Before insulting other people you should learn a few things. Here are they:

    1. Reading.
    2. After you have mastered the 1-st one, you also should learn to understand what you are reading. And this is much more important, because this demands intellectual skills which you probably don't have.

    3. And finally, you should learn what letters JDBC mean.

    Thanks anyway
    Michael.

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >3. And finally, you should learn what letters JDBC mean.
    Why?
    Knowing "JDBC" get you no closer to your desired solution;
    while researching "AUTONOMOUS TRANSACTION" just might be what you want.

    I know how to code a JDBC connection & know enough to avoid using it when at all possible.

    When my Java coders complain that Oracle is refusing their connection request,
    I demonstrate my simple Java program succeeds from their box &
    suggest they do a better job of debugging their code & stop blaming Oracle for their own deficiencies.

    With free advice you get what you paid for it!
    YOYO!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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