Hi, What is the Isolation level ? READ_UNCOMITTED should help u out to solve the problem.As per my understanding, u want to read the data before it is commited to the db, with in the same tx from the data base.
----- Original Message ----- From: "Ashwani Kalra" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 9:08 AM Subject: Re: Flush caching in the middle of transaction > > hi, > > I have a doubt here, On one hand you dont want to update Db till Tx ends, > while you also want to flush the data to db(ie update it in db) , Isnt > contradictory, > > > > > Dongmei Cao > <[EMAIL PROTECTED] To > NUM.COM> cc: (bcc: ashwani.kalra/Polaris) > Sent by: A Subject: Flush caching in the middle of transaction > mailing list for > Enterprise > JavaBeans > development > <[EMAIL PROTECTED] > A.SUN.COM> > > > 06/17/2003 12:37 > AM > Please respond to > Dongmei Cao > > > > > > > > Hi, > > I have a question, which is somewhat WebLogic 7 specific. If anyone > has any suggestions, it is highly appriciated! > > I have a transaction. In the first half, I use CMP beans to insert/update > data to database. After all the data are inserted/updated, I use SQL > directly to make a copy of the data. The problem I noticed is that some of > the > data are not copied. I think what is going on is that the update happened > at the end of the transaction so that the the SQL copy couldn't pick > up some of the data. I have the "delay-updates-until-end-of-tx" set to > true. > I can not really set it to false becuase it's going to cause lots of > other problems. My question is that whether there is a way to > flush the cached data into database manually. > > Thanks, > Dongmei Cao > > =========================================================================== > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > of the message "signoff EJB-INTEREST". For general help, send email to > [EMAIL PROTECTED] and include in the body of the message "help". > > > > > > =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
