[TRAFODION-1240] LP Bug: 1455679 - mtserver - spjs with output params fail with error 29019

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Component/s: connectivity-dcs
• External issue URL: https://bugs.launchpad.net/bugs/1455679
• Assignee: Anuradha Hegde
• Reporter: Aruna Sadashiva
• Created: 22/Jul/15 18:20
• Updated: 06/Mar/18 16:16

Description

With multithreaded dcs, SPJs with output params are failing.

SQL>create library spjcall file '/opt/home/trafodion/SPJ/call.jar';

SQL>Create procedure N0210 (in in1 int, out out1 int)
external name 'Procs.N0210'
library spjcall
language java
parameter style java;

SQL>Call N0210(64548478,?);

• • • ERROR[29019] Parameter 1 for 1 set of parameters is not set

The SPJ jar file, call.jar, can be found on amber7 under /opt/home/trafodion/SPJ. It has a very simple SPJ procedure:

public static void N0210(int paramInt, int[] paramArrayOfInt)

{ paramArrayOfInt[0] = paramInt; }