OHDSI Home | Forums | Wiki | Github

Error running Achilles: "Cannot use commit while Connection is in auto-commit mode"

Implementers
#1

Hi,
I am getting the following error while running Achilles. It seems a Redshift JDBC driver issue, but I am not sure how to fix it. Does anyone in the community have experienced this already?
I appreciate any help! Thanks!

Connecting using Redshift driver
Executing multiple queries. This could take a while
|================== | 40%
Error: Error executing SQL:
java.sql.SQLException: [Amazon]JDBC Cannot use commit while Connection is in auto-commit mode.

#2

What did you use for createIndices parameter FALSE or TRUE? As far as I know createIndices=TRUE is not works with Redshift.

#3

You need to find out which analysis ID is trigerring the problem.

Can you run just a subset of analyses.

(see help here
https://github.com/OHDSI/Achilles/blob/master/extras/notes.md )

achilles(......,analysisIds = c(1:12))
#4

Thanks a lot for your replies.

I finally solved the error.
You might be interested to know that the problem was the Redshift driver. I solved it by installing the latest version of the ohdsi/DatabaseConnector package, which has the recently updated driver.

t