|
INTERVIEW QUESTIONS
J2EE
JDBC
DETAILS
Question: How do I receive a ResultSet from a stored procedure?
Answer: Stored procedures can return a result parameter, which can be a result set. For a discussion of standard JDBC syntax for dealing with result, IN, IN/OUT and OUT parameters, see Stored Procedures.
|
|
|
Category |
JDBC Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 7754 users |
Added on |
9/12/2014 |
Views |
70892 |
Rate it! |
|
|
Question:
How do I receive a ResultSet from a stored procedure?
Answer:
Stored procedures can return a result parameter, which can be a result set. For a discussion of standard JDBC syntax for dealing with result, IN, IN/OUT and OUT parameters, see Stored Procedures. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Connecting to a database through the Proxy I want to connect to remote database using a program that is running in the local network behind the proxy. Is that possible?
|
View Answer
|
|
Is possible to open a connection to a database with exclusive mode with JDBC?
|
View Answer
|
|
What driver should I use for scalable Oracle JDBC applications?
|
View Answer
|
|
How can I protect my database password ? I'm writing a client-side java application that will access a database over the internet. I have concerns about the security of the database passwords. The client will have access in one way or another to the class files, where the connection string to the database, including user and password, is stored in as plain text. What can I do to protect my passwords?
|
View Answer
|
|
Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.
|
View Answer
|
|
How do I implement a RowSetReader? I want to populate a CachedRowSet myself and the documents specify that a RowSetReader should be used. The single method accepts a RowSetInternal caller and returns void. What can I do in the readData method?
|
View Answer
|
|
How does a custom RowSetReader get called from a CachedRowSet?
|
View Answer
|
|
How to create a custom RowSetMetaData object from scratch?
|
View Answer
|
|
Where can I find info, frameworks and example source for writing a JDBC driver?
|
View Answer
|
|
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
|
View Answer
|
|
If I use the JDBC API, do I have to use ODBC underneath?
|
View Answer
|
|
There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?
|
View Answer
|
|
How many types of JDBC Drivers are present and what are they?
|
View Answer
|
|
How can I retrieve a String or other object type without creating a new object each time?
|
View Answer
|
|
Why can't I invoke the ResultSet methods afterLast and beforeFirst when the method next works?
|
View Answer
|
|
What is the query used to display all tables names in SQL Server (Query analyzer)?
|
View Answer
|
|
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
|
View Answer
|
|
Is the JDBC-ODBC Bridge multi-threaded?
|
View Answer
|
|
Are all the required JDBC drivers to establish connectivity to my database part of the JDK?
|
View Answer
|
|
Which type of JDBC driver is the fastest one?
|
View Answer
|