Hi,
  I do not know wht excatly you use, so here are some comments that may direct u ...

  1. When using the Oracle Thin/XA 8.1.7 driver, you cannot change the transaction isolation level for a transaction. Transactions use the default transaction isolation as set for the database.
  2. If u are using bean managed persistence and if u have specified "Transaction_Required" as the isolation level. If u try to acces the bean before starting the transcation then u will get this error.

Leo Donald

Ramya_Sundaresan <Ramya_Sundaresan@SATYAM.COM> Sent by: An interest list for Sun Java Center J2EE Pattern Catalog <J2EEPATTERNS-INTEREST@JAVA.SUN.COM> 11/05/2003 10:11 AM Please respond to An interest list for Sun Java Center J2EE Pattern Catalog

To:        J2EEPATTERNS-INTEREST@JAVA.SUN.COM         cc:        (bcc: leo.donald/Polaris)         Subject:        Set transaction problem

When i run my j2ee application sometimes, i get the following error:
 
EXCEPTION userAccessExp java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction
Can anybody help me out as to why it arises and the solution for the same
 
ramya
 

**************************************************************************

This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.

**************************************************************************

==================================================================== Companion Site: http://www.corej2eepatterns.com J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@java.sun.com

This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only.
If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately.
You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification,
distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.

Visit Us at http://www.polaris.co.in