That is a bug. I will get it fixed. Thanks for the help
troubleshooting it.
Nathan
From: Pradnya Gawade [mailto:[email protected]]
Sent: Thursday, February 26, 2009 4:55 PM
To: [email protected]
Subject: Re: [Liquibase-user] liquibase: database schema
anddatacontentschangeLog
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,ind
exes,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
