Menu ▾ ▴

Variables not working ${AgentID}

Open Discussion
David Fishburn
2004-11-23
2013-04-25

  • David Fishburn

    David Fishburn - 2004-11-23

    I am using todays CVS version.
    Hopefully I am not making a simple mistake with this, since I have spent too long on a typo...

    Very simple test:

      <test name="Retrieve Remotes Agent ID">
        <sql connection-id="remote" >
          <stmt>
            SELECT TOP 1 agy_id
              FROM T0PTY
             ORDER BY agy_id
          </stmt>
        </sql>
        <result>
          <resultset id="1">
            <row id="1">
              <col id="1" name="agy_id" type="INTEGER">${AgentID}</col>
            </row>
          </resultset>
        </result>
      </test>

      <test name="Retrieve Record">
        <sql connection-id="remote" >
          <stmt>
            SELECT TOP 1 agy_id
              FROM T0PTY
             WHERE agy_id = ?
             ORDER BY agy_id
          </stmt>
          <param id="1" type="INTEGER">${AgentID}</param>
        </sql>
        <result>
          <resultset id="1">
            <row id="1">
              <col id="1" name="agy_id" type="INTEGER">102</col>
            </row>
          </resultset>
        </result>
      </test>

    Results:
    sqlunit-flat:
      [sqlunit] *** Running SQLUnit file: D:\files\SQLAny\rep9\sqlunit\variable.xml
      [sqlunit] Getting connection(remote)
      [sqlunit] Setting up test...
      [sqlunit] Running test[1]: Retrieve Remotes Agent ID (70ms)
      [sqlunit] Running test[2]: Retrieve Record (70ms)
      [sqlunit] Assertion "resultset-equals" failed (1 != 0 at result[1].#rows)
      [sqlunit] *** expected:
      [sqlunit] <result>
      [sqlunit]   <resultset id="1">
      [sqlunit]     <row id="1">
      [sqlunit]       <col id="1" name="agy_id" type="INTEGER">102</col>
      [sqlunit]     </row>
      [sqlunit]   </resultset>
      [sqlunit] </result>
      [sqlunit] *** but got: <result>
      [sqlunit]   <resultset id="1" />
      [sqlunit] </result>

    Here is the debug output:

    init:

    precompile:

    compile:
        [javac] Compiling 7 source files to D:\Programs\sqlunit-cvs\build
        [javac] Note: D:\Programs\sqlunit-cvs\src-gen\IncludeFileParser.java uses unchecked or unsafe operations.
        [javac] Note: Recompile with -Xlint:unchecked for details.

    def:

    sqlunit-flat:
      [sqlunit] DEBUG [main] (SQLUnit.java:217) - >> testWrapper()
      [sqlunit] DEBUG [main] (SQLUnit.java:239) - >> processDoc()
      [sqlunit] DEBUG [main] (TypeMapper.java:67) - instantiating TypeMapper
      [sqlunit] DEBUG [main] (TypeMapper.java:169) - loading types from: net.sourceforge.sqlunit.types
      [sqlunit] DEBUG [main] (TypeMapper.java:169) - loading types from: usertypes
      [sqlunit] DEBUG [main] (TypeMapper.java:203) - loading non-mapped types
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -7
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -7
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-7)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BIT=-7
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BIT for -7
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BIT
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BIT)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BIT
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -6
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -6
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-6)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding TINYINT=-6
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key TINYINT for -6
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: TINYINT
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(TINYINT)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by TINYINT
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 5
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 5
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(5)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding adaptive_server_anywhere.SMALLINT=5
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding adaptive_server_enterprise.SMALLINT=5
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding SMALLINT=5
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding sybase_sql_server.SMALLINT=5
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding sql_server.SMALLINT=5
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + adaptive_server_anywhere.SMALLINT for 5
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + adaptive_server_enterprise.SMALLINT for 5
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key SMALLINT for 5
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + sybase_sql_server.SMALLINT for 5
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + sql_server.SMALLINT for 5
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: SMALLINT
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(SMALLINT)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by SMALLINT
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 4
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by INTEGER
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -5
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -5
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-5)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BIGINT=-5
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BIGINT for -5
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BIGINT
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BIGINT)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BIGINT
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 6
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 6
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(6)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding mysql.FLOAT=6
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding FLOAT=6
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + mysql.FLOAT for 6
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key FLOAT for 6
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: FLOAT
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(FLOAT)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by FLOAT
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 7
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 7
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(7)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding REAL=7
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key REAL for 7
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: REAL
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(REAL)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by REAL
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 8
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 8
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(8)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding DOUBLE=8
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key DOUBLE for 8
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DOUBLE
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DOUBLE)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by DOUBLE
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding sybase_sql_server.NUMERIC=2
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding postgresql.NUMERIC=2
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding oracle.NUMERIC=2
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding adaptive_server_anywhere.NUMERIC=2
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding sql_server.NUMERIC=2
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding adaptive_server_enterprise.NUMERIC=2
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding NUMERIC=2
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + sybase_sql_server.NUMERIC for 2
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + postgresql.NUMERIC for 2
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + oracle.NUMERIC for 2
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + adaptive_server_anywhere.NUMERIC for 2
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + sql_server.NUMERIC for 2
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + adaptive_server_enterprise.NUMERIC for 2
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key NUMERIC for 2
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: NUMERIC
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by NUMERIC
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 3
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 3
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(3)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding DECIMAL=3
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key DECIMAL for 3
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DECIMAL
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DECIMAL)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by DECIMAL
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 1
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 1
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(1)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding CHAR=1
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key CHAR for 1
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: CHAR
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(CHAR)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by CHAR
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 12
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 12
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(12)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding VARCHAR=12
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key VARCHAR for 12
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by VARCHAR
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -1
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -1
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-1)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding LONGVARCHAR=-1
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding mysql.LONGVARCHAR=-1
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key LONGVARCHAR for -1
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + mysql.LONGVARCHAR for -1
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: LONGVARCHAR
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(LONGVARCHAR)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by LONGVARCHAR
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 91
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 91
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(91)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding oracle.DATE=91
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding DATE=91
      [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + oracle.DATE for 91
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key DATE for 91
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DATE
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by DATE
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 92
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 92
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(92)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding TIME=92
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key TIME for 92
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: TIME
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(TIME)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by TIME
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 93
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 93
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(93)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding TIMESTAMP=93
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key TIMESTAMP for 93
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: TIMESTAMP
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(TIMESTAMP)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by TIMESTAMP
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -2
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -2
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-2)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BINARY=-2
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BINARY for -2
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BINARY
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BINARY)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BINARY
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -3
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -3
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-3)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding VARBINARY=-3
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key VARBINARY for -3
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARBINARY
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARBINARY)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by VARBINARY
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -4
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -4
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-4)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding LONGVARBINARY=-4
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key LONGVARBINARY for -4
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: LONGVARBINARY
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(LONGVARBINARY)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by LONGVARBINARY
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 0
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 0
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(0)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding NULL=0
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key NULL for 0
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: NULL
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NULL)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by NULL
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 1111
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 1111
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(1111)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding OTHER=1111
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key OTHER for 1111
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: OTHER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(OTHER)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by OTHER
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2000
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2000
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2000)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding JAVA_OBJECT=2000
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key JAVA_OBJECT for 2000
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: JAVA_OBJECT
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(JAVA_OBJECT)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by JAVA_OBJECT
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2001
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2001
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2001)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: null
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(null)
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2002
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2002
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2002)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: null
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(null)
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2003
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2003
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2003)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding ARRAY=2003
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key ARRAY for 2003
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: ARRAY
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(ARRAY)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by ARRAY
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2004
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2004
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2004)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BLOB=2004
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BLOB for 2004
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BLOB
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BLOB)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BLOB
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2005
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2005
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2005)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding CLOB=2005
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key CLOB for 2005
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: CLOB
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(CLOB)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by CLOB
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2006
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2006
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2006)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: null
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(null)
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 70
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 70
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(70)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: null
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(null)
      [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 16
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 16
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(16)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BOOLEAN=16
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BOOLEAN for 16
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BOOLEAN
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BOOLEAN)
      [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BOOLEAN
      [sqlunit] DEBUG [main] (SQLUnitResult.java:126) - >> setTestFile(D:\files\SQLAny\rep9\sqlunit\variable.xml)
      [sqlunit] *** Running SQLUnit file: D:\files\SQLAny\rep9\sqlunit\variable.xml
      [sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(null)
      [sqlunit] Getting connection(remote)
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(connection)
      [sqlunit] DEBUG [main] (ConnectionHandler.java:177) - >> process()
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,connection-id)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(remote)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,extern)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,transaction-support)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(on)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,reconnect-on-failure)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(on)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,server-name)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element driver)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(sun.jdbc.odbc.JdbcOdbcDriver)
      [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element url)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(jdbc:odbc:remote)
      [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element user)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(DBA)
      [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element password)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(SQL)
      [sqlunit] DEBUG [main] (ConnectionRegistry.java:121) - >> setConnectionById(remote)
      [sqlunit] DEBUG [main] (ConnectionFactory.java:61) - >> getInstance(props)
      [sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(remote)
      [sqlunit] Setting up test...
      [sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(test)
      [sqlunit] DEBUG [main] (TestHandler.java:154) - >> process(elTest)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(off)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(off)
      [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},off)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,failure-message)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,name)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(Retrieve Remotes Agent ID)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,expected-duration-millis)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,percentage-tolerance)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,assert)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(sql)
      [sqlunit] DEBUG [main] (SqlHandler.java:102) - >> process(elSql)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element sql,connection-id)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(remote)
      [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element stmt)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(
      [sqlunit]         SELECT TOP 1 agy_id
      [sqlunit]           FROM T0PTY
      [sqlunit]          ORDER BY agy_id
      [sqlunit]       )
      [sqlunit] DEBUG [main] (SymbolTable.java:273) - >> replaceVariables(
      [sqlunit]         SELECT TOP 1 agy_id
      [sqlunit]           FROM T0PTY
      [sqlunit]          ORDER BY agy_id
      [sqlunit]       )
      [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
      [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__JavaObjectSupport__})
      [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__JavaObjectSupport__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__JavaObjectSupport__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__JavaObjectSupport__})
      [sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(remote,
      [sqlunit]         SELECT TOP 1 agy_id
      [sqlunit]           FROM T0PTY
      [sqlunit]          ORDER BY agy_id
      [sqlunit]       ,params)
      [sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(remote)
      [sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
      [sqlunit] DEBUG [main] (SymbolTable.java:292) - >> setCurrentResultSet(1)
      [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.resultset__},1)
      [sqlunit] DEBUG [main] (SymbolTable.java:302) - >> setCurrentRow(1)
      [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.row__},1)
      [sqlunit] DEBUG [main] (SymbolTable.java:312) - >> setCurrentCol(1)
      [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.col__},1)
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
      [sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(INTEGER)
      [sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
      [sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for INTEGER
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
      [sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
      [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
      [sqlunit] DEBUG [main] (TypeUtils.java:64) - >> getXmlTypeFromSqlType(4)
      [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
      [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
      [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
      [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
      [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(result)
      [sqlunit] DEBUG [main] (ResultHandler.java:139) - >> process(elResult)
      [sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(resultset)
      [sqlunit] DEBUG [main] (ResultSetHandler.java:90) - >> process(elResultSet)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,id)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,rowcount)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(row)
      [sqlunit] DEBUG [main] (RowHandler.java:70) - >> process(elRow)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element row,id)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(col)
      [sqlunit] DEBUG [main] (ColHandler.java:66) - >> process(elCol)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,id)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,name)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(agy_id)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,type)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(INTEGER)
      [sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(INTEGER)
      [sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
      [sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for INTEGER
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
      [sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
      [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,order-by)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},null)
      [sqlunit] DEBUG [main] (SymbolTable.java:210) - >> update(target,source)
      [sqlunit] DEBUG [main] (SymbolTable.java:219) - looking at colValue: ${AgentID}
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:342) - >> dump()
      [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
      [sqlunit] DEBUG [main] (SymbolTable.java:344) -
      [sqlunit] Symbol table dump
      [sqlunit] DEBUG [main] (SymbolTable.java:345) - -----------------
      [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.resultset__} => 1
      [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.row__} => 1
      [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__JavaObjectSupport__} => null
      [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.col__} => 1
      [sqlunit] DEBUG [main] (SymbolTable.java:355) - -----------------
      [sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
      [sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
      [sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
      [sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
      [sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(INTEGER)
      [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
      [sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(INTEGER)
      [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
      [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__ElapsedMillisStr__},201)
      [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
      [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
      [sqlunit] Running test[1]: Retrieve Remotes Agent ID (201ms)
      [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
      [sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(test)
      [sqlunit] DEBUG [main] (TestHandler.java:154) - >> process(elTest)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(off)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(off)
      [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},off)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,failure-message)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,name)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(Retrieve Record)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,expected-duration-millis)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,percentage-tolerance)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,assert)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(sql)
      [sqlunit] DEBUG [main] (SqlHandler.java:102) - >> process(elSql)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element sql,connection-id)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(remote)
      [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element stmt)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(
      [sqlunit]         SELECT TOP 1 agy_id
      [sqlunit]           FROM T0PTY
      [sqlunit]          WHERE agy_id = ?
      [sqlunit]          ORDER BY agy_id
      [sqlunit]       )
      [sqlunit] DEBUG [main] (SymbolTable.java:273) - >> replaceVariables(
      [sqlunit]         SELECT TOP 1 agy_id
      [sqlunit]           FROM T0PTY
      [sqlunit]          WHERE agy_id = ?
      [sqlunit]          ORDER BY agy_id
      [sqlunit]       )
      [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
      [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.resultset__})
      [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.resultset__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.resultset__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.resultset__})
      [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.row__})
      [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.row__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.row__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.row__})
      [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__JavaObjectSupport__})
      [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__JavaObjectSupport__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__JavaObjectSupport__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__JavaObjectSupport__})
      [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
      [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
      [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.col__})
      [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.col__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.col__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.col__})
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(param)
      [sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(INTEGER)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(false)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(in)
      [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${AgentID})
      [sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(remote,
      [sqlunit]         SELECT TOP 1 agy_id
      [sqlunit]           FROM T0PTY
      [sqlunit]          WHERE agy_id = ?
      [sqlunit]          ORDER BY agy_id
      [sqlunit]       ,params)
      [sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(remote)
      [sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(${AgentID},INTEGER)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${AgentID})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${AgentID})
      [sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(null,INTEGER)
      [sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(INTEGER)
      [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
      [sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
      [sqlunit] DEBUG [main] (SymbolTable.java:292) - >> setCurrentResultSet(1)
      [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.resultset__},1)
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(result)
      [sqlunit] DEBUG [main] (ResultHandler.java:139) - >> process(elResult)
      [sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(resultset)
      [sqlunit] DEBUG [main] (ResultSetHandler.java:90) - >> process(elResultSet)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,id)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,rowcount)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(row)
      [sqlunit] DEBUG [main] (RowHandler.java:70) - >> process(elRow)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element row,id)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(col)
      [sqlunit] DEBUG [main] (ColHandler.java:66) - >> process(elCol)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,id)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,name)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(agy_id)
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,type)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(INTEGER)
      [sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(INTEGER)
      [sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
      [sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for INTEGER
      [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
      [sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
      [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
      [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
      [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
      [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,order-by)
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
      [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},null)
      [sqlunit] DEBUG [main] (SymbolTable.java:210) - >> update(target,source)
      [sqlunit] DEBUG [main] (SymbolTable.java:219) - looking at colValue: 102
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(102)
      [sqlunit] DEBUG [main] (SymbolTable.java:342) - >> dump()
      [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
      [sqlunit] DEBUG [main] (SymbolTable.java:344) -
      [sqlunit] Symbol table dump
      [sqlunit] DEBUG [main] (SymbolTable.java:345) - -----------------
      [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.resultset__} => 1
      [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.row__} => 1
      [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__JavaObjectSupport__} => null
      [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__ElapsedMillisStr__} => 201
      [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.col__} => 1
      [sqlunit] DEBUG [main] (SymbolTable.java:355) - -----------------
      [sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
      [sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
      [sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
      [sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
      [sqlunit] DEBUG [main] (DatabaseResult.java:232) - >> toString()
      [sqlunit] DEBUG [main] (DatabaseResult.java:193) - >> toElement()
      [sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
      [sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
      [sqlunit] DEBUG [main] (XMLUtils.java:106) - >> toXMLString(Element result)
      [sqlunit] DEBUG [main] (DatabaseResult.java:232) - >> toString()
      [sqlunit] DEBUG [main] (DatabaseResult.java:193) - >> toElement()
      [sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
      [sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
      [sqlunit] DEBUG [main] (XMLUtils.java:106) - >> toXMLString(Element result)
      [sqlunit] DEBUG [main] (SQLUnitResult.java:47) - >> addFailureCount()
      [sqlunit] DEBUG [main] (SQLUnitResult.java:108) - >> setLastException(e)
      [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
      [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
      [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
      [sqlunit] Running test[2]: Retrieve Record (201ms)
      [sqlunit] DEBUG [main] (SQLUnitResult.java:99) - >> getLastException()
      [sqlunit] Assertion "resultset-equals" failed (1 != 0 at result[1].#rows)
      [sqlunit] *** expected:
      [sqlunit] <result>
      [sqlunit]   <resultset id="1">
      [sqlunit]     <row id="1">
      [sqlunit]       <col id="1" name="agy_id" type="INTEGER">102</col>
      [sqlunit]     </row>
      [sqlunit]   </resultset>
      [sqlunit] </result>
      [sqlunit] *** but got: <result>
      [sqlunit]   <resultset id="1" />
      [sqlunit] </result>

      [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
      [sqlunit] Tearing down test...
      [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(teardown)
      [sqlunit] DEBUG [main] (TeardownHandler.java:82) - >> process(elTeardown)
      [sqlunit] DEBUG [main] (ConnectionRegistry.java:170) - >> releaseConnections()
      [sqlunit] DEBUG [main] (SQLUnitResult.java:90) - >> errorCount()
      [sqlunit] DEBUG [main] (SQLUnitResult.java:81) - >> failureCount()
      [sqlunit] DEBUG [main] (SQLUnitResult.java:135) - >> wasSuccessful()
      [sqlunit] DEBUG [main] (SQLUnitResult.java:90) - >> errorCount()
      [sqlunit] DEBUG [main] (SQLUnitResult.java:81) - >> failureCount()
      [sqlunit] DEBUG [main] (SQLUnitResult.java:144) - >> toString()
      [sqlunit] DEBUG [main] (SQLUnitResult.java:99) - >> getLastException()
      [sqlunit] FATAL [main] (SQLUnit.java:198) - SQLUnit Tests Failed: In file: D:\files\SQLAny\rep9\sqlunit\variable.xml, tests: 2, failures: 1, errors = 0
      [sqlunit] net.sourceforge.sqlunit.SQLUnitException: SQLUnit Tests Failed: In file: D:\files\SQLAny\rep9\sqlunit\variable.xml, tests: 2, failures: 1, errors = 0
      [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.testWrapper(SQLUnit.java:221)
      [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.runTest(SQLUnit.java:195)
      [sqlunit]     at net.sourceforge.sqlunit.ant.SqlunitTask.execute(SqlunitTask.java:111)
      [sqlunit]     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
      [sqlunit]     at org.apache.tools.ant.Task.perform(Task.java:364)
      [sqlunit]     at org.apache.tools.ant.Target.execute(Target.java:341)
      [sqlunit]     at org.apache.tools.ant.Target.performTasks(Target.java:369)
      [sqlunit]     at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
      [sqlunit]     at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
      [sqlunit]     at org.apache.tools.ant.Main.runBuild(Main.java:673)
      [sqlunit]     at org.apache.tools.ant.Main.startAnt(Main.java:188)
      [sqlunit]     at org.apache.tools.ant.launch.Launcher.run(Launcher.java:196)
      [sqlunit]     at org.apache.tools.ant.launch.Launcher.main(Launcher.java:55)
      [sqlunit] Caused by: net.sourceforge.sqlunit.SQLUnitException: Assertion "resultset-equals" failed (1 != 0 at result[1].#rows)
      [sqlunit] *** expected:
      [sqlunit] <result>
      [sqlunit]   <resultset id="1">
      [sqlunit]     <row id="1">
      [sqlunit]       <col id="1" name="agy_id" type="INTEGER">102</col>
      [sqlunit]     </row>
      [sqlunit]   </resultset>
      [sqlunit] </result>
      [sqlunit] *** but got: <result>
      [sqlunit]   <resultset id="1" />
      [sqlunit] </result>

      [sqlunit]     at net.sourceforge.sqlunit.Assertions.invokeAssertion(Assertions.java:794)
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.assertIsTrue(Assertions.java:114)
      [sqlunit]     at net.sourceforge.sqlunit.handlers.TestHandler.process(TestHandler.java:212)
      [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.processDoc(SQLUnit.java:299)
      [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.testWrapper(SQLUnit.java:218)
      [sqlunit]     ... 12 more
      [sqlunit] Caused by: net.sourceforge.sqlunit.SQLUnitException: Assertion "resultset-equals" failed (1 != 0 at result[1].#rows)
      [sqlunit] *** expected:
      [sqlunit] <result>
      [sqlunit]   <resultset id="1">
      [sqlunit]     <row id="1">
      [sqlunit]       <col id="1" name="agy_id" type="INTEGER">102</col>
      [sqlunit]     </row>
      [sqlunit]   </resultset>
      [sqlunit] </result>
      [sqlunit] *** but got: <result>
      [sqlunit]   <resultset id="1" />
      [sqlunit] </result>

      [sqlunit]     at net.sourceforge.sqlunit.Assertions.invokeAssertion(Assertions.java:794)
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.assertIsTrue(Assertions.java:114)
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.assertEqual(Assertions.java:168)
      [sqlunit]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      [sqlunit]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      [sqlunit]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      [sqlunit]     at java.lang.reflect.Method.invoke(Method.java:585)
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.invokeAssertion(Assertions.java:791)
      [sqlunit]     ... 16 more
      [sqlunit] Caused by: net.sourceforge.sqlunit.SQLUnitException: Assertion "resultset-equals" failed (1 != 0 at result[1].#rows)
      [sqlunit] *** expected:
      [sqlunit] <result>
      [sqlunit]   <resultset id="1">
      [sqlunit]     <row id="1">
      [sqlunit]       <col id="1" name="agy_id" type="INTEGER">102</col>
      [sqlunit]     </row>
      [sqlunit]   </resultset>
      [sqlunit] </result>
      [sqlunit] *** but got: <result>
      [sqlunit]   <resultset id="1" />
      [sqlunit] </result>

      [sqlunit]     at net.sourceforge.sqlunit.Assertions.assertResultSetsEqual(Assertions.java:459)
      [sqlunit]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      [sqlunit]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      [sqlunit]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      [sqlunit]     at java.lang.reflect.Method.invoke(Method.java:585)
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.invokeAssertion(Assertions.java:791)
      [sqlunit]     ... 23 more
      [sqlunit] Caused by: junit.framework.AssertionFailedError: 1 != 0 at result[1].#rows
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.subAssertRowCountEqual(Assertions.java:841)
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.assertResultSetsEqual(Assertions.java:413)
      [sqlunit]     ... 28 more
      [sqlunit] sqlunit-ant: SQLUnit Tests Failed: In file: D:\files\SQLAny\rep9\sqlunit\variable.xml, tests: 2, failures: 1, errors = 0
      [sqlunit] net.sourceforge.sqlunit.SQLUnitException: SQLUnit Tests Failed: In file: D:\files\SQLAny\rep9\sqlunit\variable.xml, tests: 2, failures: 1, errors = 0
      [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.testWrapper(SQLUnit.java:221)
      [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.runTest(SQLUnit.java:195)
      [sqlunit]     at net.sourceforge.sqlunit.ant.SqlunitTask.execute(SqlunitTask.java:111)
      [sqlunit]     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
      [sqlunit]     at org.apache.tools.ant.Task.perform(Task.java:364)
      [sqlunit]     at org.apache.tools.ant.Target.execute(Target.java:341)
      [sqlunit]     at org.apache.tools.ant.Target.performTasks(Target.java:369)
      [sqlunit]     at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
      [sqlunit]     at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
      [sqlunit]     at org.apache.tools.ant.Main.runBuild(Main.java:673)
      [sqlunit]     at org.apache.tools.ant.Main.startAnt(Main.java:188)
      [sqlunit]     at org.apache.tools.ant.launch.Launcher.run(Launcher.java:196)
      [sqlunit]     at org.apache.tools.ant.launch.Launcher.main(Launcher.java:55)
      [sqlunit] Caused by: net.sourceforge.sqlunit.SQLUnitException: Assertion "resultset-equals" failed (1 != 0 at result[1].#rows)
      [sqlunit] *** expected:
      [sqlunit] <result>
      [sqlunit]   <resultset id="1">
      [sqlunit]     <row id="1">
      [sqlunit]       <col id="1" name="agy_id" type="INTEGER">102</col>
      [sqlunit]     </row>
      [sqlunit]   </resultset>
      [sqlunit] </result>
      [sqlunit] *** but got: <result>
      [sqlunit]   <resultset id="1" />
      [sqlunit] </result>

      [sqlunit]     at net.sourceforge.sqlunit.Assertions.invokeAssertion(Assertions.java:794)
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.assertIsTrue(Assertions.java:114)
      [sqlunit]     at net.sourceforge.sqlunit.handlers.TestHandler.process(TestHandler.java:212)
      [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.processDoc(SQLUnit.java:299)
      [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.testWrapper(SQLUnit.java:218)
      [sqlunit]     ... 12 more
      [sqlunit] Caused by: net.sourceforge.sqlunit.SQLUnitException: Assertion "resultset-equals" failed (1 != 0 at result[1].#rows)
      [sqlunit] *** expected:
      [sqlunit] <result>
      [sqlunit]   <resultset id="1">
      [sqlunit]     <row id="1">
      [sqlunit]       <col id="1" name="agy_id" type="INTEGER">102</col>
      [sqlunit]     </row>
      [sqlunit]   </resultset>
      [sqlunit] </result>
      [sqlunit] *** but got: <result>
      [sqlunit]   <resultset id="1" />
      [sqlunit] </result>

      [sqlunit]     at net.sourceforge.sqlunit.Assertions.invokeAssertion(Assertions.java:794)
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.assertIsTrue(Assertions.java:114)
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.assertEqual(Assertions.java:168)
      [sqlunit]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      [sqlunit]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      [sqlunit]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      [sqlunit]     at java.lang.reflect.Method.invoke(Method.java:585)
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.invokeAssertion(Assertions.java:791)
      [sqlunit]     ... 16 more
      [sqlunit] Caused by: net.sourceforge.sqlunit.SQLUnitException: Assertion "resultset-equals" failed (1 != 0 at result[1].#rows)
      [sqlunit] *** expected:
      [sqlunit] <result>
      [sqlunit]   <resultset id="1">
      [sqlunit]     <row id="1">
      [sqlunit]       <col id="1" name="agy_id" type="INTEGER">102</col>
      [sqlunit]     </row>
      [sqlunit]   </resultset>
      [sqlunit] </result>
      [sqlunit] *** but got: <result>
      [sqlunit]   <resultset id="1" />
      [sqlunit] </result>

      [sqlunit]     at net.sourceforge.sqlunit.Assertions.assertResultSetsEqual(Assertions.java:459)
      [sqlunit]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      [sqlunit]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      [sqlunit]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      [sqlunit]     at java.lang.reflect.Method.invoke(Method.java:585)
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.invokeAssertion(Assertions.java:791)
      [sqlunit]     ... 23 more
      [sqlunit] Caused by: junit.framework.AssertionFailedError: 1 != 0 at result[1].#rows
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.subAssertRowCountEqual(Assertions.java:841)
      [sqlunit]     at net.sourceforge.sqlunit.Assertions.assertResultSetsEqual(Assertions.java:413)
      [sqlunit]     ... 28 more
      [sqlunit] SQLUnit Tests Failed: In file: D:\files\SQLAny\rep9\sqlunit\variable.xml, tests: 2, failures: 1, errors = 0

    BUILD FAILED
    D:\Programs\sqlunit-cvs\build.xml:130: SQLUnit Tests Failed: In file: D:\files\SQLAny\rep9\sqlunit\variable.xml, tests: 2, failures: 1, errors = 0

    Total time: 5 seconds

     

    • Sujit Pal

      Sujit Pal - 2004-11-30

      Hi Dave,

      This was a bug. In this particular use case, the symbol table was not getting updated after the comparison was done in the first test. I have put in the fix and added test cases (last two tests in variabletests.xml) that simulate this use case. I checked the changes into CVS this morning.

      Please rerun this test and let me know if this worked. I have regressed this change against my existing unit tests as well.

      -sujit

       

    • David Fishburn

      David Fishburn - 2004-12-01

      The only update was to this file:
      src\net\sourceforge\sqlunit\beans\OutParam.java

      Same (bad) results to the test.  I deleted the sqlunit jar and ran ant install (made sure the jar had the new date).

      Here is the debug output:

      init:

      precompile:

      compile:
          [javac] Compiling 7 source files to D:\Programs\sqlunit-cvs\build
          [javac] Note: D:\Programs\sqlunit-cvs\src-gen\IncludeFileParser.java uses unchecked or unsafe operations.
          [javac] Note: Recompile with -Xlint:unchecked for details.

      def:

      sqlunit-flat:
        [sqlunit] DEBUG [main] (SQLUnit.java:217) - >> testWrapper()
        [sqlunit] DEBUG [main] (SQLUnit.java:239) - >> processDoc()
        [sqlunit] DEBUG [main] (TypeMapper.java:67) - instantiating TypeMapper
        [sqlunit] DEBUG [main] (TypeMapper.java:169) - loading types from: net.sourceforge.sqlunit.types
        [sqlunit] DEBUG [main] (TypeMapper.java:169) - loading types from: usertypes
        [sqlunit] DEBUG [main] (TypeMapper.java:203) - loading non-mapped types
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -7
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -7
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-7)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BIT=-7
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BIT for -7
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BIT
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BIT)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BIT
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -6
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -6
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-6)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding TINYINT=-6
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key TINYINT for -6
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: TINYINT
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(TINYINT)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by TINYINT
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 5
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 5
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(5)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding adaptive_server_anywhere.SMALLINT=5
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding adaptive_server_enterprise.SMALLINT=5
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding SMALLINT=5
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding sybase_sql_server.SMALLINT=5
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding sql_server.SMALLINT=5
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + adaptive_server_anywhere.SMALLINT for 5
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + adaptive_server_enterprise.SMALLINT for 5
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key SMALLINT for 5
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + sybase_sql_server.SMALLINT for 5
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + sql_server.SMALLINT for 5
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: SMALLINT
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(SMALLINT)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by SMALLINT
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 4
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by INTEGER
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -5
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -5
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-5)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BIGINT=-5
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BIGINT for -5
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BIGINT
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BIGINT)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BIGINT
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 6
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 6
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(6)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding mysql.FLOAT=6
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding FLOAT=6
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + mysql.FLOAT for 6
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key FLOAT for 6
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: FLOAT
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(FLOAT)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by FLOAT
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 7
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 7
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(7)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding REAL=7
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key REAL for 7
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: REAL
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(REAL)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by REAL
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 8
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 8
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(8)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding DOUBLE=8
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key DOUBLE for 8
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DOUBLE
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DOUBLE)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by DOUBLE
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding sybase_sql_server.NUMERIC=2
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding postgresql.NUMERIC=2
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding oracle.NUMERIC=2
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding adaptive_server_anywhere.NUMERIC=2
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding sql_server.NUMERIC=2
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding adaptive_server_enterprise.NUMERIC=2
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding NUMERIC=2
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + sybase_sql_server.NUMERIC for 2
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + postgresql.NUMERIC for 2
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + oracle.NUMERIC for 2
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + adaptive_server_anywhere.NUMERIC for 2
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + sql_server.NUMERIC for 2
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + adaptive_server_enterprise.NUMERIC for 2
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key NUMERIC for 2
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: NUMERIC
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by NUMERIC
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 3
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 3
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(3)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding DECIMAL=3
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key DECIMAL for 3
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DECIMAL
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DECIMAL)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by DECIMAL
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 1
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 1
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(1)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding CHAR=1
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key CHAR for 1
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: CHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(CHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by CHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 12
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 12
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(12)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding VARCHAR=12
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key VARCHAR for 12
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by VARCHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -1
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -1
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-1)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding LONGVARCHAR=-1
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding mysql.LONGVARCHAR=-1
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key LONGVARCHAR for -1
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + mysql.LONGVARCHAR for -1
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: LONGVARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(LONGVARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by LONGVARCHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 91
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 91
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(91)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding oracle.DATE=91
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding DATE=91
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + oracle.DATE for 91
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key DATE for 91
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DATE
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by DATE
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 92
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 92
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(92)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding TIME=92
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key TIME for 92
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: TIME
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(TIME)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by TIME
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 93
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 93
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(93)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding TIMESTAMP=93
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key TIMESTAMP for 93
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: TIMESTAMP
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(TIMESTAMP)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by TIMESTAMP
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -2
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -2
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-2)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BINARY=-2
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BINARY for -2
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BINARY
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BINARY)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BINARY
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -3
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -3
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-3)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding VARBINARY=-3
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key VARBINARY for -3
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARBINARY
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARBINARY)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by VARBINARY
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -4
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -4
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-4)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding LONGVARBINARY=-4
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key LONGVARBINARY for -4
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: LONGVARBINARY
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(LONGVARBINARY)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by LONGVARBINARY
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 0
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 0
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(0)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding NULL=0
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key NULL for 0
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: NULL
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NULL)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by NULL
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 1111
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 1111
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(1111)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding OTHER=1111
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key OTHER for 1111
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: OTHER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(OTHER)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by OTHER
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2000
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2000
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2000)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding JAVA_OBJECT=2000
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key JAVA_OBJECT for 2000
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: JAVA_OBJECT
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(JAVA_OBJECT)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by JAVA_OBJECT
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2001
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2001
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2001)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: null
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(null)
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2002
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2002
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2002)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: null
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(null)
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2003
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2003
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2003)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding ARRAY=2003
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key ARRAY for 2003
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: ARRAY
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(ARRAY)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by ARRAY
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2004
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2004
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2004)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BLOB=2004
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BLOB for 2004
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BLOB
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BLOB)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BLOB
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2005
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2005
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2005)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding CLOB=2005
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key CLOB for 2005
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: CLOB
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(CLOB)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by CLOB
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2006
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2006
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2006)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: null
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(null)
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 70
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 70
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(70)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: null
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(null)
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 16
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 16
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(16)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BOOLEAN=16
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BOOLEAN for 16
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BOOLEAN
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BOOLEAN)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BOOLEAN
        [sqlunit] DEBUG [main] (SQLUnitResult.java:126) - >> setTestFile(D:\Ptrack\Pearson\rep9\sqlunit\test.xml)
        [sqlunit] *** Running SQLUnit file: D:\Ptrack\Pearson\rep9\sqlunit\test.xml
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(null)
        [sqlunit] Getting connection(cons)
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(connection)
        [sqlunit] DEBUG [main] (ConnectionHandler.java:177) - >> process()
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,connection-id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(cons)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,extern)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,transaction-support)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(on)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,reconnect-on-failure)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(on)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,server-name)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element driver)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(ianywhere.ml.jdbcodbc.IDriver)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element url)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(jdbc:odbc:dsn=cons)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element user)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(DBA)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element password)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(SQL)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:121) - >> setConnectionById(cons)
        [sqlunit] DEBUG [main] (ConnectionFactory.java:61) - >> getInstance(props)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(cons)
        [sqlunit] Getting connection(remote)
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(connection)
        [sqlunit] DEBUG [main] (ConnectionHandler.java:177) - >> process()
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,connection-id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(remote)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,extern)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,transaction-support)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(on)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,reconnect-on-failure)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(on)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element connection,server-name)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element driver)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(ianywhere.ml.jdbcodbc.IDriver)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element url)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(jdbc:odbc:dsn=remote)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element user)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(DBA)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element password)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(SQL)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:121) - >> setConnectionById(remote)
        [sqlunit] DEBUG [main] (ConnectionFactory.java:61) - >> getInstance(props)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(remote)
        [sqlunit] Setting up test...
        [sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(test)
        [sqlunit] DEBUG [main] (TestHandler.java:154) - >> process(elTest)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(off)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(off)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},off)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,failure-message)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,name)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(Retrieve Consolidated Publisher)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,expected-duration-millis)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,percentage-tolerance)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,assert)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(sql)
        [sqlunit] DEBUG [main] (SqlHandler.java:102) - >> process(elSql)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element sql,connection-id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(cons)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element stmt)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(
        [sqlunit]         SELECT CURRENT PUBLISHER
        [sqlunit]       )
        [sqlunit] DEBUG [main] (SymbolTable.java:273) - >> replaceVariables(
        [sqlunit]         SELECT CURRENT PUBLISHER
        [sqlunit]       )
        [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(cons,
        [sqlunit]         SELECT CURRENT PUBLISHER
        [sqlunit]       ,params)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(cons)
        [sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
        [sqlunit] DEBUG [main] (SymbolTable.java:292) - >> setCurrentResultSet(1)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.resultset__},1)
        [sqlunit] DEBUG [main] (SymbolTable.java:302) - >> setCurrentRow(1)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.row__},1)
        [sqlunit] DEBUG [main] (SymbolTable.java:312) - >> setCurrentCol(1)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.col__},1)
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 12
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(12)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding VARCHAR=12
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key VARCHAR for 12
        [sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
        [sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
        [sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
        [sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
        [sqlunit] DEBUG [main] (TypeUtils.java:64) - >> getXmlTypeFromSqlType(12)
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 12
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(12)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding VARCHAR=12
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key VARCHAR for 12
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(result)
        [sqlunit] DEBUG [main] (ResultHandler.java:139) - >> process(elResult)
        [sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(resultset)
        [sqlunit] DEBUG [main] (ResultSetHandler.java:90) - >> process(elResultSet)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,rowcount)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(row)
        [sqlunit] DEBUG [main] (RowHandler.java:70) - >> process(elRow)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element row,id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(col)
        [sqlunit] DEBUG [main] (ColHandler.java:66) - >> process(elCol)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,name)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,type)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(VARCHAR)
        [sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
        [sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
        [sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
        [sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,order-by)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},null)
        [sqlunit] DEBUG [main] (SymbolTable.java:210) - >> update(target,source)
        [sqlunit] DEBUG [main] (SymbolTable.java:219) - looking at colValue: ${ConsPublisher}
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${ConsPublisher})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${ConsPublisher})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${ConsPublisher})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${ConsPublisher})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${ConsPublisher})
        [sqlunit] DEBUG [main] (SymbolTable.java:342) - >> dump()
        [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
        [sqlunit] DEBUG [main] (SymbolTable.java:344) -
        [sqlunit] Symbol table dump
        [sqlunit] DEBUG [main] (SymbolTable.java:345) - -----------------
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.resultset__} => 1
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.row__} => 1
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__JavaObjectSupport__} => null
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.col__} => 1
        [sqlunit] DEBUG [main] (SymbolTable.java:355) - -----------------
        [sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
        [sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
        [sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
        [sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
        [sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
        [sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__ElapsedMillisStr__},230)
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] Running test[1]: Retrieve Consolidated Publisher (230ms)
        [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
        [sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(test)
        [sqlunit] DEBUG [main] (TestHandler.java:154) - >> process(elTest)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(off)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(off)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},off)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,failure-message)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,name)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(Retrieve Remote Publisher)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,expected-duration-millis)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,percentage-tolerance)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,assert)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(sql)
        [sqlunit] DEBUG [main] (SqlHandler.java:102) - >> process(elSql)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element sql,connection-id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(remote)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element stmt)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(
        [sqlunit]         SELECT CURRENT PUBLISHER
        [sqlunit]       )
        [sqlunit] DEBUG [main] (SymbolTable.java:273) - >> replaceVariables(
        [sqlunit]         SELECT CURRENT PUBLISHER
        [sqlunit]       )
        [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.resultset__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.resultset__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.resultset__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.resultset__})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.row__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.row__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.row__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.row__})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.col__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.col__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.col__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.col__})
        [sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(remote,
        [sqlunit]         SELECT CURRENT PUBLISHER
        [sqlunit]       ,params)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(remote)
        [sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
        [sqlunit] DEBUG [main] (SymbolTable.java:292) - >> setCurrentResultSet(1)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.resultset__},1)
        [sqlunit] DEBUG [main] (SymbolTable.java:302) - >> setCurrentRow(1)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.row__},1)
        [sqlunit] DEBUG [main] (SymbolTable.java:312) - >> setCurrentCol(1)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.col__},1)
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 12
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(12)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding VARCHAR=12
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key VARCHAR for 12
        [sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
        [sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
        [sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
        [sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
        [sqlunit] DEBUG [main] (TypeUtils.java:64) - >> getXmlTypeFromSqlType(12)
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 12
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(12)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding VARCHAR=12
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key VARCHAR for 12
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(result)
        [sqlunit] DEBUG [main] (ResultHandler.java:139) - >> process(elResult)
        [sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(resultset)
        [sqlunit] DEBUG [main] (ResultSetHandler.java:90) - >> process(elResultSet)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,rowcount)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(row)
        [sqlunit] DEBUG [main] (RowHandler.java:70) - >> process(elRow)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element row,id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(col)
        [sqlunit] DEBUG [main] (ColHandler.java:66) - >> process(elCol)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,name)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,type)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(VARCHAR)
        [sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
        [sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
        [sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
        [sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,order-by)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},null)
        [sqlunit] DEBUG [main] (SymbolTable.java:210) - >> update(target,source)
        [sqlunit] DEBUG [main] (SymbolTable.java:219) - looking at colValue: ${RemotePublisher}
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${RemotePublisher})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${RemotePublisher})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${RemotePublisher})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${RemotePublisher})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${RemotePublisher})
        [sqlunit] DEBUG [main] (SymbolTable.java:342) - >> dump()
        [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
        [sqlunit] DEBUG [main] (SymbolTable.java:344) -
        [sqlunit] Symbol table dump
        [sqlunit] DEBUG [main] (SymbolTable.java:345) - -----------------
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.resultset__} => 1
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.row__} => 1
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__JavaObjectSupport__} => null
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__ElapsedMillisStr__} => 230
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.col__} => 1
        [sqlunit] DEBUG [main] (SymbolTable.java:355) - -----------------
        [sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
        [sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
        [sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
        [sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
        [sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
        [sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__ElapsedMillisStr__},150)
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] Running test[2]: Retrieve Remote Publisher (150ms)
        [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
        [sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(test)
        [sqlunit] DEBUG [main] (TestHandler.java:154) - >> process(elTest)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(off)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(off)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},off)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,failure-message)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,name)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(Retrieve Remotes SSUserID)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,expected-duration-millis)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,percentage-tolerance)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,assert)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(sql)
        [sqlunit] DEBUG [main] (SqlHandler.java:102) - >> process(elSql)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element sql,connection-id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(remote)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element stmt)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(
        [sqlunit]         SELECT TOP 1 agy_id
        [sqlunit]           FROM PARTY
        [sqlunit]          ORDER BY agy_id
        [sqlunit]       )
        [sqlunit] DEBUG [main] (SymbolTable.java:273) - >> replaceVariables(
        [sqlunit]         SELECT TOP 1 agy_id
        [sqlunit]           FROM PARTY
        [sqlunit]          ORDER BY agy_id
        [sqlunit]       )
        [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.resultset__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.resultset__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.resultset__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.resultset__})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.row__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.row__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.row__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.row__})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.col__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.col__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.col__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.col__})
        [sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(remote,
        [sqlunit]         SELECT TOP 1 agy_id
        [sqlunit]           FROM PARTY
        [sqlunit]          ORDER BY agy_id
        [sqlunit]       ,params)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(remote)
        [sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
        [sqlunit] DEBUG [main] (SymbolTable.java:292) - >> setCurrentResultSet(1)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.resultset__},1)
        [sqlunit] DEBUG [main] (SymbolTable.java:302) - >> setCurrentRow(1)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.row__},1)
        [sqlunit] DEBUG [main] (SymbolTable.java:312) - >> setCurrentCol(1)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__0.col__},1)
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
        [sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(INTEGER)
        [sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.INTEGER)
        [sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
        [sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for INTEGER
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
        [sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
        [sqlunit] DEBUG [main] (TypeUtils.java:64) - >> getXmlTypeFromSqlType(4)
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(result)
        [sqlunit] DEBUG [main] (ResultHandler.java:139) - >> process(elResult)
        [sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(resultset)
        [sqlunit] DEBUG [main] (ResultSetHandler.java:90) - >> process(elResultSet)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,rowcount)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(row)
        [sqlunit] DEBUG [main] (RowHandler.java:70) - >> process(elRow)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element row,id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(col)
        [sqlunit] DEBUG [main] (ColHandler.java:66) - >> process(elCol)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,name)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(agy_id)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,type)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(INTEGER)
        [sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(INTEGER)
        [sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.INTEGER)
        [sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
        [sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for INTEGER
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
        [sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,order-by)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},null)
        [sqlunit] DEBUG [main] (SymbolTable.java:210) - >> update(target,source)
        [sqlunit] DEBUG [main] (SymbolTable.java:219) - looking at colValue: ${SSUserID}
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:342) - >> dump()
        [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
        [sqlunit] DEBUG [main] (SymbolTable.java:344) -
        [sqlunit] Symbol table dump
        [sqlunit] DEBUG [main] (SymbolTable.java:345) - -----------------
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.resultset__} => 1
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.row__} => 1
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__JavaObjectSupport__} => null
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__ElapsedMillisStr__} => 150
        [sqlunit] DEBUG [main] (SymbolTable.java:353) - ${__0.col__} => 1
        [sqlunit] DEBUG [main] (SymbolTable.java:355) - -----------------
        [sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
        [sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
        [sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
        [sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
        [sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(INTEGER)
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
        [sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(INTEGER)
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__ElapsedMillisStr__},161)
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] Running test[3]: Retrieve Remotes SSUserID (161ms)
        [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
        [sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(diff)
        [sqlunit] DEBUG [main] (DiffHandler.java:136) - >> process(elDiff)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element diff,java-object-support)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(off)
        [sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},off)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element diff,failure-message)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(ADDRESS table match failed)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element diff,multi-threaded)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(false)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element diff,assert)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(sql)
        [sqlunit] DEBUG [main] (SqlHandler.java:102) - >> process(elSql)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element sql,connection-id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(cons)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element stmt)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(
        [sqlunit]         SELECT adr_id, adr_ln_1
        [sqlunit]           FROM ADDRESSES
        [sqlunit]          WHERE ? IN (
        [sqlunit]                       SELECT AGY_ID
        [sqlunit]                         FROM PARTY_ADDRESS pa
        [sqlunit]                        WHERE pa.ADR_ID = ADDRESSES.ADR_ID
        [sqlunit]                     )
        [sqlunit]          ORDER BY adr_id
        [sqlunit]       )
        [sqlunit] DEBUG [main] (SymbolTable.java:273) - >> replaceVariables(
        [sqlunit]         SELECT adr_id, adr_ln_1
        [sqlunit]           FROM ADDRESSES
        [sqlunit]          WHERE ? IN (
        [sqlunit]                       SELECT AGY_ID
        [sqlunit]                         FROM PARTY_ADDRESS pa
        [sqlunit]                        WHERE pa.ADR_ID = ADDRESSES.ADR_ID
        [sqlunit]                     )
        [sqlunit]          ORDER BY adr_id
        [sqlunit]       )
        [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.resultset__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.resultset__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.resultset__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.resultset__})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.row__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.row__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.row__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.row__})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__JavaObjectSupport__})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.col__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.col__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.col__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__0.col__})
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(param)
        [sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(1)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(INTEGER)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(false)
        [sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(in)
        [sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${SSUserID})
        [sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(cons,
        [sqlunit]         SELECT adr_id, adr_ln_1
        [sqlunit]           FROM ADDRESSES
        [sqlunit]          WHERE ? IN (
        [sqlunit]                       SELECT AGY_ID
        [sqlunit]                         FROM PARTY_ADDRESS pa
        [sqlunit]                        WHERE pa.ADR_ID = ADDRESSES.ADR_ID
        [sqlunit]                     )
        [sqlunit]          ORDER BY adr_id
        [sqlunit]       ,params)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(cons)
        [sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(${SSUserID},INTEGER)
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${SSUserID})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${SSUserID})
        [sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(null,INTEGER)
        [sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(INTEGER)
        [sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
        [sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:144) - >> invalidate(cons)
        [sqlunit] DEBUG [main] (SQLUnitResult.java:47) - >> addFailureCount()
        [sqlunit] DEBUG [main] (SQLUnitResult.java:108) - >> setLastException(e)
        [sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] DEBUG [main] (SymbolTable.java:262) - >> isVariableName(${__ElapsedMillisStr__})
        [sqlunit] Running diff[4]: Diffing the ADDRESS table (161ms)
        [sqlunit] DEBUG [main] (SQLUnitResult.java:99) - >> getLastException()
        [sqlunit] System error (java.lang.NullPointerException): null
        [sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
        [sqlunit] Tearing down test...
        [sqlunit] DEBUG [main] (HandlerFactory.java:56) - >> getInstance(teardown)
        [sqlunit] DEBUG [main] (TeardownHandler.java:82) - >> process(elTeardown)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:170) - >> releaseConnections()
        [sqlunit] DEBUG [main] (SQLUnitResult.java:90) - >> errorCount()
        [sqlunit] DEBUG [main] (SQLUnitResult.java:81) - >> failureCount()
        [sqlunit] DEBUG [main] (SQLUnitResult.java:135) - >> wasSuccessful()
        [sqlunit] DEBUG [main] (SQLUnitResult.java:90) - >> errorCount()
        [sqlunit] DEBUG [main] (SQLUnitResult.java:81) - >> failureCount()
        [sqlunit] DEBUG [main] (SQLUnitResult.java:144) - >> toString()
        [sqlunit] DEBUG [main] (SQLUnitResult.java:99) - >> getLastException()
        [sqlunit] FATAL [main] (SQLUnit.java:198) - SQLUnit Tests Failed: In file: D:\Ptrack\Pearson\rep9\sqlunit\test.xml, tests: 4, failures: 1, errors = 0
        [sqlunit] net.sourceforge.sqlunit.SQLUnitException: SQLUnit Tests Failed: In file: D:\Ptrack\Pearson\rep9\sqlunit\test.xml, tests: 4, failures: 1, errors = 0
        [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.testWrapper(SQLUnit.java:221)
        [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.runTest(SQLUnit.java:195)
        [sqlunit]     at net.sourceforge.sqlunit.ant.SqlunitTask.execute(SqlunitTask.java:111)
        [sqlunit]     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
        [sqlunit]     at org.apache.tools.ant.Task.perform(Task.java:364)
        [sqlunit]     at org.apache.tools.ant.Target.execute(Target.java:341)
        [sqlunit]     at org.apache.tools.ant.Target.performTasks(Target.java:369)
        [sqlunit]     at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
        [sqlunit]     at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
        [sqlunit]     at org.apache.tools.ant.Main.runBuild(Main.java:673)
        [sqlunit]     at org.apache.tools.ant.Main.startAnt(Main.java:188)
        [sqlunit]     at org.apache.tools.ant.launch.Launcher.run(Launcher.java:196)
        [sqlunit]     at org.apache.tools.ant.launch.Launcher.main(Launcher.java:55)
        [sqlunit] Caused by: net.sourceforge.sqlunit.SQLUnitException: System error (java.lang.NullPointerException): null
        [sqlunit]     at net.sourceforge.sqlunit.handlers.SqlHandler.executeSQL(SqlHandler.java:166)
        [sqlunit]     at net.sourceforge.sqlunit.handlers.SqlHandler.process(SqlHandler.java:124)
        [sqlunit]     at net.sourceforge.sqlunit.handlers.DiffHandler.process(DiffHandler.java:189)
        [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.processDoc(SQLUnit.java:299)
        [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.testWrapper(SQLUnit.java:218)
        [sqlunit]     ... 12 more
        [sqlunit] Caused by: java.lang.NullPointerException
        [sqlunit]     at ianywhere.ml.jdbcodbc.IPreparedStatement.setObject(IPreparedStatement.java:217)
        [sqlunit]     at ianywhere.ml.jdbcodbc.IPreparedStatement.setObject(IPreparedStatement.java:234)
        [sqlunit]     at net.sourceforge.sqlunit.handlers.SqlHandler.setParameters(SqlHandler.java:223)
        [sqlunit]     at net.sourceforge.sqlunit.handlers.SqlHandler.executeSQL(SqlHandler.java:143)
        [sqlunit]     ... 16 more
        [sqlunit] sqlunit-ant: SQLUnit Tests Failed: In file: D:\Ptrack\Pearson\rep9\sqlunit\test.xml, tests: 4, failures: 1, errors = 0
        [sqlunit] net.sourceforge.sqlunit.SQLUnitException: SQLUnit Tests Failed: In file: D:\Ptrack\Pearson\rep9\sqlunit\test.xml, tests: 4, failures: 1, errors = 0
        [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.testWrapper(SQLUnit.java:221)
        [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.runTest(SQLUnit.java:195)
        [sqlunit]     at net.sourceforge.sqlunit.ant.SqlunitTask.execute(SqlunitTask.java:111)
        [sqlunit]     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
        [sqlunit]     at org.apache.tools.ant.Task.perform(Task.java:364)
        [sqlunit]     at org.apache.tools.ant.Target.execute(Target.java:341)
        [sqlunit]     at org.apache.tools.ant.Target.performTasks(Target.java:369)
        [sqlunit]     at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
        [sqlunit]     at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
        [sqlunit]     at org.apache.tools.ant.Main.runBuild(Main.java:673)
        [sqlunit]     at org.apache.tools.ant.Main.startAnt(Main.java:188)
        [sqlunit]     at org.apache.tools.ant.launch.Launcher.run(Launcher.java:196)
        [sqlunit]     at org.apache.tools.ant.launch.Launcher.main(Launcher.java:55)
        [sqlunit] Caused by: net.sourceforge.sqlunit.SQLUnitException: System error (java.lang.NullPointerException): null
        [sqlunit]     at net.sourceforge.sqlunit.handlers.SqlHandler.executeSQL(SqlHandler.java:166)
        [sqlunit]     at net.sourceforge.sqlunit.handlers.SqlHandler.process(SqlHandler.java:124)
        [sqlunit]     at net.sourceforge.sqlunit.handlers.DiffHandler.process(DiffHandler.java:189)
        [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.processDoc(SQLUnit.java:299)
        [sqlunit]     at net.sourceforge.sqlunit.SQLUnit.testWrapper(SQLUnit.java:218)
        [sqlunit]     ... 12 more
        [sqlunit] Caused by: java.lang.NullPointerException
        [sqlunit]     at ianywhere.ml.jdbcodbc.IPreparedStatement.setObject(IPreparedStatement.java:217)
        [sqlunit]     at ianywhere.ml.jdbcodbc.IPreparedStatement.setObject(IPreparedStatement.java:234)
        [sqlunit]     at net.sourceforge.sqlunit.handlers.SqlHandler.setParameters(SqlHandler.java:223)
        [sqlunit]     at net.sourceforge.sqlunit.handlers.SqlHandler.executeSQL(SqlHandler.java:143)
        [sqlunit]     ... 16 more
        [sqlunit] SQLUnit Tests Failed: In file: \sqlunit\test.xml, tests: 4, failures: 1, errors = 0

      BUILD FAILED
      D:\Programs\sqlunit-cvs\build.xml:130: SQLUnit Tests Failed: In file: \sqlunit\test.xml, tests: 4, failures: 1, errors = 0

      Total time: 6 seconds

       

    • Sujit Pal

      Sujit Pal - 2004-12-01

      Hi Dave,

      No, that was not the change you need to fix the problem.

      The OutParam change was to fix the way the assert failure looked in James's post. That has no bearing on the fix to this problem. The change that is needed is in SymbolTable.java where it now updates the symbol table after updating the source from the target. See here:
      http://cvs.sourceforge.net/viewcvs.py/sqlunit/sqlunit/src/net/sourceforge/sqlunit/SymbolTable.java?r1=1.34&r2=1.35

      You should also see some more updates in the xml files, they contain some mock test cases to simulate this condition.

      -sujit

       

    • David Fishburn

      David Fishburn - 2004-12-01

      It was the case where it took a while for the public copy of the CVS tree to get updated.

      If you make a fix (and it is just one file), could you indicate the name of the file.  That way when we (I) do the refresh I will know if I have the change you made or not.

      When I did a refresh this morning, the change was updated on my machine.

      The fix works fine.

      Thanks,
      Dave

       

Log in to post a comment.