MQSeries.net :: View topic - Issue while calling java function from ESQL using BLOB data

vanshul · Posted: Wed Jun 11, 2014 1:08 am Post subject:

Hi,

My java function is this

package com.bnsf.mech.da.cmrs.appservice;
public class ComponentResolverAPI {
public static byte[] improveTrainMatch(byte[] inputMsgBytes) {
return inputMsgBytes;
}
}

I am calling it using esql like this

DECLARE inCCSID, inEncoding INT;
SET inCCSID = CAST(InputRoot.Properties.CodedCharSetId AS INT);
SET inEncoding = CAST(InputRoot.Properties.Encoding AS INT);
DECLARE messageOutBlob BLOB;
DECLARE messageBlob BLOB ;
SET messageBlob = ASBITSTREAM(InputRoot.JSON.Data);
SET messageOutBlob = improveTrainMatch(messageBlob);

CREATE LASTCHILD OF OutputRoot DOMAIN('JSON')
PARSE(messageOutBlob ENCODING inEncoding CCSID inCCSID FORMAT 'JSON' OPTIONS RootBitStream) ;

CREATE FUNCTION improveTrainMatch( IN messageBlobIn BLOB)
RETURNS BLOB
LANGUAGE JAVA
EXTERNAL NAME "com.bnsf.mech.da.cmrs.appservice.ComponentResolverAPI.improveTrainMatch";

Issue is I can see the BLOB getting created from JSON when I use ASBITSTREAM but when I enter the java function, value is blank.

Any leads would be appreciated.