Search code examples
springjdbcdatabase-connectionconnection-poolingautocommit

JDBC and Spring connection pool

I would like to use connection pool for a web app and mysql dbms. If I have want to force the connection to set autocommit to false for a particular method, is it possibile that this connection (with autocommitt off) is used by other requests?

Solution

  • is it possibile that this connection (with autocommitt off) is used by other requests?

    You should always retrieve the Connection in the narrowest scope, this means, preferably as a local variable for your methods. Then, you can turn autocommit off by calling Connection#setAutocommit with false, and after using the connection object, close it. Note that this will only affect the current transaction and other requests won't be affected.