Re: Problem with a java SQL UDF -- JAVA400-L

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.

Subject: Re: Problem with a java SQL UDF
From: David Gibbs <david@xxxxxxxxxxxx>
Date: Fri, 03 Apr 2009 15:24:58 -0500
List-archive: <http://archive.midrange.com/java400-l>
List-help: <mailto:java400-l-request@midrange.com?subject=help>
List-id: Java Programming on and around the iSeries / AS400 <java400-l.midrange.com>
List-post: <mailto:java400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/java400-l>, <mailto:java400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/java400-l>, <mailto:java400-l-request@midrange.com?subject=unsubscribe>

Gary L Peskin wrote:

Have you checked the contents of SYSJAROBJECTS, SYSJARCONTENTS, and
/QIBM/UserData/OS400/SQLLib/Function. Also, the InfoCenter shows that the
external name clause should be jarid:classname.methodname. However, you
have a ! separating the classname and methodname.

I tried specifying the external name as 'mksis3:mks.ci.server.schema.Functions3DB2.testFunc3' and we got a SQL4304 RC=1 error, which indicates the class was not found in the classpath.

I'm assuming that you left off the package name from the Functions3DB2 class
definition in this email.

Correct.

david

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.