Liquibase update doesn't close connections, when web application keeps running

[pmihalcin]

Given I have web application and enable liquibase updates with liquibase.enabled=true.
The application connects to Oracle db.
Let's say I have 2 users/schemas, one for deployment, second one for the application:

• appdeploy
• appuser

Application properties look like:

• liquibase.url=jdbc:oracle:thin:@localhost:1521:XE
• liquibase.user=appdeploy
• liquibase.password=appdeploy
• spring.datasource.url=jdbc:oracle:thin:@localhost:1521:XE
• spring.datasource.username=appuser
• spring.datasource.password=appuser

When I boot up the application (whereas liquibase update is executed) and I try to DROP USER appdeploy CASCADE;
Then I get ORA-01940: cannot drop a user that is currently connected
what indicates web application didn't release db connections

[philwebb]

It's possible that the appuser connection is established before liquibase gets a chance to run with the appdeploy connection. Do you have a sample application that you can share that demonstrates the problem?

[pmihalcin]

Hi Phil,
I pushed sample app here: https://github.com/pmihalcin/liquibase-sample

[wilkinsona]

I think the problem is that we use DataSourceBuilder to create the Liquibase-specific DataSource. It will be using a connection pool so it will create and keep open whatever the default number of connections is for the pool. I think we need to do one of the following:

• Bypass the connection pool entirely
• Tune it so that it doesn't keep any connections open
• Close it once Liquibase has migrated the database.