aspose file tools*
The moose likes JDBC and the fly likes On small stress getting Exhausted Resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "On small stress getting Exhausted Resultset" Watch "On small stress getting Exhausted Resultset" New topic
Author

On small stress getting Exhausted Resultset

Dale Carnegie
Greenhorn

Joined: Oct 12, 2007
Posts: 9
He,everybody!

My program works just fine for one user. But when I stress my application with 300 transactions per minute (avg 5/sec) i am getting an error (1 transaction of 300 failed).
When i stress with 1000 about 100 transactions are failed.
And I can't understand what's wrong.

The error:



Piece of code:



Can't you tell me what may be wrong and how to troubleshoot this?




A dreamer is one step behind the achiever, and the achiever was once a dreamer.
Tom Reilly
Rancher

Joined: Jun 01, 2010
Posts: 618
I assume that multiple threads can call the method you post. Can you post the implementation of getConnection()?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: On small stress getting Exhausted Resultset