[jira] [Created] (TRAFODION-296) LP Bug: 1322451 - SPJ calls does not work in Trafci

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-296:
------------------------------------

             Summary: LP Bug: 1322451 - SPJ calls does not work  in Trafci
                 Key: TRAFODION-296
                 URL: https://issues.apache.org/jira/browse/TRAFODION-296
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Chong Hsu
            Assignee: justin.du@hp.com
            Priority: Critical


Testing Trafodion - trafodion-ci-project-datalake_64_1-20140516-v40596_release

Calling a simple SPJ, that returns the input value, worked ok from sqlci.  But failed from Trafci.  A testing SPJ is attached with Java procedures:

    public static void NA001(int paramInt, Integer[] paramArrayOfInteger)
   {
       paramArrayOfInteger[0] = new Integer(paramInt);
   }

   public static void ST001(String paramString, String[] paramArrayOfString)
   {
       paramArrayOfString[0] = paramString;
   }


- Running SPJ from sqlci:

set schema spj_test;

create library testlib file '/opt/home/SQFQA/SPJRoot/TestSPJ.jar';

Create procedure NA001 (in in1 int, out out1 integer)
	external name 'TestSPJ.NA001(int,java.lang.Integer[])'	  
	library testlib	    
	parameter style java
	language java	;

call NA001(100,?);

OUT1
-----------

        100

--- SQL operation complete.

Create procedure ST001 (in in1 varchar(50), out out1 varchar(50))
            external name 'TestSPJ.ST001'
            library testlib
            language java
            parameter style java;

--- SQL operation complete.

call st001('aaa', ?);

OUT1
--------------------------------------------------

aaa

--- SQL operation complete.



- Running SPJ from trafci:

set schema spj_test;

SQL>call na001(100,?);

OUT1
-----------
         60

--- SQL operation complete.

SQL>call na001(32656148, ?);

OUT1
-----------
         60

--- SQL operation complete.


SQL>call st001('aaaa',?);

*** ERROR[29451] Internal error processing command. Details=null

SQL>call st001('aaa bbb ccc ddd', ?);

*** ERROR[29451] Internal error processing command. Details=null



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)