Re: [Liquibase-user] Re commendation

2009-05-18 Thread MichaelM
Add a changeset at the end of the changelog with the runallways attribute. When you add a new changeset to the changelog, add it just before the last one, so that the grants are always run at the end. jfrapper wrote: > > Greetings, > > With the way our Oracle DBA's have setup security, after e

[Liquibase-user] Here's how to generate a changelog using Groovy

2009-03-29 Thread MichaelM
If you need to generate a changelog from a structured source, the Groovy scripting language makes it quite easy. I wrote up a brief tutorial here: http://www.liquibase.org/generate-changelog-with-groovy Let me know if it requires clarification and I'll be happy to update it. // M. -- View this

[Liquibase-user] New tutorial available

2009-03-22 Thread MichaelM
I have uploaded an extensive tutorial using LiquiBase with Oracle: http://www.liquibase.org/tutorial-using-oracle This should help newcomers to LiquiBase to see how it can be used in a real-world example. The tutorial can also provide a starting point for those needing to define their standards

[Liquibase-user] diff: parameters in properties file?

2009-03-21 Thread MichaelM
If I specify the diff parameters in a property file as shown below: #liquibase.properties driver: oracle.jdbc.OracleDriver classpath: ../ojdbc14.jar url: jdbc:oracle:thin:@localhost:1521:XE username: dev password: dev baseUrl: jdbc:oracle:thin:@localhost:1521:XE baseUsername: test basePassword: t

Re: [Liquibase-user] preCondition: unexpected behavior

2009-02-06 Thread MichaelM
Using Liquibase 1.9: f0.xml: http://www.liquibase.org/xml/ns/dbchangelog/1.9"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-

Re: [Liquibase-user] includeAll tag gives error: URI has an authority component

2009-02-01 Thread MichaelM
The changelog file is in a standard directory. Voxland, Nathan wrote: > > Is your changelog file in a jar or a standard directory ? > > Nathan > > > > On Jan 31, 2009, at 1:35 AM, "MichaelM" > wrote: > >> >> I am running on Windows. T

Re: [Liquibase-user] includeAll tag gives error: URI has an authority component

2009-01-30 Thread MichaelM
of your base dir (uri?) to which includeAll is resolved. > > Just my EUR 0.02, > Carsten > > MichaelM schrieb: >> I am using liquibase 1.9 and a migration script with this line in the >> changelog: >> >> >> >> Executing this changelo

[Liquibase-user] includeAll tag gives error: URI has an authority component

2009-01-25 Thread MichaelM
I am using liquibase 1.9 and a migration script with this line in the changelog: Executing this changelog gives: java.lang.IllegalArgumentException: URI has an authority component at java.io.File.(Unknown Source) at liquibase.parser.xml.XMLChangeLogHandler.startElement(XMLC

[Liquibase-user] preCondition: unexpected behavior

2009-01-03 Thread MichaelM
I am trying to apply a preCondition on an included file, but I am not getting the expected behavior. Depending on a situation set in the main file, I want the included file to run (or not). The examples below illustrate the problem. The script below works as expected: - the first changeset inser

[Liquibase-user] Condition in included file: NPE

2009-01-02 Thread MichaelM
If I use a condition in an included file, I get a null pointer exception. Is this unsupported usage, or a bug? See scenario below: File v1.xml: http://www.liquibase.org/xml/ns/dbchangelog/1.8"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:sch

[Liquibase-user] Including a file without an error if the file does not exist

2009-01-01 Thread MichaelM
When creating a stored procedure, I would like to define it in its own file, with runOnChange="true". The main advantage is that in the version control system, the procedure and all changes to the source code are easily tracked. So the first changeset that defines the procedure will contain: No