where do you define your resultset rs... maarten
-----Oorspronkelijk bericht----- Van: Robert Harper [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 28 juni 2005 21:00 Aan: 'Tomcat Users List'; 'Carlos Bracho' Onderwerp: RE: Stored Procedures problem 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] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.5/32 - Release Date: 27-6-2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.5/32 - Release Date: 27-6-2005 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
