jQuery in Action, 3rd edition
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: http://aspose.com/file-tools
subject: Java Stored procedure
It's not a secret anymore!