Connection is not getting closed for MSSQL Server 2005 (Developer) for sa (admin) user. since admin user has only one dedicated connection database is throwing exception. I tried with other users too but getting the same exception.
Is there any way to close the connection in Ibatis or spring config file which was created by Spring bean
my Spring configuration
<jee:jndi-lookup id="dataAccess.dataSource" jndi-name="jdbc/myJNDI"/>
I am referring the above bean in IBATIS configuration to get the connection object
This setup is working fine for inserting the single records but when i try to insert the multiple (20+) records then it fails with exception : http://forum.springframework.org/showthread.php?t=41634
After looking into the database log it come to know that connection is not getting closed.
Is there any way to close the connection explicitly either in configuration file or in IBATIS generated code.