Richard - 2006-10-27

Hi,

I'm just trying to set up SQLUnit for the first time. I've run into a problem and I'm hoping somebody can tell me what I've done wrong.

My test calls a really basic Oracle procedure that looks like this:

procedure test_proc (p1 in integer) as
begin
null;
end;
/

Here's the test:

<test name="Simple Procedure Test" failure-message="Simple Procedure Test Failed">
  <call>
    <stmt>{call test_proc(?)}</stmt>
    <param id="1" name="p1" type="INTEGER" inout="in">2</param>
  </call>
  <result>
  </result>
</test>

When I run the test without debug, I get this...

run-ora-proc-test:
  [sqlunit] *** Running SQLUnit file: c:\sqlunit-5.0\test\oracle\simple_ora_proc_test.xml
  [sqlunit] Getting connection(DEFAULT)
  [sqlunit] Setting up test...

...then nothing happens. The debug version looks like this...

run-ora-proc-test:
  [sqlunit] DEBUG [main] (SymbolTable.java:102) - >> setObject(${__Reporter__},net.sourceforge.sqlunit.reporters.TextReporter
  [sqlunit] DEBUG [main] (SymbolTable.java:139) - >> setValue(${ant.java.runtime.name},Java(TM) 2 Runtime Environment, Standard Edition)
  [sqlunit] DEBUG [main] (SymbolTable.java:139) - >> setValue(${ant.basedir},C:\sqlunit-5.0)
  [sqlunit] DEBUG [main] (SymbolTable.java:139) - >> setValue(${ant.java.vm.specification.name},Java Virtual Machine Specification)
  [sqlunit] DEBUG [main] (SymbolTable.java:139) - >> setValue(${ant.path.separator},;)

...

[sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(2)
[sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(null,{call test_proc(?)},params)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:64) - >> getConnection(null)
[sqlunit] DEBUG [main] (ConnectionRegistry.java:197) - >> isTransactionSupportImplicit(null)
[sqlunit] DEBUG [main] (TypeUtils.java:95) - >> convertToObject(2,INTEGER)
[sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(2)
[sqlunit] DEBUG [main] (TypeFactory.java:53) - >> getInstance(INTEGER)
[sqlunit] DEBUG [main] (TypeFactory.java:75) - Looking up oracle.INTEGER
[sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: oracle.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(oracle.INTEGER)
[sqlunit] DEBUG [main] (TypeMap.java:63) - Looking up value by oracle.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 oracle.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 oracle.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (TypeUtils.java:78) - >> 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 oracle.INTEGER
[sqlunit] DEBUG [main] (TypeMap.java:73) - Falling back on basic lookup by INTEGER
[sqlunit] DEBUG [main] (DatabaseResult.java:50) - [DatabaseResult]

... again the application seems to pause.

Can anybody point me in the right direction here?

Thanks.