This week's book giveaway is in the Game Development forum.
We're giving away four copies of Badass: Making Users Awesome and have Kathy Sierra on-line!
See this thread for details.
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

Win a copy of Badass: Making Users Awesome this week in the Game Development forum!
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