Results 1 to 9 of 9
  1. #1
    Join Date
    Aug 2004
    Posts
    24

    Unanswered: an error while call a java procedure

    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 ....
    Last edited by stephen.song; 08-25-04 at 04:25.

  2. #2
    Join Date
    Aug 2004
    Posts
    24
    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.
    Last edited by stephen.song; 08-25-04 at 05:13.

  3. #3
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

  4. #4
    Join Date
    Aug 2004
    Posts
    24
    let me see
    Last edited by stephen.song; 08-26-04 at 03:01.

  5. #5
    Join Date
    Aug 2004
    Posts
    24
    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 .

  6. #6
    Join Date
    Aug 2004
    Posts
    24
    any suggestion ?

  7. #7
    Join Date
    Aug 2004
    Posts
    24

    Question

    who can help me ?

  8. #8
    Join Date
    Aug 2004
    Posts
    24
    i am still in this trouble.

  9. #9
    Join Date
    Sep 2004
    Location
    Osaka,Japan
    Posts
    1

    use the same name of method as class_name

    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
    Last edited by Eiji; 11-08-04 at 03:33.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •