Check for existing schema? Create but don't drop?

dnoyeb · **Joined:** Sat Dec 16, 2006 1:52 pm **Posts:** 40

I am using the SchemaExport to create my schema at runtime. Is it possible to create a schema without dropping the existing schema?

It seems as if the schemas match, then it will not drop the existing schema. But just now, when my schemas did not match, it seems to have dropped the existing schema and recreated a new one.

I want to create if there is none, but if there is existing schema, it should abort. Perhaps there is a simple way to check if a schema exists? And I mean exists, not that its completely valid, just that there is _any_ schema present.

Thanks!

batmat · **Posted:** Fri Dec 29, 2006 10:28 am

I'm not sure it's possible to tell SchemaUpdate to not execute if the given schema is already present.

But maybe you could do it by yourself, doing some jdbc before calling SchemaUpdate to verify it's possible, then create a patch for it?

Something like:

Code:

if(!schemaAlreadyExists(jdbcConnection, "theSchemaName"))
{
new SchemaUpdate()...execute(...);
}

dnoyeb · **Joined:** Sat Dec 16, 2006 1:52 pm **Posts:** 40

That looks interesting. Right now I get a JDBC conneciton and start checking for tables. Does hibernate give a schema or catalog name or something I can check for? Can I control that name? It would be much easier to check for that then to start checking for table names.