wood burning stoves*
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
Author

Java Stored procedure

Aparna Sharma
Ranch Hand

Joined: Mar 12, 2003
Posts: 30
Hi,

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?

Thanks,
Aparna S.

-fyi-
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....


Kuldeep
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Java Stored procedure