#84 Autocommit required

v2.1
closed-invalid
Bug (232)
5
2009-03-02
2005-02-03
Stephen
No

It would appear as though DBUnit requires autocommit to
be set to true. This is not the default behavior for
the new DB2 JDBC type 4 driver.
This causes several problems when using the
maven-dbunit-plugin and DB2. Noteably, the data is
loaded, but never commited so all the inserts are
rolled back.

DBUnit should either set autocommit to true before
starting any of its work or it should perform a commit
at regular intervals.

Discussion

  • matthias g

    matthias g - 2008-12-30

    Is this still an issue? If so, could you give me some more hints where you would expect this to happen?

    Did you try to do the same thing with the ant task? In the ant "DbUnitTask.createConnection()" the it is always invoked "jdbcConnection.conn.setAutoCommit(true)".

    regards,
    mat

     
  • matthias g

    matthias g - 2009-02-28
    • status: open --> pending
     
  • matthias g

    matthias g - 2009-02-28

    There is also the possibility to wrap an operation into a transaction using the DatabaseOperation.TRANSACTION operation. I think dbunit offers possibilities to handle this whereas I of course agree that it should work just out of the box. Setting this item to pending waiting for any response by a DB2 user...

     
  • Stephen

    Stephen - 2009-03-02

    according to the spec, autocommit should be set to true for new db connections, so this was more than likely a bug in the db2 driver I was using at the time.
    I'm not using db2 anymore, so I don't know if it's still an issue.

     
  • Stephen

    Stephen - 2009-03-02

    according to the spec, autocommit should be set to true for new db connections, so this was more than likely a bug in the db2 driver I was using at the time.
    I'm not using db2 anymore, so I don't know if it's still an issue.

     
  • Stephen

    Stephen - 2009-03-02
    • labels: -->
    • status: pending --> pending
     
  • Stephen

    Stephen - 2009-03-02
    • labels: --> Bug
    • status: pending --> closed-invalid
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks