JSTL jstl.sql.Result

[Justin Richardson]

I'm having trouble getting up to speed with JSTL. I'm trying to create a javax.servlet.jsp.jstl.sql.Result object in a bean, and then access it from a jsp page. It sounds simple enough, but I've yet to make it work. Here's what I'm doing. Here is the method in my class:

 
public Result getSuppliers() {
        dbConnectionInfo dbi = new dbConnectionInfo();
        String oracleOwner = dbi.getOracleOwner();
        Integer nppuserID = 10270;
        Result result = null;
 
        supplierListSQL.append("select distinct d.NAME, c.CONTRACT_ID, g.GROUP_DESC, c.ID, c.CONTRACT_DESC, c.COMP_BID, c.AMERINET_CONTRACT_ID ")
                .append("from " + oracleOwner + ".contract c, ")
                .append("     " + oracleOwner + ".nppuser u, ")
                .append("     " + oracleOwner + ".cust_contact cc, ")
                .append("     " + oracleOwner + ".cust_group cg, ")
                .append("     " + oracleOwner + ".contract_access ca, ")
                .append("     " + oracleOwner + ".dist d, ")
                .append("     " + oracleOwner + ".contract_group cog, ")
                .append("     " + oracleOwner + ".group_type g ")
                .append("where u.fk_cust_contact_id = cc.id ")
                .append("   and nvl(c.end_date,sysdate+1) > sysdate - 1")
                .append("   and u.id = " + nppuserID + " ")
                .append("   and cc.fk_cust_id = cg.fk_cust_id ")
                .append("   and cg.fk_group_type_id = ca.fk_group_type_id ")
                .append("   and ca.fk_contract_id = c.id ")
                .append("   and c.fk_dist_id = d.id ")
                .append("   and c.id = cog.fk_contract_id ")
                .append("   and cog.fk_group_type_id = g.id ")
                .append("order by group_desc ");
        try {
            conn = dbi.getConnection();
            PreparedStatement ps = conn.prepareStatement(supplierListSQL.toString());
            result = ResultSupport.toResult(ps.executeQuery());
        } catch (SQLException sqle) {
            System.out.println("SQL Exception in Suppliers and Contracts: " + sqle.getMessage());
            sqle.printStackTrace();
        } catch (Exception e) {
            System.out.println("Exception in Suppliers and Contracts: " + e.getMessage());
            e.printStackTrace();
        } finally {
            try {
                conn.close();
            } catch (SQLException sqle) {
                System.out.println("problem closing conn: " + sqle.getMessage());
            }
        }
        return result;
    }
 
 

Here is how I'm trying to access it in my page:

 
 
<jsp:useBean id="bean" class="npp.SuppliersAndContracts" scope="session"/>
 
<c:catch var="Exception">
<c:forEach items="${bean.suppliers}" var="item">
    <c :-o	 ut value="${item.contract_id}"/>
</c:forEach>
</c:catch>
<c:if test="${not empty Exception}">
    <c :-o	 ut value="${Exception.message}"/>
</c:if>
 

When I run it, this is the error I get:

Don't know how to iterate over supplied "items" in <forEach>

What am I doing wrong?

Thanks

[Bear Bibeault]

"Betty Crocker",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
Forum Bartender

[Bear Bibeault]

The forEach items attribute value is expected to be one of:

an array

an implementation of java.util.Collection

an implementation of java.util.Iterator

an implementation of java.util.Enumeration

an implementation of java.util.Map

a String

The interface javax.servlet.jsp.jstl.sql.Result is none of these things.

[Justin Richardson]

My apologies to all who were offended by Betty Crocker.

It was my understanding that the javax.servlet.jsp.jstl.sql.Result object was intended to wrap a ResultSet object to simplify its use in JSTL. Am I incorrect? Does this tag only relate to use with the <sql:*> library?

Thanks

[Bear Bibeault]

Perhaps it's the rows property of that interface that you wish to iterate over?

[Justin Richardson]

Oh, maybe that's it. I'm stuck in the mentality of refering to the field names contained in a ResultSet. However, those methods don't exist in a Result. Thanks for setting me straight.

[Dilip kumar]

Hi All -

Which version of J2EE I need to install to import
javax.servlet.jsp.jstl.sql.ResultSupport and javax.servlet.jsp.jstl.sql.Result
in my java class ?

Thanks

[Stefan Evans]

The classes you mention are included with JSTL, in jstl.jar.
They are not part of the standard J2EE API at this point in time.