Two Laptop Bag*
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java Stored procedure
 
Similar Threads
DB2 Stored procedures written in Java
WSAD and DB2 stored procedure
Java Stored procedure vs DB stored procedure
Limit in sending input data to db2 stored procedure
invoke Java stored procedure in trigger body