---

Note: Whenever any changes are made to the XML configuration file, the connection agent server needs to be restarted so the new configuration is reloaded.

---

 

<config>

 

The configuration file is an XML file. On a Tomcat server the file is located at the following path: tomcat_install_dir/webapps/PerfectFormsAgent/WEB-INF/config.xml

 

The config.xml file will look something like this:

 

<config>

    <logins> 

        <login id=”login1” username=”username1” password=”password1” />

        <login id=”login2” username=”username2” password=”password2” />

    </logins>

 <access

        <ip address=”*” access=”deny” />

      <ip address=”123.123.124.1” access=”allow” /> 

    </access>

    <datasources>

        <datasource name=”Oracle Production” id=”1” server=”127.0.5.192” port=”1521” 

                 type=”oracle”>

            <database name=”Personel” id=”11”  db=”employees” user=”usr1” password=”pass1”  

                 login=”*”/>

            <database name=”Parts” id=”12” db=”parts_catalog” user=”usr2” password=”pass2” 

                 login="msmith"                

            <database name=”Customers” id=”1n” db=”customers” user=”usrn” password=”passn” 

                 login="msmith, jdoe, rjones"

        <datasource/>

    <datasources/>

</config>

 

 

Making Changes to the config.xml File (WebSphere Application Server)

 

The config.xml file is located in the connection agent's installation on the WebSphere application server. Whenever any changes are made to the XML configuration file, the connection agent needs to be restarted so the new configuration is reloaded.

 

 

 

Setting Higher Number of Rows Returned through the Config File

 

The Connection Agent allows users to set a higher limit into config.xml. If the config xml does not contain an explicit limit, then the default of 1000 is used.

 

The Connect behavior command enables users to set Max Records to a maximum of 999999999. The Connection Agent's limit will maintain higher priority. Because of this, when a request reaches the Connection Agent, the maximum returned records cannot be higher than the limit that is set into config.xml, although PerfectForms™ users can still set it into the Properties dialog.

 

config.xml example:

<datasource  name ="Northwind" id="3" server="SHRP" port="1433" type="sqlserver">

 <database name ="Northwind" id="11"  db="Northwind" user="sa" password="black" login="*" maxrecords="2500"/>

</datasource>

 

In the above example the limit for maximum returned records was set to 2500.

Updated: 06/12/2011  Page url: http://www.perfectforms.com/Documentation/manual/html/?admin_config_file.htm
PerfectForms™ -- forms software, workflow software, and business process management