Current CVS version.
Connected to an ASA database.
Wrote a test that intentional retruns a warning.
So I catch the error.
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 (30ms)
[sqlunit] Running test[4]: Adding John Doe again (30ms)
[sqlunit] System error (java.sql.SQLException): 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 (121ms)
[sqlunit] Running test[9]: Looking up all employees in IT (40ms)
[sqlunit] Running test[10]: Adding timecard for John (20ms)
[sqlunit] Running test[11]: Adding another timecard for John (20ms)
[sqlunit] Running test[12]: Adding timecard for Dick (20ms)
[sqlunit] Running test[13]: Getting monthly report for IT (40ms)
[sqlunit] Tearing down test...
[sqlunit] sqlunit-ant: SQLUnit Tests Failed: In file: test/ASA/test.xml, tests: 13, failures: 1, errors = 0
[sqlunit] SQLUnit Tests Failed: In file: test/ASA/test.xml, tests: 13, failures: 1, errors = 0
Since the failure was *intentional* I do not want SQLUnit to report 1 failures.
Is there a way to configure the target to do this?
Here is the target:
<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>
You should use the assertion fail-with-failure, in this case, your test will probably look something like this:
<test name="Adding John Doe again" assert="fail-with-failure">
<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>
Let me know if this works. You may have to provide the failure-message as well, although I think that is optional.
-sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have tried both of these:
<test name="Adding John Doe again" assert="fail-with-failure">
<test name="Adding John Doe again" assert="fail-with-failure"
failure-message="whoa"-->
In both cases (despite the bogus error message) I get the same output:
[sqlunit] Running test[4]: Adding John Doe again (20ms)
[sqlunit] System error (java.sql.SQLException): Accessing a closed Connection object
[sqlunit] Running test[5]: Adding Jane Doe to HR (40ms)
It looks like either reconnect-on-failure is not set to "on" (which is unlikely since the cvs version of your suite has it set), or the invalidate() method does not get rid of this correctly. Can you confirm that reconnect-on-failure is set on?
Thanks
Sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ok, I think I found it, made the updates, just checked it in tonight, you can probably see it tomorrow. Look for this version on this file to make sure you got the fix.
Checking in src/net/sourceforge/sqlunit/handlers/SqlHandler.java;
/cvsroot/sqlunit/sqlunit/src/net/sourceforge/sqlunit/handlers/SqlHandler.java,v <-- SqlHandler.java
new revision: 1.14; previous revision: 1.13
I also opened up the LOG.fatal() call to print the stack trace instead of a single line error message, perhaps it can give some more clues if this fix does not work out. The stack trace is normally produced if you set the debug flag.
Specifically the problem I found was that it was trying to check the autocommit status on the connection object after it was closed, and if so, trying to rollback the transaction if transaction-support="off". The code is still there, its moved to the ConnectionRegistry.invalidate() call where there are more checks before the operations actually happen.
Let me know if this worked.
Thanks
Sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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 (441ms)
[sqlunit] Running test[2]: Adding department IT (10ms)
[sqlunit] Running test[3]: Adding employee John Doe to IT (40ms)
[sqlunit] Running test[4]: Adding John Doe again (40ms)
[sqlunit] Assertion "fail-with-failure" failed ("" != "Assertion "exception-matches" failed ([Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists != [Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] at exception.message)")
[sqlunit] *** expected:
[sqlunit] <result>
[sqlunit] <exception>
[sqlunit] <code>-20746</code>
[sqlunit] <message>[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERRO
R executed: add_employee: Employee already exists</message>
[sqlunit] </exception>
[sqlunit] </result>
[sqlunit] *** but got: <result>
[sqlunit] <exception>
[sqlunit] <code>-20746</code>
[sqlunit] <message>[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERRO
R executed: add_employee: Employee already exists</message>
[sqlunit] </exception>
[sqlunit] </result>
[sqlunit] Running test[5]: Adding Jane Doe to HR (30ms)
I am not sure really how to format the failure-message option. I tried this:
<test name="Adding John Doe again" assert="fail-with-failure" failure-message="[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists">
Got this:
[sqlunit] Assertion "fail-with-failure" failed ("[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists" !=
"Assertion "exception-matches" failed ([Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists != [Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee
already exists
[sqlunit] at exception.message)")
So I tried this:
<test name="Adding John Doe again" assert="fail-with-failure" failure-message="Assertion \"exception-matches\" failed ([Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists at exception.message)">
Got this:
Does not like the embedded quotes " around the exception-matches string.
Here is the debug output from the previous test that was closer.
Oops, sorry to not have told you earlier, but the fail-with-failure is not applicable to the current situation. Basically you should just check for the exception with the default assert, which seems to be succeeding going by the stack trace.
Basically when you specify the exception and the assert="fail-with-failure", it should return a positive if the sproc did not in fact raise an exception :-). Alternatively, you could specify a real result (not an exception) that you would have got if there were not a primary key violation and then set the fail-with-failure.failure-message should be the error that SQLUnit will give you in that case, something along the lines of "Assert 'equals' failed: this != that".
BTW, I have been busy with adapting Victor's tags these last few days for SQLUnit. I have just completed a pretty large checkin, about 4 new tags, DTD changes, new tests, and new beans. You may want to pull down the CVS tree again just to verify that I havent broken your tests.
I think we should be ready to make a release after this problem is resolved. Yes, I know, I have been saying that for a while, but then I started working on Victor's tags and that took a while.
Let me know if the fix is good.
Thanks
-sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Looking at the above output, the only difference I see between the expected result and the real result is a carriage return at the end of the message. I have that carriage return in my test.
Let me know what you think I should change the test to (exactly please) and I will try it.
Looks like we have to "normalize" the message returned from the database before comparing. JDOM will ignore the carriage return when pulling the text from the element unless you declare it a CDATA. I think we may need to change the code to handle this situation. The code change is simple, but not sure if you will be able to get it off CVS, so I will also publish a patch to the appropriate file which you can then apply on your local copy and rebuild. Give me few hours, I will get back to you on this thread today.
-sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am getting CVS changes now since I am logging in as myself. So just sent out a notice when I can grab it. Let me know the file that changed so I can verify it was downloaded.
Thanks,
Dave
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Great, here are the changes.
---
Checking in src/net/sourceforge/sqlunit/beans/DatabaseResult.java;
/cvsroot/sqlunit/sqlunit/src/net/sourceforge/sqlunit/beans/DatabaseResult.java,v <-- DatabaseResult.java
new revision: 1.7; previous revision: 1.6
done
Checking in src/net/sourceforge/sqlunit/utils/XMLUtils.java;
/cvsroot/sqlunit/sqlunit/src/net/sourceforge/sqlunit/utils/XMLUtils.java,v <-- XMLUtils.java
new revision: 1.4; previous revision: 1.3
done
-sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks for finding the bug and testing it so thoroughly. You will see the next version of SQLUnit ready to download (which would be more or less what you have right now) when you get back. Enjoy your vacation :-).
Thanks
-sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Current CVS version.
Connected to an ASA database.
Wrote a test that intentional retruns a warning.
So I catch the error.
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 (30ms)
[sqlunit] Running test[4]: Adding John Doe again (30ms)
[sqlunit] System error (java.sql.SQLException): 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 (121ms)
[sqlunit] Running test[9]: Looking up all employees in IT (40ms)
[sqlunit] Running test[10]: Adding timecard for John (20ms)
[sqlunit] Running test[11]: Adding another timecard for John (20ms)
[sqlunit] Running test[12]: Adding timecard for Dick (20ms)
[sqlunit] Running test[13]: Getting monthly report for IT (40ms)
[sqlunit] Tearing down test...
[sqlunit] sqlunit-ant: SQLUnit Tests Failed: In file: test/ASA/test.xml, tests: 13, failures: 1, errors = 0
[sqlunit] SQLUnit Tests Failed: In file: test/ASA/test.xml, tests: 13, failures: 1, errors = 0
Since the failure was *intentional* I do not want SQLUnit to report 1 failures.
Is there a way to configure the target to do this?
Here is the target:
<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>
Here is the debug output around that target:
[sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
[sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(test)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (TestHandler.java:149) - >> process(elTest)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(off)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(off)
[sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},off)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,failure-message)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,name)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(Adding John Doe again)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,expected-duration-millis)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,percentage-tolerance)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,assert)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:71) - >> getExecutableTags(test)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(call)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (CallHandler.java:103) - >> process()
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element call,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element stmt)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:276) - >> replaceVariables({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__0.col__})
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(2)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(3)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(DATE)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(4)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(5)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(NUMERIC)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(null,{call add_employee(?,?,?,?,?)},params)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(Information Technology,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(John Doe,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(1970-11-29,DATE)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(DATE)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.DATE)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for DATE
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.DateType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(DATE)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(123456789,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(40.00,NUMERIC)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(NUMERIC)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.BigDecimalType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(NUMERIC)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
[sqlunit] DEBUG [main] (ConnectionRegistry.java:144) - >> invalidate(null)
[sqlunit] DEBUG [main] (DatabaseResult.java:160) - >> resetAsException(-20746,[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] )
[sqlunit] DEBUG [main] (ConnectionRegistry.java:144) - >> invalidate(null)
[sqlunit] DEBUG [main] (SQLUnitResult.java:47) - >> addFailureCount()
[sqlunit] DEBUG [main] (SQLUnitResult.java:108) - >> setLastException(e)
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] Running test[4]: Adding John Doe again (500ms)
Thanks,
Dave
You should use the assertion fail-with-failure, in this case, your test will probably look something like this:
<test name="Adding John Doe again" assert="fail-with-failure">
<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>
Let me know if this works. You may have to provide the failure-message as well, although I think that is optional.
-sujit
I have tried both of these:
<test name="Adding John Doe again" assert="fail-with-failure">
<test name="Adding John Doe again" assert="fail-with-failure"
failure-message="whoa"-->
In both cases (despite the bogus error message) I get the same output:
[sqlunit] Running test[4]: Adding John Doe again (20ms)
[sqlunit] System error (java.sql.SQLException): Accessing a closed Connection object
[sqlunit] Running test[5]: Adding Jane Doe to HR (40ms)
Debug output:
[sqlunit] Running test[3]: Adding employee John Doe to IT (421ms)
[sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
[sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(test)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (TestHandler.java:149) - >> process(elTest)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(off)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(off)
[sqlunit] DEBUG [main] (SymbolTable.java:129) - >> setValue(${__JavaObjectSupport__},off)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,failure-message)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,name)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(Adding John Doe again)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,expected-duration-millis)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,percentage-tolerance)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,assert)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(fail-with-failure)
[sqlunit] DEBUG [main] (HandlerFactory.java:71) - >> getExecutableTags(test)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(call)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (CallHandler.java:103) - >> process()
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element call,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element stmt)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:276) - >> replaceVariables({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:138) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__0.resultset__})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${empId_John})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__0.row__})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__JavaObjectSupport__})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${deptId_IT})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${deptId_HR})
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__0.col__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__0.col__})
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(2)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(3)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(DATE)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(4)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(5)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(NUMERIC)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(null,{call add_employee(?,?,?,?,?)},params)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnectionById(null)
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(Information Technology,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(John Doe,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(1970-11-29,DATE)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(DATE)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.DATE)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for DATE
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.DateType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(DATE)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(123456789,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(40.00,NUMERIC)
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(NUMERIC)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.BigDecimalType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(NUMERIC)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
[sqlunit] DEBUG [main] (ConnectionRegistry.java:144) - >> invalidate(null)
[sqlunit] DEBUG [main] (DatabaseResult.java:160) - >> resetAsException(-20746,[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] )
[sqlunit] DEBUG [main] (ConnectionRegistry.java:144) - >> invalidate(null)
[sqlunit] DEBUG [main] (SQLUnitResult.java:47) - >> addFailureCount()
[sqlunit] DEBUG [main] (SQLUnitResult.java:108) - >> setLastException(e)
[sqlunit] DEBUG [main] (SymbolTable.java:104) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:77) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:265) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] Running test[4]: Adding John Doe again (421ms)
Hi Dave,
It looks like either reconnect-on-failure is not set to "on" (which is unlikely since the cvs version of your suite has it set), or the invalidate() method does not get rid of this correctly. Can you confirm that reconnect-on-failure is set on?
Thanks
Sujit
I can confirm I have that setting on.
Hi Dave,
Ok, I think I found it, made the updates, just checked it in tonight, you can probably see it tomorrow. Look for this version on this file to make sure you got the fix.
Checking in src/net/sourceforge/sqlunit/handlers/SqlHandler.java;
/cvsroot/sqlunit/sqlunit/src/net/sourceforge/sqlunit/handlers/SqlHandler.java,v <-- SqlHandler.java
new revision: 1.14; previous revision: 1.13
I also opened up the LOG.fatal() call to print the stack trace instead of a single line error message, perhaps it can give some more clues if this fix does not work out. The stack trace is normally produced if you set the debug flag.
Specifically the problem I found was that it was trying to check the autocommit status on the connection object after it was closed, and if so, trying to rollback the transaction if transaction-support="off". The code is still there, its moved to the ConnectionRegistry.invalidate() call where there are more checks before the operations actually happen.
Let me know if this worked.
Thanks
Sujit
btw, you should just do a cvs update -dAP, theres been quite a few changes, but you will know you got the latest version if the SqlHandler is 1.14.
-sujit
Just updated from CVS today.
Finally got around to trying this:
<test name="Adding John Doe again" assert="fail-with-failure">
<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>
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 (441ms)
[sqlunit] Running test[2]: Adding department IT (10ms)
[sqlunit] Running test[3]: Adding employee John Doe to IT (40ms)
[sqlunit] Running test[4]: Adding John Doe again (40ms)
[sqlunit] Assertion "fail-with-failure" failed ("" != "Assertion "exception-matches" failed ([Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists != [Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] at exception.message)")
[sqlunit] *** expected:
[sqlunit] <result>
[sqlunit] <exception>
[sqlunit] <code>-20746</code>
[sqlunit] <message>[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERRO
R executed: add_employee: Employee already exists</message>
[sqlunit] </exception>
[sqlunit] </result>
[sqlunit] *** but got: <result>
[sqlunit] <exception>
[sqlunit] <code>-20746</code>
[sqlunit] <message>[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERRO
R executed: add_employee: Employee already exists</message>
[sqlunit] </exception>
[sqlunit] </result>
[sqlunit] Running test[5]: Adding Jane Doe to HR (30ms)
I am not sure really how to format the failure-message option. I tried this:
<test name="Adding John Doe again" assert="fail-with-failure" failure-message="[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists">
Got this:
[sqlunit] Assertion "fail-with-failure" failed ("[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists" !=
"Assertion "exception-matches" failed ([Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists != [Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee
already exists
[sqlunit] at exception.message)")
So I tried this:
<test name="Adding John Doe again" assert="fail-with-failure" failure-message="Assertion \"exception-matches\" failed ([Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists at exception.message)">
Got this:
Does not like the embedded quotes " around the exception-matches string.
Here is the debug output from the previous test that was closer.
[sqlunit] Running test[3]: Adding employee John Doe to IT (280ms)
[sqlunit] DEBUG [main] (SymbolTable.java:140) - >> getSymbols()
[sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(test)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (TestHandler.java:149) - >> process(elTest)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(off)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(off)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__JavaObjectSupport__},off)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,failure-message)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName([Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Adding John Doe again)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,expected-duration-millis)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,percentage-tolerance)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,assert)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(fail-with-failure)
[sqlunit] DEBUG [main] (HandlerFactory.java:71) - >> getSwappableTags(test)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(call)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (CallHandler.java:103) - >> process()
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element call,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element stmt)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:280) - >> replaceVariables({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(2)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(3)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(DATE)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(4)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(5)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(NUMERIC)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(null,{call add_employee(?,?,?,?,?)},params)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnection(null)
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(Information Technology,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(John Doe,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(1970-11-29,DATE)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(DATE)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.DATE)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for DATE
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.DateType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(DATE)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(123456789,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(40.00,NUMERIC)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(NUMERIC)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.BigDecimalType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(NUMERIC)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
[sqlunit] DEBUG [main] (ConnectionRegistry.java:144) - >> invalidate(null)
[sqlunit] DEBUG [main] (DatabaseResult.java:160) - >> resetAsException(-20746,[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] )
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(result)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ResultHandler.java:139) - >> process(elResult)
[sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(exception)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ExceptionHandler.java:70) - >> process(elException)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element code)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(-20746)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element message)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName([Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists)
[sqlunit] DEBUG [main] (DatabaseResult.java:160) - >> resetAsException(-20746,[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__JavaObjectSupport__},null)
[sqlunit] DEBUG [main] (SymbolTable.java:212) - >> update(target,source)
[sqlunit] DEBUG [main] (SymbolTable.java:344) - >> dump()
[sqlunit] DEBUG [main] (SymbolTable.java:140) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:346) -
[sqlunit] Symbol table dump
[sqlunit] DEBUG [main] (SymbolTable.java:347) - -----------------
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__0.resultset__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${empId_John} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__0.row__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__JavaObjectSupport__} => null
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${deptId_IT} => 2
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__ElapsedMillisStr__} => 280
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${deptId_HR} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__0.col__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:357) - -----------------
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:232) - >> toString()
[sqlunit] DEBUG [main] (DatabaseResult.java:193) - >> toElement()
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (XMLUtils.java:106) - >> toXMLString(Element result)
[sqlunit] DEBUG [main] (DatabaseResult.java:232) - >> toString()
[sqlunit] DEBUG [main] (DatabaseResult.java:193) - >> toElement()
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (XMLUtils.java:106) - >> toXMLString(Element result)
[sqlunit] DEBUG [main] (DatabaseResult.java:232) - >> toString()
[sqlunit] DEBUG [main] (DatabaseResult.java:193) - >> toElement()
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (XMLUtils.java:106) - >> toXMLString(Element result)
[sqlunit] DEBUG [main] (DatabaseResult.java:232) - >> toString()
[sqlunit] DEBUG [main] (DatabaseResult.java:193) - >> toElement()
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (XMLUtils.java:106) - >> toXMLString(Element result)
[sqlunit] DEBUG [main] (SQLUnitResult.java:47) - >> addFailureCount()
[sqlunit] DEBUG [main] (SQLUnitResult.java:108) - >> setLastException(e)
[sqlunit] DEBUG [main] (SymbolTable.java:106) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:79) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] Running test[4]: Adding John Doe again (280ms)
[sqlunit] DEBUG [main] (SQLUnitResult.java:99) - >> getLastException()
[sqlunit] Assertion "fail-with-failure" failed ("[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists" != "Assertion "exception-matches" failed ([Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists != [Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] at exception.message)")
[sqlunit] *** expected:
[sqlunit] <result>
[sqlunit] <exception>
[sqlunit] <code>-20746</code>
[sqlunit] <message>[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists</message>
[sqlunit] </exception>
[sqlunit] </result>
[sqlunit] *** but got: <result>
[sqlunit] <exception>
[sqlunit] <code>-20746</code>
[sqlunit] <message>[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists</message>
[sqlunit] </exception>
[sqlunit] </result>
[sqlunit] [Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] DEBUG [main] (SymbolTable.java:140) - >> getSymbols()
[sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(test)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (TestHandler.java:149) - >> process(elTest)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(off)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(off)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__JavaObjectSupport__},off)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,failure-message)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Adding Jane Doe to HR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,expected-duration-millis)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,percentage-tolerance)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,assert)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:71) - >> getSwappableTags(test)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(call)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (CallHandler.java:103) - >> process()
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element call,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element stmt)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:280) - >> replaceVariables({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Human Resources)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(2)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Jane Doe)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(3)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(DATE)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1980-12-13)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(4)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(234567890)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:91) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(5)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(NUMERIC)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(45.00)
[sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(null,{call add_employee(?,?,?,?,?)},params)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnection(null)
[sqlunit] DEBUG [main] (ConnectionFactory.java:61) - >> getInstance(props)
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(Human Resources,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Human Resources)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(Jane Doe,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Jane Doe)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(1980-12-13,DATE)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1980-12-13)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(DATE)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.DATE)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for DATE
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.DateType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(DATE)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(234567890,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(234567890)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(45.00,NUMERIC)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(45.00)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(NUMERIC)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.BigDecimalType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(NUMERIC)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
[sqlunit] DEBUG [main] (SymbolTable.java:294) - >> setCurrentResultSet(1)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__0.resultset__},1)
[sqlunit] DEBUG [main] (SymbolTable.java:304) - >> setCurrentRow(1)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__0.row__},1)
[sqlunit] DEBUG [main] (SymbolTable.java:314) - >> setCurrentCol(1)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__0.col__},1)
[sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
[sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
[sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
[sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
[sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (TypeUtils.java:64) - >> getXmlTypeFromSqlType(4)
[sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
[sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
[sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
[sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
[sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(result)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ResultHandler.java:139) - >> process(elResult)
[sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(resultset)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ResultSetHandler.java:90) - >> process(elResultSet)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,rowcount)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(row)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (RowHandler.java:70) - >> process(elRow)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element row,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(col)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ColHandler.java:66) - >> process(elCol)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,order-by)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__JavaObjectSupport__},null)
[sqlunit] DEBUG [main] (SymbolTable.java:212) - >> update(target,source)
[sqlunit] DEBUG [main] (SymbolTable.java:221) - looking at colValue: ${empId_Jane}
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${empId_Jane})
[sqlunit] DEBUG [main] (SymbolTable.java:106) - >> getValue(${empId_Jane})
[sqlunit] DEBUG [main] (SymbolTable.java:79) - >> getObject(${empId_Jane})
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${empId_Jane})
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${empId_Jane})
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${empId_Jane},2)
[sqlunit] DEBUG [main] (SymbolTable.java:344) - >> dump()
[sqlunit] DEBUG [main] (SymbolTable.java:140) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:346) -
[sqlunit] Symbol table dump
[sqlunit] DEBUG [main] (SymbolTable.java:347) - -----------------
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__0.resultset__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${empId_Jane} => 2
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${empId_John} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__0.row__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__JavaObjectSupport__} => null
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${deptId_IT} => 2
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__ElapsedMillisStr__} => 280
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${deptId_HR} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__0.col__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:357) - -----------------
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
[sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(INTEGER)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 4
[sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
[sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
[sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
[sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
[sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__ElapsedMillisStr__},261)
[sqlunit] DEBUG [main] (SymbolTable.java:106) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:79) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] Running test[5]: Adding Jane Doe to HR (261ms)
Oops, sorry to not have told you earlier, but the fail-with-failure is not applicable to the current situation. Basically you should just check for the exception with the default assert, which seems to be succeeding going by the stack trace.
Basically when you specify the exception and the assert="fail-with-failure", it should return a positive if the sproc did not in fact raise an exception :-). Alternatively, you could specify a real result (not an exception) that you would have got if there were not a primary key violation and then set the fail-with-failure.failure-message should be the error that SQLUnit will give you in that case, something along the lines of "Assert 'equals' failed: this != that".
BTW, I have been busy with adapting Victor's tags these last few days for SQLUnit. I have just completed a pretty large checkin, about 4 new tags, DTD changes, new tests, and new beans. You may want to pull down the CVS tree again just to verify that I havent broken your tests.
I think we should be ready to make a release after this problem is resolved. Yes, I know, I have been saying that for a while, but then I started working on Victor's tags and that took a while.
Let me know if the fix is good.
Thanks
-sujit
Okay, I am on vacation starting tomorrow, so I would like to finish this one off.
I have changed the test back to what I had originally:
<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>
This is still failing with (this morning's CVS):
[sqlunit] Assertion "exception-matches" failed ([Sybase][ODBC Driver][Adaptive
Server Anywhere]RAISERROR executed: add_employee: Employee already exists != [Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee:
Employee already exists
[sqlunit] at exception.message)
[sqlunit] *** expected:
[sqlunit] <result>
[sqlunit] <exception>
[sqlunit] <code>-20746</code>
[sqlunit] <message>[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists</message>
[sqlunit] </exception>
[sqlunit] </result>
[sqlunit] *** but got:
[sqlunit] <result>
[sqlunit] <exception>
[sqlunit] <code>-20746</code>
[sqlunit] <message>[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] </message>
[sqlunit] </exception>
[sqlunit] </result>
Looking at the above output, the only difference I see between the expected result and the real result is a carriage return at the end of the message. I have that carriage return in my test.
Let me know what you think I should change the test to (exactly please) and I will try it.
Thanks,
Dave
[sqlunit] Running test[3]: Adding employee John Doe to IT (301ms)
[sqlunit] DEBUG [main] (SymbolTable.java:140) - >> getSymbols()
[sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(test)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (TestHandler.java:155) - >> process(elTest)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(off)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(off)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__JavaObjectSupport__},off)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,failure-message)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Adding John Doe again)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,expected-duration-millis)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,percentage-tolerance)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,assert)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:71) - >> getSwappableTags(test)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(call)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (CallHandler.java:103) - >> process()
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element call,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element stmt)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:280) - >> replaceVariables({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:92) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:92) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(2)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:92) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(3)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(DATE)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:92) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(4)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:92) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(5)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(NUMERIC)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(null,{call add_employee(?,?,?,?,?)},params)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnection(null)
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(Information Technology,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Information Technology)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(John Doe,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(John Doe)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(1970-11-29,DATE)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1970-11-29)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(DATE)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.DATE)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for DATE
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.DateType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(DATE)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(123456789,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(123456789)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(40.00,NUMERIC)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(40.00)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(NUMERIC)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.BigDecimalType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(NUMERIC)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
[sqlunit] DEBUG [main] (ConnectionRegistry.java:144) - >> invalidate(null)
[sqlunit] DEBUG [main] (DatabaseResult.java:160) - >> resetAsException(-20746,[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] )
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(result)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ResultHandler.java:139) - >> process(elResult)
[sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(exception)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ExceptionHandler.java:70) - >> process(elException)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element code)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(-20746)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element message)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName([Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] )
[sqlunit] DEBUG [main] (DatabaseResult.java:160) - >> resetAsException(-20746,[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__JavaObjectSupport__},null)
[sqlunit] DEBUG [main] (SymbolTable.java:212) - >> update(target,source)
[sqlunit] DEBUG [main] (SymbolTable.java:344) - >> dump()
[sqlunit] DEBUG [main] (SymbolTable.java:140) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:346) -
[sqlunit] Symbol table dump
[sqlunit] DEBUG [main] (SymbolTable.java:347) - -----------------
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__0.resultset__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${empId_John} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__0.row__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__JavaObjectSupport__} => null
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${deptId_IT} => 2
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__ElapsedMillisStr__} => 301
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${deptId_HR} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__0.col__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:357) - -----------------
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:232) - >> toString()
[sqlunit] DEBUG [main] (DatabaseResult.java:193) - >> toElement()
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (XMLUtils.java:106) - >> toXMLString(Element result)
[sqlunit] DEBUG [main] (DatabaseResult.java:232) - >> toString()
[sqlunit] DEBUG [main] (DatabaseResult.java:193) - >> toElement()
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (XMLUtils.java:106) - >> toXMLString(Element result)
[sqlunit] DEBUG [main] (SQLUnitResult.java:47) - >> addFailureCount()
[sqlunit] DEBUG [main] (SQLUnitResult.java:108) - >> setLastException(e)
[sqlunit] DEBUG [main] (SymbolTable.java:106) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:79) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] Running test[4]: Adding John Doe again (301ms)
[sqlunit] DEBUG [main] (SQLUnitResult.java:99) - >> getLastException()
[sqlunit] Assertion "exception-matches" failed ([Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists != [Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] at exception.message)
[sqlunit] *** expected:
[sqlunit] <result>
[sqlunit] <exception>
[sqlunit] <code>-20746</code>
[sqlunit] <message>[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists</message>
[sqlunit] </exception>
[sqlunit] </result>
[sqlunit] *** but got:
[sqlunit] <result>
[sqlunit] <exception>
[sqlunit] <code>-20746</code>
[sqlunit] <message>[Sybase][ODBC Driver][Adaptive Server Anywhere]RAISERROR executed: add_employee: Employee already exists
[sqlunit] </message>
[sqlunit] </exception>
[sqlunit] </result>
[sqlunit] DEBUG [main] (SymbolTable.java:140) - >> getSymbols()
[sqlunit] DEBUG [main] (SQLUnitResult.java:63) - >> addRunCount()
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(test)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (TestHandler.java:155) - >> process(elTest)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(off)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,java-object-support)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(off)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__JavaObjectSupport__},off)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,failure-message)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Adding Jane Doe to HR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,expected-duration-millis)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,percentage-tolerance)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element test,assert)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:71) - >> getSwappableTags(test)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(call)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (CallHandler.java:103) - >> process()
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element call,connection-id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element stmt)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (SymbolTable.java:280) - >> replaceVariables({call add_employee(?,?,?,?,?)})
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:92) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Human Resources)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:92) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(2)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Jane Doe)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:92) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(3)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(DATE)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1980-12-13)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:92) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(4)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(VARCHAR)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(234567890)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ParamHandler.java:92) - >> process(elParam)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(5)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(NUMERIC)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,is-null)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(false)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element param,inout)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(in)
[sqlunit] DEBUG [main] (XMLUtils.java:84) - >> getText(Element param)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(45.00)
[sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(null,{call add_employee(?,?,?,?,?)},params)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:63) - >> getConnection(null)
[sqlunit] DEBUG [main] (ConnectionFactory.java:61) - >> getInstance(props)
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(Human Resources,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Human Resources)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(Jane Doe,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(Jane Doe)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(1980-12-13,DATE)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1980-12-13)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(DATE)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.DATE)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for DATE
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.DateType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(DATE)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: DATE
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.DATE
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by DATE
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(234567890,VARCHAR)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(234567890)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(VARCHAR)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for VARCHAR
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.StringType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(VARCHAR)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.VARCHAR
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by VARCHAR
[sqlunit] DEBUG [main] (TypeUtils.java:94) - >> convertToObject(45.00,NUMERIC)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(45.00)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(NUMERIC)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for NUMERIC
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.BigDecimalType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(NUMERIC)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.NUMERIC
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by NUMERIC
[sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
[sqlunit] DEBUG [main] (SymbolTable.java:294) - >> setCurrentResultSet(1)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__0.resultset__},1)
[sqlunit] DEBUG [main] (SymbolTable.java:304) - >> setCurrentRow(1)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__0.row__},1)
[sqlunit] DEBUG [main] (SymbolTable.java:314) - >> setCurrentCol(1)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__0.col__},1)
[sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
[sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
[sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
[sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
[sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (TypeUtils.java:64) - >> getXmlTypeFromSqlType(4)
[sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
[sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
[sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
[sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
[sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(result)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ResultHandler.java:139) - >> process(elResult)
[sqlunit] DEBUG [main] (DatabaseResult.java:49) - [DatabaseResult]
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(resultset)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ResultSetHandler.java:90) - >> process(elResultSet)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,rowcount)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(row)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (RowHandler.java:70) - >> process(elRow)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element row,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1)
[sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(col)
[sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
[sqlunit] DEBUG [main] (ColHandler.java:66) - >> process(elCol)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,id)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(1)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,name)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element col,type)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(adaptive_server_anywhere.INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:77) - found a typeClass: null
[sqlunit] DEBUG [main] (TypeFactory.java:81) - Falling back on basic type lookup for INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (TypeFactory.java:90) - Instantiating a net.sourceforge.sqlunit.types.IntegerType
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (XMLUtils.java:60) - >> getAttributeValue(Element resultset,order-by)
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(null)
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__JavaObjectSupport__},null)
[sqlunit] DEBUG [main] (SymbolTable.java:212) - >> update(target,source)
[sqlunit] DEBUG [main] (SymbolTable.java:221) - looking at colValue: ${empId_Jane}
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${empId_Jane})
[sqlunit] DEBUG [main] (SymbolTable.java:106) - >> getValue(${empId_Jane})
[sqlunit] DEBUG [main] (SymbolTable.java:79) - >> getObject(${empId_Jane})
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${empId_Jane})
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${empId_Jane})
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${empId_Jane},2)
[sqlunit] DEBUG [main] (SymbolTable.java:344) - >> dump()
[sqlunit] DEBUG [main] (SymbolTable.java:140) - >> getSymbols()
[sqlunit] DEBUG [main] (SymbolTable.java:346) -
[sqlunit] Symbol table dump
[sqlunit] DEBUG [main] (SymbolTable.java:347) - -----------------
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__0.resultset__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${empId_Jane} => 2
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${empId_John} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__0.row__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__JavaObjectSupport__} => null
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${deptId_IT} => 2
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__ElapsedMillisStr__} => 301
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${deptId_HR} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:355) - ${__0.col__} => 1
[sqlunit] DEBUG [main] (SymbolTable.java:357) - -----------------
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:141) - >> isException()
[sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
[sqlunit] DEBUG [main] (DatabaseResult.java:175) - >> getUpdateCount()
[sqlunit] DEBUG [main] (TypeUtils.java:77) - >> getSqlTypeFromXmlType(INTEGER)
[sqlunit] DEBUG [main] (TypeMapper.java:134) - finding id by name: INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 4
[sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
[sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
[sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
[sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
[sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:69) - Looking up value by adaptive_server_anywhere.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (SymbolTable.java:131) - >> setValue(${__ElapsedMillisStr__},281)
[sqlunit] DEBUG [main] (SymbolTable.java:106) - >> getValue(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:79) - >> getObject(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] DEBUG [main] (SymbolTable.java:267) - >> isVariableName(${__ElapsedMillisStr__})
[sqlunit] Running test[5]: Adding Jane Doe to HR (281ms)
Here is the debug output:
Looks like we have to "normalize" the message returned from the database before comparing. JDOM will ignore the carriage return when pulling the text from the element unless you declare it a CDATA. I think we may need to change the code to handle this situation. The code change is simple, but not sure if you will be able to get it off CVS, so I will also publish a patch to the appropriate file which you can then apply on your local copy and rebuild. Give me few hours, I will get back to you on this thread today.
-sujit
I am getting CVS changes now since I am logging in as myself. So just sent out a notice when I can grab it. Let me know the file that changed so I can verify it was downloaded.
Thanks,
Dave
Great, here are the changes.
---
Checking in src/net/sourceforge/sqlunit/beans/DatabaseResult.java;
/cvsroot/sqlunit/sqlunit/src/net/sourceforge/sqlunit/beans/DatabaseResult.java,v <-- DatabaseResult.java
new revision: 1.7; previous revision: 1.6
done
Checking in src/net/sourceforge/sqlunit/utils/XMLUtils.java;
/cvsroot/sqlunit/sqlunit/src/net/sourceforge/sqlunit/utils/XMLUtils.java,v <-- XMLUtils.java
new revision: 1.4; previous revision: 1.3
done
-sujit
Wahoo!
Checking in test.xml;
/cvsroot/sqlunit/sqlunit/test/asa/test.xml,v <-- test.xml
new revision: 1.3; previous revision: 1.2
I have verified this works for the exception case, and changed the other tests to check for an INTEGER result, regardless of the value of the integer.
Thanks,
Dave
Hi Dave,
Great news!
Thanks for finding the bug and testing it so thoroughly. You will see the next version of SQLUnit ready to download (which would be more or less what you have right now) when you get back. Enjoy your vacation :-).
Thanks
-sujit