Sorry for the delay in responding. I checked for a reply from you several
times over the days after I last posted to this thread but after several
attempts there was no reply so I thought the thread had died. I finally
checked again a minute ago and now I see that you must have replied just
after I gave up on hearing from you. I'm not sure if you'll see this reply;
you've probably given up on ME by now!

Okay, now back to the problem. Yes, I can call the SQL function in an SQL
statement executed on the command line but it fails on the set() method if I
debug it through Eclipse.

Do you have any idea what files/directories need to be on the CLASSPATH for
this to work? UnsatisfiedLinkError suggests a missing DLL but I have no idea
what DLL it is looking for; whoever did the error handling code for this
class didn't see fit to identify whatever was missing in the error message.

Actually, that's what I was trying to do when I encountered this problem.

I've tried a couple of times over the years to get the IBM Distributed
Debugger to work with stored procedures - I assume it works with UDFs too
but I'm not sure - but I could never get it to work. When I posted to this
newsgroup about the problems I was having, the responses I got never helped
me enough to get that debugger working.

On March 1 2005, I posted about something I'd seen in the manuals which
suggested a way to debug a UDF with a driver program; I asked for details on
what that driver would need to contain. After getting some general remarks,
I posted my best guess on what the driver needed and you jumped in to
suggest a much simpler driver.

Two weeks ago, I had an offline enquiry from someone who'd seen that thread
and wondered if I ever got Eclipse to debug my UDF successfully. Frankly,
I'd forgotten about the whole matter so I started looking at my code from
last year and reviewed the thread and your reply.

I found that I could debug Parameter Style Java UDFs fine but got the
UnsatisfiedLinkError when I got to the set() method in the Parameter Style
DB2General UDFs. So I started this thread to see if I could get some help to
figure out the problem.

Here are the relevant parts of the Driver program. (I'm running DB2 V8.2.1
these days, not V7.2):

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

import java.sql.SQLException;

public class UdfDriverV8 {

   public static void main(String[] args) {

       new UdfDriverV8();
   }

   public UdfDriverV8(); {

       testLeftmost_Java();
       testLeftmost_DB2General();
   }

   public void testLeftmost_Java() {

       System.out.println("\nUDF: leftmost()");

       String input = "abcdefghijk";
       System.out.println("  Input String: " + input);
       int size = 3;
       System.out.println("  Characters to return: " + size);

       String output = null;
       try {
           output = com.foo.db2v8.udf.java.TextUDFs.leftmost(input, size);
       } catch (SQLException sql_excp) {
           System.err.println("UdfDriverV8 caught SQLException. Message: "
+ sql_excp.getMessage());
           sql_excp.printStackTrace();
       }

       System.out.println("  Output String: " + output);
   }

   public void testLeftmost_DB2General() {

       System.out.println("\nUDF: leftmost()");

       String input = "abcdefghijk";
       System.out.println("  Input String: " + input);
       int size = 3;
       System.out.println("  Characters to return: " + size);

       String output = null;
       try {
           com.foo.db2v8.db2general.TextUDFs textUDFs = new
com.foo.db2v8.db2general.TextUDFs();
           textUDFs.leftmost(input, size, output);
       } catch (Exception excp) {
           System.err.println("UdfDriverV8 caught Exception. Message: " +
excp.getMessage());
           excp.printStackTrace();
       }

       System.out.println("  Output String: " + output);
   }
}
---------------------------------------------------------------------------------------------------------------------

This is the code for the Parameter Style Java version of the UDF, which
works fine and can be debugged in Eclipse:

---------------------------------------------------------------------------------------------------------------------
package com.foo.db2v8.udf.java;

public class TextUDFs extends UDF {

   public static String leftmost(String input, int size) throws
SQLException {

       try {
           String trimmedInput = input.trim();
           if (trimmedInput.length() < size) size = trimmedInput.length();
           String output = trimmedInput.substring(0, size);
           return (output);
       } catch (Exception excp) {
           throw new SQLException("leftmost() - " + excp.getMessage(),
"38600");
       }

   }
}

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

This is the code for the Parameter Style DB2General version of the UDF,
which works fine and can ALMOST be debugged in Eclipse, except that I get
UnsatisfiedLinkError when I step onto the set() method:
---------------------------------------------------------------------------------------------------------------------
package come.foo.db2v8.udf.db2general;

public class TextUDFs extends UDF {

   public void leftmost(String input, int size, String output) throws
Exception {

       String trimmedInput = input.trim();
       if (trimmedInput.length() < size) size = trimmedInput.length();
       String leftmost = trimmedInput.substring(0, size);
       set(3, leftmost); //UnsatisfiedLinkError on this line
   }

}
---------------------------------------------------------------------------------------------------------------------

Important: All of the source code for both the driver and both versions of
the UDF compiles without any problems so Eclipse can clearly 'see'
everything it needs to compile. I only run into trouble when debugging the
DB2GENERAL UDF.

This is the CREATE FUNCTION statement for the Parameter Style Java version
of the UDF:
---------------------------------------------------------------------------------------------------------------------
CREATE FUNCTION leftmost (varchar(4000), int)

RETURNS varchar(4000)

SPECIFIC leftmost

EXTERNAL NAME 'TextUDFs_Java:com.foo.db2v8.udf.java.TextUDFs.leftmost'

LANGUAGE JAVA

PARAMETER STYLE JAVA

DETERMINISTIC

NO EXTERNAL ACTION

FENCED

RETURNS NULL ON NULL INPUT

ALLOW PARALLEL

NO DBINFO

NO SQL

NO SCRATCHPAD

NO FINAL CALL;

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

This is the CREATE FUNCTION statement for the Parameter Style DB2General
version of the UDF:
---------------------------------------------------------------------------------------------------------------------

CREATE FUNCTION leftmost (varchar(4000), int)

RETURNS varchar(4000)

SPECIFIC leftmost

EXTERNAL NAME
'TextUDFs_DB2General:com.foo.db2v8.udf.db2general.TextUDFs.leftmost'

LANGUAGE JAVA

PARAMETER STYLE DB2GENERAL

DETERMINISTIC

NO EXTERNAL ACTION

FENCED

RETURNS NULL ON NULL INPUT

ALLOW PARALLEL

NO DBINFO

NO SQL

NO SCRATCHPAD

NO FINAL CALL;

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

Is there any other information I can provide that would help you or anyone
else figure out how to solve my UnsatisfiedLinkError?

I'm completely baffled by this problem. I have no idea what Java thinks it
is missing so I don't know how to make the missing resource available to
Eclipse. Everything compiles fine so everything Eclipse needs seems to be
available yet I get this runtime error.

--
Rhino