Re: Cannot turn off auto commit?

[email protected] Thu, 8 Sep 2016 10:05:38 +0000

Newsgroups	gmane.comp.java.hsqldb.user
Organization	io7m.com
Message-ID	<[email protected]>

Hello.

On 2016-09-07T23:00:17 +0100
Fred Toussi <[email protected]> wrote:

> Non-transactional DDL has always been the case.
> 
> If your DDL statements do not contain syntax errors or references to
> non-existent database objects, then they won't fail the first time they
> are executed.

Right.

> 
> The IF NOT EXISTS clause can be used with all database objects.
> 
> You can query the INFORMATION_SCHEMA views to check if a table or other
> object exists, before creating database objects.
> 
> You can always drop the whole schema if you want to recreate it.

Dropping the schema is fine for initial installation, but what about
schema upgrades? If I can't reliably and atomically update the structure
of tables, then it would seem that every upgrade has a risk of getting
the database into an inconsistent state.

M

------------------------------------------------------------------------------

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

signature.asc (application/pgp-signature, 821 B)