Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQLException

Status
Not open for further replies.

chuq2001

Programmer
Jul 15, 2002
24
US
I'm querying a database from a servlet and I get an SQLException: Limit on statements exceeded. This happens when two clients try using the servlet.

any help?

Chuck t
 
I've never encountered this error before, but
I think it could be for a number of reasons -

maye you are trying to pass too many SQL transactions to the db - have you got autocommit on or off ? Are there restrictions on how many transactions you can submit simultaneously ?

are you connection pooling your servlet to db connections ? If not, then the db may be falling over if trying to connect on same port ?

Can you post back exact error message and the db you are using ...


Ben
 
Thanks,
I got it figured out. I wasn't closing my statements after I used them.

Chuck
 
If you are using Oracle. Check out last month Oracle Magazine, they got a good article on JDBC connection tips.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top