Hi,
I was trying to migrate a Sample.xml file which contains a table and a ora:createtrigger.../ tag using the liquibase-oracle-1.2.0.jar (provided in the oracle extensions) in the classpath. My Sample file is as follows:
<?xml version="1.0" encoding="UTF-8"?>
<ora:createTrigger
afterBeforeInsteadOf=“before”
procedure=“DECLARE v_username varchar2(10); BEGIN SELECT pierwsza INTO v_username FROM TriggerTest; :new.created_by := v_username; END;”
triggerName=“myTrigger”
tableName=“TriggerTest”
insert=“true”
forEachRow=“true”/>
When i executed the same from Commandline using the command:
liquibase --classpath=“ojdbc6.jar;liquibase-oracle-1.2.0.jar” --driver=oracle.jdbc.OracleDriver --changeLogFile=Sample.xml --url=“jdbc:oracle:thin:@localhost:1521:XE” --username=demo2 --password=demo2 migrate
I am getting an error stating :
INFO 6/30/11 5:38 PM:liquibase: Successfully acquired change log lock
SEVERE 6/30/11 5:38 PM:liquibase: The prefix “ora” for element “ora:createTrigger” is not bound.
INFO 6/30/11 5:38 PM:liquibase: Successfully released change log lock
Liquibase Update Failed: The prefix “ora” for element “ora:createTrigger” is not bound.
SEVERE 6/30/11 5:38 PM:liquibase: The prefix “ora” for element “ora:createTrigger” is not bound.
liquibase.exception.ChangeLogParseException: Error parsing line 11 column 24 of Sample.xml: The prefix “ora” for element “ora:createTrigger” is not bound.
at liquibase.parser.core.xml.XMLChangeLogSAXParser.parse(XMLChangeLogSAXParser.java:106)
at liquibase.Liquibase.update(Liquibase.java:106)
at liquibase.integration.commandline.Main.doMigration(Main.java:684)
at liquibase.integration.commandline.Main.main(Main.java:116)
Caused by: org.xml.sax.SAXParseException: The prefix “ora” for element “ora:createTrigger” is not bound.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(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.core.xml.XMLChangeLogSAXParser.parse(XMLChangeLogSAXParser.java:98)
… 3 more
Can anyone please help me to understand where am I going wrong ??
I am not able to figure it out…
Please help.