[SOLVED] reload union objects from database

[niraj]

We are using mysql database wth union
we have a huge web app that needs to change database values
eg. points when user land to user site.

we update mysql database directly (with out trying to connect union server via php)
the problem is the values @ union server does not change (read latest from db) until union server is restarted

is there a way to clean cache (hibernate's evict ) for union objects .
we tried

Code: Select all

<property name="hibernate.cache.use_query_cache">false</property>
<property name="hibernate.cache.use_second_level_cache">false</property>


in uhibernate.cfg.xml but does not help

[paala]

In my app i use client Attributes with flag persistent , like in the tutorial.
If i manually change a value in mysql , this value is reflected automatically in union server

[Armand]

I noticed this problem too.

If an attribute is changed in the database, the change may or may not be picked by Union, depending on its cache status.

Temporary workaround: make sure db changes are made through Union, not directly (may not be always feasible).

A "clear cache" admin command would work miracles.

[derek]

Hey guys,

Would the ability to clear the cache such that the next time an account is logged-in you could guarantee that the data was retrieved from the datasource be very helpful even if it did not automatically synchronize any active accounts? Examples:

Example 1

• Client logs into account.
• Client logs out of account.
• Third-party changes made to persistent attributes of the client.
• Cache is cleared.
• Client logs into account and changed persistent attributes are retrieved from the database.

Example 2

• Client logs into account.
• Third-party changes made to persistent attributes of the client.
• Cache is cleared.
• Client still shows the pre-change attributes.
• Client logs out of account.
• Client logs into account and changed persistent attributes are retrieved from the database.

Thanks,

Derek

[Armand]

Hi Derek,

yes, the mechanism would be satisfactory. It would solve a lot of headaches.

[derek]

Ticket at http://factory.user1.net/issues/show/698.

[cripito]

Hey derek

There is any way to launch a ATTR_CHANGE event when 3rd party modify the database?

regards
saul