tag:blogger.com,1999:blog-8636278103713590945.post8066374536469226851..comments2024-01-31T15:08:37.901+05:30Comments on Applications DBA Arena: Beware Commit on ExitSuresh Lakshmananhttp://www.blogger.com/profile/00444125162257629443noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8636278103713590945.post-58714320869290411242009-11-11T14:15:07.562+05:302009-11-11T14:15:07.562+05:30Setting autocommit off does not solve the problem,...Setting autocommit off does not solve the problem, you can do:<br /> exit rollback;<br /><br />This performs rollback on exit.Michael Elkinnoreply@blogger.comtag:blogger.com,1999:blog-8636278103713590945.post-244267534926676912009-05-20T13:36:55.095+05:302009-05-20T13:36:55.095+05:30May be the session is in auto commit mode....May be the session is in auto commit mode....Puneet Sacharnoreply@blogger.comtag:blogger.com,1999:blog-8636278103713590945.post-37649454341909377392009-05-20T13:36:29.153+05:302009-05-20T13:36:29.153+05:30Well said Siva.
Thanks
SureshWell said Siva.<br /><br />Thanks<br />SureshSuresh Lakshmananhttps://www.blogger.com/profile/00444125162257629443noreply@blogger.comtag:blogger.com,1999:blog-8636278103713590945.post-33617492304422002642009-05-20T05:05:45.261+05:302009-05-20T05:05:45.261+05:30Hi Suresh,
Well I think, we can setup our login p...Hi Suresh,<br /><br />Well I think, we can setup our login profile i.e. in login.sql set autocommit off;<br /><br />But as you said, its by default on and hence an issue if we dont want to save the data.<br /><br />Anyways nice posting..<br /><br />Thanks<br />SivaSivahttps://www.blogger.com/profile/01266727407396335727noreply@blogger.com