Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 16120 invoked from network); 2 Jul 2007 18:40:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Jul 2007 18:40:16 -0000 Received: (qmail 74119 invoked by uid 500); 2 Jul 2007 18:40:13 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 74093 invoked by uid 500); 2 Jul 2007 18:40:13 -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 Delivered-To: moderator for derby-user@db.apache.org Received: (qmail 75249 invoked by uid 99); 2 Jul 2007 14:09:44 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Message-ID: <468906EB.8000703@integragen.com> Date: Mon, 02 Jul 2007 16:08:43 +0200 From: Ekrame Ayari Organization: IntegraGen User-Agent: Thunderbird 1.5.0.7 (X11/20060915) MIME-Version: 1.0 To: derby-user@db.apache.org Subject: How delete rows in table with free disk space? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Hi I wish to remove table rows to allow user decrease space disk. I try to delete table rows for free disk space with this code : "Connect connect = DriverManager.getConnection("jdbc:derby:GenoCensusMin2"); Statement stat = connect.createStatement(); stat.executeUpdate("DELETE FROM Project WHERE id="+idProjet);" But disk space size of my system directory is the same before and after the deletion. Can you help me? Sincerly E'Krame Jacoby IntegraGen SA (France)