Re: trigger call java class

Hi,

Your CREATE FUNCTION is different as mine !

The parameter style should be "java" instead of "db2general" ! (unless you
take other considerations as explained on the link you mentioned in your
previous posts).

Kind regards,
Paul

----- Oorspronkelijk bericht -----
Van: Sultan yılmaz [mailto:yilmazsultan@xxxxxxxxx]
Verzonden: woensdag, juli 11, 2007 10:29 AM
Aan: 'Java Programming on and around the iSeries / AS400'
Onderwerp: Re: trigger call java class

Hİ,

Unfortunately it does not work.I try the way that mentioned in your
mail.But i does not work.
the following error occured:

[SQL4304] Java stored procedure or user-defined function PROPER, specific
name PROPER could not load Java class TSTUDF for reason code 2.


Details:

create function proper(VARCHAR(255),VARCHAR(255))
returns varchar(255)
external name 'TSTUDF.JVMORCL' language java
parameter style db2general fenced no sql
disallow parallel scratchpad

SELECT proper('test','test') FROM SYSIBM.SYSDUMMY1 AS A

*

public* *class* TSTUDF {

*public* *static* String JVMORCL(String property, String value)
*throws*Exception
*{*

*....*

*}*

I read mails,forums,red books.But i can't solve problems.

I can run only table funtion with no parameters.But i has to run it with
parameters.

what can i do?

Sultan








On 7/10/07, Paul Nicolay <Paul.Nicolay@xxxxxxxxxx> wrote:

Hi,

You can pass parameters by defining them on the CREATE FUNCTION.

For example;

create function MyUDF(varchar(255), varchar(255))
returns varchar(255)
external name 'JavaUDF.TestUDF' language java
parameter style java fenced no sql
disallow parallel scratchpad

.. with...

public class JavaUDF {

public static String TestUDF(String s1, String s2) {

return s1.concat(s2);
}

}

... works fine as select MyUDF('abc', 'def') from pn/onerow

If a combination with returning a table works is something I haven't
tried.

Kind regards,
Paul

----- Oorspronkelijk bericht -----
Van: Sultan yılmaz [mailto:yilmazsultan@xxxxxxxxx]
Verzonden: dinsdag, juli 10, 2007 10:48 AM
Aan: 'Java Programming on and around the iSeries / AS400'
Onderwerp: Re: trigger call java class

Hi again,


http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzaha/udftable.htm

There is a sample function and java class in this link.
And public void dump (String property, String value) methods have two
parameters.
And i call function like this :SELECT * FROM TABLE(PROPERTIES())

Why i don't call function like PROPERTIES('sample','test') with
parameters?

is it possible?I want to send parameter to my java method.But how?


Sultan





--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.