Hi All

I am facing an issue when I am trying to execute Ant Script in Suse Linux 
Environment. I am using Ant Version 1.6.1. I am using exec Tag in 
Build.xml to make connection to DB2 Database and then using Exec Tag again 
to execute a SQL File

<exec executable="db2" output="db2-nagano.txt" append="true">
           <arg line="-v CONNECT TO dummy USER db2admin USING db2pass" />
</exec>
<exec executable="db2" output="db2-nagano.txt" append="true">
           <arg line="-f getNaganoInfo.sql" />
</exec>


In this case I would like that both Exec Commands should execute in same 
Shell Environment so that Connection made by First Tag can be used by Tag 
2

However I guess Ant is executing both the Command in different shell 
environment and therefore connection made is not passed to next command 
while executing sql file. Hence I am getting Error for "No Connection made 
to database".

This Script seems to be working perfectly fine in Windows Environment. 
Also If I manually type my Command on prompt at Linux shell then also I 
get correct result. Only when I try to do this task using Ant Script I am 
getting this Error which suggest that exec Command is not executing in 
same shell in Linux. Can some one please suggest me workaround for this 
issue as this has become a High Prioroty Issue.



Thanks and Regards
------------------------------------------------------------------------------------------------------------------
Kapil Bajaj
India Software Labs
IBM Software Group.
Email : [EMAIL PROTECTED]

Reply via email to