Menu ▾ ▴

How to handle Oracle 10 function return code?

Open Discussion
Flavio Matiello
2006-09-06
2013-04-25

  • Flavio Matiello

    Flavio Matiello - 2006-09-06

    Hello.

    I'm new to SQLUnit and I have a simple question that I couldn't find in the FAQ or Forum, regarding the function return codes.

    First of all, I'm using Oracle 10g, SQLUnit 5.0, JDK jdk1.5.0_07 and I'm using the testcase bellow:

    <test name="Testing API 2" failure-message="Failed Test of API 2">
      <call connection-id="DATABASE">
        <stmt>{? = call TEMPLATE_PACKAGE.FUNCTION_NAME_2}</stmt>
        <param id="1" name="inVar1" type="INTEGER" inout="out" ></param>
      </call>
      <result>
        <outparam id="1" type="INTEGER">1</outparam>
      </result>
    </test>

    My package is very simple as follows:

    CREATE OR REPLACE PACKAGE TEMPLATE_PACKAGE AS
        FUNCTION FUNCTION_NAME_2 RETURN NUMBER;
    END TEMPLATE_PACKAGE;
    /

    CREATE OR REPLACE PACKAGE BODY TEMPLATE_PACKAGE AS
        FUNCTION FUNCTION_NAME_2 RETURN NUMBER
        AS BEGIN
            RETURN 10;
        END FUNCTION_NAME_2;
    END TEMPLATE_PACKAGE;
    /

    The problem is that when it runs, it seems to enter in some sort of loop and doesn't end it anymore. Locks like a dead-lock of some sort.

    Here's the log for some debug information:

    [sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(INB-SDP-Dev-Evl,{? = call TEMPLATE_PACKAGE.FUNCTION_NAME_2},params)
    [sqlunit] DEBUG [main] (ConnectionRegistry.java:64) - >> getConnection(DATABASE)
    [sqlunit] DEBUG [main] (ConnectionRegistry.java:197) - >> isTransactionSupportImplicit(DATABASE)
    [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName()
    [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] (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]

    Am I testing it wrong or is ther something with the sqlunit version I'm using.

    Regards,

    Flavio Matiello.

     

    • Sujit Pal

      Sujit Pal - 2006-09-06

      Hi Flavio,

      The DEBUG is very verbose. The first few hundred lines are all from TypeMapper as it sets up the different types from the types.properties file. The log that you have shown so far seem to be good. I am not sure what is wrong, but in your test, can you set this line:
      <outparam id="1" type="INTEGER">1</outparam>
      to this instead?
      <outparam id="1" type="INTEGER">${rc}</outparam>

      and see if this works?

      -sujit

       

    • Flavio Matiello

      Flavio Matiello - 2006-09-06

      Hello Sujit.

      It tried what you told me but it still does not work.

      Here's the Testcase again.

      <test name="Testing API 2" failure-message="Failed Test of API 2">
          <call connection-id="DATABASE">
              <stmt>{?=call TEMPLATE_PACKAGE.FUNCTION_NAME_2}</stmt>
              <param id="1" name="inVar3" type="INTEGER" inout="out">10</param>
          </call>
          <result>
              <outparam id="1" type="INTEGER">${rc}</outparam>
          </result>
      </test>

      I'm also including all the Debug messages from the sqlunit debug file, as follows:

      *** Running SQLUnit file: D:\Temp\Teste\project-template\tst\01 - TestAPIs.xml
      Getting connection(DATABASE)
      Setting up test...
      Running test[1]: Testing API 2xec
      Could not load a dependent class (com/jcraft/jsch/UserInfo) for type scp
      Could not load a dependent class (jdepend/xmlui/JDepend) for type jdepend
      fileset: Setup scanner in dir D:\Temp\Teste\project-template\tst with patternSet{ includes: [**/*.xml] excludes: [] }
      .....
      .. environment variables
      .....

        [sqlunit] DEBUG [main] (SQLUnit.java:242) - >> testWrapper()
        [sqlunit] DEBUG [main] (SQLUnit.java:259) - >> processDoc()
        [sqlunit] DEBUG [main] (TypeMapper.java:67) - instantiating TypeMapper
        [sqlunit] DEBUG [main] (TypeMapper.java:169) - loading types from: net.sourceforge.sqlunit.types
        [sqlunit] DEBUG [main] (TypeMapper.java:169) - loading types from: usertypes
        [sqlunit] DEBUG [main] (TypeMapper.java:203) - loading non-mapped types
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -7
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -7
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-7)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BIT=-7
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BIT for -7
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BIT
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BIT)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BIT
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -6
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -6
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-6)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding microsoft_sql_server.TINYINT=-6
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding TINYINT=-6
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + microsoft_sql_server.TINYINT for -6
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key TINYINT for -6
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: TINYINT
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(TINYINT)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by TINYINT
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 5
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 5
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(5)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding adaptive_server_anywhere.SMALLINT=5
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding adaptive_server_enterprise.SMALLINT=5
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding SMALLINT=5
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding sybase_sql_server.SMALLINT=5
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding sql_server.SMALLINT=5
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding microsoft_sql_server.SMALLINT=5
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + adaptive_server_anywhere.SMALLINT for 5
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + adaptive_server_enterprise.SMALLINT for 5
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key SMALLINT for 5
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + sybase_sql_server.SMALLINT for 5
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + sql_server.SMALLINT for 5
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + microsoft_sql_server.SMALLINT for 5
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: SMALLINT
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(SMALLINT)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by SMALLINT
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 4
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 4
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(4)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding INTEGER=4
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key INTEGER for 4
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: INTEGER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(INTEGER)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by INTEGER
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -5
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -5
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-5)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BIGINT=-5
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BIGINT for -5
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BIGINT
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BIGINT)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BIGINT
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 6
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 6
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(6)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding FLOAT=6
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key FLOAT for 6
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: FLOAT
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(FLOAT)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by FLOAT
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 7
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 7
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(7)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding REAL=7
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key REAL for 7
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: REAL
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(REAL)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by REAL
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 8
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 8
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(8)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding DOUBLE=8
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key DOUBLE for 8
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DOUBLE
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DOUBLE)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by DOUBLE
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding NUMERIC=2
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key NUMERIC for 2
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: NUMERIC
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NUMERIC)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by NUMERIC
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 3
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 3
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(3)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding DECIMAL=3
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key DECIMAL for 3
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DECIMAL
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DECIMAL)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by DECIMAL
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 1
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 1
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(1)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding CHAR=1
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key CHAR for 1
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: CHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(CHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by CHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 12
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 12
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(12)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding VARCHAR=12
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key VARCHAR for 12
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by VARCHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -1
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -1
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-1)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding LONGVARCHAR=-1
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding mysql.LONGVARCHAR=-1
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key LONGVARCHAR for -1
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + mysql.LONGVARCHAR for -1
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: LONGVARCHAR
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(LONGVARCHAR)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by LONGVARCHAR
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 91
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 91
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(91)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding oracle.DATE=91
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding DATE=91
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + oracle.DATE for 91
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key DATE for 91
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: DATE
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(DATE)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by DATE
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 92
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 92
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(92)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding TIME=92
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key TIME for 92
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: TIME
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(TIME)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by TIME
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 93
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 93
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(93)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding TIMESTAMP=93
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key TIMESTAMP for 93
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: TIMESTAMP
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(TIMESTAMP)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by TIMESTAMP
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -2
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -2
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-2)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BINARY=-2
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BINARY for -2
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BINARY
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BINARY)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BINARY
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -3
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -3
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-3)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding VARBINARY=-3
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key VARBINARY for -3
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: VARBINARY
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(VARBINARY)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by VARBINARY
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: -4
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: -4
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(-4)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding LONGVARBINARY=-4
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key LONGVARBINARY for -4
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: LONGVARBINARY
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(LONGVARBINARY)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by LONGVARBINARY
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 0
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 0
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(0)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding NULL=0
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key NULL for 0
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: NULL
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(NULL)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by NULL
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 1111
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 1111
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(1111)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding OTHER=1111
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key OTHER for 1111
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: OTHER
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(OTHER)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by OTHER
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2000
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2000
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2000)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding JAVA_OBJECT=2000
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key JAVA_OBJECT for 2000
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: JAVA_OBJECT
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(JAVA_OBJECT)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by JAVA_OBJECT
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2001
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2001
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2001)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: null
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(null)
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2002
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2002
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2002)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding oracle.STRUCT=2002
        [sqlunit] DEBUG [main] (TypeMap.java:129) - Found other server specific key + oracle.STRUCT for 2002
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: null
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(null)
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2003
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2003
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2003)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding ARRAY=2003
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key ARRAY for 2003
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: ARRAY
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(ARRAY)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by ARRAY
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2004
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2004
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2004)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BLOB=2004
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BLOB for 2004
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BLOB
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BLOB)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BLOB
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2005
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2005
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2005)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding CLOB=2005
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key CLOB for 2005
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: CLOB
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(CLOB)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by CLOB
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 2006
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 2006
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(2006)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: null
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(null)
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 70
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 70
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(70)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: null
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(null)
        [sqlunit] DEBUG [main] (TypeMapper.java:107) - finding class by id: 16
        [sqlunit] DEBUG [main] (TypeMapper.java:119) - finding name by id: 16
        [sqlunit] DEBUG [main] (TypeMap.java:98) - >> rget(16)
        [sqlunit] DEBUG [main] (TypeMap.java:102) - Unrolling all values into list
        [sqlunit] DEBUG [main] (TypeMap.java:109) - Adding BOOLEAN=16
        [sqlunit] DEBUG [main] (TypeMap.java:126) - Found basic key BOOLEAN for 16
        [sqlunit] DEBUG [main] (TypeMapper.java:96) - finding class by name: BOOLEAN
        [sqlunit] DEBUG [main] (TypeMap.java:58) - >> get(BOOLEAN)
        [sqlunit] DEBUG [main] (TypeMap.java:78) - No servername found, lookup up value by BOOLEAN
        [sqlunit] DEBUG [main] (SQLUnitResult.java:135) - >> setTestFile(D:\Temp\Teste\project-template\tst\01 - TestAPIs.xml)
        [sqlunit] DEBUG [main] (SQLUnitEntityResolver.java:49) - Resolving entity: null/file:docs/sqlunit.dtd
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:64) - >> getConnection(null)
        [sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(connection)
        [sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
        [sqlunit] DEBUG [main] (ConnectionHandler.java:186) - >> process()
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element connection,connection-id)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(DATABASE)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element connection,extern)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element connection,transaction-support)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(on)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element connection,reconnect-on-failure)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(off)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element connection,server-name)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:87) - >> getText(Element driver)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(oracle.jdbc.driver.OracleDriver)
        [sqlunit] DEBUG [main] (XMLUtils.java:87) - >> getText(Element url)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(jdbc:oracle:thin:@10.51.160.191:1521:INDEV01)
        [sqlunit] DEBUG [main] (XMLUtils.java:87) - >> getText(Element user)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(S3GSDP)
        [sqlunit] DEBUG [main] (XMLUtils.java:87) - >> getText(Element password)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(S3GSDP)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:137) - >> setConnectionById(DATABASE)
        [sqlunit] DEBUG [main] (ConnectionFactory.java:61) - >> getInstance(props)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:64) - >> getConnection(DATABASE)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:197) - >> isTransactionSupportImplicit(DATABASE)
        [sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(setup)
        [sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
        [sqlunit] DEBUG [main] (SetupHandler.java:98) - >> process(elSetup)
        [sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(set)
        [sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
        [sqlunit] DEBUG [main] (SetHandler.java:145) - >> process(elSet)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(${inVar1})
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element set,value)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(String1)
        [sqlunit] DEBUG [main] (SymbolTable.java:139) - >> setValue(${inVar1},String1)
        [sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(set)
        [sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
        [sqlunit] DEBUG [main] (SetHandler.java:145) - >> process(elSet)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(${inVar2})
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element set,value)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(String2)
        [sqlunit] DEBUG [main] (SymbolTable.java:139) - >> setValue(${inVar2},String2)
        [sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(set)
        [sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
        [sqlunit] DEBUG [main] (SetHandler.java:145) - >> process(elSet)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(${inVar3})
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element set,value)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(10)
        [sqlunit] DEBUG [main] (SymbolTable.java:139) - >> setValue(${inVar3},10)
        [sqlunit] DEBUG [main] (HandlerFactory.java:71) - >> getSwappableTags(sqlunit)
        [sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
        [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:168) - >> process(elTest)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element test,java-object-support)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(off)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element test,java-object-support)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(off)
        [sqlunit] DEBUG [main] (SymbolTable.java:139) - >> setValue(${__JavaObjectSupport__},off)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element test,failure-message)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(Failed Test of API 2)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element test,name)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(Testing API 2)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element test,expected-duration-millis)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element test,percentage-tolerance)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element test,assert)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> 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:111) - >> process()
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element call,connection-id)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(DATABASE)
        [sqlunit] DEBUG [main] (XMLUtils.java:87) - >> getText(Element stmt)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName({?=call TEMPLATE_PACKAGE.FUNCTION_NAME_2})
        [sqlunit] DEBUG [main] (SymbolTable.java:301) - >> replaceVariables({?=call TEMPLATE_PACKAGE.FUNCTION_NAME_2})
        [sqlunit] DEBUG [main] (HandlerFactory.java:58) - >> getInstance(param)
        [sqlunit] DEBUG [main] (HandlerFactory.java:89) - >> getResourceBundle()
        [sqlunit] DEBUG [main] (ParamHandler.java:102) - >> process(elParam)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element param,id)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(1)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element param,name)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(inVar3)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element param,type)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(INTEGER)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element param,scale)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element param,typename)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(null)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element param,is-null)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(false)
        [sqlunit] DEBUG [main] (XMLUtils.java:63) - >> getAttributeValue(Element param,inout)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(out)
        [sqlunit] DEBUG [main] (XMLUtils.java:87) - >> getText(Element param)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(10)
        [sqlunit] DEBUG [main] (SqlHandler.java:137) - executeSQL(DATABASE,{?=call TEMPLATE_PACKAGE.FUNCTION_NAME_2},params)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:64) - >> getConnection(DATABASE)
        [sqlunit] DEBUG [main] (ConnectionRegistry.java:197) - >> isTransactionSupportImplicit(DATABASE)
        [sqlunit] DEBUG [main] (SymbolTable.java:288) - >> isVariableName(10)
        [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] (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]

      Any other ideas? Can you see something wrong in the debug file?

      Regards,

      Flavio Matiello

       

    • Flavio Matiello

      Flavio Matiello - 2006-09-15

      So, no ideas regarding this issue? No one is facing the same problem?

       

    • Sujit Pal

      Sujit Pal - 2006-09-17

      Hi Flavio,

      Yes, sorry, this looks quite weird. The stored procedure looks simple enough. I am assuming you are isolating it out so you are sure that there is no interactions. Also, did you check to see if the stored procedure ran inside the query client (sqlplus?).

      Are you doing something other than the SQLUnit test in your build.xml target. I see these in your output and I these dont look familiar, and it does not seem to correspond to anything in the test case you posted.

      If these are not something related to the test case you are erroring on, perhaps there is a classpath problem with some overlapping JAR files?

      ==
      Could not load a dependent class (com/jcraft/jsch/UserInfo) for type scp
      Could not load a dependent class (jdepend/xmlui/JDepend) for type jdepend
      fileset: Setup scanner in dir D:\Temp\Teste\project-template\tst with patternSet{ includes: [**/*.xml] excludes: [] }

      -sujit

       

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.