aspose file tools*
The moose likes JDBC and the fly likes java.sql.SQLException: Limit on number of statements exceeded Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: Limit on number of statements exceeded" Watch "java.sql.SQLException: Limit on number of statements exceeded" New topic
Author

java.sql.SQLException: Limit on number of statements exceeded

Mitch Robinson
Ranch Hand

Joined: Oct 29, 2009
Posts: 30
Hi guys,

I'm connecting to an AS400 database and seem to be getting this SQLException, 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?

thanks,
Mitch
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3697
    
    5

You probably are forgetting to properly close a statement, connection, or result set.


My Blog: Down Home Country Coding with Scott Selikoff
Rahul Nair
Ranch Hand

Joined: Dec 01, 2007
Posts: 138

Hello Mitch,

Can you please post some more lines and message of this SQLExeception ? So that we can investigate it.

Thanks,

Rahul
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: Limit on number of statements exceeded
 
Similar Threads
Connection pooling vs using a single connection
Make Connection to Database in JSP
FTP Client MultiThread
Oracle -- Closing Statements
"Cannot get a connection" exception