Stored Proc resultset empty

[Rene Dupre]

I have a stored procedure to do a simple select. When I call the procedure using the MySQL command line, everything works ok (I get 1 row back). But in my java program, I don't get any resultset.

my java code:

CallableStatement cStmt = connect.prepareCall("{call ReadUserbyPK(?)}");
cStmt.setString("inUserID", inUserID);
boolean hadResults = cStmt.execute();
while (hadResults)
{
rs = cStmt.getResultSet();
logger.debug("Got result set row:"+rs.getRow());
hadResults = cStmt.getMoreResults();
}

Output shows getRow() returns zero.
I get an error "Before start of result set" if I try to use rs.

my stored procedure:
DELIMITER $$
DROP PROCEDURE IF EXISTS ReadUserbyPK$$
CREATE PROCEDURE ReadUserbyPK(IN inUserID VARCHAR(25))
BEGIN
SELECT * FROM Userid
WHERE Userid.userName = inUserID;
END$$
DELIMITER ;

Any ideas as to why I'm not getting a resultset?

I'm using mySQL 5.1, and ConnectorJ 5.1.7
Thanks!