If this is an update, you will almost always get this exception. What is the query you are attempting to run?
Robert S. Harper Information Access Technology, Inc. -----Original Message----- From: Carlos Bracho [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 28, 2005 12:54 PM To: [email protected] Subject: Stored Procedures problem I got this exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced at line # 2 in this code: conn = this.dataSource.getConnection(); ResourceBundle resourceBundle = ResourceBundle.getBundle("ladw/resources"); statement = conn.prepareCall(resourceBundle.getString("sp.getPassword")); statement.registerOutParameter(1,Types.VARCHAR); statement.setString(2, userName); statement.registerOutParameter(3,Types.VARCHAR); statement.execute(); String result = rs.getString(1); can somebody help me? -- ------------------------------------------------------------------ Carlos J, Bracho M. ------------------------------------------------------------------ e-mail: [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] +58 416 409 21 75 ------------------------------------------------------------------ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
