I am using the PostgreSQL JDBC (JDBC4) driver to connect to a local installlation with postgresql 9.2.3.
It works quite well reading from the database on multiple threads, but I can only write successfully if I write only to only one Database Writer. If I try to write to two or more (different tables and everything, I think), then it returns an error complaining about autoCommit settings:
ERROR Database Writer Execute failed: Cannot commit when autoCommit is enabled.
Is there any way to set this to True/False? It seems like there could be another option that allows this to be set for postgres.
Thanks,
Eric
P.S. I wonder if this has anything to do with it: