This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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 ??????
Similar Threads
No resultset
Java and Sybase nested stored procedures
Java and Sybase nested stored procedures
program to make start-connect by (oracle )
Error :java.sql.SQLException: Invalid column index