In many systems closing connection by default commits all pending...]]> Sat, 22 Oct 2005 22:33:59 -0400 Sat, 22 Oct 2005 22:33:59 -0400 Sat, 22 Oct 2005 22:33:59 -0400 Oct 22, 2005 Karthik Krishnan 0 http://www.theserverside.com/discussions/thread.tss?thread_id=37173 Fri, 21 Oct 2005 19:10:21 -0400 Fri, 21 Oct 2005 19:10:21 -0400 Fri, 21 Oct 2005 19:10:21 -0400 Oct 21, 2005 Eduardo Ochiai 0 http://www.theserverside.com/discussions/thread.tss?thread_id=37173 Fri, 21 Oct 2005 12:14:57 -0400 Fri, 21 Oct 2005 12:14:57 -0400 Fri, 21 Oct 2005 12:14:57 -0400 Oct 21, 2005 Paul Lee 0 http://www.theserverside.com/discussions/thread.tss?thread_id=37173 And where did you come up with the blaming part again? In order to blame someone you firstly must have done something wrong or been in a position where something went wrong, and...]]> Fri, 21 Oct 2005 06:08:46 -0400 Fri, 21 Oct 2005 06:08:46 -0400 Fri, 21 Oct 2005 06:08:46 -0400 Oct 21, 2005 Radu-Adrian Popescu 1 http://www.theserverside.com/discussions/thread.tss?thread_id=37173 I was interested what databases (and by database I mean database systems, not client programs or libraries), if any, choose to commit _themselves_ (again, not the client program or...]]> Fri, 21 Oct 2005 05:54:24 -0400 Fri, 21 Oct 2005 05:54:24 -0400 Fri, 21 Oct 2005 05:54:24 -0400 Oct 21, 2005 Radu-Adrian Popescu 0 http://www.theserverside.com/discussions/thread.tss?thread_id=37173 in case of failure (like loosing control from client application), not in case of clean connection::close called by that external...]]> Fri, 21 Oct 2005 04:11:26 -0400 Fri, 21 Oct 2005 04:11:26 -0400 Fri, 21 Oct 2005 04:11:26 -0400 Oct 21, 2005 Dmytro 3 http://www.theserverside.com/discussions/thread.tss?thread_id=37173 finally {
   try {
      connection.close();
      connection =...]]> Fri, 21 Oct 2005 03:16:55 -0400 Fri, 21 Oct 2005 03:16:55 -0400 Fri, 21 Oct 2005 03:16:55 -0400 Oct 21, 2005 Ville Oikarinen 0 http://www.theserverside.com/discussions/thread.tss?thread_id=37173
Check out these sites:

idontgettransactions.com
idontunderstandprogramming.com

And MOST importantly

iwanttobeanindustryragbutcantactuallykeepthiscrapoffmysite.com]]> Thu, 20 Oct 2005 22:13:58 -0400 Thu, 20 Oct 2005 22:13:58 -0400 Thu, 20 Oct 2005 22:13:58 -0400 Oct 20, 2005 U G 0 http://www.theserverside.com/discussions/thread.tss?thread_id=37173 Sql*plus, if you don't know, is a kind of etalon pogram to interact with Oracle. But if you think your connection::close works cleaner then just [re]read Oracle manuals that explicitly states:If auto-commit mode is disabled and you...]]> Thu, 20 Oct 2005 14:18:18 -0400 Thu, 20 Oct 2005 14:18:18 -0400 Thu, 20 Oct 2005 14:18:18 -0400 Oct 20, 2005 Radu-Adrian Popescu 5 http://www.theserverside.com/discussions/thread.tss?thread_id=37173 connection::close works cleaner then just [re]read Oracle manuals that explicitly states:


If auto-commit mode is disabled and you...]]> Thu, 20 Oct 2005 08:17:29 -0400 Thu, 20 Oct 2005 08:17:29 -0400 Thu, 20 Oct 2005 08:17:29 -0400 Oct 20, 2005 Dmytro 6 http://www.theserverside.com/discussions/thread.tss?thread_id=37173

In many systems closing connection by default commits all pending changes, to prevent data loss and ... because it's far easier than rolling back :-)

Any examples? That doesn't seem like the sane thing to...]]> Thu, 20 Oct 2005 07:46:21 -0400 Thu, 20 Oct 2005 07:46:21 -0400 Thu, 20 Oct 2005 07:46:21 -0400 Oct 20, 2005 Radu-Adrian Popescu 7 http://www.theserverside.com/discussions/thread.tss?thread_id=37173

In many systems closing connection by default commits all pending changes, to prevent data loss and ... because it's far easier than rolling back :-)

Any examples? That doesn't seem like the sane thing to...]]> Thu, 20 Oct 2005 06:55:50 -0400 Thu, 20 Oct 2005 06:55:50 -0400 Thu, 20 Oct 2005 06:55:50 -0400 Oct 20, 2005 Dmytro 8 http://www.theserverside.com/discussions/thread.tss?thread_id=37173 In many systems closing connection by default commits all pending changes, to prevent data loss and ... because it's far easier than rolling back :-)

Any examples? That doesn't seem like the sane thing to do.]]> Thu, 20 Oct 2005 06:40:11 -0400 Thu, 20 Oct 2005 06:40:11 -0400 Thu, 20 Oct 2005 06:40:11 -0400 Oct 20, 2005 Radu-Adrian Popescu 9 http://www.theserverside.com/discussions/thread.tss?thread_id=37173 Karl, ignoring the unwarranted sarcasm to a valid question ...I would be surprised if closing a connection without calling commit would automatically commit the data unless of course AutoCommit was turned on.