File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
java.sql.SQLException: Limit on number of statements exceeded
Joined: Oct 29, 2009
Jun 09, 2010 07:00:07
I'm connecting to an AS400 database and seem to be getting this
, I have double checked my code and every statement I create for this connection is closed as soon as I'm done using it.
I recreate the connection each time, instead of reusing the statement but I'm very confident I close it in every location that I create it?
Is there any other reasons why I could be getting this exception?
Joined: Oct 23, 2005
Jun 09, 2010 12:26:04
You probably are forgetting to properly close a statement, connection, or result set.
[OCA 8 Book]
Joined: Dec 01, 2007
Jun 10, 2010 01:23:53
Can you please post some more lines and message of this SQLExeception ? So that we can investigate it.
I agree. Here's the link:
subject: java.sql.SQLException: Limit on number of statements exceeded
Oracle -- Closing Statements
"Cannot get a connection" exception
FTP Client MultiThread
Connection pooling vs using a single connection
Make Connection to Database in JSP
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015