Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Cannot use commit while auto commit mode is on

  1. #1
    Join Date
    Aug 2017
    Posts
    1

    Default Cannot use commit while auto commit mode is on

    I have to run jobs created by others and I am pretty new to Pentaho. On several steps I am consistently getting this error:
    [Amazon][JDBC](10040) Cannot use commit while Connection is in auto-commit mode.

    When we try running the job on someone else's computer, it works fine. I am not sure if there is a setting I am missing or if its a driver issue. Your help is really appreciated

  2. #2
    Join Date
    Apr 2014
    Posts
    18

    Default

    On what steps do you get this error? Check if there is a difference in the database connections in both the machines.

    Quote Originally Posted by jasminh View Post
    I have to run jobs created by others and I am pretty new to Pentaho. On several steps I am consistently getting this error:
    [Amazon][JDBC](10040) Cannot use commit while Connection is in auto-commit mode.

    When we try running the job on someone else's computer, it works fine. I am not sure if there is a setting I am missing or if its a driver issue. Your help is really appreciated

  3. #3
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    If it is the EXACT SAME KTR, then check the drivers and check the kettle.properties file. It's likely a difference in the driver version.

Tags for this Thread

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.