Skip to content
This repository was archived by the owner on Nov 9, 2017. It is now read-only.

Probably is occurring a connection leak in MyBatis Migrations 3.1.1 #691

Open
GoogleCodeExporter opened this issue Apr 21, 2015 · 3 comments

Comments

@GoogleCodeExporter
Copy link

What version of the MyBatis are you using?
3.1.1.


Please describe the problem.  Unit tests are best!
My project has more than 650 migrations and it uses Oracle XE 10g Database. 
When I run "migrate up" I'm usually getting this error "ORA-12519, TNS:no 
appropriate service handler found".

This error normally occurs when Oracle has no more connection in connection 
pool or there's no more possibility to create new processes.

This error always happened to me when I was using a version prior to 3.0.6, 
after upgrading to the version 3.0.6 it doesn't happen anymore. But recently 
after upgrading to version 3.1.1 this same error came back to make me sad.

I think MyBatis Migrations is not closing connections properly (maybe on the 
right time) or really there's a kind of connection leak. Is Mybatis Migrations 
using an internal connection pool? 


What is the expected output? What do you see instead?
Not receive the error "ORA-12519, TNS:no appropriate service handler found".

Can you provide stack trace, logs, error messages that are displayed?
[java] ------------------------------------------------------------------------
[15:52:16][java] MyBatis Migrations FAILURE
[15:52:16][java] Total time: 11s
[15:52:16][java] Finished at: Tue Oct 09 15:52:16 BRT 2012
[15:52:16][java] Final Memory: 2M/118M
[15:52:16][java] 
------------------------------------------------------------------------
[15:52:16][java] 
[15:52:16][java] ERROR: Error executing command.  Cause: 
org.apache.ibatis.migration.MigrationException: Could not create SqlRunner. 
Cause: java.sql.SQLException: Listener refused the connection with the 
following error:
[15:52:16][java] ORA-12519, TNS:no appropriate service handler found
[15:52:16][java] The Connection descriptor used by the client was:
[15:52:16][java] 172.16.50.5:1521:XE

Please provide any additional information below.

Original issue reported on code.google.com by rpo...@gmail.com on 9 Oct 2012 at 7:44

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant