Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Transaction (Oracle)

  1. #1
    Join Date
    Oct 2008
    Posts
    3

    Question Transaction (Oracle)

    I have one question.
    Is it possible in Kettel Spoon to work wit transaction on ORACLE DB ?
    I didn't find any information about this.
    I try to design transformation and job, but
    transaction did'n work.

    Can you help me ?

    Thanks...

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Of course it works with transactions ... In Oracle you don't even have a choice

    What error do you get, what do you see happening?

    Regards,
    Sven

  3. #3
    Join Date
    Oct 2008
    Posts
    3

    Default Transaction (Oracle)

    I try to design simple example.
    See attachments.

    But record in DB was written. Why ?
    Attached Files Attached Files

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    So what's actually the problem? You get your row in the database...

    Regards,
    Sven

  5. #5
    Join Date
    Oct 2008
    Posts
    3

    Default My mistake

    Sorry,
    it's my mistake.
    I didn't check "use unique connection" for transformation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.