A new topic, 'Use of XInclude', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=709.new#new
The text of the topic is shown below:
I would like to move our Oracle database processes to use liquibase but I don't
want to include trigger and package code inside the XML itself (for a start it
is all in source control as it is a secondly I don't want to prevent developers
compiling code into the database manually - at least for now.)
Beyond the basic concepts I have no experience of using XML but I have come
accross what appears to be the solution to my problem. It is "XInclude" which
should allow me to include sql files in the XML. However I can't get it to
work. Has anyone else tried this? And if so can you provide an example showing
how to go about it? Or am I barking up the wrong tree!!
The code I am trying to write looks like this (at the moment.) It is based on
the walk through example but I have moved the departments_bi trigger code into
a seperate file departments_bi.sql
<?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";>
<changeSet author="jsmith" id="1" runOnChange="true">
<createProcedure>
<xi:include href="departments_bi.sql" parse="text"/>
</createProcedure>
<rollback>
drop trigger departments_bi
</rollback>
</changeSet>
</databaseChangeLog>
When I run this against liquibase I get a massive stack trace, I haven't
provided it as I think I am probably doing something fundamentally wrong but I
can post it if it would help.
Can anyone point me in the right direction?
Thanks
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The Liquibase Community Forum Team.------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
