Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3E070D84F for ; Thu, 11 Oct 2012 07:29:05 +0000 (UTC) Received: (qmail 39199 invoked by uid 500); 11 Oct 2012 07:29:05 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 38571 invoked by uid 500); 11 Oct 2012 07:28:56 -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 29383 invoked by uid 99); 11 Oct 2012 01:35:58 -0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 402606.68458.bm@omp1032.mail.bf1.yahoo.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1349919328; bh=C7khm8AFXD1HUKGIbiwUUNfN687+1uSJkzzXRR9+N3w=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=q5hv4Ki75uQ9XmiuIBQjIjJHbD/PNox2hlhdEdW1TWfdCuRXXWeB7PcCaaYxZOGKtqM+9W8K78GFd9Hqigl/QK83GyWZAkg84TEEKAWR9CpRiFV5SX9Jx7IEosXnKjE7yweq9qVRkiSXRjg9X/g0tUzksHl678pXS+fKhd0sfYA= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=h70KV0ZRSag9cOGjN2a5a3qMx/8Y0D38WYP690DY/UAmLlDNKD2SHwMh6cxkuMD0WTu6FGxVM4wm+3hNssjYxmmdq4k0nf0I+UOo202/6YE6W/m5u0LHRkpQFtsPS22+ss5EEewN3Llzgnj3eA9Yc4qWNnG0egryEOJBUBQckLM=; X-YMail-OSG: B.uWxO0VM1l.vcWWtNWuDcV8Y0R42x1xfLA.wcAaojv4IPN Aop99KUZxVi.qr099MjTjr76XNzv8KiFHLZPhyTs9cEeEPHdyX8NaB9v4lYY xKJoKHk.48_sYaIdzoc.FES1vLrovG3nIvm15Ig2M_gdVaBjINNQZbVsICgu R.uhWRJaQ_3jy066LO.XjR884uQyah7LoGS.euvcPTiDKe7x0KD341nkF5XS 9lhysPfftSuFQfjad4neQPWFiLGKFC1_3q6J3njQNgYY7Xmx0g2H6EXqnSUo 2WqCyGlxGuOf2jb.1efVBfvxvtnN2BqAwRNf6c7sSBztyzbHbztycub9DYf0 ReJBtbvpR5.wQaTvtdf2UxquQnIOClaqCockvYXXYkSg4UJ2Xf5VEwrUhWby JjR6fypl2iZMnkUB8gdhU1nEOlhjQeZIOXOpC_GcoauKSU2.rrwcmOJQXJIK 3aj5z5VDAX5qRyFxziHh4RVVLXR9_bOWFY8PF.CI- X-Rocket-MIMEInfo: 001.001,SGkgRGVyYnkgQ29tbXVuaXR5LAoKSSdtIGhhdmluZyBzb21lIGRpZmZpY3VsdGllcyByZXNldHRpbmcgYSBEZXJieSBEYXRhYmFzZSB3aXRob3V0IHJlc3RhcnRpbmcgdGhlIHdob2xlIGFwcGxpY2F0aW9uIChKVk0pLgoKSSdtIGRlcGxveWluZyBEZXJieSBOZXR3b3JrIFNlcnZlci4gTXkgYXBwbGljYXRpb24gaGFzIGEgc2VydmljZSB0aGF0IGV4ZWN1dGVzIHNodXRkb3duIC8gc3RhcnQgb2YgdGhlIERlcmJ5IE5ldHdvcmsgU2VydmVyIG9uIGRlbWFuZC4KCi8vIGNvZGUgaGVyZSB0byBjbGVhciBEZXJieSABMAEBAQE- X-Mailer: YahooMailWebService/0.8.123.450 Message-ID: <1349919328.3013.YahooMailNeo@web162802.mail.bf1.yahoo.com> Date: Wed, 10 Oct 2012 18:35:28 -0700 (PDT) From: Oskar Zinger Reply-To: Oskar Zinger Subject: How to reset Derby Database in JVM To: "derby-user@db.apache.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1893461944-1410642671-1349919328=:3013" X-Virus-Checked: Checked by ClamAV on apache.org --1893461944-1410642671-1349919328=:3013 Content-Type: text/plain; charset=us-ascii Hi Derby Community, I'm having some difficulties resetting a Derby Database without restarting the whole application (JVM). I'm deploying Derby Network Server. My application has a service that executes shutdown / start of the Derby Network Server on demand. // code here to clear Derby connection pool derbyServer.shutdown(); derbyServer = null; The above does not reset the Derby database. For example, what if my database becomes corrupted and I would like to stop the service, remove the database, and copy over my new template database (or recreate the database) without having to restart my whole application. Is this possible? Thanks, Oskar Zinger --1893461944-1410642671-1349919328=:3013 Content-Type: text/html; charset=us-ascii
Hi Derby Community,

I'm having some difficulties resetting a Derby Database without restarting the whole application (JVM).

I'm deploying Derby Network Server. My application has a service that executes shutdown / start of the Derby Network Server on demand.

// code here to clear Derby connection pool
derbyServer.shutdown();
derbyServer = null;

The above does not reset the Derby database.

For example, what if my database becomes corrupted and I would like to stop the service, remove the database, and copy over my new template database (or recreate the database) without having to restart my whole application. Is this possible?

Thanks,
Oskar Zinger
--1893461944-1410642671-1349919328=:3013--