[izpack-users] How to Execute Oracle DB Script By Installer?

[Tam]

Hi,

 

I need to make the installer to execute the oracle db scripts (.sql) file. I
have tried by include this in install.xml file:

        <pack name="DB Patch" required="yes">

            <description>DB Patch scripts</description>

            <file src=" DB-PATCH" targetdir="$INSTALL_PATH"/>

            

            <!-- Tells IzPack to execute script that apply db patch after
the installation process -->

            <executable keep="true" os="windows" stage="postinstall"
failure="warn" targetfile="$INSTALL_PATH/$DB_PATCH_PATH/test.cmd"/>

        </pack>

 

And in the test.cmd is:

            sqlplus mst_admin/xls at xls66_local @test.sql

 

In the test.sql could be any insert or update statement or even
create/replace stored proc.

 

I will appreciate if you can help to solve this problem.

Thank you.

            

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.berlios.de/pipermail/izpack-users/attachments/20060215/493269b2/attachment.html