aspose file tools*
The moose likes JDBC 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 JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "No resultset" Watch "No resultset" New topic
Author

No resultset

Sanjay Deshpande
Ranch Hand

Joined: May 22, 2001
Posts: 111
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

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.
Robert Brunner
Ranch Hand

Joined: Jul 18, 2001
Posts: 49
Originally posted by sanjay deshpande:
i have a stored proc in sql server :
==========
ResultSet rs1 = cst1.executeQuery();

Try using
ResultSet rs1 = cst1.execute() ;
Callable Statements should be called using this method in order to handle the subtelties of stored procedures.
DAYANAND BURAMSHETTY
Ranch Hand

Joined: Aug 06, 2001
Posts: 34
java.sql.CallableStatement cst1=con.prepareCall("{call Proc_Company_Get(?)}");
cst1.registerOutParameter(1,java.sql.Types.VARBINARY);
...........
//If U need this value.....
byte result[]=cst1.getBytes(1);
String str=new String(result);
System.out.println("result"+str);

Dil se....,<BR>Dayanand<BR>0065-8839071(off)<BR>0065-7547034(Res0
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: No resultset