RV: Session & Context variables architecture problem

[falvarez]

Dear All,

                I'm currently using Tomcat 6.0.28 and having some doubt on
how to solve and implement this problem:

 

                               My webapp has a MySQL Database with a table
named "parameters", in which we have just two columns ("property" and
"value"). This table is acceded many times but doesn't change often.

 

                               For performance purposes I want to save this
parameters in the user's tomcat session, so they are read from memory and
not database. So far so good.

 

                               Now the problem: how can I tell this sessions
that an attribute has changed?

 

                I had suggestions of using "context variables" instead of
"session variables", but that didn't solve the problem.

 

Any help in this matter is more than welcome. I have no problem in changing
the approach, and may be not use sessions at all.

 

Thanks in advance.

 

Best regards,

                Federico Alvarez.

 

Info:

                Tomcat 6.0.28

                Java 1.6

                MySQL 5.5

                NOT USING HIBERNATE, so 2nd Level cache is not an option