No, it's not really a bug; Let's say you have objects A, B and C where C is an objject mapped onto a view joining A & B.
OJB Caches objects on their Class + PK; when you update an object, it is ejected from the cache based on it's class and PK. So, let's say C with a PK of one is references A with a PK of 2 You read from C -> C[1] is inserted in the cache You read A -> A[2] is inserted in the cache You update A -> A[2] is dropped from the cache but C[1] is still in the cache. OJB doesn't (and can't) know about the relationship between A & C If all updates are done from OJB, and if you can derive the PK of C (in the above example) from A, then you could implement some kind of listener that says "whenever A is updated, drop C from the cache" You might also be able to specify that C should never be cached (by specifying the org.apache.ojb.broker.cache.ObjectCacheEmptyImpl in object-cache element for the class in the repostory.xml) Cheers, Charles. > -----Original Message----- > From: Hiller, Frank RD-AS2 [mailto:[EMAIL PROTECTED] > Sent: 19 September 2006 14:09 > To: OJB Users List > Subject: AW: Support of database views > > Additional information: When I explicitely remove the objects > from the brokers internal cache (broker.removeFromCache(obj)) > it works. > Is it a bug? > > Frank > > -----Ursprüngliche Nachricht----- > Von: Hiller, Frank RD-AS2 [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 19. September 2006 13:56 > An: OJB Users List > Betreff: AW: Support of database views > > Hi Vasily, > > using the view as a table (following your recommendation) > shows a strange behaviour. > When a field in a table is updated and the matching object > returns the correct new value the object related to the view > (spanning two tables ) still holds the old value for a long > time (minutes). > > Have you (or soneome else) ever had such a problem? > Is there something I can configure (in ojb.properties)? > > I'm using OJB 1.0.3 with PB api. > > Frank > > -----Ursprüngliche Nachricht----- > Von: Vasily Ivanov [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 12. September 2006 01:19 > An: OJB Users List > Betreff: Re: Support of database views > > Hi Frank, > > We used to work with views without any issue, just put view's > name as "table" attribute in "class-descriptor". However, you > will only be able to read objects from that view. > > Regards, > Vasily > > On 9/11/06, Hiller, Frank RD-AS2 <[EMAIL PROTECTED]> wrote: > > Short question: I couldn't find a functionality to deal > with database > > views (create view...) within OJB. > > Is there a reason for that? > > Is the answer "use ReportQuery". > > > > Thank you, > > Frank > > > > > > > > Confidentiality note: > > The information in this email and any attachment may > contain confidential and proprietary information of > Heidelberger Druckmaschinen AG and/or its affiliates and may > be privileged or otherwise protected from disclosure. If you > are not the intended recipient, you are hereby notified that > any review, reliance or distribution by others or forwarding > without express permission is strictly prohibited and may > cause liability. In case you have received this message due > to an error in transmission, we kindly ask you to notify the > sender immediately and to delete this email and any > attachment from your system. > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > Confidentiality note: > The information in this email and any attachment may contain > confidential and proprietary information of Heidelberger > Druckmaschinen AG and/or its affiliates and may be privileged > or otherwise protected from disclosure. If you are not the > intended recipient, you are hereby notified that any review, > reliance or distribution by others or forwarding without > express permission is strictly prohibited and may cause > liability. In case you have received this message due to an > error in transmission, we kindly ask you to notify the sender > immediately and to delete this email and any attachment from > your system. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > Confidentiality note: > The information in this email and any attachment may contain > confidential and proprietary information of Heidelberger > Druckmaschinen AG and/or its affiliates and may be privileged > or otherwise protected from disclosure. If you are not the > intended recipient, you are hereby notified that any review, > reliance or distribution by others or forwarding without > express permission is strictly prohibited and may cause > liability. In case you have received this message due to an > error in transmission, we kindly ask you to notify the sender > immediately and to delete this email and any attachment from > your system. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]