Re: [enhydra] Using variables in loaderJob xml file

["Sinisa Milosevic" <sinisa@xxxxxxxxxxxxx>]

Title: Message

Hi,

 

Variable which you define in variables tag can't be used to replace values in connection parameters. These variables can be used to replace some source data or some values in SQL statements.

 

Of course, you can define variable using property file (you have to set this property file in xml).

 

Regards,

Sinisa

----- Original Message -----

From: Laurent Clausse

To: enhydra@xxxxxxxxxxx

Sent: Thursday, April 29, 2004 5:43 PM

Subject: [enhydra] Using variables in loaderJob xml file

I use octopus 2.6.1 as an ant task. And I want to use parameters because I have several environments. So I use build.properties and I can easily use these parameters in build.xml. OK! But I want to use parameter in the loaderJob xml file too.

 

In the documentation of Octopus 2.6.1, there is an examples of LoaderTask (in the file build.xml) in which you declare variables:

 

<taskdef name="LoaderTask" classname="org.webdocwf.util.loader.task.LoaderTask"/>
  <LoaderTask
           mode="full"
           restartIndicator="yes"
           userID="admin"
           logDir="c:\my_directory_for_logfiles"
           logFile="c:\somewhere\down\..\mydir2\mylog.txt"
           vendorFile="MyVendor.xml"
          
           commitCount="1000"
           loadJob="GRECOOMDSBROWSER/ObjectLoader/LoadOMDSProject.xml">
      <additionalPaths>
          <additionalPath path="../lib/xercesImpl.jar"/>
          <additionalPath path="../lib/Octopus.jar"/>
          <additionalPath path="../lib/freetds_jdbc.jar"/>
      </additionalPaths>
      <variables>
          <variable name="name" value="varval"/>
      </variables>
  </LoaderTask>

 

The explanation says about the <varaible> tag: "name" is name of variable that is used in Octopus variable columns (loaderJob xml file). "value" is value of variable that is used in Octopus variable columns (loaderJob xml file).

 

I want to get the parameter in loaderJob xml file to use it in the <jdbcDefaultParameters> tag. Is it possible? If the answer is yes then what is the syntax? (I tried %name%, $name$, !name!...) and that does not work.

 

If it works, I will try get the value of the variable in the build.properties file. Consequently, I hope to finally be able to declare the variable as follows:

      <variables>
          <variable name="name" value="${varval}$"/>
      </variables>

 

Thanks,

Laurent