1 Reply Latest reply on Apr 21, 2005 11:30 AM by Rafal Kedziorski

    JBoss queries aren't cached by MySQL

    Rafal Kedziorski Novice

      Hi,

      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?


      Regards,
      Rafal

        • 1. Re: JBoss queries aren't cached by MySQL
          Rafal Kedziorski Novice

           

          "rafcio" wrote:
          Hi,

          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?


          Regards,
          Rafal


          The MySQL version is the problem:

          "In MySQL 4.0, the query cache works only with autocommit enabled. This restriction is removed in MySQL 4.1.1 and up."