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>
<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
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
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