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 > Uneven behaviour when calling an UDF

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-09-04, 00:01
santhosh_fisc santhosh_fisc is offline
Registered User
 
Join Date: Sep 2004
Posts: 1
Uneven behaviour when calling an UDF

hi friends...
i am finding a problem in DB2 UDF execution.
i make a soap call from the DB2 UDF (a call back class put in sqllib/function)..and through this soap call i'm trying to invoke a method on my server. This call to DB2 UDF is fired by a database trigger
...if 4 times (or any number) trigger is called few calls are successfully executed
and response also is successfully got. but for few data the call is failing.

the important thing is that the fails are not always for the same data.. a particular data is sometimes successful sometimes failure.

i tried tracking this via tunnel.
my server is ending back the response and i can view thw reponse in the tunnel too. but i'm not getting the Response object back in the UDF function and DB2 generates and error -723 adn state 9000 (which i think indicate rollback) and SQLCODE -4302, SQLSTATE 38501 ...

the error i get in log sometimes is outofmemoryexception when parsing using xerces and and sometimes..some class not found in xerces( this too may be due to memory lack..as no loading could be done) ....


can any one tell me what is the problem????
i'm after this for a week...but no idea....
please respond...
is it problem in the soap.jar file??
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