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
JDBC and Relational Databases
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
large resultset connection times out
Get cusor from SQLServer StoreProcedure to Java Program
urgent help reqd
Connection.close() and preparedStatement.close() in Connection.TRANSACTION_SERIALIZABLE mode.
Closing Statement object prior to committing
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015