Someone PLEASE help!
Environment:
multiple webapps under Tomcat 5.5, MySQL, JDBC, Hibernate3, using SessionFactory
Problem:
Database changes in an application are not seen in the other applications until Tomcat is restarted OR I see this in the mysql log file:
Code:
26 Connect root@localhost on mydatabase
26 Query SET NAMES latin1
26 Query SET character_set_results = NULL
26 Query SHOW VARIABLES
26 Query SHOW COLLATION
26 Query SET autocommit=1
26 Query SET autocommit=0
So, it seems that each time I get a new connection, I get the latest data. The question is, why don't I get the latest data using an existing connection?
Notes:
- second-level caching is disabled
- show_sql is on, hibernate reports all queries on each request
- mysql's query log in on, all queries reported on each request
I have read just about every post here related to caching and I can't solve my problem.
If someone can help me with this, I would really appreciate it.
Login
FAQ
Search