Error When Executing Query

[radz]

How to solve this problem?...

Error When Executing Query
java.sql.SQLException:Data source rejected establishment of connection, messge from server:"Too many connection"

[Eranga]

May be somewhere in your code same connections are open, but not close them properly. Check that how many connections you have when you execute the query.

[daGame]

May be somewhere in your code same connections are open, but not close them properly. Check that how many connections you have when you execute the query.

Indeed. The error states that You are not closing the connection after

finishing your task. Are you using a try{} catch() {} and finally{} block?

[Eranga]

Yes, use try-catch-finally blocks and in the finally block close all open connections on your application.

[Eku]

I have encountered that same problem before. I have around 3000 connections at a time. The solution i did is i used a batch processing.
My program connects to the database every 300 entries and uses only 1 connection at a time. Try searching about batch processing in java. And make sure you close your connections after you used them ^_^

[Eranga]

Whatever the theory you follows, major thing you have to keep in mind is clear anything have to at the end of the application. But not all, some of them have to clear up on the way to end. That is the major issue you comes up with your application. I'm directing this to our thread starter. :)