But a session just indicates that a database connection has been obtain, correct? A session is not equal to a transaction is it?
_____ From: Chick, Brian [mailto:[EMAIL PROTECTED] Sent: Friday, February 16, 2007 1:01 PM To: [email protected] Subject: RE: Checking for Open Transactions The IsSessionStarted property of the ISqlMapper might be what you're looking for. I've used it in my unit tests to detect if a transaction has already been started. If it has, any changes my tests made to the database are rolled back. _____ From: Clough, Samuel (USPC.PRG.Atlanta) [mailto:[EMAIL PROTECTED] Sent: Friday, February 16, 2007 11:54 AM To: [email protected] Subject: RE: Checking for Open Transactions Ok, nobody replied which confuses me a little. I find it very hard to believe that I'm the only one that has had this problem. So far I haven't found a good solution. The perfect solution is almost there in the Session. It has a field tracking if there is an open session. If someone would wrap a property around this field, the problem would be solved. I also thought about checking the Transaction property to see if it's null, but that's no reliable because the rollback transaction method calls set the transaction to null, but the commit method calls do not set the transaction to null. Unless there is something else I've missed here, can a property be added around the _isOpenTransaction field in the SqlMapSession? I would say it should be added to the interface as well. Since it abstracts transactions, it should abstract the ability to check for a transaction IMHO. _____ From: Clough, Samuel (USPC.PRG.Atlanta) Sent: Monday, February 12, 2007 8:14 AM To: [email protected] Subject: Checking for Open Transactions Maybe I'm missing something really obvious here, but I don't see a way on the SqlMapper to check to see if a transaction is open before starting one. To me (and a couple other devs here using iBatis), this is an obvious need because you may have a class call several methods to execute several statements. When a method is called, it's very helpful for that method to be able to check to see whether or not it needs to open a transaction. Is there a solution here I'm just not seeing, or has this by chance been added in SVN? Am I missing something here? _____ Princeton Retirement Group, Inc - Important Terms This E-mail is not intended for distribution to, or use by, any person or entity in any location where such distribution or use would be contrary to law or regulation, or which would subject Princeton Retirement Group, Inc. or any affiliate to any registration requirement within such location. This E-mail may contain privileged or confidential information or may otherwise be protected by work product immunity or other legal rules. No confidentiality or privilege is waived or lost by any mistransmission. Access, copying or re-use of information by non-intended or non-authorized recipients is prohibited. If you are not an intended recipient of this E-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute any portion of this E-mail. The transmission and content of this E-mail cannot be guaranteed to be secure or error-free. Therefore, we cannot represent that the information in this E-mail is complete, accurate, uncorrupted, timely or free of viruses, and Princeton Retirement Group, Inc. cannot accept any liability for E-mails that have been altered in the course of delivery. Princeton Retirement Group, Inc. reserves the right to monitor, review and retain all electronic communications, including E-mail, traveling through its networks and systems (subject to and in accordance with local laws). If any of your details are incorrect or if you no longer wish to receive mailings such as this by E-mail please contact the sender by reply E-mail. _____
