External Property Imports from xml rather than LiquiBase command params
|
View:
New views
4 Messages
—
Rating Filter:
Alert me
|
 |
External Property Imports from xml rather than LiquiBase command params
by Christian Maslen
::
Rate this Message:
|
|
|
Re: External Property Imports from xml rather than LiquiBase command params
by Voxland, Nathan
::
Rate this Message:
You are able to specify properties as XML nodes at the beginning of a change set, but currently not in an external file. The closest you could do is create a separate file containign the property XML and include it with an XML entity include.
Nathan ________________________________ From: liquibase-user-bounces@... on behalf of Christian Maslen Sent: Sun 7/6/2008 11:11 PM To: liquibase-user@... Subject: [Liquibase-user] External Property Imports from xml rather than LiquiBase command params Hi, My current understanding of externally supplied parameter values is you can inject them from the command line using the -D parameter as per http://www.liquibase.org/manual/command_line The manual entry . What I'd really like to do is have a changeset style xml file that I can reference from all of my change set files using a tag similar to the include tag. I did try using the include tag but this didn't work. The way I use properties is to define type synonyms that make certain categories of columns consistent. Eg all the description type columns are varchar(100). All the keys are int. So I'm basically trying to migrate what I would have used ERWin's domains for to LiquiBase (note I'm not interested in user defined types here, I use properties for other stuff - eg a common base value for sequences). All of these property values would be cumbersome to supply as part of my command line to LiquiBase. Is there a way to do this that I'd missed in the manual? Thanks in advance, Christian Maslen -- View this message in context: http://www.nabble.com/External-Property-Imports-from-xml-rather-than-LiquiBase-command-params-tp18309766p18309766.html Sent from the LiquiBase - User mailing list archive at Nabble.com. ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user |
|
|
Re: External Property Imports from xml rather than LiquiBase command params
by Christian Maslen
::
Rate this Message:
|
|
|
Re: External Property Imports from xml rather than LiquiBase command params
by Voxland, Nathan
::
Rate this Message:
The liquibase include tag won't work because it will try to run it as a separate changelog file. You'd need to use something like
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.7" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.7 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.7.xsd"> <!ENTITY properties SYSTEM "properties.xml"> <preConditions> <dbms type="db2"/> <runningAs username="db2build"/> </preConditions> &properties; <changeSet id="1" author="sczm"> <comment> All tables created in the one change set. Include PKs, indexes and sequences </comment> Although I'm not exactly sure of the syntax of the Entity declaration when using XSD validation like liquibase does. The idea is to leverage the file include functionality of the XML parser since there isn't direct support in liquibase currently. Nathan ________________________________ From: liquibase-user-bounces@... on behalf of Christian Maslen Sent: Tue 7/8/2008 12:38 AM To: liquibase-user@... Subject: Re: [Liquibase-user] External Property Imports from xml rather than LiquiBase command params Voxland, Nathan wrote: > > The closest you could do is create a separate file containign the property > XML and include it with an XML entity include. > Hi Nathan, Thanks again for your response. I did try this. Below is a sample: The properties.changelog.xml file: <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.7" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.7 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.7.xsd"> <!-- Various constants --> <property name="Sequence.DefaultStart" value="300000"/> <property name="TableSpace.Table" value="TB_General"/> <property name="TableSpace.Index" value="IX_General"/> <property name="TableSpace.Blob" value="LG_General"/> <!-- etc --> </databaseChangeLog> The running change log file: <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.7" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.7 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.7.xsd"> <preConditions> <dbms type="db2"/> <runningAs username="db2build"/> </preConditions> <include file="properties.changelog.xml"/> <changeSet id="1" author="sczm"> <comment> All tables created in the one change set. Include PKs, indexes and sequences </comment> <!-- ** ** A table... ** --> <createTable tableName="Table_name" tablespace="${TableSpace.Table}"> <column name="TableName_Id" type="int"> <constraints nullable="false" /> </column> <!-- etc --> </createTable> </changeSet> </databaseChangeLog> The error (from a run from my actual file rather than the abridged sample above): C:\SvnRoot\cip\Source\Databases\Cip\Core\..\..\..\..\Tools\LiquiBase\liquibase-1.7.0\liquibase.bat --driver=com.ibm.db2.jcc.DB2Driver --classpath=".;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc.jar;C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\PROGRA~1\IBM\SQLLIB\bin;C:\PROGRA~1\IBM\SQLLIB\java\common.jar" --changeLogFile= release-1.0-root.changelog.xml --url="jdbc:db2:CIP" --username=db2build --password=Db2Build update java.lang.NumberFormatException: For input string: "${Sequence.DefaultStart}" at java.lang.NumberFormatException.forInputString(Unknown Source) at java.lang.Integer.parseInt(Unknown Source) at java.lang.Integer.valueOf(Unknown Source) at liquibase.util.ObjectUtil.setProperty(ObjectUtil.java:33) at liquibase.parser.xml.XMLChangeLogHandler.setProperty(XMLChangeLogHandler.java:242) at liquibase.parser.xml.XMLChangeLogHandler.startElement(XMLChangeLogHandler.java:154) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:71) at liquibase.parser.ChangeLogParser.parse(ChangeLogParser.java:24) at liquibase.parser.xml.XMLChangeLogHandler.handleIncludedChangeLog(XMLChangeLogHandler.java:229) at liquibase.parser.xml.XMLChangeLogHandler.startElement(XMLChangeLogHandler.java:80) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:71) at liquibase.parser.ChangeLogParser.parse(ChangeLogParser.java:24) at liquibase.Liquibase.update(Liquibase.java:101) at liquibase.commandline.Main.doMigration(Main.java:630) at liquibase.commandline.Main.main(Main.java:89) liquibase.exception.ChangeLogParseException: Invalid Migration File: For input string: "${Sequence.DefaultStart}" at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:105) at liquibase.parser.ChangeLogParser.parse(ChangeLogParser.java:24) at liquibase.parser.xml.XMLChangeLogHandler.handleIncludedChangeLog(XMLChangeLogHandler.java:229) at liquibase.parser.xml.XMLChangeLogHandler.startElement(XMLChangeLogHandler.java:80) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:71) at liquibase.parser.ChangeLogParser.parse(ChangeLogParser.java:24) at liquibase.Liquibase.update(Liquibase.java:101) at liquibase.commandline.Main.doMigration(Main.java:630) at liquibase.commandline.Main.main(Main.java:89) Caused by: java.lang.NumberFormatException: For input string: "${Sequence.DefaultStart}" at liquibase.parser.xml.XMLChangeLogHandler.startElement(XMLChangeLogHandler.java:224) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:71) ... 21 more Migration Failed: For input string: "${Sequence.DefaultStart}" -- View this message in context: http://www.nabble.com/External-Property-Imports-from-xml-rather-than-LiquiBase-command-params-tp18309766p18332236.html Sent from the LiquiBase - User mailing list archive at Nabble.com. ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user |
winmail.dat (7K) | Free Forum Powered by Nabble | Forum Help |