AW: EJB Transaction Integrity Issue

[Chan Philip]

Hello Alex,

 

Would it be possible that it has something to do with

 

    connection.setAutoCommit(boolean autoCommit)

 

regards

Philip

-----Urspr�ngliche Nachricht-----
Von: Alex Vauthey [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 12. Juli 2002 03:53
An: [EMAIL PROTECTED]
Betreff: EJB Transaction Integrity Issue

Hi,

I'm experiencing a serious issue with Weblogic and I was curious about what should be the expected behaviou of any EJB container with the following scenario:

- Start a User transaction in a client JVM with transaction timeout set to 2 seconds
  - Call a session bean within this transaction (Transaction attribute set to REQUIRED)
    - Within the session bean, create 20 entity beans in a loop (Transaction attribute of
      entity beans is REQUIRED), doing some CPU intensive tasks between each creation
      (approx 1 second between each bean creation).
- commit User Transaction on the client

I'm using one transactional datasource for all db accesses.

What I'm experiencing is the following :

I get a timeout exception when I try to commit (sounds normal), but I end-up with 18 entity beans committed in my db !! It seems like anything that happened in the session bean after the timeout was comitted. My guess is that, at timeout time, the container dissociates the thread from the transaction context, but the thread keeps running. Therefore each subsequent entity bean creation happens in its own transaction, since the entity bean attribute is marked as REQUIRED.

Any clarification with regards to what **Should** happen in this scenario would be appreciated.

Rgrds, alex.

--

Alexandre Vauthey
Server Technology Mgr.
Application Networks
444 Ramona Street
Palo Alto, CA 94301

<!--[if !supportEmptyParas]--><!--[endif]-->Tel: 1 (650) 462 7224
Fax: 1 (650) 462 7221

<!--[if !supportEmptyParas]--><!--[endif]-->

www.application-networks.com

=========================================================================== 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".