The object is not found because the transaction has not yet committed. By making the CMP TX_SUPPORTS you are enlisting it in the transaction of the SB. That means that the CMP is not committed to the DB until the SB commits.
I recommend that you read a book on OLTP. a good one is the Bernstein/Newcomer book "Principles of OLTP". I don't have it to hand but if you need the ISBN I can dig it out for you.
> -----Original Message-----
> From: Weißböck Maximilian [mailto:[EMAIL PROTECTED]]
> Sent: 11 May 2000 10:01
> To: 'JOnAS User'
> Cc: 'JOnAS Dev'
> Subject: URGENT: Heavy troble with Transactions - PLEASE HELP!
>
>
> We have a massive show-stopping problem using JOnAS 1.6.1
>
> In a Session Bean we have a method 'updateData()'
> (with attribute TX_REQUIRED) that calls methods from a
> CMP (with attribute TX_SUPPORTS).
>
> In a CMP method 'updateBuchungszeile()' we change a
> field 'buchungszeile' from eg. '333' to '555'.
>
> Still inside the SB method 'updateData()' we call the
> CMP finder method 'findByBuchungszeile()' with the value 555
> but we get a ObjectNotFoundException!!! Why???
>
> Even more misterious, if we do, imediatly after (or before)
> the 'findByBuchungszeile()' a 'findByPriamrayKey()' of the
> record where we changed 'buchungszeile' and print out
> the data, we see the expected value '555'.
>
> Why can't the 'findByBuchungszeile()' not see this value '555'???
>
>
> If whe change the TX attributes to TX_NOT_SUPPORTED the
> 'findByBuchungszeile()' works ok and finds the modified record,
> but we can not use this the solution, as we can not do a rollback
> if the 'updateData()' finds any error.
>
> We use Database Oracle 7.3 or SQLAnywhere 6.0, the problem
> is the same with both databases.
>
> PLEASE HELP, AS THIS IS A REAL SHOW-STOPPER FOR US!
>
> Thanks for any responce, Max
> ----
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body of the message "unsubscribe jonas-users".
> For general help, send email to [EMAIL PROTECTED] and
> include in the body of the message "help".
>
