NO RESULTSET
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Sanjay_deshpande
Posted On:   Wednesday, August 8, 2001 06:01 AM

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 from c_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 java.sql.CallableStatement cst1=con.prepareCall("{call Proc_Company_Get(?)}"); //cst1.registerOutParameter(2,Types.VARCHAR); cst1.setString(1,"0x0000000000000DF4"); ResultSet rs1 = cst1.executeQuery(); while(rs1.next()){ ou   More>>

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

from c_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


java.sql.CallableStatement cst1=con.prepareCall("{call Proc_Company_Get(?)}");
//cst1.registerOutParameter(2,Types.VARCHAR);
cst1.setString(1,"0x0000000000000DF4");


ResultSet rs1 = cst1.executeQuery();
while(rs1.next()){
out.print("sanjay2"+rs1.getString(1));
}

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.

   <<Less
About | Sitemap | Contact