Ant Build - How i print with a variable in echo tag using sql transaction?

[Mikel Mato]

Hi all, I have this xml to use with ant build and i want to obtain one variable that I will explain later:

<?xml version="1.0" encoding="UTF-8"?>
<project name="ProjectOne">
    <echo>----Start with project----</echo>
    <sql
          driver="com.ibm.db2.jcc.DB2Driver"
          url="jdbc:db2://xxxx:xxxx/xxxx"
          userid="xxxxxxx"
          password="xxxxx"
          print="yes"
          showheaders="false"
          showtrailers="false"
     >
          <transaction src="mysql.sql"/> //Sql with query in file.sql
     </sql>
     <echo>----Finish Project----</echo>
</project>

This is my question:
How i can obtain the result of my query and put it in variable, that it is located in transaction tag and use echo tag to show the result?
I need it to show in the future the result obtained through this variable.

e.g (I think that it is similar):

<property name="SrcDir" value="src"/>
<echo message="${SrcDir}"/>

Regards.

[Jeanne Boyarsky]

Mikel,
Welcome to CodeRanch!

The <sql> task has an "output" attribute that lets you specify where the output should go. You can have it go to a file of any name.

Then you can use <loadFile> to read the file into a property.

[Mikel Mato]

Jeanne Boyarsky wrote:Mikel,
Welcome to CodeRanch!

The <sql> task has an "output" attribute that lets you specify where the output should go. You can have it go to a file of any name.

Then you can use <loadFile> to read the file into a property.

Thanks Jeanne for reply my question.

It works and is very useful.

Regards.