Markus, if that's the case, why not (if the volume of the inserts/updates is not too high) use the same Castor instance for these operations, allowing Castor to update its caches based upon the values inserted into/updated in the database. Having said that, with Castor 0.9.9. the restriction that it has to be the same Castor instance will go, as I am currently adding support for distributed caches to Castor JDO.
If the volume of the data is too high for using Castor for inserting/updating data, you will have to follow my advice as outlined below with regards to disbaling/reconfiguring the caches. Regards Werner wg> -----Original Message----- wg> From: Markus Sell [mailto:[EMAIL PROTECTED] wg> Sent: Friday, June 17, 2005 12:30 AM wg> To: dev@castor.codehaus.org wg> Subject: AW: [castor-dev] Import data to the database and see it wg> directly via JDO wg> wg> wg> Hi, wg> wg> the script is synchronizing the data with data from another wg> database. so there are inserts and updates of existing data wg> in my databaes connect by JDO. wg> wg> the script doing the synchronisation is just an ant task i wg> have written myself (similar to the sqltask included by ant). wg> wg> regards, wg> markus wg> wg> -----Ursprüngliche Nachricht----- wg> Von: Werner Guttmann [mailto:[EMAIL PROTECTED] wg> Gesendet: Do 6/16/2005 22:53 wg> An: dev@castor.codehaus.org wg> Cc: wg> Betreff: Re: [castor-dev] Import data to the database wg> and see it directly via JDO wg> wg> wg> wg> Nick, wg> wg> you are right that we don't know about the nature of wg> the inserted data wg> (whether it includes updates to existing data, etc.), wg> so some of my wg> remarks apply to specific scenarios only. But let's wg> hear more about the wg> data inserted before coming up with any additional advice. wg> wg> Werner wg> wg> Nick Stuart wrote: wg> > Also, if you are doing new inserts you will to wg> re-pull/select the wg> > objects in question. A clearer example of the process wg> you are doing, wg> > from the script running to the jdo loading would be good. wg> > wg> > *Werner - My only thought on this is that the objects wg> aren't in the wg> > cache/or related to the cache at all if they are just wg> being inserted, wg> > and should still load fine. Now, if he is inserted wg> child objects of wg> > some pre-existing object he would have issues. wg> > wg> > -Nick wg> > wg> > On 6/16/05, Werner Guttmann wg> <[EMAIL PROTECTED]> wrote: wg> > wg> >>Markus, wg> >> wg> >>if you are using caches, this will be a problem per wg> definition, as you are using a SQL script outside of Castor wg> to insert data into your database. You've got some options, wg> some of which might suite your needs: wg> >> wg> >>a) Turn-off caches (which might eventually lead to a wg> performance penalty). wg> >>b) Use one of the CacheManager.expire() methods. wg> >>c) Switch your cache type to time-limited (with a wg> potential short timeout period). wg> >> wg> >>Regards wg> >>Werner wg> >> wg> >>wg> -----Original Message----- wg> >>wg> From: Markus Sell [mailto:[EMAIL PROTECTED] wg> >>wg> Sent: Thursday, June 16, 2005 11:53 AM wg> >>wg> To: dev@castor.codehaus.org wg> >>wg> Subject: [castor-dev] Import data to the database and see wg> >>wg> it directly wg> >>wg> via JDO wg> >>wg> wg> >>wg> wg> >>wg> Hi, wg> >>wg> wg> >>wg> my application is accessing the database via jdo. I wg> >>wg> importing data with a script directly into the database. wg> >>wg> But I don't see the data via my JDO connection. After a wg> >>wg> restart eveything is fine. wg> >>wg> How I can do it online? Do I have to use the wg> "expire" feature? wg> >>wg> wg> >>wg> regards, wg> >>wg> markus wg> >>wg> wg> >> wg> > wg> > ------------------------------------------------- wg> > If you wish to unsubscribe from this list, please wg> > send an empty message to the following address: wg> > wg> > [EMAIL PROTECTED] wg> > ------------------------------------------------- wg> > wg> > wg> wg> wg> ------------------------------------------------- wg> If you wish to unsubscribe from this list, please wg> send an empty message to the following address: wg> wg> [EMAIL PROTECTED] wg> ------------------------------------------------- wg> wg> wg> wg>
