Thanks Nathan.
Now I know the reason why it was not working. I think it is a bug in
liquibase.
2 of the tables from database were having the values 'TRUE' or 'FALSE' in
the boolean columns. When it was FALSE, I was getting the error *Migration
Failed: For input string: "f" *and when it was TRUE, I was getting the error
* **Migration Failed: For input string: "t"** *. Actual error I saw with
logLevel=finest was the NumberFormatException. It was thrown from the class
liquibase.diff.DiffResult.java
When I removed the values from all boolean fields from those tables, I could
extract the data along with table schema using the same option
diffTypes=data
Please look into it if it is a bug.
Thanks and Regards,
Pradnya
On Thu, Feb 26, 2009 at 5:42 PM, Voxland, Nathan <
[email protected]> wrote:
> I see you are using the 1.4 jvm build. Are you actually running on 1.4,
> or is that just the build you are using? Unless you are using java 1.4 it
> will probably work better to use the standard .jar because it is not
> modified by retroweaver.
>
>
>
> Try adding more diffTypes as well:
>
>
> --diffTypes=’data,tables,columns,views,primaryKeys,uniqueConstraints,indexes,foreignKeys,sequences’
>
> Nathan
>
>
>
> *From:* Pradnya Gawade [mailto:[email protected]]
> *Sent:* Thursday, February 26, 2009 12:26 PM
> *To:* [email protected]
> *Subject:* Re: [Liquibase-user] liquibase: database schema and
> datacontentschangeLog
>
>
>
> Hi,
>
> I tried 'diffTypes' option on command prompt but it was not successful.
> Only *--diffTypes='data'* syntax worked without any error on command line
> but just puts <databaseChangeLog> tag starting and nothing inside it in the
> generated xml file. I am pasting the my command line trials below, last
> command prints the output of *--diffTypes='data'* on console. Could you
> please provide the example of command using this diffTypes parameter which
> will work out exactly?:
>
> *C:\Program Files\PostgreSQL\8.2\bin>java -jar
> C:\Pradnya\Softwares\liquibase\liq
> uibase-1.9.1-14jvm\liquibase-1.9.1-14jvm\liquibase-SNAPSHOT-14jvm.jar
> --classpat
> h=C:\Projects\chin\chinapp\war\WEB-INF\lib\postgresql-8.2-508.jdbc3.jar
> --url="j
> dbc:postgresql://localhost:5432/openclinica" --username=clinica
> --password=
> clinica
> --changeLogFile=C:\Pradnya\liquiBase\samples\openclinica\test\openclinic
> a.xml --diffTypes=data generateChangeLog
> Migration Failed: For input string: "f"
>
> C:\Program Files\PostgreSQL\8.2\bin>java -jar
> C:\Pradnya\Softwares\liquibase\liq
> uibase-1.9.1-14jvm\liquibase-1.9.1-14jvm\liquibase-SNAPSHOT-14jvm.jar
> --classpat
> h=C:\Projects\chin\chinapp\war\WEB-INF\lib\postgresql-8.2-508.jdbc3.jar
> --url="j
> dbc:postgresql://localhost:5432/openclinica" --username=clinica
> --password=
> clinica
> --changeLogFile=C:\Pradnya\liquiBase\samples\openclinica\test\openclinic
> a.xml --diffTypes=DATA generateChangeLog
> Migration Failed: For input string: "f"
>
> C:\Program Files\PostgreSQL\8.2\bin>java -jar
> C:\Pradnya\Softwares\liquibase\liq
> uibase-1.9.1-14jvm\liquibase-1.9.1-14jvm\liquibase-SNAPSHOT-14jvm.jar
> --classpat
> h=C:\Projects\chin\chinapp\war\WEB-INF\lib\postgresql-8.2-508.jdbc3.jar
> --url="j
> dbc:postgresql://localhost:5432/openclinica" --username=clinica
> --password=
> clinica
> --changeLogFile=C:\Pradnya\liquiBase\samples\openclinica\test\openclinic
> a.xml --diffTypes="data" generateChangeLog
> Migration Failed: For input string: "f"
>
> C:\Program Files\PostgreSQL\8.2\bin>java -jar
> C:\Pradnya\Softwares\liquibase\liq
> uibase-1.9.1-14jvm\liquibase-1.9.1-14jvm\liquibase-SNAPSHOT-14jvm.jar
> --classpat
> h=C:\Projects\chin\chinapp\war\WEB-INF\lib\postgresql-8.2-508.jdbc3.jar
> --url="j
> dbc:postgresql://localhost:5432/openclinica" --username=clinica
> --password=
> clinica
> --changeLogFile=C:\Pradnya\liquiBase\samples\openclinica\test\openclinic
> a.xml --diffTypes='data' generateChangeLog
>
> *(above command which worked is run below withoput mentioning the
> changeLogFile, so that output will be on the command primpt)*
>
> C:\Program Files\PostgreSQL\8.2\bin>java -jar
> C:\Pradnya\Softwares\liquibase\liq
> uibase-1.9.1-14jvm\liquibase-1.9.1-14jvm\liquibase-SNAPSHOT-14jvm.jar
> --classpat
> h=C:\Projects\chin\chinapp\war\WEB-INF\lib\postgresql-8.2-508.jdbc3.jar
> --url="j
> dbc:postgresql://localhost:5432/openclinica" --username=clinica
> --password=
> clinica --diffTypes='data' generateChangeLog
> <?xml version="1.0" encoding="UTF-8" standalone="no"?>
> <databaseChangeLog xmlns="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-1.9.xsd"/>
> *
> Thanks and Regards,
> Pradnya*
>
>
> *
>
> On Wed, Feb 25, 2009 at 9:04 PM, Voxland, Nathan <
> [email protected]> wrote:
>
> If you run "liquibase --help" it will give you the options available from
> the command line. There should be a --diffTypes option or something
> similar.
>
>
>
> Nathan
>
>
>
>
> On Feb 25, 2009, at 6:11 PM, "Pradnya Gawade" <[email protected]>
> wrote:
>
> Thanks Ben for the quick reply.
>
>
>
> Presently I am only using the command line for liquibase and will be
> integrating the liquibase with web application developed using spring
> framework. I am not using Ant for liquibase but if there is no other way to
> get the xml with data contents, I will try Ant for the same. Please let me
> know if some thing is possible through command line or even maven.
>
>
>
> Thanks and Regards,
>
> Pradnya
>
>
>
>
>
>
>
> On Wed, Feb 25, 2009 at 6:36 PM, Ben Wolfe <[email protected]> wrote:
>
>
> Yes, there is a way. With the ant task you can set diffTypes="data" to
> just give you the rows in the generated xml. I'm not sure what the
> argument is for the jar file though. I can't find that in my command
> history or in the jar help text.
>
> Ben
>
>
> Pradnya Gawade wrote:
> > Hi,
> >
> > I am new to liquibase and need some help.
> >
> > I want to get the database state with schema and database contents
> > into a chageLog xml file. I want to use this xml at some other place
> > to replicate the exact original database.
> > I could get the database schema with 'generateChangeLog' command but I
> > don't know how can I get the database contents in xml file. Writing
> > the data insert statements manually will be time consuming as there
> > are large number of tables with initial application configuration data
> > in the original database.
> > Is it possible to get such xml with database contents?
> >
> > I also tried 'diff' command between the original and newly created
> > database after migrating the schema xml . but it do not show me the
> > data content differences. I read in the liquibase documentation that
> > 'diff' compares Data differences (limited) but I don't see that in the
> > diff result.
> >
> > Thanks and Regards,
> > Pradnya
>
> > ------------------------------------------------------------------------
> >
> >
> ------------------------------------------------------------------------------
> > 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
> >
>
>
> ------------------------------------------------------------------------------
> 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
>
>
>
>
> ------------------------------------------------------------------------------
> 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
>
>
>
> ------------------------------------------------------------------------------
> 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
>
>
>
>
> ------------------------------------------------------------------------------
> 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
>
>
------------------------------------------------------------------------------
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
