call Stored procedure using JSTL

Is this a stored procedure on a database?

Or a method on a bean?

What is the purpose of this stored procedure? To retrieve data? Store data? Trigger a process?

JSTL is designed to make it easier to write scriptless JSP pages - adding logic/looping/access to make it easier to render JSPs. It is not a programming language in itself. It is geared more towards display than modifying/calling data/actions.

It is possible what you want to do either can't be done in JSTL, or more rightly belongs in servlet/bean code.

Hope this helps,

evnafets

evnafetsa at 2007-7-8 21:49:29 >

Sounds like something that should be done in a Servlet/bean as opposed to a JSP.

JSTL can call getter/setter method, but can't pass parameters.

If you have a JSP2.0 container, you could consider writing a user function which would do this - essentially that lets you execute any static method you define, and can take parameters.

evnafetsa at 2007-7-8 21:49:29 >

You need to call a program on the AS400

I presume this is not a java program - it is elsewhere on the system?

The approach I would take would be to write a java class/java code to execute the procedure on the AS400.

I'm not entirely certain how you would do that probably with a call to Runtime.exec() to have it execute a system command?

I don't think JSTL will be of any direct help in this endeavour.

evnafetsa at 2007-7-8 21:49:29 >