Re: trigger call java class

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

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.