• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Java Stored procedure vs DB stored procedure

 
Ranch Hand
Posts: 162
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ?
 
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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'.
 
author
Posts: 14112
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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).
 
reply
    Bookmark Topic Watch Topic
  • New Topic