Re: trigger call java class

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.