You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Carlos Bracho <ca...@gmail.com> on 2005/06/28 20:54:21 UTC
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: carlos.bracho@gmail.com
MSN: cbrachomi@hotmail.com
+58 416 409 21 75
------------------------------------------------------------------
RE: Stored Procedures problem
Posted by Maarten Janssen <ma...@bedrijven.nl>.
where do you define your resultset rs...
maarten
-----Oorspronkelijk bericht-----
Van: Robert Harper [mailto:robert@iat-cti.com]
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:carlos.bracho@gmail.com]
Sent: Tuesday, June 28, 2005 12:54 PM
To: tomcat-user@jakarta.apache.org
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: carlos.bracho@gmail.com
MSN: cbrachomi@hotmail.com
+58 416 409 21 75
------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
--
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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
RE: Stored Procedures problem
Posted by Robert Harper <ro...@iat-cti.com>.
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:carlos.bracho@gmail.com]
Sent: Tuesday, June 28, 2005 12:54 PM
To: tomcat-user@jakarta.apache.org
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: carlos.bracho@gmail.com
MSN: cbrachomi@hotmail.com
+58 416 409 21 75
------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org