How to edit the server.xml?

server.xml is one of required system configuration files. It defines the default JDBC settings for the tppt tool to run the experiment inside the CS network.

The DB server(s) setting are defined in the server.xml file that is included in the distribution jar file. If you want to change it, you have to unzip this file from the jar, and added it back after modification.

   Content Convention

    This file is described using XML 1.0. The pre-defined XML element are listed below:

   

XML Tag/Atttribute

Description

<DBServers>  The Root Element
<Server> DB represents one of DB Server you are going to use. It can have more than one.
     <Name> The name of DBMS, right now support  "SYBASE" and "DB2"
     <JDBCDriver> The JDBC driver string.
     <JDBCURL> The JDBC url string
           ----type "Multi" or "Single". Indicate the URL is for multi-user server ot single-user server.
      <PROXY> IThe proxy server.

   Sample File

<DBServers>

    <Server>
        <NAME>SYBASE</NAME>
        <JDBCDriver>com.sybase.jdbc2.jdbc.SybDriver</JDBCDriver>
        <JDBCURL type="Multi">jdbc:sybase:Tds:rdb.translab.cs.sunysb.edu:5000</JDBCURL>
        <JDBCURL type="Single">jdbc:sybase:Tds:sbntbench.translab.cs.sunysb.edu:5000</JDBCURL>
        <PROXY>www.translab.cs.sunysb.edu:8000</PROXY>
</Server>
<Server>
        <NAME>DB2</NAME>
        <JDBCDriver>COM.ibm.db2.jdbc.net.DB2Driver</JDBCDriver>
        <JDBCURL type="Multi">jdbc:db2://rdb.translab.cs.sunysb.edu:6789/</JDBCURL>
        <!--<JDBCURL type="Multi">jdbc:db2://127.0.0.1:6789/</JDBCURL>-->
        <JDBCURL type="Single">jdbc:db2://rdb.translab.cs.sunysb.edu:6789/</JDBCURL>
</Server>

</DBServers>
 


Back to Help Contents