----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: Rohit_BD Message 4 in Discussion Check that if insert/update/delete are happening within a transaction then you are explicitly committing the transaction, unlocking tables before closing the connection, and explicitely rolled back in the event of an exception. Also try out different isolation level settings, but IMO, this works best only with SQL server. As per what I know, you do not have to explicitly lock tables once the isolation level is set, the database driver takes care of that and you only have to specify a transaction in order for the database to lock/unlock tables. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
