MQSeries.net :: View topic - Calling Java Class via ESQL

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Calling Java Class via ESQL

Calling Java Class via ESQL

« View previous topic :: View next topic »

Author

Message

HIMAGAR

Posted: Fri Apr 15, 2016 6:44 am Post subject: Calling Java Class via ESQL

Novice

Joined: 05 Nov 2015
Posts: 18

Hi,

I need to call Java Class from my ESQL.
I have made a Java Project in the Toolkit and have given project reference to my Broker Project from where I need to call my Java Class.

like This :

CREATE PROCEDURE getUserDefinedConfigServProp( IN P1 CHARACTER)
LANGUAGE JAVA
EXTERNAL NAME "com.sampleproxy.test.ConfigService_Java.getUserDefinedConfigServProp";

CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
DECLARE I INTEGER 1;
DECLARE J INTEGER;
--DECLARE result CHARACTER ;
CALL getUserDefinedConfigServProp('Configure');

but I am getting this error

Number:INTEGER:2943
Text:CHARACTER:Java class not found

Vitor

Posted: Fri Apr 15, 2016 6:54 am Post subject: Re: Calling Java Class via ESQL

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

HIMAGAR wrote:

I am getting this error

Number:INTEGER:2943
Text:CHARACTER:Java class not found

What steps have you taken to ensure the class (which you defined in the ESQL code) is actually available to the runtime?

Or put another way, if you were calling this class from Java in a WAS server or similar, could you simply give the class name in the Java source code or would you have to put the jar file somewhere?
_________________
Honesty is the best policy.
Insanity is the best defence.

mqjeff

Posted: Fri Apr 15, 2016 7:13 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Why are you using Java code to get a configurable property?
_________________
chmod -R ugo-wx /

HIMAGAR

Posted: Fri Apr 15, 2016 7:49 am Post subject:

Novice

Joined: 05 Nov 2015
Posts: 18

What Should I use ?
I need to make a User defined Configurable Service in which I have to define some Look Up Table.
I have a restriction that I cannot use the Database.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Calling Java Class via ESQL

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP