Mailing-List: contact user-help@empire-db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@empire-db.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Content-class: urn:content-classes:message
Subject: AW: dropping a database
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Date: Mon, 19 Aug 2013 10:37:51 +0200
Message-ID: <B297D4737108A0459B66C3A85BB7F901470EFE@kn.esteam.de>
In-Reply-To: <520CD4EF.7010700@raytion.com>
Thread-Topic: dropping a database
Thread-Index: Ac6ZufBvMmN92qcrQU+nqHR8muFoeQC+grFA
References: <520CD018.40100@raytion.com> <520CD4EF.7010700@raytion.com>
From: =?iso-8859-1?Q?Rainer_D=F6bele?= <doebele@esteam.de>
To: <user@empire-db.apache.org>

Hi Harald,

Sorry for the late answer, but better late than never ;-)

yes, this getDDLScript(...) method is intended for getting the drop =
command (which could as well be a sequence of commands)

Second: for HSql it should generate "DROP SCHEMA MYDBNAME;". We have =
changed DDL generation a while ago - you might not have the latest =
version of Empire-db.
The USER is probably a copy and paste bug from Oracle. In Oracle a USER =
essentially owns a schema which is what we call a database.

Please check whether you really use the HSql driver =
(DBDatabaseDriverHSql) and your Empire-db version.

Regards
Rainer


-------------------------------------------------------------------
from: Harald Kirsch [mailto:Harald.Kirsch@raytion.com]=20
to: user@empire-db.apache.org
re: Re: dropping a database

Ok, I thought I found it:

getDriver().getDDLScript(DBCmdType.DROP, myDbObject, script)

but this generates

DROP USER MYDBNAME;

The 'USER' is hard coded, as it seems and my hunch is it should rather =
be DATABASE. Why should I drop a USER when providing a DBDatabase =
object?

Regards,
Harald.

On 15.08.2013 14:56, Harald Kirsch wrote:
> Hi all,
>
> in DBDDLGenerator I find dropDatabase(), but it is protected.=20
> Similarly it is still protected in the specific implementations like=20
> MySQLDDLGenerator.
>
> Of course I could just derive from the driver and call the protected=20
> method, but this seems to be a bit odd. What would be the correct way=20
> to drop a database with empireDB?
>
> Regards,
> Harald.
>
>
>

--
Harald Kirsch
Raytion GmbH
Kaiser-Friedrich-Ring 74
40547 Duesseldorf
Fon +49-211-550266-0
Fax +49-211-550266-19
http://www.raytion.com