2007/10/30, Stanley Bradbury <[EMAIL PROTECTED]>: > Paulo Jesus wrote: > > 2007/10/26, Stanley Bradbury <[EMAIL PROTECTED]>: > > > >> 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)
