Well, that's my guess... > -----Original Message----- > From: Hiller, Frank RD-AS2 [mailto:[EMAIL PROTECTED] > Sent: 19 September 2006 15:08 > To: OJB Users List > Subject: AW: Support of database views > > Ok, I see. > Setting > <object-cache > class="org.apache.ojb.broker.cache.ObjectCacheEmptyImpl"/> > on the specific table (that actually is a view) resolves the problem? > > Frank > > -----Ursprüngliche Nachricht----- > Von: Charles Anthony [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 19. September 2006 16:04 > An: OJB Users List > Betreff: RE: Support of database views > > Yes, but all (by default) all reads ARE transparently cached > (to improve performance). > > So if you've read C, then you do an update of A or B, then > you re-read C - you will not see the updates but the OLD version of C. > > It's a bit difficult to explain, and I'm obviously not being > very clear. > > > > -----Original Message----- > > From: Hiller, Frank RD-AS2 [mailto:[EMAIL PROTECTED] > > Sent: 19 September 2006 14:52 > > To: OJB Users List > > Subject: AW: Support of database views > > > > I do not expect to automatically update the object in cache > > representing the view. > > After the update of A or B I explicitely read the view. At > that point > > my expactation was to retrieve the new value. The SQL statement > > returns the correct (new) value, but ojb uses the object from the > > cache with the old value. This confuses me a little. > > > > Best regards, > > Frank > > > > > > -----Ursprüngliche Nachricht----- > > Von: Charles Anthony [mailto:[EMAIL PROTECTED] > > Gesendet: Dienstag, 19. September 2006 15:23 > > An: OJB Users List > > Betreff: RE: Support of database views > > > > 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] > > > > > > > --------------------------------------------------------------------- > > 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] > > > > 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]
