Monday, July 26, 2010

Calling Java Routine using ESQL in Message Broker

I am facing a problem when I call a java routing from ESQL only when when I pass REFERENCE as a Parameter.

please find the detail below.

Broker Toolkit 6.0.2:

If I make a reference in ESQL to JAVA method with string as input parameter I don't see any error.


Example 1:

at ESQL:

CREATE PROCEDURE hashValue2 (
IN Value CHAR
)
RETURNS CHAR
LANGUAGE JAVA
EXTERNAL NAME "com.xyz.CommonJavaFunctions_JavaCompute.hashValue2";

at java :

public static String hashValue2(String value) {

return "";
}


EXAMPLE2 : If I use REFERENCE as an input parameter I am getting error Unable to locate a class definition named "com.xyz.CommonJavaFunctions_JavaCompute" in the project or a referenced project.

at ESQL

CREATE PROCEDURE hashValue2 (
IN Value REFERENCE
)
RETURNS CHAR
LANGUAGE JAVA
EXTERNAL NAME "com.xyz.CommonJavaFunctions_JavaCompute.hashValue2";

at java :

public static String hashValue2(MbElement value) {

return "";
}


have any one faced similer problem? please let me know if you got any suggestions, i am sure it is not related to PROJECT references or classpath, it doesn't give any error if I change the parameter type, I greatly appreciate your help.

No comments:

Post a Comment