I realize this but I cannot seem to pull a result set from an Executed Stored Procedure with cstmt.executeQuery() I have no problem executing a Query and getting a result set. I'm trying to find out how to populate a resultset from an executed stored procedure -----Original Message----- From: DIEGO RODRIGO [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 12:40 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re:Help getting a result set from a stored procedure through Importance: High you need to call cstmt.executeQuery() in order to get a ResultSet. bye. ____________________Reply Separator____________________ Subject: Help getting a result set from a stored procedure through JD Author: [EMAIL PROTECTED] Date: 16/11/2000 6:26 PM I'm a recent (yesterday) convert from asp to jsp. I've had no difficulty implementing a simple sql queries with JDBC to return a result set but now I need to start hitting some of the stored procedures I have written here is the code. Where am I going wrong. I know it is the Execute() but the documentation I have says it should act the same as the executeQuery() I used with my simple queries. Thanks for any help in advance. <html> <head> <title> Banners </title> <%@ page language="java" import="java.sql.*,java.io.*,java.lang.*,java.util.*"%> <body> <h1>Banners</h1> <table border="1" width="400"> <tr> <td><b>ID</b></td><td><b>FileName</b></td> </tr> <% // Load (and therefore register) the JDBC-ODBC Driver Class.forName("intersolv.jdbc.sequelink.SequeLinkDriver"); // Get a Connection to the database String url = "jdbc:sequelink://209.xxx.x.xxx:xxxx/[SQLServer];xxxxxxx"; Connection conn = DriverManager.getConnection(url, "xxxxx", "xxxxxxx"); //Create a Command object String cmd = "{call sp_day_session_report(?}"; //Create a Callable Statement CallableStatement cstmt = conn.prepareCall (cmd); cstmt.setString(1, "11/11/00"); // EndDate of Report cstmt.execute(); //////////////////////////////////////////////////////////////////////////// Here's where I think I'm screwing up // Create a result set aka a Recordset ResultSet rs = cstmt.execute(); // IF not null display results if (rs != null) { //Iterate through result set while (rs.next()) { String site_uid = rs.getString("site_uid"); String Site = rs.getString("Site"); %> <tr> <td><%=site_uid%></td> <td><%=Site%></td> </tr> <% } /* of while */ } /* of if */ cstmt.close(); conn.close(); %> </table> </body> </html> -------------------------------- Peter Jozsa Developer, Insite Communications www.insitecom.com 1020 Bayridge Kingston Ontario K7P 2S2 1-613-384-3581 =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
