Java Stored procedure vs DB stored procedure
Vinod John
Ranch Hand
Posts: 162
posted 11 years ago
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
posted 11 years ago
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'.
I'm not sure what you mean by 'prefer Java Stored procedure to DB Stored Proc'.
Increasingly, people seem to misinterpret complexity as sophistication, which is baffling - the incomprehensible should cause suspicion rather than admiration. Possibly this trend results from a mistaken belief that using a somewhat mysterious device confers an aura of power on the user. Niklaus Wirth
Ilja Preuss
author
Sheriff
Sheriff
Posts: 14112
posted 11 years ago
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?
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?
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
posted 11 years ago
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).
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).
