Java Stored procedure vs DB stored procedure

Ranch Hand

Posts: 162

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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'.

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

Posts: 14112

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Paul Sturrock

Bartender

Posts: 10336

I like...

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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).

JavaRanch FAQ HowToAskQuestionsOnJavaRanch