Using stored procedures with JDBC (DB2 v5 on OS/390)

Slot J.P.

Using stored procedures with JDBC (DB2 v5 on OS/390)
Hello all,

In my shop we have various Intranet applications whom are connecting to DB2
on OS/390 via an NT-machine using DB2 connect EE.
Those JAVA applications use dynamic SQL with JDBC, DB2 Connect EE, and SNA.
We don't like having dynamic SQL on a production database. Therefore we want
to implement stored procedures. We are on DB2v5, and so far the manuals and
literature on stored procedures for DB2v5 do not say anything of a JAVA
application being able to call a stored procedure via JDBC. Does anyone have
experience with this, and even more does someone have an example?
Any help will be much appreciated as this is our first attempt to use stored
procedures on DB2 OS/390.

Kind regards,

Jaap Slot,
Sr. DB2 DBA,
Rabobank ICT

Phone 0031 (0)30 215 2220
Mobile 0031 (0)6 5374 0167
e-Mail <mailto:[login to unmask email]>

Reserve your AGENDA for next DB2 Users Group Conference IDUG Florence - 8/11
October 2001 - < http://www.idug.org >

No trees were killed in the sending of this message. However - a large
number of electrons were terribly inconvenienced.




De informatie opgenomen in dit bericht kan vertrouwelijk zijn en
is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht
onterecht ontvangt, wordt u verzocht de inhoud niet te gebruiken en
de afzender direct te informeren door het bericht te retourneren.

The information contained in this message may be confidential
and is intended to be exclusively for the addressee. Should you
receive this message unintentionally, please do not use the contents
herein and notify the sender immediately by return e-mail.



Manish Lall

Re: Using stored procedures with JDBC (DB2 v5 on OS/390)
(in response to Slot J.P.)
Hello Jaap,

You can call the stored procedure through java with the
configuration you have mentioned(NT, JDBC,DB2 connect ...) But while
binding the packages use the collection id " NULLID", because whenever you
use java on NT,DB2 Connect for calling stored procedure on DB2 OS/390 it
looks for the packages under this collection id .. atleast in our case we
were forced to bind under this collection id and then it worked without any
problem.( You can also experiment by binding the packages using any other
collection id and checkout whether it works or not )

Hope to hear more from the list .....
Thanks ,
Manish Lall





"Slot, JP (Jaap)" <[login to unmask email]>@RYCI.COM> on 12/06/2000
02:12:44 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: Using stored procedures with JDBC (DB2 v5 on OS/390)


Hello all,

In my shop we have various Intranet applications whom are connecting to DB2
on OS/390 via an NT-machine using DB2 connect EE.
Those JAVA applications use dynamic SQL with JDBC, DB2 Connect EE, and SNA.
We don't like having dynamic SQL on a production database. Therefore we
want
to implement stored procedures. We are on DB2v5, and so far the manuals and
literature on stored procedures for DB2v5 do not say anything of a JAVA
application being able to call a stored procedure via JDBC. Does anyone
have
experience with this, and even more does someone have an example?
Any help will be much appreciated as this is our first attempt to use
stored
procedures on DB2 OS/390.

Kind regards,

Jaap Slot,
Sr. DB2 DBA,
Rabobank ICT

Phone 0031 (0)30 215 2220
Mobile 0031 (0)6 5374 0167
e-Mail <mailto:[login to unmask email]>

Reserve your AGENDA for next DB2 Users Group Conference IDUG Florence -
8/11
October 2001 - < http://www.idug.org >

No trees were killed in the sending of this message. However - a large
number of electrons were terribly inconvenienced.




De informatie opgenomen in dit bericht kan vertrouwelijk zijn en
is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht
onterecht ontvangt, wordt u verzocht de inhoud niet te gebruiken en
de afzender direct te informeren door het bericht te retourneren.

The information contained in this message may be confidential
and is intended to be exclusively for the addressee. Should you
receive this message unintentionally, please do not use the contents
herein and notify the sender immediately by return e-mail.








Steven Camitta

Re: Using stored procedures with JDBC (DB2 v5 on OS/390)
(in response to Manish Lall)
We're doing it. Works fine. Check the \SQLLIB\SAMPLES\JAVA subdirectory
for sample code. See StpCli.
Regards,
Steve

-----Original Message-----
From: Slot, JP (Jaap) [mailto:[login to unmask email]
Sent: Wednesday, December 06, 2000 12:43 AM
To: [login to unmask email]
Subject: Using stored procedures with JDBC (DB2 v5 on OS/390)


Hello all,

In my shop we have various Intranet applications whom are connecting to DB2
on OS/390 via an NT-machine using DB2 connect EE.
Those JAVA applications use dynamic SQL with JDBC, DB2 Connect EE, and SNA.
We don't like having dynamic SQL on a production database. Therefore we want
to implement stored procedures. We are on DB2v5, and so far the manuals and
literature on stored procedures for DB2v5 do not say anything of a JAVA
application being able to call a stored procedure via JDBC. Does anyone have
experience with this, and even more does someone have an example?
Any help will be much appreciated as this is our first attempt to use stored
procedures on DB2 OS/390.

Kind regards,

Jaap Slot,
Sr. DB2 DBA,
Rabobank ICT

Phone 0031 (0)30 215 2220
Mobile 0031 (0)6 5374 0167
e-Mail <mailto:[login to unmask email]>

Reserve your AGENDA for next DB2 Users Group Conference IDUG Florence - 8/11
October 2001 - < http://www.idug.org >

No trees were killed in the sending of this message. However - a large
number of electrons were terribly inconvenienced.




De informatie opgenomen in dit bericht kan vertrouwelijk zijn en
is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht
onterecht ontvangt, wordt u verzocht de inhoud niet te gebruiken en
de afzender direct te informeren door het bericht te retourneren.

The information contained in this message may be confidential
and is intended to be exclusively for the addressee. Should you
receive this message unintentionally, please do not use the contents
herein and notify the sender immediately by return e-mail.