[
https://issues.apache.org/jira/browse/TRAFODION-296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-296.
----------------------------------
Resolution: Fixed
Assignee: (was: justin...@hp.com)
Fix Version/s: 1.0 (pre-incubation)
> 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
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> 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)
