File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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