This would defy transaction atomicy -- you could get data without corresponding JMS notification.
> -----Original Message----- > From: Gaetan Zoritchak [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 01, 2003 4:11 PM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] managed transaction problem > > > If you use a CMP to insert your data in the database you will > be able to > do the insertion in a new Tx ( Requires New ). When the SLSB > will send > its message the commit will already be done. > > > -- > Gaetan Zoritchak > Bright Side Factory > http://www.bs-factory.com > > David Ward wrote: > > Hello, all. > > > > I'm having transaction trouble with jboss-3.0.6/jetty, jdk > 1.4.1_02 and Oracle > > 9i w/ojdbc14.jar. Please see the ASCII-art diagram below > (hopefully it will > > line up for everyone). > > > > Client > > | > > (1) > > | > > V > > SLSB--(2)-->[Oracle] > > | ^ > > (3) | > > | | > > V | > > JMS Topic (5) > > | | > > (4) | > > | | > > V | > > Subscriber-------+ > > > > Step: > > (1) Client calls SLSB (stateless session bean) > > (2) SLSB puts new data into Oracle database > > (3) SLSB sends a message to a JMS Topic saying data has been created > > (4) Topic notified Subscriber > > (5) Subscriber pulls new data from database > > > > All that gets sent to the Subscriber is the key for the new > data that was > > successfully inserted by the SLSB. The problem is that > when the Subscriber goes > > to pull the data from Oracle, it's not there (yet!). From > what I can tell, the > > JDBC Connection the SLSB was using hasn't been commited > yet, so the Connection > > the Subscriber is using can't see the inserted data yet. > > > > Right now I have transaction type of Required on the SLSB, > but I've tried > > RequiresNew and that doesn't work. I've also tried > NotSupported and Never for > > hope of doing my own JDBC Connection commit, but then the > > org.jboss.adapter.jdbc.local.LocalManagedConnection > complains that I can't do my > > own commit (or change the autoCommit setting) during a > managed transaction. > > > > Please help! Any and all suggestions welcome. > > > > Thanks, > > David ------------------------------------------------------- This SF.net email is sponsored by: ValueWeb: Dedicated Hosting for just $79/mo with 500 GB of bandwidth! No other company gives more support or power for your dedicated server http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
