Re: trigger call java class

thank you very much.

i created a function for learning more.

Sample:
create function properties()
returns table (property varchar(500), value varchar(500))
external name 'JVMProperties.dump' language java
parameter style db2general fenced no sql
disallow parallel scratchpad

SELECT * FROM TABLE(PROPERTIES())

But produce an error such as the following:
[SQL0551] Not authorized to object ies.dump in JVMPropert type *PGM.

My .jar file in /QIBM/UserData/OS400/SQLLib/function directory

I can't fix this problem

Sultan Yılmaz




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.