Re: trigger call java class

Hi,

i created a external function like this:
create function properties()
returns table (property varchar(500), value varchar(500))
external name 'JVMProperties.dump2' language java
parameter style db2general fenced no sql
disallow parallel scratchpad

The function call a java class that is extens UDF.İt works.But i want to
sent parameters to my java method.

create function properties(ID INTEGER ,VAL VARCHAR(10))
returns table (property varchar(500), value varchar(500))
external name 'JVMProperties.dump2' language java
parameter style db2general fenced no sql
disallow parallel scratchpad

SELECT * FROM TABLE(properties(1,'TEST')) AS x

but it does not work.

How can i send parameters from function to java method?What is the matter?

Sultan

On 7/5/07, Joe Sam Shirah <joe_sam@xxxxxxxxxxxxx> wrote:

Hi Sultanimus,

> How can i call a java class in trigger?

You can't, directly, and usually you wouldn't want to. ADDPFTRG wants
a
*PGM object, which a Java class is not. You could use a CLP that calls
the
Java class, but with a trigger, you want to do the least amount of work
possible and return so the DB updating program doesn't drag.

The typical solution is to use some sort of messaging to a continually
running program which does the actual work asynchronously. This method
makes a lot of sense whether or not you use Java to execute trigger
operations.


Joe Sam

Joe Sam Shirah - http://www.conceptgo.com
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International? http://www.jguru.com/faq/I18N
Que Java400? http://www.jguru.com/faq/Java400


----- Original Message -----
From: "Sultan yýlmaz" <yilmazsultan@xxxxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Sent: Thursday, July 05, 2007 3:37 AM
Subject: trigger call java class


> Hi,
>
>
>
> I were to create a jar file from eclipse and the jar file IFS on AS400
> (/QIBM/UserData/OS400/SQLLib/Function/TEST.jar)
>
> I define my class path with ADDENVVAR
>
> I can call my class this command RUNJVA CLASS(TESTPRO) and it works.
>
> Now,My aim is calling this class from in a trigger.But "[SQL0204] CLASS
in
> *N type *N not found. " error occured.
>
> How can i call a java class in trigger?
>
> Can we set path in trigger's creation?
>
>
>
>
>
> Sultanimus
> --
> 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.
>

--
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.