If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > JAVA UDF issue!

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-12-07, 07:36
kingp kingp is offline
Registered User
 
Join Date: Dec 2006
Posts: 10
JAVA UDF issue!

Hi all
I am trying to execute two JAVA UDFs throough my DB2 SQL stored procedure .These two external routines are performing some critical function which is else not possible.When I try to execute, one of the UDF workes absolutely fine without errors separately but the other ones doestn run at all
and it produces the error as SQL 4306N SQLSTATE 42724...My UDF is unable to call the java method.I dont really understand the disparitry of why one is working fine whilie other is not even though they have been built on the same framework......can someone please explain the reason...
Thanks in Advance
Reply With Quote
  #2 (permalink)  
Old 01-12-07, 09:41
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
"Explanation:

The Java method given by the EXTERNAL NAME clause of a CREATE
PROCEDURE or CREATE FUNCTION statement could not be found. Its
declared argument list may not match what the database expects,
or it may not be a "public" instance method.

User Response:

Ensure that a Java instance method exists with the "public" flag
and the expected argument list for this call."
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On