i have a stored proc in sql server : ========== @id varchar(20) AS BEGIN declare @Compid varbinary(8) begin select @compid=cast(@compId1 as VarBinary(8)) print @compid Select C.CompName fromc_CompType T, c_Company C end end =========== my jdbc code in jsp is like this :with all other necessary things like try import et al
dsn is ok.The table gives result using dsn proc runs fine in sql debugger BUT i am not getting resultset in jsp
i do not get an exception as well.
posted 14 years ago
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?