Prolog and Epilog files insertion order

BBoucard
2013-10-03
2013-10-08
  • BBoucard
    BBoucard
    2013-10-03

    Hello,

    First a great thank you for your tool Jailer.

    Do you agree wih me if i say that prolog.sql and epilog.sql files are inserted into the final scripts with an alphabetical order ? But with such an order, the final script is not correct.

    Here is an example of what i got :

    1) EXECUTE IMMEDIATE 'ALTER TABLE DOSSIER disable ... ';
    2) EXECUTE IMMEDIATE 'ALTER TABLE INSCRIPTION disable ...';
    3) BEGIN
    3)   SAVEPOINT JAILER_DEBUT_INSERT;
    
    4) Insert into ORDREDUJOUR ...;
    4) ...
    
    5) EXECUTE IMMEDIATE 'ALTER TABLE DOSSIER enable ...';
    
    6)   commit;
    6)   EXCEPTION
    6)     WHEN  others THEN
    6)       rollback to JAILER_DEBUT_INSERT;
    6) END;
    
    7) EXECUTE IMMEDIATE 'ALTER TABLE INSCRIPTION enable ... ';
    

    with :
    1) prolog\INSERT\dossier.sql
    2) prolog\INSERT\inscription.sql
    3) prolog\INSERT\PROLOG.sql
    4) script created by Jailer
    5) epilog\INSERT\dossier.sql
    6) epilog\INSERT\EPILOG.sql
    7) epilog\INSERT\inscription.sql

    I was hopping an order like :
    prolog\INSERT\prolog.sql
    prolog\INSERT...
    Jailer Script
    epilog\INSERT...
    epilog\INSERT\Epilog.sql

    Thanks in advance for your answer.
    Regards

    B. Boucard

     
  • Ralf Wisser
    Ralf Wisser
    2013-10-04

    Hi,

    yes, I agree with you that it's better to insert the files in the order you suggested. I will change it soon.

    Regards,
    Ralf

     
  • Ralf Wisser
    Ralf Wisser
    2013-10-04

    Hi,

    I've uploaded release 4.0.18.
    Please have a try.

    HTH,
    Ralf

     
  • BBoucard
    BBoucard
    2013-10-08

    Hello,

    Prolog.sql is now at the top of the sql script.
    And epilog.sql is at the bottom.
    Thank you for this release.

    Have à good day
    Bertrand

     


Anonymous


Cancel   Add attachments