db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: deleting database
Date Thu, 23 Jul 2009 12:48:03 GMT
Hi Sridhar,

You can specify derby.system.home on the java command line when you 
bring up your server or embedded application. E.g.:

java -Dderby.system.home=/apps/myDerbyApps ...

Hope this helps,
-Rick

sridhar devatha wrote:
> thanks, rick. But,  as per Scope of Derby properties in Derby property 
> reference,
> I can not put that property in derby.properties. Scope of Derby 
> properties Please tell me where to give this property.
> "The /derby.properties/ file is an optional file that can be created 
> to set properties at the system level when the Derby driver is loaded. 
> Derby looks for this file in the directory defined by the 
> /derby.system.home/ property. Any property except /derby.system.home/ 
> can be set by including it in the /derby.properties/ file."
>
> the second problem is completed it is working now. earlier it did not 
> work, i gave the correct syntax only.
>
> Wed, Jul 22, 2009 at 7:09 PM, Rick Hillegas <Richard.Hillegas@sun.com 
> <mailto:Richard.Hillegas@sun.com>> wrote:
>
>     Hi Sridhar,
>
>     Some responses inline...
>
>
>     sridhar devatha wrote:
>
>         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.
>
>     You can use the derby.system.home system property to tell Derby
>     where to put your databases. For more information, please see the
>     following section of the Derby Developer's Guide:
>     http://db.apache.org/derby/docs/10.5/devguide/devguide-single.html#cdevdvlp27610
>
>
>
>         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?
>
>     What command are you using to bring up the server and what error
>     are you seeing?
>
>     Thanks,
>     -Rick
>
>          Regards,
>         Sridhar
>
>
>         On Mon, Jul 20, 2009 at 8:40 PM, Rick Hillegas
>         <Richard.Hillegas@sun.com <mailto:Richard.Hillegas@sun.com>
>         <mailto:Richard.Hillegas@sun.com
>         <mailto:Richard.Hillegas@sun.com>>> 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
>
>
>
>
>
> -- 
>
> Yours Sincerely,
> Devatha Sridhar


Mime
View raw message