Mapper关闭mysql连接,无法关闭与MyBatis的数据库连接

What I'm doing:

I've got an AWS Lambda, written in Kotlin (JVM) which reads a message from a queue and writes something on a MySQL table.

I'm using MyBatis for this purpose, and this is a short simplified snippet of what I'm doing inside the Handler:

// initializing configuration

val dataSource = PooledDataSource(driver, url, username, password)

val environment = Environment(environmentName, JdbcTransactionFactory(), dataSource)

val configuration = Configuration(environment)

try {

val builder = SqlSessionFactoryBuilder()

val session = builder.build(configuration).openSession()

val mapper: CustomMapper = session.getMapper(CustomMapper::class.java)

mapper.doSomething()

session.commit()

} finally {

session.close()

}

My problem:

When this Lambda is executed, some connections remain opened on the database. They get destroyed only when the lambda container is automatically destroyed.

Why is this happening since I'm closing all the sessions? Is there anything that I can do in order to prevent this behaviour?

解决方案

You are using PooledDataSource which creates a connection pool. Change to UnpooledDataSource and that will likely resolve the issue.