MQSeries.net :: View topic - Call a java function from esql code in WMB v8.0

rock33 · Posted: Mon Oct 07, 2013 5:57 am Post subject:

Hi All,

I am trying to call user defined java function from esql.

I have created an Message broker application and added the java project (Myutil)as an project reference.

Once the bar file has generated from message broker tool kit Myutil.jar have successfully added as part of bar file.

Java project name : Myutil

Esql Code :

CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
CALL CopyMessageHeaders();
-- CALL CopyEntireMessage();

DECLARE c1 CHARACTER 'Good';
DECLARE c2 CHARACTER 'Morning';
DECLARE c3 CHARACTER;
SET c3 = myProc( c1, c2);
SET OutputRoot.XMLNSC.Result.value=c3;
RETURN TRUE;
END;

CREATE FUNCTION myproc( IN P1 CHARACTER, OUT P2 CHARACTER)
RETURNS CHARACTER
LANGUAGE JAVA
EXTERNAL NAME "com.own.pack.MyClass.addValues";

Java method :

package com.own.pack;

public class MyClass {

public static String addValues( String c1, String c2)
{
return (c1+c2);
}
}

I am getting the below exception :

Text:CHARACTER:The Java method could not be found

Even if I have placed the Myutil.jar file in Message broker runtime directory C:\Program Files\ibm\MQSI\8.0.0.2\classes\ but getting the same exception.

Any help would be really appreciated.