I am wirting a script to import data, i have 2 XML’s which contain book data and another which contains the page contents.
The script i have written produces the Liquibase changeSet’s.
I have an issue that i am inserting a book into 1 table and then when i come to insert the page there is a foreign key that i need to then select from the book table for the book that has just been inserted.
This i what i have so far:
Inserting the Book.
I tried using the SQL tag to run the query but i get a parsing error.
Has anyone got any ideas on how i can do this.
Thanks in advanced.