Stored procedures

Stored procedures - syntax

Thread view:

tursergei@yandex.ru - 27 Sep 2006 11:57 GMT

Hi,

Currently coding a program which connects to Informix 7.3x. Java
version is 1.4.2.
I tend to use stored procedures executing them from Java code and
getting recordsets back.

Should I use

EXECUTE PROCEDURE spl_name (param1,param2)

syntax or

{call spl_name(?,?)}

one with setting parameters ? Shoudl I stick to CallableStatement

Thanks in advance and regards,
Sergei

Reply to this Message

Robert Klemme - 27 Sep 2006 12:57 GMT

> Hi,
>
[quoted text clipped - 12 lines]
>
> one with setting parameters ? Shoudl I stick to CallableStatement

As long as possible I'd stick with standard solutions. So, yes, use
CallableStatement with the JDCB escape syntax wherever possible unless
you do not get the functionality you need or have to pay too high a
price (performance, overly complex code...).

robert

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...