Hi All , In my application ,I am using stateless session beans with bean managed transactions with MS SQL Server 2000 as my database. Presently I am not calling the UserTransaction object explicitly.I am instead relying on the begin(),commit(),setAutoCommit() of the java.sql.Connection object to perform inserts/updates/deletes. Now I understand that it is good practice not to group too many statements in one transaction when auto-commit is set to OFF on the Connection object because the database can experience problems due to lack of memory. I have 2 questions relating to this
1. Does anybody have a performance benchmark as to how many statements can be grouped into one transaction ? 2. At the database level , if some triggers have been set which are supposed to fire upon a insert/delete/update , would they be part of a bean managed transaction if a) UserTransaction object is used explicitly b) UserTransaction object is not used , only java.sql.Connection methods are relied upon for transaction management? - Rahul =========================================================================== 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".
