SQL Server with a Select * stored proc

[Christian Schnepf]

I have a select * stored proc that I need to access from a jsp page. I am having difficulty setting up the output params and could use a little help. I dont get an error, but I do not get any data either.

Is there something wrong with my prepare or the registerOuts?

Table:

 CREATE TABLE [dbo].[tblUsers] (
[password] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[userName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[userID] [int] IDENTITY (1, 1) NOT NULL ,
[userEmail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[userPhone] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[userZip] [int] NULL ,
[userLastName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[userCity] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[userFirstName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[userAddr] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[activeFlag] [bit] NOT NULL ,
[passwordDate] [datetime] NULL ,
[last_update] [datetime] NULL 
) ON [PRIMARY]
GO
 
 

StoredProc:

 CREATE procedure dbo.select_UserInfo
 
@userIDint
 
as
 
begin
 
select *
from tblUsers
where userID = @userID
 
end
GO 

JavaCode

 stmt = conn.prepareCall("{call select_UserInfo(?)}");
stmt.setString(1,userID);
 
stmt.registerOutParameter(2, Types.VARCHAR);
stmt.registerOutParameter(3, Types.VARCHAR);
        stmt.registerOutParameter(4, Types.INTEGER);
        ....
 

[David Yutzy]

Why wouldn't you just read the resulset instead of messing with out parameters?

[Christian Schnepf]

I have been unsuccessful finding any examples on getting out put from params or results sets for SQL Server.