Prolog and Epilog files insertion order

[BBoucard]

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]

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]

Hi,

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

HTH,
Ralf

[BBoucard]

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