Please use the google group to ask questions - thanks.

by satinder 25 Apr 08:20
How do i close database connections when using Future list ..?

i am getting above mentioned error every time i refresh my page...it seems connection are not getting closed...

can any1 help me on this?


Here's my properties file content
datasource.default=mysql

datasource.mysql.username=test
datasource.mysql.password=test
datasource.mysql.databaseUrl=jdbc:mysql://172.25.14.195:3306/test?characterEncoding=UTF-8&allowMultiQueries=true&sessionVariables=storage_engine=InnoDB
datasource.mysql.databaseDriver=com.mysql.jdbc.Driver
datasource.mysql.minConnections=1
datasource.mysql.maxConnections=5

Getting Error when all connection in pool are used up is :-
javax.persistence.PersistenceException: java.sql.SQLException: Unsuccessfully waited [1000] millis for a connection to be returned. No connections are free. You need to Increase the max connections of [5] or look for a connection pool leak using datasource.xxx.capturestacktrace=true

Create a New Topic

Title:
Body:
 
Introduction User Guide (pdf) Install/Configure Public JavaDoc Whitepapers
General Database Specific Byte Code Deployment Annotations Features
Top Bugs Top Enhancements
woResponse