You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community, you will:
have access to post topics
communicate privately with other members (PM)
not see advertisements between posts
have the possibility to earn one of our surprises if you are an active member
access many other special features that will be introduced later.
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.
__________________
Use an appropriate Subject. "Help, urgent!" isn't one. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Has someone helped you? Then you can To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. their helpful post.
Want to make your IDE the best? To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
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?
Yes, use try-catch-finally blocks and in the finally block close all open connections on your application.
__________________
Use an appropriate Subject. "Help, urgent!" isn't one. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Has someone helped you? Then you can To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. their helpful post.
Want to make your IDE the best? To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
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 ^_^
__________________
Mind only knows what lies near the heart, it alone sees the depth of the soul.
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.
__________________
Use an appropriate Subject. "Help, urgent!" isn't one. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Has someone helped you? Then you can To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. their helpful post.
Want to make your IDE the best? To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
ata source rejected establishment of connection, messge from server:"Too many connection"
Linear Mode
