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 > Data Access, Manipulation & Batch Languages > JAVA > Java Stored Procedure Wont start

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-10-08, 21:56
pczurak pczurak is offline
Registered User
 
Join Date: Jan 2007
Posts: 4
Java Stored Procedure Wont start

DB2 version DB2 v8.1.2.88, on Linux Red Hat


I am trying to create java stored procedure, everything seems to be setup correctly, but when I call the stored procedure I get the following error. How can I fix this or what am I doing wrong?

Here's the error:
SQL4306N Java stored procedure or user-defined function
"E1USER.INSERT_TN_BSFN", specific name "INSERT_TN_BSFN" could not call Java
method "javastp", signature "(Ljava/lang/StringV". SQLSTATE=42724


Here's the DB2 Procedure.
CREATE PROCEDURE E1USER.INSERT_TN_BSFN
(IN test GRAPHIC(30))

SPECIFIC E1USER.INSERT_TN_BSFN
DYNAMIC RESULT SETS 0
NOT DETERMINISTIC
LANGUAGE JAVA

PARAMETER STYLE JAVA
EXTERNAL NAME 'stpclass.javastp'
FENCED
THREADSAFE

@


Here's the java class.


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class stpclass
{
public static void javastp(String test) throws SQLException
{
return;
}


}


------------------------------------------

Here's the log file

2008-03-10-20.53.08.822578-300 I171631G379 LEVEL: Warning
PID : 23670 TID : 3004169120 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejCallJavaRoutine_dll, probe:130
MESSAGE : JNI GetMethodID failed. class:
DATA #1 : Hexdump, 8 bytes
0xB64AD4B0 : 7374 7063 6C61 7373 stpclass

2008-03-10-20.53.08.822753-300 I172011G379 LEVEL: Warning
PID : 23670 TID : 3004169120 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejCallJavaRoutine_dll, probe:140
MESSAGE : JNI GetMethodID failed. method:
DATA #1 : Hexdump, 7 bytes
0xB64AD4B9 : 6A61 7661 7374 70 javastp

2008-03-10-20.53.08.822884-300 I172391G454 LEVEL: Warning
PID : 23670 TID : 3004169120 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejCallJavaRoutine_dll, probe:150
MESSAGE : JNI GetMethodID failed. signature:
DATA #1 : Hexdump, 21 bytes
0xB64AD4F0 : 284C 6A61 7661 2F6C 616E 672F 5374 7269 (Ljava/lang/Stri
0xB64AD500 : 6E67 3B29 56 ngV

2008-03-10-20.53.08.823251-300 E172846G366 LEVEL: Warning
PID : 23670 TID : 3004169120 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejLogException, probe:10
MESSAGE : ADM10000W A Java exception has been caught. The Java stack
traceback has been written to the db2diag.log.

2008-03-10-20.53.08.823418-300 I173213G402 LEVEL: Warning
PID : 23670 TID : 3004169120 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejLogException, probe:10
MESSAGE : java.lang.NoSuchMethodError: stpclass.javastp(Ljava/lang/StringV
DATA #1 : Hexdump, 4 bytes
0xB30FE854 : 0000 0000 ....

2008-03-10-20.53.08.823526-300 I173616G375 LEVEL: Warning
PID : 23670 TID : 3004169120 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerJavaCallRoutine, probe:30
MESSAGE : Error from DB2ER CallUDF. RC:
DATA #1 : Hexdump, 4 bytes
0xB30FED84 : 2EEF FFFF
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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On