Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Transaction Commit Issue

  1. #1

    Default Transaction Commit Issue

    Hi,

    I am trying to run a transformation on an APP server. The kettle is basically integrated with my application and i trigger the transformation through my application.

    My application makes a call to the kettle transformation within a created transaction. The kettle transformation however has a DB insert operation step, i.e. a table output step which inserts records in my database table.
    The transformation also tries to create another transaction to do the insert operation and fails with the following error trace.

    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Can't turn auto commit off
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error disconnecting from database:
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error comitting connection
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : You cannot commit during a managed transaction!
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error comitting connection
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : You cannot commit during a managed transaction!
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.commit(Database.java:635)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.commit(Database.java:605)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.disconnect(Database.java:496)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.beginProcessing(Trans.java:1443)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:523)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.execute(Trans.java:275)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:897)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:446)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:547)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:547)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:332)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:299)
    .
    .
    .
    .
    2009/08/19 19:11:09 - Kettle_Conn - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.sql.SQLException: You cannot commit during a managed transaction!
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:543)
    2009/08/19 19:11:09 - Kettle_Conn - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:334)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.commit(Database.java:625)
    2009/08/19 19:11:09 - Kettle_Conn- ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 111 more
    2009/08/19 19:11:09 - Table output.0 - Connected to database [Kettle_Conn] (commit=0)
    2009/08/19 19:11:09 - [LinkedItemSupport_Staging].[Input Date Filter].Date_Extract_Filter - Dispatching started for transformation [Date_Extract_Filter]


    Is there any way to make the kettle use the current transaction to commit?

  2. #2

    Default

    Is there a way to disbale craetion of transactions in kettle while writing to DB?

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.