Re: [Liquibase-user] Disable concurrent access database lock

2009-02-27 Thread Voxland, Nathan
Is that a feature others would like? My assumption has been that it doesn't really hurt to always force it, and then you know things will be working right. Nathan On Feb 27, 2009, at 8:43 PM, "Paul Keeble" wrote: There is currently no way to turn it off. Paul From: "david.swal...@ubs.

Re: [Liquibase-user] Problems with Database.supportsDDLInTransaction()

2009-02-27 Thread Voxland, Nathan
The ddl in transactions flag is for flagging databases like sybase that actually throw errors if you try to do ddl in a transaction. Oracle et al allow ddl in transactions even if it is auto-committing. If firebird doesn't have the same problem as sybase then it should return true. It may h

Re: [Liquibase-user] Disable auto-apply of changes to sql usingintellij plugin

2009-02-27 Thread Voxland, Nathan
Or are you wondering of you can build up an in memory database schema and then apply it when it is done? That would not be possible either since we rely on the database to supply the state, not an in memory representation. Your only option with the IDE would be to build your database up usi

Re: [Liquibase-user] Disable auto-apply of changes to sql using intellij plugin

2009-02-27 Thread Paul Keeble
Are you saying that you want the changelog to run completely without ever committing until everything has been done? In which case you need to put all the Changes/Statements you want into a single ChangeSet. That is the work unit that has a transaction around it. However this will only work with

Re: [Liquibase-user] Disable concurrent access database lock

2009-02-27 Thread Paul Keeble
There is currently no way to turn it off. Paul From: "david.swal...@ubs.com" To: liquibase-user@lists.sourceforge.net Sent: Saturday, 28 February, 2009 2:27:27 Subject: [Liquibase-user] Disable concurrent access database lock Hi, Is there a way to disable t

[Liquibase-user] Disable concurrent access database lock

2009-02-27 Thread David.Swallow
Hi, Is there a way to disable the concurrent database lock feature? I have no need of it and would prefer that it doesn't create the extra tables on the database. Thanks, Dave Visit our website at http://www.ubs.com This message contains confidential information and is intended only for the i

[Liquibase-user] Disable auto-apply of changes to sql using intellij plugin

2009-02-27 Thread David.Swallow
Hi, I would like to be able to create a full schema (as a changelog) without committing to the db. I would like to do this without committing to the db until the schema is done. Is it possible to do this via the plugin? I know that I can hand craft the xml, but that doesn't seem very efficient.

[Liquibase-user] Problems with Database.supportsDDLInTransaction()

2009-02-27 Thread DATACOM - Diego
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 t

[Liquibase-user] runOnChange="true"

2009-02-27 Thread doublede
MS SQL Server 2005 Liquibase 1.9.0 We use ant target updateDatabase for our development changes, and promote our changes using ant target updateDatabase with parameter outputFile to generate a file to submit to dba's. We set runOnChange="true" on our changeSet. The generated sql produces : UPDA

Re: [Liquibase-user] Liquibase: Custon sql with tag

2009-02-27 Thread Pradnya Gawade
Yeah, that was the problem. Thanks a lot, I am done with all my custom sql statements. Thanks and Regards, On Fri, Feb 27, 2009 at 9:35 AM, Voxland, Nathan < nvoxl...@intelligentinsites.com> wrote: > The trouble is that you have < and > tags inside your text block with > confuses the XML pars

Re: [Liquibase-user] Liquibase: Custon sql with tag

2009-02-27 Thread Voxland, Nathan
The trouble is that you have < and > tags inside your text block with confuses the XML parser. You need to wrap it in a CDATA section: "" at the end. You'll also need to add the splitStatements="false" attribute to the tag. Nathan From: Pradnya Gawade [mailto:pradnya.gawa...@gmail.com]

Re: [Liquibase-user] Liquibase: Custon sql with tag

2009-02-27 Thread Pradnya Gawade
I am still not successful in implementing my create function custom sql :-( Following is my custom sql tag: * CREATE FUNCTION event_crf_trigger() RETURNS "trigger" AS 'DECLARE pk INTEGER; entity_name_value TEXT; BEGIN IF