sqlunit-flat:
[sqlunit] *** Running SQLUnit file: test/ASA/test.xml
[sqlunit] Getting connection(DEFAULT)
[sqlunit] Setting up test...
[sqlunit] Running test[1]: Adding department HR (90ms)
[sqlunit] Running test[2]: Adding department IT (10ms)
[sqlunit] Running test[3]: Adding employee John Doe to IT (20ms)
[sqlunit] Running test[4]: Adding John Doe againError (java.sql.SQLException)
encountered: Accessing a closed Connection object
[sqlunit] Accessing a closed Connection object
[sqlunit] One or more SQLUnit Tests failed, see the console for details
Thanks, fixed it now, it was throwing an SQLException with this, but the code was not catching it as one, but it was getting caught in the Exception block, where it was trying to rollback the transaction. Just realized that when the code is all the way down there, it makes no sense to try to rollback the connection, so removed the call from there. Let me know if this works.
Thanks
Sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It did not compile the new changes you downloaded. This is because of a "feature" where if it sees a sqlunit-xx.jar file in the classpath, it does not rebuild it. You will need to delete the sqlunit-xx.jar file from lib/ and do ant clean compile compile-test, then rerun your tests. I say this because towards the top of the trace you provided, the compile target shows nothing, it should tell you it compiled some 95 or so files, and the line where its complaining is the line I removed. The line thats just pushes the Connection object into a map, it does not do anything with the connection itself.
-sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
That is unusual, since I did do a clean before the install.
I think it did not refresh all of the changes from CVS right away. I just did an update again and it downloaded a couple of more. Anyway, this time the tests passed!
sqlunit-flat:
[sqlunit] *** Running SQLUnit file: test/ASA/test.xml
[sqlunit] Getting connection(DEFAULT)
[sqlunit] Setting up test...
[sqlunit] Running test[1]: Adding department HR (90ms)
[sqlunit] Running test[2]: Adding department IT (20ms)
[sqlunit] Running test[3]: Adding employee John Doe to IT (20ms)
[sqlunit] Running test[4]: Adding John Doe again (20ms)
[sqlunit] Accessing a closed Connection object
[sqlunit] Running test[5]: Adding Jane Doe to HR (30ms)
[sqlunit] Running test[6]: Adding Dick Tracy to IT (20ms)
[sqlunit] Running test[7]: Updating Hourly Rate for John (20ms)
[sqlunit] Running test[8]: Looking up John Doe by name (20ms)
[sqlunit] Running test[9]: Looking up all employees in IT (20ms)
[sqlunit] Running test[10]: Adding timecard for John (20ms)
[sqlunit] Running test[11]: Adding another timecard for John (10ms)
[sqlunit] Running test[12]: Adding timecard for Dick (20ms)
[sqlunit] Running test[13]: Getting monthly report for IT (30ms)
[sqlunit] Tearing down test...
[sqlunit] SQLUnit Tests Failed: In file: test/ASA/test.xml, tests: 13, failure
s: 1, errors = 0
[sqlunit] One or more SQLUnit Tests failed, see the console for details
I take it the 1 failure, was the one I was counting on the exception.
I will continue on my different data types test now.
Thanks,
Dave
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is a change between my last tests before we added the reconnect on error.
Part of my test does this:
<test name="Adding employee John Doe to IT">
<call>
<stmt>{call add_employee(?,?,?,?,?)}</stmt>
<param id="1" type="VARCHAR">Information Technology</param>
<param id="2" type="VARCHAR">John Doe</param>
<param id="3" type="DATE">1970-11-29</param>
<param id="4" type="VARCHAR">123456789</param>
<param id="5" type="NUMERIC">40.00</param>
</call>
<result>
<resultset id="1">
<row id="1">
<col id="1" type="INTEGER">${empId_John}</col>
</row>
</resultset>
</result>
</test>
Now do it again and make sure the error is returned:
<test name="Adding John Doe again">
<call>
<stmt>{call add_employee(?,?,?,?,?)}</stmt>
<param id="1" type="VARCHAR">Information Technology</param>
<param id="2" type="VARCHAR">John Doe</param>
<param id="3" type="DATE">1970-11-29</param>
<param id="4" type="VARCHAR">123456789</param>
<param id="5" type="NUMERIC">40.00</param>
</call>
<result>
<exception>
<code>-20746</code>
<message>[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists</message>
</exception>
</result>
</test>
When I run the test I get:
sqlunit-flat:
[sqlunit] *** Running SQLUnit file: test/ASA/test.xml
[sqlunit] Getting connection(DEFAULT)
[sqlunit] Setting up test...
[sqlunit] Running test[1]: Adding department HR (90ms)
[sqlunit] Running test[2]: Adding department IT (10ms)
[sqlunit] Running test[3]: Adding employee John Doe to IT (20ms)
[sqlunit] Running test[4]: Adding John Doe againError (java.sql.SQLException)
encountered: Accessing a closed Connection object
[sqlunit] Accessing a closed Connection object
[sqlunit] One or more SQLUnit Tests failed, see the console for details
In my <connection> object I have:
<sqlunit>
<connection reconnect-on-failure="on">
<driver>ianywhere.ml.jdbcodbc.IDriver</driver>
<url>jdbc:odbc:driver=Adaptive Server Anywhere 9.0</url>
<user>DBA</user>
<password>SQL</password>
</connection>
So I have the reconnect-on-failure set.
I am not sure how we need to modify the test or resultset or whatever to accomodate this.
Thanks,
Dave
This may be a bug that got introduced when I refactored the code. Can you send me a full trace (debug on)?
Thanks
Sujit
Here is most of a trace, trying to keep the size of the post down, let me know if it is not enough.
[sqlunit] Running test[3]: Adding employee John Doe to IT (341ms)
[sqlunit] DEBUG [main] (SymbolTable.java:124) - >> getSymbols()
[sqlunit] DEBUG [main] (SQLUnit.java:390) - >> SymbolTable: cleanUp, key = ${__JavaObjectSupport__}
[sqlunit] DEBUG [main] (SQLUnit.java:390) - >> SymbolTable: cleanUp, key = ${__ElapsedMillisStr__}
[sqlunit] DEBUG [main] (SQLUnit.java:390) - >> SymbolTable: cleanUp, key = ${__FailureMessage__}
[sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(test)
[sqlunit] DEBUG [main] (TestHandler.java:143) - >> process(elTest)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(off)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(off)
[sqlunit] DEBUG [main] (SymbolTable.java:115) - >> setValue(${__JavaObjectSupport__},off)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,failure-message)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(null)
[sqlunit] DEBUG [main] (SymbolTable.java:79) - >> setObject(${__FailureMessage__},net.sourceforge.sqlunit.SQLUnitException
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,name)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(Adding John Doe again)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,expected-duration-millis)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,percentage-tolerance)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,assert)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(call)
[sqlunit] DEBUG [main] (CallHandler.java:108) - >> process()
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element call,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element stmt)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:124) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:91) - >> getValue(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:65) - >> getObject(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:91) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:65) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:91) - >> getValue(${__FailureMessage__})
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(${__FailureMessage__})
[sqlunit] DEBUG [main] (SymbolTable.java:65) - >> getObject(${__FailureMessage__})
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(${__FailureMessage__})
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(2)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(3)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(DATE)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(4)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(5)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(NUMERIC)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (SqlHandler.java:141) - executeSQL(null,{call add_employee(?,?,?,?,?)},params)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(Information Technology,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(John Doe,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(1970-11-29,DATE)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(DATE)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for DATE
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: DATE
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.DateType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(DATE)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(123456789,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(40.00,NUMERIC)
[sqlunit] DEBUG [main] (SymbolTable.java:222) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(NUMERIC)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: net.sourceforge.sqlunit.types.BigDecimalType
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.BigDecimalType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(NUMERIC)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (DatabaseResult.java:55) - [DatabaseResult]
[sqlunit] DEBUG [main] (ConnectionRegistry.java:135) - >> invalidate(null)
[sqlunit] DEBUG [main] (DatabaseResult.java:165) - >> resetAsException(-20746,[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] )
[sqlunit] Running test[4]: Adding John Doe againError (java.sql.SQLException) encountered: Accessing a closed Connection object
[sqlunit] DEBUG [main] (ConnectionRegistry.java:158) - >> releaseConnections()
[sqlunit] DEBUG [main] (SQLUnitResult.java:90) - >> errorCount()
[sqlunit] DEBUG [main] (SQLUnitResult.java:81) - >> failureCount()
[sqlunit] FATAL [main] (SQLUnit.java:197) - Accessing a closed Connection object
[sqlunit] net.sourceforge.sqlunit.SQLUnitException: Accessing a closed Connection object
[sqlunit] at net.sourceforge.sqlunit.SQLUnit.processDoc(SQLUnit.java:348)
[sqlunit] at net.sourceforge.sqlunit.SQLUnit.testWrapper(SQLUnit.java:216)
[sqlunit] at net.sourceforge.sqlunit.SQLUnit.runTest(SQLUnit.java:194)
[sqlunit] at net.sourceforge.sqlunit.ant.SqlunitTask.execute(SqlunitTask.java:109)
[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: java.sql.SQLException: Accessing a closed Connection object
[sqlunit] at ianywhere.ml.jdbcodbc.IConnection.getAutoCommit(Native Method)
[sqlunit] at net.sourceforge.sqlunit.handlers.SqlHandler.executeSQL(SqlHandler.java:164)
[sqlunit] at net.sourceforge.sqlunit.handlers.CallHandler.process(CallHandler.java:132)
[sqlunit] at net.sourceforge.sqlunit.handlers.TestHandler.process(TestHandler.java:184)
[sqlunit] at net.sourceforge.sqlunit.SQLUnit.processDoc(SQLUnit.java:295)
[sqlunit] ... 13 more
[sqlunit] Accessing a closed Connection object
[sqlunit] net.sourceforge.sqlunit.SQLUnitException: One or more SQLUnit Tests failed, see the console for details
[sqlunit] at net.sourceforge.sqlunit.ant.SqlunitTask.execute(SqlunitTask.java:126)
[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] One or more SQLUnit Tests failed, see the console for details
Hi Dave,
Thanks, fixed it now, it was throwing an SQLException with this, but the code was not catching it as one, but it was getting caught in the Exception block, where it was trying to rollback the transaction. Just realized that when the code is all the way down there, it makes no sense to try to rollback the connection, so removed the call from there. Let me know if this works.
Thanks
Sujit
Doesn't appear to have helped.
init:
compile:
def:
sqlunit-flat:
[sqlunit] DEBUG [main] (SQLUnit.java:216) - >> testWrapper()
[sqlunit] DEBUG [main] (SQLUnit.java:238) - >> processDoc()
[sqlunit] DEBUG [main] (TypeMapper.java:67) - instantiating TypeMapper
[sqlunit] DEBUG [main] (TypeMapper.java:189) - loading types from: net.sourceforge.sqlunit.types
[sqlunit] DEBUG [main] (TypeMapper.java:189) - loading types from: usertypes
[sqlunit] DEBUG [main] (TypeMapper.java:221) - loading non-mapped types
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: -7
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: -7
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: BIT
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: -6
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: -6
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: TINYINT
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 5
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 5
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: SMALLINT
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 4
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 4
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: -5
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: -5
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: BIGINT
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 6
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 6
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: FLOAT
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 7
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 7
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: REAL
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 8
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 8
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: DOUBLE
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 2
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 2
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 3
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 3
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: DECIMAL
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 1
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 1
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: CHAR
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 12
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 12
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: -1
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: -1
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: LONGVARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 91
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 91
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: DATE
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 92
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 92
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: TIME
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 93
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 93
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: TIMESTAMP
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: -2
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: -2
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: BINARY
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: -3
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: -3
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARBINARY
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: -4
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: -4
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: LONGVARBINARY
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 0
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 0
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: NULL
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 1111
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 1111
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: OTHER
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 2000
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 2000
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: JAVA_OBJECT
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 2001
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 2001
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: null
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 2002
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 2002
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: null
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 2003
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 2003
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: ARRAY
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 2004
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 2004
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: BLOB
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 2005
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 2005
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: CLOB
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 2006
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 2006
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: null
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 70
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 70
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: null
[sqlunit] DEBUG [main] (TypeMapper.java:102) - finding class by id: 16
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 16
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: BOOLEAN
[sqlunit] DEBUG [main] (SQLUnitResult.java:126) - >> setTestFile(test/ASA/test.xml)
[sqlunit] *** Running SQLUnit file: test/ASA/test.xml
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] Getting connection(DEFAULT)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(connection)
[sqlunit] DEBUG [main] (ConnectionHandler.java:181) - >> process()
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element connection,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element connection,extern)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element connection,transaction-support)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(on)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element connection,reconnect-on-failure)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(on)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element connection,server-name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element driver)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(ianywhere.ml.jdbcodbc.IDriver)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element url)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(jdbc:odbc:driver=Adaptive Server Anywhere 9.0)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element user)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(DBA)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element password)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(SQL)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:113) - >> setConnectionById(null)
[sqlunit] DEBUG [main] (ConnectionFactory.java:56) - >> getInstance(props)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] Setting up test...
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(setup)
[sqlunit] DEBUG [main] (SetupHandler.java:89) - >> process(elSetup)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(include)
[sqlunit] DEBUG [main] (IncludeHandler.java:94) - >> process(elInclude)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,file)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(test/asa/schema.sql)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(include)
[sqlunit] DEBUG [main] (IncludeHandler.java:94) - >> process(elInclude)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,file)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(test/asa/add_dept.sql)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(include)
[sqlunit] DEBUG [main] (IncludeHandler.java:94) - >> process(elInclude)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,file)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(test/asa/add_employee.sql)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(include)
[sqlunit] DEBUG [main] (IncludeHandler.java:94) - >> process(elInclude)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,file)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(test/asa/add_timecard.sql)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(include)
[sqlunit] DEBUG [main] (IncludeHandler.java:94) - >> process(elInclude)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,file)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(test/asa/get_depts.sql)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(include)
[sqlunit] DEBUG [main] (IncludeHandler.java:94) - >> process(elInclude)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,file)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(test/asa/get_emp_by_name.sql)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(include)
[sqlunit] DEBUG [main] (IncludeHandler.java:94) - >> process(elInclude)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,file)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(test/asa/get_emp_in_dept.sql)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(include)
[sqlunit] DEBUG [main] (IncludeHandler.java:94) - >> process(elInclude)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,file)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(test/asa/get_mthly_dept_rpt.sql)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(include)
[sqlunit] DEBUG [main] (IncludeHandler.java:94) - >> process(elInclude)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element include,file)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(test/asa/upd_rate.sql)
[sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(test)
[sqlunit] DEBUG [main] (TestHandler.java:143) - >> process(elTest)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(off)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(off)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__JavaObjectSupport__},off)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,failure-message)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(Adding department HR)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,expected-duration-millis)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,percentage-tolerance)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,assert)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(call)
[sqlunit] DEBUG [main] (CallHandler.java:108) - >> process()
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element call,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element stmt)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName({call add_dept(?)})
[sqlunit] DEBUG [main] (SymbolTable.java:263) - >> replaceVariables({call add_dept(?)})
[sqlunit] DEBUG [main] (SymbolTable.java:129) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(Human Resources)
[sqlunit] DEBUG [main] (SqlHandler.java:141) - executeSQL(null,{call add_dept(?)},params)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(Human Resources,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(Human Resources)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (DatabaseResult.java:55) - [DatabaseResult]
[sqlunit] DEBUG [main] (SymbolTable.java:280) - >> setCurrentResultSet(1)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__0.resultset__},1)
[sqlunit] DEBUG [main] (SymbolTable.java:290) - >> setCurrentRow(1)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__0.row__},1)
[sqlunit] DEBUG [main] (SymbolTable.java:300) - >> setCurrentCol(1)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__0.col__},1)
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 4
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (TypeUtils.java:83) - >> getXmlTypeFromSqlType(4)
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 4
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(result)
[sqlunit] DEBUG [main] (ResultHandler.java:144) - >> process(elResult)
[sqlunit] DEBUG [main] (DatabaseResult.java:55) - [DatabaseResult]
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(resultset)
[sqlunit] DEBUG [main] (ResultSetHandler.java:94) - >> process(elResultSet)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element resultset,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element resultset,rowcount)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(row)
[sqlunit] DEBUG [main] (RowHandler.java:74) - >> process(elRow)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element row,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(col)
[sqlunit] DEBUG [main] (ColHandler.java:72) - >> process(elCol)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element col,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element col,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element col,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element resultset,order-by)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__JavaObjectSupport__},null)
[sqlunit] DEBUG [main] (SymbolTable.java:200) - >> update(target,source)
[sqlunit] DEBUG [main] (SymbolTable.java:209) - looking at colValue: ${deptId_HR}
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:330) - >> dump()
[sqlunit] DEBUG [main] (SymbolTable.java:129) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:332) -
[sqlunit] Symbol table dump
[sqlunit] DEBUG [main] (SymbolTable.java:333) - -----------------
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__0.resultset__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__0.row__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__JavaObjectSupport__} => null
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__0.col__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:343) - -----------------
[sqlunit] DEBUG [main] (DatabaseResult.java:147) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:147) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:181) - >> getUpdateCount()
[sqlunit] DEBUG [main] (DatabaseResult.java:181) - >> getUpdateCount()
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(INTEGER)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(INTEGER)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__ElapsedMillisStr__},221)
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] Running test[1]: Adding department HR (221ms)
[sqlunit] DEBUG [main] (SymbolTable.java:129) - >> getSymbols()
[sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(test)
[sqlunit] DEBUG [main] (TestHandler.java:143) - >> process(elTest)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(off)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(off)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__JavaObjectSupport__},off)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,failure-message)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(Adding department IT)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,expected-duration-millis)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,percentage-tolerance)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,assert)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(call)
[sqlunit] DEBUG [main] (CallHandler.java:108) - >> process()
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element call,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element stmt)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName({call add_dept(?)})
[sqlunit] DEBUG [main] (SymbolTable.java:263) - >> replaceVariables({call add_dept(?)})
[sqlunit] DEBUG [main] (SymbolTable.java:129) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.col__})
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (SqlHandler.java:141) - executeSQL(null,{call add_dept(?)},params)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(Information Technology,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (DatabaseResult.java:55) - [DatabaseResult]
[sqlunit] DEBUG [main] (SymbolTable.java:280) - >> setCurrentResultSet(1)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__0.resultset__},1)
[sqlunit] DEBUG [main] (SymbolTable.java:290) - >> setCurrentRow(1)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__0.row__},1)
[sqlunit] DEBUG [main] (SymbolTable.java:300) - >> setCurrentCol(1)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__0.col__},1)
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 4
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (TypeUtils.java:83) - >> getXmlTypeFromSqlType(4)
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 4
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(result)
[sqlunit] DEBUG [main] (ResultHandler.java:144) - >> process(elResult)
[sqlunit] DEBUG [main] (DatabaseResult.java:55) - [DatabaseResult]
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(resultset)
[sqlunit] DEBUG [main] (ResultSetHandler.java:94) - >> process(elResultSet)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element resultset,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element resultset,rowcount)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(row)
[sqlunit] DEBUG [main] (RowHandler.java:74) - >> process(elRow)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element row,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(col)
[sqlunit] DEBUG [main] (ColHandler.java:72) - >> process(elCol)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element col,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element col,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element col,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element resultset,order-by)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__JavaObjectSupport__},null)
[sqlunit] DEBUG [main] (SymbolTable.java:200) - >> update(target,source)
[sqlunit] DEBUG [main] (SymbolTable.java:209) - looking at colValue: ${deptId_IT}
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:330) - >> dump()
[sqlunit] DEBUG [main] (SymbolTable.java:129) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:332) -
[sqlunit] Symbol table dump
[sqlunit] DEBUG [main] (SymbolTable.java:333) - -----------------
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__0.resultset__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__0.row__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__JavaObjectSupport__} => null
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__ElapsedMillisStr__} => 221
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__0.col__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:343) - -----------------
[sqlunit] DEBUG [main] (DatabaseResult.java:147) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:147) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:181) - >> getUpdateCount()
[sqlunit] DEBUG [main] (DatabaseResult.java:181) - >> getUpdateCount()
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(INTEGER)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(INTEGER)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__ElapsedMillisStr__},210)
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] Running test[2]: Adding department IT (210ms)
[sqlunit] DEBUG [main] (SymbolTable.java:129) - >> getSymbols()
[sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(test)
[sqlunit] DEBUG [main] (TestHandler.java:143) - >> process(elTest)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(off)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(off)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__JavaObjectSupport__},off)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,failure-message)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(Adding employee John Doe to IT)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,expected-duration-millis)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,percentage-tolerance)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,assert)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(call)
[sqlunit] DEBUG [main] (CallHandler.java:108) - >> process()
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element call,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element stmt)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:263) - >> replaceVariables({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:129) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.col__})
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(2)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(3)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(DATE)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(4)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(5)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(NUMERIC)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (SqlHandler.java:141) - executeSQL(null,{call add_employee(?,?,?,?,?)},params)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(Information Technology,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(John Doe,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(1970-11-29,DATE)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(DATE)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for DATE
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: DATE
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.DateType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(DATE)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(123456789,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(40.00,NUMERIC)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(NUMERIC)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: net.sourceforge.sqlunit.types.BigDecimalType
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.BigDecimalType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(NUMERIC)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (DatabaseResult.java:55) - [DatabaseResult]
[sqlunit] DEBUG [main] (SymbolTable.java:280) - >> setCurrentResultSet(1)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__0.resultset__},1)
[sqlunit] DEBUG [main] (SymbolTable.java:290) - >> setCurrentRow(1)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__0.row__},1)
[sqlunit] DEBUG [main] (SymbolTable.java:300) - >> setCurrentCol(1)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__0.col__},1)
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 4
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (TypeUtils.java:83) - >> getXmlTypeFromSqlType(4)
[sqlunit] DEBUG [main] (TypeMapper.java:114) - finding name by id: 4
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(result)
[sqlunit] DEBUG [main] (ResultHandler.java:144) - >> process(elResult)
[sqlunit] DEBUG [main] (DatabaseResult.java:55) - [DatabaseResult]
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(resultset)
[sqlunit] DEBUG [main] (ResultSetHandler.java:94) - >> process(elResultSet)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element resultset,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element resultset,rowcount)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(row)
[sqlunit] DEBUG [main] (RowHandler.java:74) - >> process(elRow)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element row,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(col)
[sqlunit] DEBUG [main] (ColHandler.java:72) - >> process(elCol)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element col,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element col,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element col,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element resultset,order-by)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__JavaObjectSupport__},null)
[sqlunit] DEBUG [main] (SymbolTable.java:200) - >> update(target,source)
[sqlunit] DEBUG [main] (SymbolTable.java:209) - looking at colValue: ${empId_John}
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:330) - >> dump()
[sqlunit] DEBUG [main] (SymbolTable.java:129) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:332) -
[sqlunit] Symbol table dump
[sqlunit] DEBUG [main] (SymbolTable.java:333) - -----------------
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__0.resultset__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__0.row__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__JavaObjectSupport__} => null
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__ElapsedMillisStr__} => 210
[sqlunit] DEBUG [main] (SymbolTable.java:341) - ${__0.col__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:343) - -----------------
[sqlunit] DEBUG [main] (DatabaseResult.java:147) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:147) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:181) - >> getUpdateCount()
[sqlunit] DEBUG [main] (DatabaseResult.java:181) - >> getUpdateCount()
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(INTEGER)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(INTEGER)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__ElapsedMillisStr__},220)
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] Running test[3]: Adding employee John Doe to IT (220ms)
[sqlunit] DEBUG [main] (SymbolTable.java:129) - >> getSymbols()
[sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(test)
[sqlunit] DEBUG [main] (TestHandler.java:143) - >> process(elTest)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(off)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(off)
[sqlunit] DEBUG [main] (SymbolTable.java:120) - >> setValue(${__JavaObjectSupport__},off)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,failure-message)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(Adding John Doe again)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,expected-duration-millis)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,percentage-tolerance)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element test,assert)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(call)
[sqlunit] DEBUG [main] (CallHandler.java:108) - >> process()
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element call,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element stmt)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:263) - >> replaceVariables({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:129) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:96) - >> getValue(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:70) - >> getObject(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(${__0.col__})
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(2)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(3)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(DATE)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(4)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (HandlerFactory.java:52) - >> getInstance(param)
[sqlunit] DEBUG [main] (ParamHandler.java:94) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(5)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(NUMERIC)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:53) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:77) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (SqlHandler.java:141) - executeSQL(null,{call add_employee(?,?,?,?,?)},params)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:55) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(Information Technology,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(John Doe,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(1970-11-29,DATE)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(DATE)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for DATE
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: DATE
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.DateType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(DATE)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(123456789,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:79) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:113) - >> convertToObject(40.00,NUMERIC)
[sqlunit] DEBUG [main] (SymbolTable.java:252) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (TypeFactory.java:51) - >> getInstance(NUMERIC)
[sqlunit] DEBUG [main] (TypeFactory.java:73) - Looking up adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:92) - finding class by name: adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:75) - found a typeClass: net.sourceforge.sqlunit.types.BigDecimalType
[sqlunit] DEBUG [main] (TypeFactory.java:88) - Instantiating a net.sourceforge.sqlunit.types.BigDecimalType
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeUtils.java:96) - >> getSqlTypeFromXmlType(NUMERIC)
[sqlunit] DEBUG [main] (TypeMapper.java:155) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (DatabaseResult.java:55) - [DatabaseResult]
[sqlunit] DEBUG [main] (ConnectionRegistry.java:135) - >> invalidate(null)
[sqlunit] DEBUG [main] (DatabaseResult.java:165) - >> resetAsException(-20746,[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] )
[sqlunit] Running test[4]: Adding John Doe againError (java.sql.SQLException) encountered: Accessing a closed Connection object
[sqlunit] DEBUG [main] (ConnectionRegistry.java:158) - >> releaseConnections()
[sqlunit] DEBUG [main] (SQLUnitResult.java:90) - >> errorCount()
[sqlunit] DEBUG [main] (SQLUnitResult.java:81) - >> failureCount()
[sqlunit] FATAL [main] (SQLUnit.java:198) - Accessing a closed Connection object
[sqlunit] net.sourceforge.sqlunit.SQLUnitException: Accessing a closed Connection object
[sqlunit] at net.sourceforge.sqlunit.SQLUnit.processDoc(SQLUnit.java:368)
[sqlunit] at net.sourceforge.sqlunit.SQLUnit.testWrapper(SQLUnit.java:217)
[sqlunit] at net.sourceforge.sqlunit.SQLUnit.runTest(SQLUnit.java:195)
[sqlunit] at net.sourceforge.sqlunit.ant.SqlunitTask.execute(SqlunitTask.java:109)
[sqlunit] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269)
[sqlunit] at org.apache.tools.ant.Task.perform(Task.java:364)
[sqlunit] at org.apache.tools.ant.Target.execute(Target.java:301)
[sqlunit] at org.apache.tools.ant.Target.performTasks(Target.java:328)
[sqlunit] at org.apache.tools.ant.Project.executeTarget(Project.java:1215)
[sqlunit] at org.apache.tools.ant.Project.executeTargets(Project.java:1063)
[sqlunit] at org.apache.tools.ant.Main.runBuild(Main.java:632)
[sqlunit] at org.apache.tools.ant.Main.startAnt(Main.java:183)
[sqlunit] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:197)
[sqlunit] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:56)
[sqlunit] Caused by: java.sql.SQLException: Accessing a closed Connection object
[sqlunit] at ianywhere.ml.jdbcodbc.IConnection.getAutoCommit(Native Method)
[sqlunit] at net.sourceforge.sqlunit.handlers.SqlHandler.executeSQL(SqlHandler.java:164)
[sqlunit] at net.sourceforge.sqlunit.handlers.CallHandler.process(CallHandler.java:132)
[sqlunit] at net.sourceforge.sqlunit.handlers.TestHandler.process(TestHandler.java:182)
[sqlunit] at net.sourceforge.sqlunit.SQLUnit.processDoc(SQLUnit.java:296)
[sqlunit] ... 13 more
[sqlunit] Accessing a closed Connection object
[sqlunit] net.sourceforge.sqlunit.SQLUnitException: One or more SQLUnit Tests failed, see the console for details
[sqlunit] at net.sourceforge.sqlunit.ant.SqlunitTask.execute(SqlunitTask.java:126)
[sqlunit] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269)
[sqlunit] at org.apache.tools.ant.Task.perform(Task.java:364)
[sqlunit] at org.apache.tools.ant.Target.execute(Target.java:301)
[sqlunit] at org.apache.tools.ant.Target.performTasks(Target.java:328)
[sqlunit] at org.apache.tools.ant.Project.executeTarget(Project.java:1215)
[sqlunit] at org.apache.tools.ant.Project.executeTargets(Project.java:1063)
[sqlunit] at org.apache.tools.ant.Main.runBuild(Main.java:632)
[sqlunit] at org.apache.tools.ant.Main.startAnt(Main.java:183)
[sqlunit] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:197)
[sqlunit] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:56)
[sqlunit] One or more SQLUnit Tests failed, see the console for details
BUILD SUCCESSFUL
Total time: 3 seconds
It did not compile the new changes you downloaded. This is because of a "feature" where if it sees a sqlunit-xx.jar file in the classpath, it does not rebuild it. You will need to delete the sqlunit-xx.jar file from lib/ and do ant clean compile compile-test, then rerun your tests. I say this because towards the top of the trace you provided, the compile target shows nothing, it should tell you it compiled some 95 or so files, and the line where its complaining is the line I removed. The line thats just pushes the Connection object into a map, it does not do anything with the connection itself.
-sujit
That is unusual, since I did do a clean before the install.
I think it did not refresh all of the changes from CVS right away. I just did an update again and it downloaded a couple of more. Anyway, this time the tests passed!
sqlunit-flat:
[sqlunit] *** Running SQLUnit file: test/ASA/test.xml
[sqlunit] Getting connection(DEFAULT)
[sqlunit] Setting up test...
[sqlunit] Running test[1]: Adding department HR (90ms)
[sqlunit] Running test[2]: Adding department IT (20ms)
[sqlunit] Running test[3]: Adding employee John Doe to IT (20ms)
[sqlunit] Running test[4]: Adding John Doe again (20ms)
[sqlunit] Accessing a closed Connection object
[sqlunit] Running test[5]: Adding Jane Doe to HR (30ms)
[sqlunit] Running test[6]: Adding Dick Tracy to IT (20ms)
[sqlunit] Running test[7]: Updating Hourly Rate for John (20ms)
[sqlunit] Running test[8]: Looking up John Doe by name (20ms)
[sqlunit] Running test[9]: Looking up all employees in IT (20ms)
[sqlunit] Running test[10]: Adding timecard for John (20ms)
[sqlunit] Running test[11]: Adding another timecard for John (10ms)
[sqlunit] Running test[12]: Adding timecard for Dick (20ms)
[sqlunit] Running test[13]: Getting monthly report for IT (30ms)
[sqlunit] Tearing down test...
[sqlunit] SQLUnit Tests Failed: In file: test/ASA/test.xml, tests: 13, failure
s: 1, errors = 0
[sqlunit] One or more SQLUnit Tests failed, see the console for details
I take it the 1 failure, was the one I was counting on the exception.
I will continue on my different data types test now.
Thanks,
Dave