MQSeries.net :: View topic - Error while calling java method using esql

IBM_Newbie · Posted: Thu Dec 08, 2011 11:31 pm Post subject:

Hi,

I am getting error that java method not found while calling a java method using esql

My java class is

/**
*
*/

package com.someorg.cache;
import java.util.*;
/**
* @author Administrator
*
*/
public class Cache {

/**
* @param args
*/
static Map hm;

static {
hm = new HashMap();
createHash(hm);
}

public static void createHash(Map hm)
{

// Put elements to the map
hm.put("Vanshul", "Chawla");
hm.put("Anshul","Sah");
hm.put("Anuj", "Bandlish");
}
public static String retrieveHash(String key)
{
String value=(String) hm.get(key);
return value;
}

public static void resetHash()
{
//String value=(String) hm.get(key);
hm.put("Vanshul", "Chawla1");
hm.put("Anshul","Sah1");
hm.put("Anuj", "Bandlish1");
}

/*
public static void initialize() {
// TODO Auto-generated method stub
// Create a hash map

// String value=retrieveHash("Vanshul");
// System.out.println("value is: " +value);
}

*/

}

ESQL in Compute is

CREATE COMPUTE MODULE CacheTest1_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
CALL CopyMessageHeaders();
-- CALL CopyEntireMessage();
DECLARE value CHARACTER '';
CALL retrieveHash('Vanshul') INTO value;
set OutputRoot.xmlnsc.Message.value=value;
RETURN TRUE;
END;

CREATE PROCEDURE retrieveHash( OUT value CHARACTER)
RETURNS CHARACTER
LANGUAGE JAVA
EXTERNAL NAME "com.someOrg.cache.Cache.retrieveHash";

CREATE PROCEDURE CopyMessageHeaders() BEGIN
DECLARE I INTEGER 1;
DECLARE J INTEGER;
SET J = CARDINALITY(InputRoot.*[]);
WHILE I < J DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I + 1;
END WHILE;
END;

CREATE PROCEDURE CopyEntireMessage() BEGIN
SET OutputRoot = InputRoot;
END;
END MODULE;

Please let me know where is the issue in esql?Am i missing something?