Too many connections

[Santhosh Reddy]

Anyone please tell me the possible problem in getting the below mentioned error


Environment: Tomcat5.5 Mysql 5.0 Ibatis
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2644)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:580)
at com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:222)
at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)
at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:565)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:540)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:84
[ March 10, 2008: Message edited by: Santhosh Reddy ]

[Roger Chung-Wee]

Are you closing the connection after usage?

[Santhosh Reddy]

Originally posted by Roger Chung-Wee:
Are you closing the connection after usage?

Connection closing is not required as i'm using iBATIS

[Roger Chung-Wee]

Failure to close connections causes lots of problems, regardless of whether or not you are using a mapping framework.

[Suraj Berwal]

Originally posted by Santhosh Reddy:


Connection closing is not required as i'm using iBATIS

Check whether iBATIS is closing the unused connections.

I feel you will have to explicitly close connections using iBATIS when they are not in use.

It seems iBATIS is opening up lot of new connections without disposing existing unused connections.

Thanks,
Suraj

[Santhosh Reddy]

we dont get any connection directly, we get only the sqlmaps,is it required to make the sqlmap reference to null.

[Suraj Berwal]

You will have to consult the iBATIS documentation/manual for that. I am sorry I haven't worked on iBATIS so exact mechanism is not known to me.

Suraj