File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Correct approach ? Stored Proc (returning cursor) Vs Prepared statment
Joined: Mar 19, 2006
Nov 12, 2009 08:05:43
I have lot of select queries to integrate with my
I have two options to select within :
1. Store procedure which returns cursor
2. Prepared statements
Which one should I use ? Which one is the fastest and a correct approach?
Can java experts please put some pros and cons of both approaches?
Joined: Dec 20, 2006
Nov 12, 2009 13:20:46
1 is proprietary , 2 is portable across databases.
OCUP UML fundamental and ITIL foundation
I agree. Here's the link:
subject: Correct approach ? Stored Proc (returning cursor) Vs Prepared statment
Get cusor from SQLServer StoreProcedure to Java Program
urgent help reqd
large resultset connection times out
Closing Statement object prior to committing
Connection.close() and preparedStatement.close() in Connection.TRANSACTION_SERIALIZABLE mode.
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014