changes to entity bean data doesn't have to be written to the database until the end of the transaction - or until a finder is executed.
so you're not seeing it because its not updated - you then call the finder, JBoss updates the db, and then you can see it. cheers dim ----- Original Message ----- From: "Saroj Kumar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 03, 2002 10:40 AM Subject: [JBoss-user] How is TRANSACTION handled (jboss 3.0 , ORACLE 9i) > Hi, > > I am puzzled by this sequence of events. Any hint?? > > I am having a session bean which is running under transaction. It calls > a > JAVA Class. This java class makes 1st call to a Session Bean. This > session > bean B invokes method on a Entity Bean. Then it invokes another Session > > Bean C which makes Direct JDBC calls to DB for the data updated by > Session B > using Entity Bean. All this happens in one method which by the virtue of > being > Invoked by a Session bean which is under a transaction also participates > in TX. > > PROBLEM: JDBC calls show that there is no data INSERTED in earlier call > to Session > Bean B. SELECT for the inserted data does not return any row. It is as > if no insert is > Working. > > Scenario is : > > Session Bean A ---> Java Class -- Session Bean B --- Entity Bean EB1 , > EB2 > +-- Session Bean C --- jdbc > call > > PUZZLE: > I added some EJB finders on my CMP using ejb-ql and get the > correct data in the same > Method. Once this finder is called then all JDBC calls show correct > result. > > Please note that Session Bean c gets its own SQLConnection from > javax.sql.DataSource. > > Why is it so? I think that even if Session Bean C gets its own > connection, it should be > Part of TX started in Session Bean A and should return correct result > for all the updates/INSERT > By Session Bean B. > > Please help. > > TIA, > Saroj > > > > ------------------------------------------------------- > This sf.net email is sponsored by: OSDN - Tired of that same old > cell phone? Get a new here for FREE! > https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
