openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MiƂosz <mtyle...@o2.pl>
Subject Re: no cache, direct reads from db each time..
Date Mon, 07 Jun 2010 13:51:56 GMT
Hi Nino,

If you can stick to database-specific API, check whether your database supports some sort
of change propagation mechanism.

Examples:
Oracle - Data Change Notification [1]
PostgreSQL - LISTEN/NOTIFY [2]

Regards,
Milosz

[1] http://www.oracle.com/technology/obe/11gr1_db/appdev/dcn/dcn.htm
[2] http://jdbc.postgresql.org/documentation/83/listennotify.html




> Hi
> 
> I have a case where I need to check the database on each query,
> because there can be modifications to the data from a 3rd party non
> java application. Currently I have to refresh each object, otherwise
> it could be stale data however this approach are really slow and feels
> very wrong..
> 
> Any ideas on what I could do?
> 
> regards Nino


Mime
View raw message