• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Mitch Robinson
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author
Saloon Keeper
Posts: 4020
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You probably are forgetting to properly close a statement, connection, or result set.
 
Rahul Nair
Ranch Hand
Posts: 138
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hello Mitch,

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

Thanks,

Rahul
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic