We are using JAVA & jConnect52. We have some Stored procedures in the
Database with the following structure:
@var1 = select <whatever> FROM ....
@var2 = select <whatever> FROM ....
/* the expected returned select is */
select @var1, @var2, <whatever> FROM ....
The problem is that instead of returning a Resultset with the fields
"@var1, @var2, <whatever>" we are not able to instantiate a Resultset.
The last chance is creating the Sproc as just one select, but the
resulting code would be too much complicated to follow for the rest of
Does anyone know what the problem maybe?
Date: Thu, 4 Jan 2001 10:54:07 -0500
Subject: Problems retrieving a Resultset
Content-Type: text/plain; charset="us-ascii"
Xref: forums-1-dub sybase.public.jconnect30:201
Article PK: 255683
Date: Thu, 04 Jan 2001 11:41:00 -0600
From: "Kevin J. Grittner" <email@example.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
Subject: Re: Problems retrieving a Resultset
Content-Type: text/plain; charset=us-ascii
Xref: forums-1-dub sybase.public.jconnect30:200
Article PK: 254560
You're getting row counts in the response stream ahead of the result
set. You need to set up a loop to process the entire response stream.
Look at the examples that came with jConnect to find examples of the