File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes No resultset ?????? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "No resultset ??????" Watch "No resultset ??????" New topic

No resultset ??????

Sanjay Deshpande
Ranch Hand

Joined: May 22, 2001
Posts: 111
i have a stored proc in sql server :
@id varchar(20)
declare @Compid varbinary(8)
select @compid=cast(@compId1 as VarBinary(8))
print @compid
Select C.CompName
fromc_CompType T,
c_Company C
my jdbc code in jsp is like this :with all other necessary things like try import et al

java.sql.CallableStatement cst1=con.prepareCall("{call Proc_Company_Get(?)}");

ResultSet rs1 = cst1.executeQuery();

dsn is ok.The table gives result using dsn
proc runs fine in sql debugger
i am not getting resultset in jsp

i do not get an exception as well.
Vlad Patryshev
Ranch Hand

Joined: Jun 30, 2001
Posts: 61
Did you try the same using plain SQL? Did you try doing the same from a java application? Since you declare a result set and assign it some value, you must have something there (well, maybe an empty set), right?

Thanks,<br />Vlad
I agree. Here's the link:
subject: No resultset ??????
It's not a secret anymore!