Difference between revisions of "JDBC: Accessing a Resultset from a Stored Procedure"

// Stored Procedure getexamplecursor.prg
lparameters lcAccountNo
exec sql
select * from example
 where account_no = lcAccountNo
 into cursor curExample;
return setresultset("curExample")
// end of getexamplecursor.prg

import java.sql.*;
import java.io.*;
import java.net.URL;
import Recital.sql.*;
 
public class rs_example {
 
	public static void main(String[] args) {
 
		int	i;
		ResultSet rs;
		ResultSetMetaData rsmd;
		String s;
 
		System.out.println("Recital resultset example program started.");
		try {
			new RecitalDriver();
			String url = "jdbc:Recital:" +
			"SERVERNAME=?;" +
			"DATABASE=southwind;" +
			"USERNAME=?;" +
			"PASSWORD=?";
			Connection con = DriverManager.getConnection(url);
			Statement stmt = con.createStatement();
 
			rs = stmt.executeQuery("recital 	getexamplecursor(‘0001’)");
			rsmd = rs.getMetaData();
			int nr_cols = rsmd.getColumnCount();
			while (rs.next()) {
				for (i = 1; i <= nr_cols; i++) {
					s = rs.getString(i);
					System.out.println(rsmd.getColumnName(i) +" ("+ rsmd.getColumnTypeName(i)+") = "+s);
				}
				System.out.println("***** Next Record *****");
			}
			System.out.println("End of results:");
			stmt.close();
			con.close();
		} catch (Exception e) {
			System.out.flush();
			System.err.flush();
			DriverManager.println("Driver exception: " + e.getMessage());
			e.printStackTrace();
		}
		try {
			System.out.println("Press any key to continue...");
			System.in.read();
		} catch(IOException ie) {
			;
		}
	}
}