New answers tagged

1

Sounds like you are not properly deallocating objects like Statement, ResultSet, etc., so your application is holding open statement handles in the database. This will eventually exhaust "CLI Packages" in the database, resulting in the SQL0805N error. The proper solution is to make sure that you close these as soon as you're done reading them. You may ...


1

Suppose you have a web app with no connection pooling. Now suppose, also, that your web app leaks connections (does not close them properly - for example: by not using finally blocks in java). Leaky connections are much more problematic with a long wait-timeout (the default is 8 hours). The app will quickly run out of connections (mysql's "Too many ...



Top 50 recent answers are included