Inserting a row, getting Foreign Key from another table.


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.