• Post Reply Bookmark Topic Watch Topic
  • New Topic

Java Stored procedure vs DB stored procedure

 
Vinod John
Ranch Hand
Posts: 162
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
From a developement and code maintainence point of view, I would prefer Java Stored procedure to DB Stored Proc. But from performance end, how much are we to lose (or gain - I am trying to be bit optimistic) by using Java stored procedures. How does it vary across different databases. Any good/bad experiences ?
 
Bill Goldsworthy
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A stored procedure is a program which is physically stored in the database.

I'm not sure what you mean by 'prefer Java Stored procedure to DB Stored Proc'.
 
Ilja Preuss
author
Sheriff
Posts: 14112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Bill Goldsworthy:
A stored procedure is a program which is physically stored in the database.

I'm not sure what you mean by 'prefer Java Stored procedure to DB Stored Proc'.


Many modern RDBMS accept there stored procedures written in Java, in addition to the native format. Those stored procedures are called "Java Stored Procedures". The question, as I understand it, is: which format should be preferred when, and why?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Bill Goldsworthy:
A stored procedure is a program which is physically stored in the database.

I'm not sure what you mean by 'prefer Java Stored procedure to DB Stored Proc'.


A Java Stored Procedure is a stored procedure, written in Java, stored and run in the database. Only some databases support this (Oracle does, for example).
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!