File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes disadvantage of stored procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "disadvantage of stored procedures" Watch "disadvantage of stored procedures" New topic

disadvantage of stored procedures

naidu gulla

Joined: Jul 19, 2006
Posts: 14
hi javaranchers,
i would like to know the disadvantages of storedprocedures.
thanks in advance
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
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.
I agree. Here's the link:
subject: disadvantage of stored procedures
It's not a secret anymore!