search

mybatis / spring

Spring integration for MyBatis 3
Apache License 2.0
2.81k stars 2.6k forks source link

Mybatis keeping inactive session in oracle db even after closing the session #570

Closed Sejalgo closed 1 year ago

Sejalgo commented 3 years ago

Hi, We have recently migrated from ibatis to mybatis .We are using mybatis 3.5.6 and mybatis-spring 2.0.5 version and spring version 5.2.9.RELEASE. We are using following code for connection 

SqlSession session = getSqlSession();
session.insert( Name, insertname );

and for the batch methode

final SqlSession session =  getSqlSessionFactory().openSession(ExecutorType.BATCH);
session.insert( Names, insertnames );

After using this code it has been observer there are many inacative session at oracle db side . Let us know thw issue or any property we are missing

kazuki43zoo commented 3 years ago

@Sejalgo Sorry for late reply.

I cannot investigate by provided information. Could provide more detail informations or/and a small reproduce project?

kazuki43zoo commented 1 year ago

Close because no reply at long time. Of course you can reopen at any time.