Menu

System error (java.lang.NullPointerException)

2004-11-25
2013-04-25
  • David Fishburn

    David Fishburn - 2004-11-25

    SQLUnit current CVS version.

    I am running a diff test, which always reports:
    [sqlunit] Running diff[4]: Diffing the ADDRESS table (30ms)
    [sqlunit] System error (java.lang.NullPointerException): null
    [sqlunit] Tearing down test...

    Based on the debug output:
      [sqlunit] Running diff[4]: Diffing the ADDRESS table (121ms)
      [sqlunit] DEBUG [main] (SQLUnitResult.java:99) - >> getLastException()
      [sqlunit] System error (java.lang.NullPointerException): null

    This looks like it might be related to my earlier posts. 
      [sqlunit] DEBUG [main] (SymbolTable.java:273) - >> replaceVariables(
      [sqlunit]         SELECT TOP 1 agy_id
      [sqlunit]           FROM PARTY
      [sqlunit]          ORDER BY agy_id
      [sqlunit]       )

    This query does return an INTEGER.
    But it does not look like SQLUnit is getting it.

    Here is the full test:
    <?xml version="1.0"?>
    <!DOCTYPE sqlunit SYSTEM "file:docs/sqlunit.dtd">
    <sqlunit>
      <connection connection-id="cons" reconnect-on-failure="on">
       <driver>ianywhere.ml.jdbcodbc.IDriver</driver>
        <url>jdbc:odbc:dsn=cons</url>
        <user>DBA</user>
        <password>SQL</password>
      </connection>

      <connection connection-id="remote" reconnect-on-failure="on">
       <driver>ianywhere.ml.jdbcodbc.IDriver</driver>
        <url>jdbc:odbc:dsn=remote</url>
        <user>DBA</user>
        <password>SQL</password>
      </connection>

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

      <diff name="Diffing the ADDRESS table"
        failure-message="ADDRESS table match failed">
        <sql connection-id="cons">
          <stmt>
            SELECT adr_id, adr_ln_1
              FROM ADDRESSES
             WHERE ? IN (
                          SELECT AGY_ID
                            FROM PARTY_ADDRESS pa
                           WHERE pa.ADR_ID = ADDRESSES.ADR_ID
                        )
             ORDER BY adr_id
          </stmt>
          <param id="1" type="INTEGER">${SSUserID}</param>
        </sql>
        <sql connection-id="remote">
          <stmt>
            SELECT adr_id, adr_ln_1
              FROM ADDRESSES
             ORDER BY adr_id
          </stmt>
        </sql>
      </diff>

      <teardown />

    </sqlunit>

    Here is the full 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__},191)
      [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 (191ms)
      [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__} => 191
      [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__},130)
      [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 (130ms)
      [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__} => 130
      [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__},110)
      [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 (110ms)
      [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 (110ms)
      [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: D:\Ptrack\Pearson\rep9\sqlunit\test.xml, tests: 4, failures: 1, errors = 0

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

    Total time: 5 seconds

     
    • Sujit Pal

      Sujit Pal - 2004-11-30

      Hi Dave,

      The error looks like a result of the bug you pointed out in the thread "Variables not working ${AgentId}". The fix I checked in should make this problem go away. Please let me know if it did.

      Thanks
      Sujit

       

Log in to post a comment.