EJB programming & troubleshooting: JBoss queries aren't cached by MySQL
- Posted by: Rafal Kedziorski
- Posted on: April 21 2005 10:33 EDT
we have the problem, that queries generated by JBoss or our code which runns under JBoss will be not cached by MySQL. The same query sendet from an external application or MySQLFront will be cached by the same MySQL.
Any idea why?
"In MySQL 4.0, the query cache works only with autocommit enabled. This restriction is removed in MySQL 4.1.1 and up."