Re: Multiple ResultSets
- From: jaya nair <jayanair@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 6 Sep 2005 17:07:44 -0700
Hi Joe,
I have a problem again while retriveing multiple results sets from SQLServer
stored procedure
I used call.execute(), then tried to retrive OUT parameters using
call.getString(1) , it works fine
later im trying to retrive multiple resultsets one after other.
As you said first i tried to retrieve first resultset using
rs1 = call.getResultSet();
and tried to retrieve second one
call.getMoreResults()
rs2 = call.getResultSet()
But im getting rs1 and rs1 are null. Im not getting resultsets
But when i execute this stored proc using Query Analyser. It returns both
resultsets and i can see the records.
But using jdbc im not able to retrieve.
Can you tell me why??
thanks in advance
sudha
"Joe Weinstein" wrote:
>
>
> jaya nair wrote:
>
> > Hi
> > I have a stored procedure which returns mulitple resultsets
> > rs = call.executeQuery();
> > call.getMoreResults();
> > irs = call.getResultSet();
> > I want to pass these two resultsets to another method.
> > When i pass these two
> > i get error saying "ResultSet is closed" for the first resultset.
> > i came to know there is method in jdk1.4.2 which keeps the resultsets open.
> > "call.getMoreResults(Statement.Keep_Current_Result)"
> > But i tried to use that But again i have another problem
> > Im using WSAD5.1 which uses to jdk1.4.1
> > So i configured the setting in WSAD so that it uses jdk1.4.2.
> > So at compile time im not gettign any problem
> > But at runtime it says
> > "getMoreResults(int) is not supported by webshpere java.sql.Statement
> > Implementation"
> >
> > Can you please help me regarding this..
> > Thanks in Advance
>
> Hi. By JDBC spec, getMoreResults() will close any previous
> result set. You have to do whatever processing you want
> with a given resultset before getting another from the same
> statement.
>
> Joe Weinstein at BEA Systems
>
>
.
- Prev by Date: Problem while retrieving Multiple resultsets
- Next by Date: Exception comes from where?
- Previous by thread: Problem while retrieving Multiple resultsets
- Next by thread: Exception comes from where?
- Index(es):
Relevant Pages
|
