• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

disadvantage of stored procedures

 
naidu gulla
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi javaranchers,
i would like to know the disadvantages of storedprocedures.
thanks in advance
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by naidu gulla:
hi javaranchers,
i would like to know the disadvantages of storedprocedures.
thanks in advance


Different databases have different stored procedure languages; some databases don't support stored procedures at all. While at least one database supports Java as a stored procedure language, most don't, so Java programmers who are going to write stored procedures must learn an additional language; however, some companies who use Java and stored procedures have different people or groups work in each area, which of course leads to the normal boundary/integration issues of software development.

Particularly in companies that divide the work, Java programmers might have difficulty getting visibility into the logic implemented in the stored procedures (if they need it), but this can be worked around with good development practices, such as keeping stored procedure definitions in an accessible source code repository. The Java team may also require additional daatabase-related tools. Using stored procedures well often requires more understanding of your particular database product, in particular learning any built-in packages.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic