wood burning stoves 2.0*
The moose likes JDBC and the fly likes disadvantage of stored procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "disadvantage of stored procedures" Watch "disadvantage of stored procedures" New topic
Author

disadvantage of stored procedures

naidu gulla
Greenhorn

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: http://aspose.com/file-tools
 
subject: disadvantage of stored procedures
 
Similar Threads
what are the advantages of struts
Disadvantage for the Inheritance
Struts Interview
Locking: how much is enough?
Question