« Return to Thread: Changelog parameters

Re: Changelog parameters

by Voxland, Nathan :: Rate this Message:

Reply to Author | View in Thread

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

 « Return to Thread: Changelog parameters