Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: regarding unique db connection

  1. #1

    Question regarding unique db connection

    hi all,

    i have a transformation in which i use unique connection option(that is there in the transformation setting) so that roll back can take place if some db error occurs. But i run this transformation from a java API... while doing so the table output statement's as are not working properly.. ie it is not inserting data into the table. and not giving me an error in the logs that are being generated..

    can any one suggest any solution

    regards
    sarat kiran

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

    Default

    That's too little information:
    - Does it work without unique connections. Maybe you're just doing it wrong
    - For the rest attach transformation and trace file you get.

    Regards,
    Sven

  3. #3

    Default

    Thanks for the reply

    I am trying to insert data in multiple table (around 60-70 tables)

    when i run my transformation through ETL Kettle tool with unique connection checkbox checked, it works perfectly. but when i unselect this i get too many connection error.

    the constrain is ( i need to run the .ktr through java API classes.) now the problem that i face is... "when the checbox is not selected it gives me the same error saying too many connection error(while running form java).
    but if i checked (unique connection checkbox) , it works but nothing is inserted the DB. and there is no error logs as well.

    if there are no exceptions or errors in the logs why my DB is not getting populated that is what i am not able to figure out.

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

    Default

    still a deadlock somewhere?

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.