You are correct, my mistake. I will try wrapping it inside <changeSet>.
Thanks and Regards,
Pradnya
On Thu, Feb 26, 2009 at 6:15 PM, Voxland, Nathan <
[email protected]> wrote:
> I think you are forgetting to wrap your <sql> tag in a <changeSet> tag.
>
>
>
> You can support multi-line sql by using the splitStatements=”false”
> attribute
>
>
>
> Nathan
>
>
>
> *From:* Pradnya Gawade [mailto:[email protected]]
> *Sent:* Thursday, February 26, 2009 5:07 PM
> *To:* [email protected]
> *Subject:* [Liquibase-user] Liquibase: Custon sql with <sql> tag
>
>
>
> Hi,
>
> I have a query about implementing Custon sql with <sql> tag in the
> liquibase changeLog xml file.
> I have to add some CREATE FUNCTION sql code in the <sql> tag. It has
> multilined sql statements and I am not successful in excecuting the same. I
> am not very clear with the line and statement separators inside <sql> tag
> I get following exception:
>
> *C:\Program Files\PostgreSQL\8.2\bin>java -jar
> C:\Pradnya\Softwares\liquibase\liquibase-1.9.1-14jvm\liquibase-1.9.1-14jvm\liquibase-SNAPSHOT-14jvm.jar
> --classpath=C:\Projects\chin\chinapp\war\WEB-INF\lib\postgresql-8.2-508.jdbc3.jar
> --changeLogFile=C:\Pradnya\liquiBase\openclinica_2.5_snapshot\openclinica3.xml
> --url="jdbc:postgresql://localhost:5432/test_openclinica_2.5_snapshot"
> --username=clinica --password=clinica migrate
>
> Migration Failed: Error parsing line 2307 column 10 of
> C:/Pradnya/liquiBase/openclinica_2.5_snapshot/openclinica3.xml:
> cvc-complex-type.2.4.a: Invalid content was found starting with element
> 'sql'. One of {"http://www.liquibase.org/xml/ns/dbchangelog/1.9":changeSet,
> "http://www.liquibase.org/xml/ns/dbchangelog/1.9":include, "
> http://www.liquibase.org/xml/ns/dbchangelog/1.9":includeAll}' is expected.
> *
>
> It was a multilined create function in it this time. When I tried with a
> simple insert statement as follows,
>
> *<sql>insert into status (status_id, name, description) values (00001,
> 'test', 'test')</sql>*
>
> It gave me similar error as follows (logLevel is set to 'finest' this
> time):*
>
> C:\Program Files\PostgreSQL\8.2\bin>java -jar
> C:\Pradnya\Softwares\liquibase\liquibase-1.9.1-14jvm\liquibase-1.9.1-14jvm\liquibase-SNAPSHOT-14jvm.jar
> --classpath=C:\Projects\chin\chinapp\war\WEB-INF\lib\postgresql-8.2-508.jdbc3.jar
> --changeLogFile=C:\Pradnya\liquiBase\openclinica_2.5_snapshot\openclinica3.xml
> --url="jdbc:postgresql://localhost:5432/test_openclinica_2.5_snapshot"
> --username=clinica --password=clinica --logLevel=finest migrate
> Feb 26, 2009 5:42:55 PM liquibase.database.template.JdbcTemplate comment
> INFO: Create Database Lock Table
> Feb 26, 2009 5:42:55 PM liquibase.database.template.JdbcTemplate comment
> INFO: Lock Database
> Feb 26, 2009 5:42:55 PM liquibase.lock.LockHandler acquireLock
> INFO: Successfully acquired change log lock
> Feb 26, 2009 5:42:55 PM liquibase.database.template.JdbcTemplate comment
> INFO: Create Database Change Log Table
> Feb 26, 2009 5:42:55 PM liquibase.database.AbstractDatabase
> checkDatabaseChangeL
> ogTable
> INFO: Creating database history table with name: databasechangelog
> Feb 26, 2009 5:42:57 PM liquibase.parser.xml.XMLChangeLogParser$1 error
> SEVERE: cvc-complex-type.2.4.a: Invalid content was found starting with
> element'sql'. One of
> '{"http://www.liquibase.org/xml/ns/dbchangelog/1.9":changeSet,
> "http://www.liquibase.org/xml/ns/dbchangelog/1.9":include, "
> http://www.liquibase.org/xml/ns/dbchangelog/1.9":includeAll}' is expected.
> Feb 26, 2009 5:42:57 PM liquibase.database.template.JdbcTemplate comment
> INFO: Release Database Lock
> Feb 26, 2009 5:42:57 PM liquibase.lock.LockHandler releaseLock
> INFO: Successfully released change log lock
> Migration Failed: Error parsing line 2307 column 10 of
> C:/Pradnya/liquiBase/openclinica_2.5_snapshot/openclinica3.xml:
> cvc-complex-type.2.4.a: Invalid content w
> as found starting with element 'sql'. One of '{"
> http://www.liquibase.org/xml/ns/dbchangelog/1.9":changeSet, "
> http://www.liquibase.org/xml/ns/dbchangelog/1.9":in
> clude, "http://www.liquibase.org/xml/ns/dbchangelog/1.9":includeAll}' is
> expected.. For more information, use the --logLevel flag)
> Feb 26, 2009 5:42:57 PM liquibase.commandline.Main main
> SEVERE: Error parsing line 2307 column 10 of
> C:/Pradnya/liquiBase/openclinica_2.5_snapshot/openclinica3.xml:
> cvc-complex-type.2.4.a: Invalid content was found s
> tarting with element 'sql'. One of '{"
> http://www.liquibase.org/xml/ns/dbchangelog/1.9":changeSet, "
> http://www.liquibase.org/xml/ns/dbchangelog/1.9":include, "ht
> tp://www.liquibase.org/xml/ns/dbchangelog/1.9":includeAll}' is
> expected.liquibase.exception.ChangeLogParseException: Error parsing line
> 2307 column 10 o
> f C:/Pradnya/liquiBase/openclinica_2.5_snapshot/openclinica3.xml:
> cvc-complex-type.2.4.a: Invalid content was found starting with element
> 'sql'. One of '{"http:
> //www.liquibase.org/xml/ns/dbchangelog/1.9":changeSet, "
> http://www.liquibase.org/xml/ns/dbchangelog/1.9":include, "
> http://www.liquibase.org/xml/ns/dbchangelog/1.9":includeAll}' is expected.
> at
> liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java
> :78)
> at liquibase.parser.ChangeLogParser.parse(ChangeLogParser.java:28)
> at liquibase.Liquibase.update(Liquibase.java:105)
> at liquibase.commandline.Main.doMigration(Main.java:646)
> at liquibase.commandline.Main.main(Main.java:95)*
>
> Could some one pls explain what could be wrong with this. Also providing a
> sample of multilined sql statements and multiple statements in the same xml
> file would help me understand the rules for muliti lined stataments and
> multiple statements in the same file.
> Thanks in advance.
>
> - 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
