Hi folks, I need to manually upgrade the schema on an older database by applying the changelog from the command line. I rarely do this (I let Spring do all the work for me) - here’s my command line:
java -jar -verbose ./liquibase-core-1.8.1.jar
–driver=com.mysql.jdbc.Driver
–classpath=pwd:./mysql-connector-java-5.1.6.jar
–changeLogFile=./install.changelog.xml
–url=“jdbc:mysql://redacted.com/redacted”
–username=REDACTED
–password=REDACTED
update
My changelog has in it:
But when I run the liquibase command, I get:
liquibase.exception.ChangeLogParseException: Error Reading Migration File: classpath:/com/stonekeep/congo/structs/stored-procedures.changelog.xml could not be found
at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:76)
at liquibase.parser.ChangeLogParser.parse(ChangeLogParser.java:24)
at liquibase.parser.xml.XMLChangeLogHandler.handleIncludedChangeLog(XMLChangeLogHandler.java:233)
at liquibase.parser.xml.XMLChangeLogHandler.startElement(XMLChangeLogHandler.java:80)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(AbstractSAXParser.java:501)
at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(AbstractXMLDocumentParser.java:179)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyElement(XMLSchemaValidator.java:719)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:377)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:140)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:70)
at liquibase.parser.ChangeLogParser.parse(ChangeLogParser.java:24)
at liquibase.Liquibase.update(Liquibase.java:107)
at liquibase.commandline.Main.doMigration(Main.java:637)
at liquibase.commandline.Main.main(Main.java:90)
Caused by: java.io.IOException: classpath:/com/stonekeep/congo/structs/stored-procedures.changelog.xml could not be found
at liquibase.commandline.CommandLineFileOpener.getResourceAsStream(CommandLineFileOpener.java:25)
at liquibase.CompositeFileOpener.getResourceAsStream(CompositeFileOpener.java:44)
at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:63)
… 21 more
Migration Failed: classpath:/com/stonekeep/congo/structs/stored-procedures.changelog.xml could not be found
The file is there, in a local subdir:
dbs@nimitz:~/lb$ ls -l com/stonekeep/congo/structs/stored-procedures.changelog.xml
-rw-r–r-- 1 dbs dbs 3903 2010-12-30 14:53 com/stonekeep/congo/structs/stored-procedures.changelog.xml
Help?