From derby-user-return-11306-apmail-db-derby-user-archive=db.apache.org@db.apache.org Wed Jul 22 04:36:13 2009 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 58934 invoked from network); 22 Jul 2009 04:36:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 22 Jul 2009 04:36:13 -0000 Received: (qmail 68182 invoked by uid 500); 22 Jul 2009 04:37:18 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 68103 invoked by uid 500); 22 Jul 2009 04:37:17 -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 68094 invoked by uid 99); 22 Jul 2009 04:37:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Jul 2009 04:37:17 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of devatha.sridhar@gmail.com designates 209.85.216.171 as permitted sender) Received: from [209.85.216.171] (HELO mail-px0-f171.google.com) (209.85.216.171) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Jul 2009 04:37:09 +0000 Received: by pxi1 with SMTP id 1so4213035pxi.5 for ; Tue, 21 Jul 2009 21:36:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=P9zXk+cKsnwGmAV0FEja6I87hwoCvboV007s0ly39Uc=; b=S1YQ6mkzd8wpd0k5pohtYC7CBfkN/2a8G4KjHsCdcpxpLSnd19l0sWy1rxlFMBWdiR ND8+H3ZqjVk/Bxhq7uDmMKsR5IPB/cOLZhrUFOXEtMKyuUVvQjcB3ImXImxCCivN1KDi pNV16FhU+9zz2Ozo6dHYxBSvXFinMMdA98d6w= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=SjRlGZMzyQGLzBw3K+flias/yvPHPm38F9Zch0Zio2Y3msuIJTSY57QCedNsMPU9P+ z70E5FRR2xlR+ygbPJrNI9aW2g9d7oj/ca06cJ2tPuIAY4fmGZsEnXbVk7Ki0+4BIqC3 zZLkO8qqn642b/XYlajaBgXcdz6JY+aiJogT0= MIME-Version: 1.0 Received: by 10.115.79.1 with SMTP id g1mr770677wal.80.1248237408950; Tue, 21 Jul 2009 21:36:48 -0700 (PDT) In-Reply-To: <4A6488F3.7050403@sun.com> References: <4A6488F3.7050403@sun.com> Date: Wed, 22 Jul 2009 10:06:48 +0530 Message-ID: Subject: Re: deleting database From: sridhar devatha To: Derby Discussion Content-Type: multipart/alternative; boundary=00163646c2285b1aa4046f43eb59 X-Virus-Checked: Checked by ClamAV on apache.org --00163646c2285b1aa4046f43eb59 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi Rick Hillegas, Thank you very much for your reply. I just want some more information regarding derby. I want to move this database directory from my home directory. I use windows xp professional. My c drive is not having enough space. So, it is not good to put the database in my home directory. Moreover, When I have to install I will format my c drive. So, I need a way to tell derby to store databases in some other location. I am having 2 more problems with derby is that I am unable to start derby network server using derbynet.jar and derbyrun.jar. At present, What is working is thru setNetworkServerCP,startNetworkServer and stopNetworkServer. Can you or any body help me in this issues? Regards, Sridhar On Mon, Jul 20, 2009 at 8:40 PM, Rick Hillegas wrote: > Hi Sridhar, > > There is no Derby command for deleting a database. A database is simply a > directory of files--if you want to delete it, you just use operating system > commands to remove the directory. In your case, you would be deleting the > sampleDB directory. > > You also asked a question about schemas, which I didn't understand. Forgive > me if I am talking past your question: You can use the CREATE SCHEMA command > to create schemas other than sys and app. If you use an authentication > mechanism to control who logs into the database and if you turn on > fine-grained SQL access checks, you can control who is able to read and > write the data in the schema which you created. For more information, you > may want to consult the security documentation in the Derby Developer's > guide: > http://db.apache.org/derby/docs/10.5/devguide/devguide-single.html#cdevcsecuree > > Hope this helps, > -Rick > > > sridhar devatha wrote: > >> Hi, >> I hava a database, let us call it, sampleDB. >> I connect to it using ij through the below command. >> connect 'jdbc:derby://localhost:1527/sampleDB;create=false'; >> I want to remove sampleDB. So that nobody can connect to it even using sys >> schema. >> This database is in different schema other than sys and app. >> I am unable to find in docs and google on deleting derby database. >> Can I delete it from my own schema from which I usually connect to this >> database? >> what is the command for deleting database? >> how to know the tables / data in the database? >> bye >> sridhar >> >> -- >> >> Yours Sincerely, >> Devatha Sridhar >> > > -- Yours Sincerely, Devatha Sridhar --00163646c2285b1aa4046f43eb59 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hi Rick Hillegas,
=A0
Thank you very much for your reply. I just want some more information = regarding derby.
I want to move this database directory from my home directory. I use w= indows xp professional. My c drive is not having enough space. So, it is no= t good to put the database in my home directory. Moreover, When I have to i= nstall I will format my c drive. So, I need a way to tell derby to store da= tabases in some other location. I am having 2 more problems with derby is t= hat I am unable to start derby network server using derbynet.jar and derbyr= un.jar. At present, What is working is thru setNetworkServerCP,startNetwork= Server and stopNetworkServer. Can you or any body help me in this issues?
=A0
Regards,
Sridhar

On Mon, Jul 20, 2009 at 8:40 PM, Rick Hillegas <= span dir=3D"ltr"><Richard.Hi= llegas@sun.com> wrote:
Hi Sridhar,

There is no D= erby command for deleting a database. A database is simply a directory of f= iles--if you want to delete it, you just use operating system commands to r= emove the directory. In your case, you would be deleting the sampleDB direc= tory.

You also asked a question about schemas, which I didn't understand.= Forgive me if I am talking past your question: You can use the CREATE SCHE= MA command to create schemas other than sys and app. If you use an authenti= cation mechanism to control who logs into the database and if you turn on f= ine-grained SQL access checks, you can control who is able to read and writ= e the data in the schema which you created. For more information, you may w= ant to consult the security documentation in the Derby Developer's guid= e: http://db.apache.org/derby/docs/10.5/= devguide/devguide-single.html#cdevcsecuree

Hope this helps,
-Rick=20


sridhar devatha wrote:
Hi,
=A0I hava a database, let= us call it, sampleDB.
I connect to it using ij through the below comman= d.
connect 'jdbc:derby://localhost:1527/sampleDB;create=3Dfalse';
I= want to remove sampleDB. So that nobody can connect to it even using sys s= chema.
This database is in different schema other than sys and app.
I am unable to find in docs and google on deleting derby database.
Can I= delete it from my own schema from which I usually connect to this database= ?
what is the command for deleting database?
how to know the tables /= data in the database?
=A0=A0bye
sridhar

--

Yours Sincerely,
Devatha Sridhar<= br>




--

Yours Sincerely,
Devatha Sridhar
--00163646c2285b1aa4046f43eb59--