SQLException

[chuq2001]

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

 

[sedj]

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

 

[chuq2001]

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

Chuck

 

[confusedone]

If you are using Oracle. Check out last month Oracle Magazine, they got a good article on JDBC connection tips.