|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
RE: JBoss queries aren't cached by MySQL
From: Al Caponi (don_alcaponi
yahoo.com.sg)
Date: Thu Oct 06 2005 - 04:56:59 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi again,
The query cache finally works after I've reverted to
mm.mysql-2.0.12-bin.jar.
The problem was that the query cache somehow wouldn't work within
transactions with mysql-connector-java-3.1.10-bin.jar. Anyone care to dig
further?
Here is one working combination:
Jboss 3.2.2 with transactions
JDBC: mm.mysql-2.0.12-bin.jar (3.1.10 doesn't work for me)
MySQL: 4.1.14 (Haven't tried 5.0)
Extract from http://dev.mysql.com/doc/mysql/en/query-cache-how.html
' In MySQL 4.0, the query cache is disabled within transactions (it does not
return results). Beginning with MySQL 4.1.1, the query cache also works
within transactions when using InnoDB tables (it uses the table version
number to detect whether or not its contents are still current).'
Regards,
Al
Send instant messages to your online friends http://asia.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]