What does: "Cannot commit when autoCommit is enabled” error mean?

Question

In my program, I’ve got several threads in pool that each try to write to the DB. The number of threads created is dynamic. When the number of threads created is only one, all works fine. However, when there are multi-thread executing, I get the error:

org.apache.ddlutils.DatabaseOperationException: org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled.

I’m guessing, perhaps since each thread executes in parallel, two threads are trying to write at the same time and giving this error.

Do you think this is the case, if not, what could be causing this error?

Otherwise, if what I said is the problem, what I can do to fix it?

Answer 1

In your jdbc code, you should turn off autocommit as soon as you fetch the connection. Something like this:

DataSource datasource = getDatasource(); // fetch your datasource somehow
Connection c = null;
try{
  c = datasource.getConnection();
  c.setAutoCommit(false);