Re: trigger call java class

["Sultan yılmaz" <yilmazsultan@xxxxxxxxx>]

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.