Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Queries in Code V/s Stored Procedures

843854Apr 14 2004 — edited Apr 15 2004

Hi Friend,

Can any one of you guide me with following..

What is faster ? using SQL Queries in Java code or using Stored Procedures which are called from code?

I understnd Stroed Procedures are faster and definitely it provides more maintainability.

If any one can give me any links or resources which outlines pros and cons of using Stored Proc and SQL Queries embedded in Java than it would be a great help..

If there are any articles which proves either of the above is a preferred way, that would also help..

Appreciate the effort in advance !!

Thanks
Gurudatt

Locked Post

New comments cannot be posted to this locked post.

Locked on May 13 2004

Added on Apr 14 2004

#java-database-connectivity-jdbc

3 comments

268 views