Changelog parameters

[jfrapper]

Greetings,

I am using changelog parameters in my liquibase changelogs.  Everything works fine from the ant task, but I cant get them to be recognized from the command line.  Here is a sample:

liquibase --driver=oracle.jdbc.OracleDriver --classpath=C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar --changeLogFile=sql\base.changelog.xml --url="jdbc:oracle:thin:@myjdbc" -username=my_username --password=my_password --logLevel=finest update -Dschema.name=my_schema -Dtablespace.data=data -Dtablespace.index=index

If I try and execute updateSQL it verifies that the properties have not been applied.  If I throw the update command at the end of the line, I get the liquibase.bat -help message.  Any ideas?!

Cheers,
JF

[Voxland, Nathan]

The dots in the properties may be throwing it off.  What if you try it with underscores?

Nathan

On Apr 27, 2009, at 4:28 PM, "jfrapper" <jfrapper@...> wrote:

Greetings,

I am using changelog parameters in my liquibase changelogs.  Everything
works fine from the ant task, but I cant get them to be recognized from the
command line.  Here is a sample:

liquibase --driver=oracle.jdbc.OracleDriver
--classpath=C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar
--changeLogFile=sql\base.changelog.xml --url="jdbc:oracle:thin:@myjdbc"
-username=my_username --password=my_password --logLevel=finest update
-Dschema.name=my_schema -Dtablespace.data=data -Dtablespace.index=index

If I try and execute updateSQL it verifies that the properties have not been
applied.  If I throw the update command at the end of the line, I get the
liquibase.bat -help message.  Any ideas?!

Cheers,
JF
--
View this message in context: http://www.nabble.com/Changelog-parameters-tp23265536p23265536.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.


------------------------------------------------------------------------------
Crystal Reports &#45; New Free Runtime and 30 Day Trial
Check out the new simplified licensign option that enables unlimited
royalty&#45;free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[jfrapper]

Hi Nathan,

I tried it with underscores and also just using the two words together, for example schemaname.  Neither attempt worked.  The liquibase.bat just doesn't like my properties.  Is there any other information I can provide?  Here is a sample changeset:

    <changeSet author="(generated)" id="1234295864339-1">
        <createTable schemaName="${schemaname}" tablespace="${tablespace.data}" tableName="AUDIT_LOG">
            <column name="AUDIT_LOG_ID" type="NUMBER(22,0)">
                <constraints nullable="false"/>
            </column>
            <column name="ENTITY_ATTRIBUTE" type="VARCHAR2(50)"/>
            <column name="ENTITY_ID" type="NUMBER(22,0)"/>
            <column name="ENTITY_NAME" type="VARCHAR2(50)"/>
            <column name="MESSAGE" type="VARCHAR2(255)"/>
            <column name="UPDATED_BY" type="VARCHAR2(50)"/>
            <column name="OLD_VALUE" type="CLOB"/>
            <column name="NEW_VALUE" type="CLOB"/>
            <column defaultValueDate="sysdate" name="UPDATED_DATE" type="TIMESTAMP(6)"/>
        </createTable>
    </changeSet>

Again, it works fine from ant, but not the command line.

Cheers,
JF

Voxland, Nathan wrote:

The dots in the properties may be throwing it off.  What if you try it  
with underscores?

Nathan

[Voxland, Nathan]

What if you move your paremeters to before the update:

liquibase --driver=oracle.jdbc.OracleDriver
--classpath=C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar
--changeLogFile=sql\base.changelog.xml --url="jdbc:oracle:thin:@myjdbc"
-username=my_username --password=my_password --logLevel=finest
-Dschema.name=my_schema -Dtablespace.data=data -Dtablespace.index=index
update

-----Original Message-----
From: jfrapper [mailto:jfrapper@...]
Sent: Tuesday, April 28, 2009 10:54 AM
To: liquibase-user@...
Subject: Re: [Liquibase-user] Changelog parameters


Hi Nathan,

I tried it with underscores and also just using the two words together,
for
example schemaname.  Neither attempt worked.  The liquibase.bat just
doesn't
like my properties.  Is there any other information I can provide?  Here
is
a sample changeset:

    <changeSet author="(generated)" id="1234295864339-1">
        <createTable schemaName="${schemaname}"
tablespace="${tablespace.data}" tableName="AUDIT_LOG">
            <column name="AUDIT_LOG_ID" type="NUMBER(22,0)">
                <constraints nullable="false"/>
            </column>
            <column name="ENTITY_ATTRIBUTE" type="VARCHAR2(50)"/>
            <column name="ENTITY_ID" type="NUMBER(22,0)"/>
            <column name="ENTITY_NAME" type="VARCHAR2(50)"/>
            <column name="MESSAGE" type="VARCHAR2(255)"/>
            <column name="UPDATED_BY" type="VARCHAR2(50)"/>
            <column name="OLD_VALUE" type="CLOB"/>
            <column name="NEW_VALUE" type="CLOB"/>
            <column defaultValueDate="sysdate" name="UPDATED_DATE"
type="TIMESTAMP(6)"/>
        </createTable>
    </changeSet>

Again, it works fine from ant, but not the command line.

Cheers,
JF


Voxland, Nathan wrote:
>
> The dots in the properties may be throwing it off.  What if you try it

> with underscores?
>
> Nathan
>
>
>

--
View this message in context:
http://www.nabble.com/Changelog-parameters-tp23265536p23279722.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.


------------------------------------------------------------------------
------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[jfrapper]

I get the help message, for example:

liquibase --driver=oracle.jdbc.OracleDriver --classpath=C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar --changeLogFile=sql\base.changelog.xml -url="jdbc:oracle:thin:@local:1521:asdf" --username=my_user --password=my_pass Dschemaname=my_schema -Dtablespacedata=_data -Dtablespaceindex=_index updateSQL
Usage: java -jar liquibase.jar [options] [command]

Standard Commands:
 update                         Updates database to current version
 updateSQL                      Writes SQL to update database to current
                                version to STDOUT
 updateCount <num>              Applies next NUM changes to the database

Voxland, Nathan wrote:

What if you move your paremeters to before the update:

liquibase --driver=oracle.jdbc.OracleDriver
--classpath=C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar
--changeLogFile=sql\base.changelog.xml --url="jdbc:oracle:thin:@myjdbc"
-username=my_username --password=my_password --logLevel=finest
-Dschema.name=my_schema -Dtablespace.data=data -Dtablespace.index=index
update

[Voxland, Nathan]

I think I figured out where the bug is.  It is in the command line app
class, and how it parses the parameters.  How important is it to you to
have it run as a command line app?  Do you need a custom build (or want
the patch so you can build it yourself), or can you hold off until the
next release comes out?

Nathan

-----Original Message-----
From: jfrapper [mailto:jfrapper@...]
Sent: Tuesday, April 28, 2009 1:35 PM
To: liquibase-user@...
Subject: Re: [Liquibase-user] Changelog parameters


I get the help message, for example:

liquibase --driver=oracle.jdbc.OracleDriver
--classpath=C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar
--changeLogFile=sql\base.changelog.xml
-url="jdbc:oracle:thin:@local:1521:asdf" --username=my_user
--password=my_pass Dschemaname=my_schema -Dtablespacedata=_data
-Dtablespaceindex=_index updateSQL
Usage: java -jar liquibase.jar [options] [command]

Standard Commands:
 update                         Updates database to current version
 updateSQL                      Writes SQL to update database to current
                                version to STDOUT
 updateCount <num>              Applies next NUM changes to the database



Voxland, Nathan wrote:
>
> What if you move your paremeters to before the update:
>
> liquibase --driver=oracle.jdbc.OracleDriver
> --classpath=C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar
> --changeLogFile=sql\base.changelog.xml
--url="jdbc:oracle:thin:@myjdbc"
> -username=my_username --password=my_password --logLevel=finest
> -Dschema.name=my_schema -Dtablespace.data=data
-Dtablespace.index=index
> update
>
>
--
View this message in context:
http://www.nabble.com/Changelog-parameters-tp23265536p23283567.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.


------------------------------------------------------------------------
------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[jfrapper]

A patch would be great if you have it ;)

Thanks for the help Nathan...

Cheers,
JF

Voxland, Nathan wrote:

I think I figured out where the bug is.  It is in the command line app
class, and how it parses the parameters.  How important is it to you to
have it run as a command line app?  Do you need a custom build (or want
the patch so you can build it yourself), or can you hold off until the
next release comes out?

Nathan

-----Original Message-----
From: jfrapper [mailto:[e-mail]]
Sent: Tuesday, April 28, 2009 1:35 PM
To: [e-mail]
Subject: Re: [Liquibase-user] Changelog parameters


I get the help message, for example:

liquibase --driver=oracle.jdbc.OracleDriver
--classpath=C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar
--changeLogFile=sql\base.changelog.xml
-url="jdbc:oracle:thin:@local:1521:asdf" --username=my_user
--password=my_pass Dschemaname=my_schema -Dtablespacedata=_data
-Dtablespaceindex=_index updateSQL
Usage: java -jar liquibase.jar [options] [command]

Standard Commands:
 update                         Updates database to current version
 updateSQL                      Writes SQL to update database to current
                                version to STDOUT
 updateCount <num>              Applies next NUM changes to the database



Voxland, Nathan wrote:
>
> What if you move your paremeters to before the update:
>
> liquibase --driver=oracle.jdbc.OracleDriver
> --classpath=C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar
> --changeLogFile=sql\base.changelog.xml
--url="jdbc:oracle:thin:@myjdbc"
> -username=my_username --password=my_password --logLevel=finest
> -Dschema.name=my_schema -Dtablespace.data=data
-Dtablespace.index=index
> update
>
>
--
View this message in context:
http://www.nabble.com/Changelog-parameters-tp23265536p23283567.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.


------------------------------------------------------------------------
------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
[e-mail]
https://lists.sourceforge.net/lists/listinfo/liquibase-user

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
[e-mail]
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[Voxland, Nathan]

You need to replace the parseOptions method in
liquibase.commandline.main with the following version (note: I haven't
actually tested it because my version is lying in small pieces on the
floor of my IDE.  It works for me with my mental JVM though... )

    protected void parseOptions(String[] args) throws
CommandLineParsingException {
        args = fixupArgs(args);

        boolean seenCommand = false;
        for (String arg : args) {
            if (isCommand(arg)) {
                this.command = arg;
                if (this.command.equalsIgnoreCase("migrate")) {
                    this.command = "update";
                } else if (this.command.equalsIgnoreCase("migrateSQL"))
{
                    this.command = "updateSQL";
                }
                seenCommand = true;
            } else if (seenCommand) {
                if (arg.startsWith("-D")) {
                    String[] splitArg = splitArg(arg);

                    String attributeName =
splitArg[0].replaceFirst("^-D", "");
                    String value = splitArg[1];

                    changeLogParameters.put(attributeName, value);
                } else {
                    commandParams.add(arg);
                }
            } else if (arg.startsWith("--")) {
                String[] splitArg = splitArg(arg);

                String attributeName = splitArg[0];
                String value = splitArg[1];

                try {
                    Field field =
getClass().getDeclaredField(attributeName);
                    if (field.getType().equals(Boolean.class)) {
                        field.set(this, Boolean.valueOf(value));
                    } else {
                        field.set(this, value);
                    }
                } catch (Exception e) {
                    throw new CommandLineParsingException("Unknown
parameter: '" + attributeName + "'");
                }
            } else {
                throw new CommandLineParsingException("Unexpected value
" + arg + ": parameters must start with a '--'");
            }
        }

    }



-----Original Message-----
From: jfrapper [mailto:jfrapper@...]
Sent: Tuesday, April 28, 2009 1:56 PM
To: liquibase-user@...
Subject: Re: [Liquibase-user] Changelog parameters


A patch would be great if you have it ;)

Thanks for the help Nathan...

Cheers,
JF


Voxland, Nathan wrote:
>
> I think I figured out where the bug is.  It is in the command line app
> class, and how it parses the parameters.  How important is it to you
to
> have it run as a command line app?  Do you need a custom build (or
want

> the patch so you can build it yourself), or can you hold off until the
> next release comes out?
>
> Nathan
>
> -----Original Message-----
> From: jfrapper [mailto:jfrapper@...]
> Sent: Tuesday, April 28, 2009 1:35 PM
> To: liquibase-user@...
> Subject: Re: [Liquibase-user] Changelog parameters
>
>
> I get the help message, for example:
>
> liquibase --driver=oracle.jdbc.OracleDriver
> --classpath=C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar
> --changeLogFile=sql\base.changelog.xml
> -url="jdbc:oracle:thin:@local:1521:asdf" --username=my_user
> --password=my_pass Dschemaname=my_schema -Dtablespacedata=_data
> -Dtablespaceindex=_index updateSQL
> Usage: java -jar liquibase.jar [options] [command]
>
> Standard Commands:
>  update                         Updates database to current version
>  updateSQL                      Writes SQL to update database to

current
>                                 version to STDOUT
>  updateCount <num>              Applies next NUM changes to the
database

>
>
>
> Voxland, Nathan wrote:
>>
>> What if you move your paremeters to before the update:
>>
>> liquibase --driver=oracle.jdbc.OracleDriver
>> --classpath=C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar
>> --changeLogFile=sql\base.changelog.xml
> --url="jdbc:oracle:thin:@myjdbc"
>> -username=my_username --password=my_password --logLevel=finest
>> -Dschema.name=my_schema -Dtablespace.data=data
> -Dtablespace.index=index
>> update
>>
>>
> --
> View this message in context:
> http://www.nabble.com/Changelog-parameters-tp23265536p23283567.html
> Sent from the LiquiBase - User mailing list archive at Nabble.com.
>
>
>

------------------------------------------------------------------------
> ------
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code
vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> Liquibase-user mailing list
> Liquibase-user@...
> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>
>
------------------------------------------------------------------------
------
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code
vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> Liquibase-user mailing list
> Liquibase-user@...
> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>
>

--
View this message in context:
http://www.nabble.com/Changelog-parameters-tp23265536p23283895.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.


------------------------------------------------------------------------
------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[jfrapper]

I will give it a shot and let you know if there are any issues.

Cheers,
JF

[jfrapper]

Hey Nathan,

I just made the changes to the source file, but the build is failing for me.  This is from the src download for the latest liquibase version 1.9.3.  Build results:

C:\tools\liquibase-1.9.3-src\src>ant clean all
Buildfile: build.xml

clean:

prepare:
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-test
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-dbtest
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-14
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-test-14
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-dbtest-14
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\package\liquibase-1.9.3
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\package\liquibase-1.9.3-src
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\release
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\release\site
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\lib-deps
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-reports
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-reports\api
    [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-reports\doxygen

BUILD FAILED
C:\tools\liquibase-1.9.3-src\src\build.xml:87: C:\tools\liquibase-1.9.3-src\lib-14jvm not found.

Total time: 0 seconds

jfrapper wrote:

I will give it a shot and let you know if there are any issues.

Cheers,
JF

[rynam0]

Hi...  I had the same issue trying to build from a download...
Checking out from svn and then building worked for me.  A link to the
repo can be found here : http://www.liquibase.org/community

Hope this helps.

On 4/29/09, jfrapper <jfrapper@...> wrote:

>
> Hey Nathan,
>
> I just made the changes to the source file, but the build is failing for me.
> This is from the src download for the latest liquibase version 1.9.3.  Build
> results:
>
> C:\tools\liquibase-1.9.3-src\src>ant clean all
> Buildfile: build.xml
>
> clean:
>
> prepare:
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-test
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-dbtest
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-14
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-test-14
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-dbtest-14
>     [mkdir] Created dir:
> C:\tools\liquibase-1.9.3-src\package\liquibase-1.9.3
>     [mkdir] Created dir:
> C:\tools\liquibase-1.9.3-src\package\liquibase-1.9.3-src
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\release
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\release\site
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\lib-deps
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-reports
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-reports\api
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-reports\doxygen
>
> BUILD FAILED
> C:\tools\liquibase-1.9.3-src\src\build.xml:87:
> C:\tools\liquibase-1.9.3-src\lib-14jvm not found.
>
> Total time: 0 seconds
>
>
>
>
> jfrapper wrote:
>>
>> I will give it a shot and let you know if there are any issues.
>>
>> Cheers,
>> JF
>>
>
> --
> View this message in context:
> http://www.nabble.com/Changelog-parameters-tp23265536p23301863.html
> Sent from the LiquiBase - User mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> Liquibase-user mailing list
> Liquibase-user@...
> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>

--
Sent from my mobile device

®¥@N

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[Voxland, Nathan]

The built jar must not be quite right.  I think I had tried pulling out only the "core" library source, not the IDE code etc. and must be missing some things that are needed.

I would mention that the trunk is significantly different and probably broken compared to 1.9.3, so you would probably want to use https://liquibase.svn.sourceforge.net/svnroot/liquibase/tags/1_9_3

Nathan

-----Original Message-----
From: Ryan Connolly [mailto:rynam0@...]
Sent: Wednesday, April 29, 2009 3:40 PM
To: liquibase-user@...
Subject: Re: [Liquibase-user] Changelog parameters

Hi...  I had the same issue trying to build from a download...
Checking out from svn and then building worked for me.  A link to the
repo can be found here : http://www.liquibase.org/community

Hope this helps.

On 4/29/09, jfrapper <jfrapper@...> wrote:

>
> Hey Nathan,
>
> I just made the changes to the source file, but the build is failing for me.
> This is from the src download for the latest liquibase version 1.9.3.  Build
> results:
>
> C:\tools\liquibase-1.9.3-src\src>ant clean all
> Buildfile: build.xml
>
> clean:
>
> prepare:
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-test
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-dbtest
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-14
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-test-14
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-dbtest-14
>     [mkdir] Created dir:
> C:\tools\liquibase-1.9.3-src\package\liquibase-1.9.3
>     [mkdir] Created dir:
> C:\tools\liquibase-1.9.3-src\package\liquibase-1.9.3-src
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\release
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\release\site
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\lib-deps
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-reports
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-reports\api
>     [mkdir] Created dir: C:\tools\liquibase-1.9.3-src\build-reports\doxygen
>
> BUILD FAILED
> C:\tools\liquibase-1.9.3-src\src\build.xml:87:
> C:\tools\liquibase-1.9.3-src\lib-14jvm not found.
>
> Total time: 0 seconds
>
>
>
>
> jfrapper wrote:
>>
>> I will give it a shot and let you know if there are any issues.
>>
>> Cheers,
>> JF
>>
>
> --
> View this message in context:
> http://www.nabble.com/Changelog-parameters-tp23265536p23301863.html
> Sent from the LiquiBase - User mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> Liquibase-user mailing list
> Liquibase-user@...
> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>

--
Sent from my mobile device

®¥@N

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[jfrapper]

Well,

I got the 1.9.3, built it successfully with the changes you posted...  When I ran liquibase with the parameters, I just get the help message.  I have attached the Main.java with the changes included.

Cheers,
JF

Main.java

[Voxland, Nathan]

You forgot to include the .java file, but I'll just apply what I had
sent and take a look.  

Nathan  

-----Original Message-----
From: jfrapper [mailto:jfrapper@...]
Sent: Thursday, April 30, 2009 9:18 AM
To: liquibase-user@...
Subject: Re: [Liquibase-user] Changelog parameters


Well,

I got the 1.9.3, built it successfully with the changes you posted...
When
I ran liquibase with the parameters, I just get the help message.  I
have
attached the Main.java with the changes included.

Cheers,
JF

http://www.nabble.com/file/p23317219/Main.java Main.java
--
View this message in context:
http://www.nabble.com/Changelog-parameters-tp23265536p23317219.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.


------------------------------------------------------------------------
------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[Voxland, Nathan]

It looks like the patch was right, but I think your command line was
using -url instead of --url.   I made the help message output include
the problem to make catching those things easier.

I committed the fix to the new /branches/1_9 branch, and I also put a
build up on http://www.liquibase.org/liquibase-SNAPSHOT.jar that has the
fix.  Take a look and let me know how it works for you.

Nathan

-----Original Message-----
From: Voxland, Nathan [mailto:nvoxland@...]
Sent: Thursday, April 30, 2009 9:57 AM
To: liquibase-user@...
Subject: Re: [Liquibase-user] Changelog parameters

You forgot to include the .java file, but I'll just apply what I had
sent and take a look.  

Nathan  

-----Original Message-----
From: jfrapper [mailto:jfrapper@...]
Sent: Thursday, April 30, 2009 9:18 AM
To: liquibase-user@...
Subject: Re: [Liquibase-user] Changelog parameters


Well,

I got the 1.9.3, built it successfully with the changes you posted...
When
I ran liquibase with the parameters, I just get the help message.  I
have
attached the Main.java with the changes included.

Cheers,
JF

http://www.nabble.com/file/p23317219/Main.java Main.java
--
View this message in context:
http://www.nabble.com/Changelog-parameters-tp23265536p23317219.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.


------------------------------------------------------------------------
------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

------------------------------------------------------------------------
------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[jfrapper]

Good morning Nathan,

Here are a couple test results:

Test 1
liquibase --driver=oracle.jdbc.OracleDriver --classpath=C:\oracle\product\10.2.0db_1\jdbc\lib\ojdbc14.jar --changeLogFile=sql\base.changelog.xml --url="jdbc:oracle:thin:@dev.local:1521:rac" --username=X_OBJ --password=X_QTP UpdateSQL -Dschema.name=X_OBJ -Dtablespace.data=x_data -Dtablespace.index=x_index

Could not parse '-Dschema.name'


Test 2
liquibase --driver=oracle.jdbc.OracleDriver --classpath=C:\oracle\product\10.2.0db_1\jdbc\lib\ojdbc14.jar --changeLogFile=sql\base.changelog.xml --url="jdbc:oracle:thin:@dev.local:1521:rac" --username=X_OBJ --password=X_QTP -Dschema.name=X_OBJ -Dtablespace.data=x_data UpdateSQL

Unexpected value -Dschema.name: parameters must start with a '--'

Cheers,
JF

[Voxland, Nathan]

Version #1 is the one you should be using.  I can run it locally fine
and it gets to "can't find path ...\odbc14.jar" which means it is
parsing it fine for me.  You got the snapshot jar I uploaded?  It could
be related to the .bat file and/or windows command line parsing.  I
don't have it set up at this point to test that very easily.  Could you
try it without the .'s in the parameter names?  

Otherwise, could you try running the java class directly, rather than
using the bat file?  

java -jar PATH_TO_LIQUIBASE.jar --driver=oracle.jdbc.OracleDriver
--classpath=C:\oracle\product\10.2.0db_1\jdbc\lib\ojdbc14.jar
--changeLogFile=sql\base.changelog.xml
--url="jdbc:oracle:thin:@dev.local:1521:rac" --username=X_OBJ
--password=X_QTP UpdateSQL -Dschema.name=X_OBJ -Dtablespace.data=x_data
-Dtablespace.index=x_index

Nathan

-----Original Message-----
From: jfrapper [mailto:jfrapper@...]
Sent: Monday, May 04, 2009 8:31 AM
To: liquibase-user@...
Subject: Re: [Liquibase-user] Changelog parameters


Good morning Nathan,

Here are a couple test results:

Test 1
liquibase --driver=oracle.jdbc.OracleDriver
--classpath=C:\oracle\product\10.2.0db_1\jdbc\lib\ojdbc14.jar
--changeLogFile=sql\base.changelog.xml
--url="jdbc:oracle:thin:@dev.local:1521:rac" --username=X_OBJ
--password=X_QTP UpdateSQL -Dschema.name=X_OBJ -Dtablespace.data=x_data
-Dtablespace.index=x_index

Could not parse '-Dschema.name'


Test 2
liquibase --driver=oracle.jdbc.OracleDriver
--classpath=C:\oracle\product\10.2.0db_1\jdbc\lib\ojdbc14.jar
--changeLogFile=sql\base.changelog.xml
--url="jdbc:oracle:thin:@dev.local:1521:rac" --username=X_OBJ
--password=X_QTP -Dschema.name=X_OBJ -Dtablespace.data=x_data UpdateSQL

Unexpected value -Dschema.name: parameters must start with a '--'

Cheers,
JF
--
View this message in context:
http://www.nabble.com/Changelog-parameters-tp23265536p23367216.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.


------------------------------------------------------------------------
------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[jfrapper]

Hey Nathan,

Both versions work fine referring to the jar file directly.

Cheers,
JF

[Voxland, Nathan]

OK, I'll take a look at the .bat when I get a chance then to try to
figure out where it is going wrong.

Thanks for the troubleshooting help.

Nathan

-----Original Message-----
From: jfrapper [mailto:jfrapper@...]
Sent: Monday, May 04, 2009 12:26 PM
To: liquibase-user@...
Subject: Re: [Liquibase-user] Changelog parameters


Hey Nathan,

Both versions work fine referring to the jar file directly.

Cheers,
JF
--
View this message in context:
http://www.nabble.com/Changelog-parameters-tp23265536p23372803.html
Sent from the LiquiBase - User mailing list archive at Nabble.com.


------------------------------------------------------------------------
------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user

[stevemit]

Did this fix make it into 1.9.4?

Thanks,
  --Steve


OK, I'll take a look at the .bat when I get a chance then to try to
figure out where it is going wrong.

Thanks for the troubleshooting help.

Nathan