Stored Procedure
2 posts in topic
Flat View  Flat View

Posted By:   Anonymous
Posted On:   Friday, April 9, 2010 06:30 AM

What is the use of stored procedures in java?

Re: Stored Procedure

Posted By:   Anonymous  
Posted On:   Thursday, April 15, 2010 07:47 AM

I don't know much about java....:)

Re: Stored Procedure

Posted By:   Tim_Frith  
Posted On:   Tuesday, April 13, 2010 03:12 PM

Stored procedures are database objects, not Java. You can execute them from Java.

Their advantage is that they run right on the database and if written properly can take advantage of processing sets of records at a time. If you tried to do the same thing in Java you would need to retrieve all the records from the database, then process them iteratively, then usually write the results back to the database. This is way slower and less efficient than having a stored procedure do it right within the database.

About | Sitemap | Contact