A problem about setAutoCommit
1 posts in topic
Flat View  Flat View

Posted By:   Yanfeng_Shi
Posted On:   Monday, July 7, 2003 01:31 AM

If i setAutoCommit(false),and execute some sql(insert, update....), and i don't execute the commit() method, don't setAutoCommit(true), what will happen? is previous operations will be commit? when?

Re: A problem about setAutoCommit

Posted By:   Steven_Martin  
Posted On:   Monday, July 7, 2003 07:15 AM

The database operations will be rolled back on the connection close. Also, you are taking a high overhead for the database to keep your transactions in limbo if you leave it for the pool to close it for you.
About | Sitemap | Contact