It was a good guess then ! Glad I could help,
Charles. > -----Original Message----- > From: Hiller, Frank RD-AS2 [mailto:[EMAIL PROTECTED] > Sent: 19 September 2006 15:26 > To: OJB Users List > Subject: AW: Support of database views > > Yes, it works. > Thank you............Frank > > -----Ursprüngliche Nachricht----- > Von: Charles Anthony [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 19. September 2006 16:09 > An: OJB Users List > Betreff: RE: Support of database views > > 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] > > > > 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]