SQLException: [Vertica][VJDBC](100161) The connection is closed

2.3k views Asked by At

I use grails, vertica, tomcat. all is working fine until about one day after the application started. i get Exceptions.

java.sql.SQLException: [Vertica][VJDBC](100161) The connection is closed.

and

[Vertica][JDBC](10040) Cannot use commit while Connection is in auto-commit mode.
1

There are 1 answers

0
KennyXu On

I solve it myself. this is caused by grails' connection pooling. I had set pooled=false in external java property file. but this won't work. i have to use groovyslurper config.