db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paulo Jesus" <paulsch...@gmail.com>
Subject Re: crate and drop databases.
Date Tue, 30 Oct 2007 16:36:33 GMT
2007/10/30, Stanley Bradbury <Stan.Bradbury@gmail.com>:
> Paulo Jesus wrote:
> > 2007/10/26, Stanley Bradbury <Stan.Bradbury@gmail.com>:
> >
> >> Paulo Jesus wrote:
> >>
> >>> I have two questions on create an drop databases.
> >>> Do I have a command to drop a database?  Or do I need to "gently"
> >>> remove the directory of the database? I didn't find references to
> >>> this.
> >>>
> >>> There is other way to create a database  than the
> >>> '.../newDatabase;create=true' at the connection string.?
> >>>
> >>> Thanks
> >>> PJ
> >>>
> >>>
> >>>
> >> Hi Paulo -
> >> You are correct on both counts.  ;create=true will cause an empty (no
> >> user tables) database to be created if it does not already exist.
> >> Removing the directory structure deletes the database and returns the
> >> disk space to the filesystem.
> >>
> >> If you are familiar with databases where you connect to the engine and
> >> have multiple database to access you should consider using SCHEMAS.  You
> >> can create and drop schemas using standard SQL commands.
> >>
> >>
> >
> > Ok.
> > If the scripts to start and stop the NetworkServer are called from the
> > host machine than the administrator has also access to database files.
> > But if i can remotely  configure a new database (at connection string)
> > then, i think, it should be also possible to drop it..  with the
> > required validations first.
> >
> > Thanks
> > PJ
> >
> >
> Hi PJ -
> You have a good point.  Derby was designed to be a zero administration
> system hence such validation was not available in earlier versions
> within the SQL layer.  The Administrator account is new with version
> 10.3 and now that one exists (when sqlAuthorization=true administration
> is required) then there is a validation that can be used to as you
> suggest.  Would you please file a feature request in JIRA so this will
> be considered for inclusion in a future release?
>
> Info on filing defects and feature requests can be found at:
>   http://db.apache.org/derby/DerbyBugGuidelines.html

I can see if there isn't already a request or post a new.
But i need to read the guidelines first..
I will look to this, later.

PJ
(Paulo Jesus)

Mime
View raw message