Hi all,

there seems to be a problem with the Database implementations regarding 
the method supportsDDLInTransaction(). After a quick search in the 1.9.1 
sources, I found only Sybase, Hibernate, and Firebird returning false 
for this call. All other databases are returning true.

The problem is that Firebird does support DDL in transactions (with 
proper rollback) and is returning false, while databases such as Oracle 
and MySQL don't support this feature and are returning true. One 
consequence of this is that Firebird is executing in autoCommit mode, 
which can be dangerous in some situations.

Going a little bit further, I wonder whether this property should be 
completely removed so that all databases could use transactions (well, 
at least DML transactions). What do you think? Does it deserve a bug 
submission?

Thanks in advance,
Diego


------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user

Reply via email to