File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Websphere and the fly likes Java Stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Java Stored procedure" Watch "Java Stored procedure" New topic

Java Stored procedure

Aparna Sharma
Ranch Hand

Joined: Mar 12, 2003
Posts: 30

I had a general question about writing Stored procedures using WSAD. The database is DB2 and our plan is to write Java Stored procedures. I read some where that in terms of efficiency SQL stored procedure is first , then C stored procedure and last comes Java Stored procedure.

Any thoughts on this?

Aparna S.

on DB2 stored proceduresIBM RedBook link

Aparna Sharma<br />SCJP 1.4 (yippeeee!)
Kuldeep Vaishnav
Ranch Hand

Joined: May 23, 2004
Posts: 72
well as such stored procs itself is a big performance hit(we are converting all our sql stor procs to java classes currently) compared to jdbc..but within stored procs u may right bout the numbering....

I agree. Here's the link:
subject: Java Stored procedure
jQuery in Action, 3rd edition