Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 71128 invoked from network); 30 Mar 2006 08:27:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 30 Mar 2006 08:27:06 -0000 Received: (qmail 51975 invoked by uid 500); 30 Mar 2006 08:27:05 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 51944 invoked by uid 500); 30 Mar 2006 08:27:04 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 51933 invoked by uid 99); 30 Mar 2006 08:27:04 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Mar 2006 00:27:04 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [212.27.42.27] (HELO smtp1-g19.free.fr) (212.27.42.27) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Mar 2006 00:27:03 -0800 Received: from lns-bzn-58-82-251-238-240.adsl.proxad.net (lns-bzn-58-82-251-238-240.adsl.proxad.net [82.251.238.240]) by smtp1-g19.free.fr (Postfix) with ESMTP id F3FFE9AAD5 for ; Thu, 30 Mar 2006 10:26:41 +0200 (CEST) Subject: Re: [SHUTDOWN] Should I shutdown embedded data base ? From: yves pielusenet To: Derby Discussion In-Reply-To: <442B942E.9020404@sun.com> References: <1143645437.7150.35.camel@localhost.localdomain> <442AC54B.2000302@gmail.com> <1143705471.6786.5.camel@localhost.localdomain> <442B942E.9020404@sun.com> Content-Type: text/plain; charset=ISO-8859-1 Date: Thu, 30 Mar 2006 10:29:33 +0200 Message-Id: <1143707373.6786.17.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.2.1 Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Le jeudi 30 mars 2006 � 10:17 +0200, Oystein Grovlen - Sun Norway a �crit : > yves pielusenet wrote: > > > Thank you for your answer :) > > So, since I use an embedded database, should I use the shutdown command > > (database shutdown nor derby shutdown) everytime I do > > Connection.close() ? (an if so, why derby connection close command call > > itself database;shutdown=true commande ?) > > > > And a the very end of my application I do a derby shutdown > > DriverManager.getConnection("jdbc:derby:cs;shutdown=true"); > > > > that's right ? :) > > No, you need only shut down the database at the end of your application. > Note that a derby shutdown is just a shutdown of all databases you have > opened. If you just have a single database, a single shut down is enough. > So if I call shutdown a the very of the application I should use Derby shutdown to close all database (even if there is only one) ? In fact, Derby shutdown do a checkpoint of all database that have been opened during the JVM life. That's it ?