JBoss queries aren't cached by MySQL

[rafcio]

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

[rafcio]

"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."