while calling a java procedure
i get SQL4306N & SQLSTATE=42724

i am sure there is no mistake in my procedure,if i change the procedure`s name and change the class` name and change the method`s name,it will be ok

in db2diag.log , it says:


2004-08-25-15.20.25.156000 InstanceB2 Node:000
PID:3476(db2fmp.exe) TID:3472 Appid:none
BSU Java support sqlejCallJavaRoutine_dll Probe:130

JNI GetMethodID failed. class:

0x00C77580 : 4C43 4344 5F45 544C 5F4D 4F4E 5448 5F53 LCCD_ETL_MONTH_S
0x00C77590 : 4C53 4D41 4E5F 4954 454D 5F4D 4F4E 5448 LSMAN_ITEM_MONTH

2004-08-25-15.20.25.156001 InstanceB2 Node:000
PID:3476(db2fmp.exe) TID:3472 Appid:none
BSU Java support sqlejCallJavaRoutine_dll Probe:140

JNI GetMethodID failed. method:

0x00C775A1 : 6C43 4344 5F45 544C 5F4D 4F4E 5448 5F53 lCCD_ETL_MONTH_S
0x00C775B1 : 4C53 4D41 4E5F 4954 454D 5F4D 4F4E 5448 LSMAN_ITEM_MONTH

2004-08-25-15.20.25.171000 InstanceB2 Node:000
PID:3476(db2fmp.exe) TID:3472 Appid:none
BSU Java support sqlejCallJavaRoutine_dll Probe:150

JNI GetMethodID failed. signature:

0x00C775F0 : 284C 6A61 7661 2F6C 616E 672F 5374 7269 (Ljava/lang/Stri
0x00C77600 : 6E67 3B29 56 ngV

2004-08-25-15.20.25.171001 InstanceB2 Node:000
PID:3476(db2fmp.exe) TID:3472 Appid:none
BSU Java support sqlejLogException Probe:10

ADM10000W A Java exception has been caught. The Java stack traceback has been
written to the db2diag.log.

2004-08-25-15.20.25.171002 InstanceB2 Node:000
PID:3476(db2fmp.exe) TID:3472 Appid:none
BSU Java support sqlejLogException Probe:10

java.lang.NoSuchMethodError: lCCD_ETL_MONTH_SLSMAN_ITEM_MONTH

0x0231F378 : 0x00000000 ....

2004-08-25-15.20.25.171003 InstanceB2 Node:000
PID:3476(db2fmp.exe) TID:3472 Appid:none
routine_infrastructure sqlerJavaCallRoutine Probe:30

Error from DB2ER CallUDF. RC:

0x0231F640 : 0xFFFFEF2E ....

i get this error on windows2000 and aix.

can any body help me ?
i want to know the reason and how to solve it.
thanks.

hi
read this apar?
http://www-1.ibm.com/support/docview...id=swg1IY26471

Bye
Abel.

let me see

thank you so much .

but i am using db2 v8 , can i use the fixes in that page?

if can not , how to do then ?

i haven`t got this error while using db2 v7 .

thank you .

any suggestion ?

who can help me ?

i am still in this trouble.

Hi.
I'v got the same error on aix.

When this error occurred,my source file is like this
-----
class CLSAPLUTILCAL{
public static void proc( .....) {
}
}
-----

I changed the name of method
"proc -> CLSAPLUTILCAL".
Then,this stored_proc worked well.

Bye