Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java Stored procedure

 
Aparna Sharma
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Kuldeep Vaishnav
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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....
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic