In this blog post, let’s learn about the error message “257 System limit on maximum number of statements exceeded, maximum is count.” in Hydra and the description of the error.
Error Message
257 System limit on maximum number of statements exceeded, maximum is count.
Error Details
The database server cannot execute this COMMIT WORK or ROLLBACK WORK statement because no BEGIN WORK was executed to start a transaction. Because no transaction was started, you cannot end one. Any database modifications that were made are now permanent; they cannot be rolled back but do not need to be committed. Review the sequence of SQL statements to see where the transaction should have started.
This error can occur when you open a cursor for update and have not started a transaction yet.