Number of rows affected by sql:update

[Eman Adenola]

Hi,
I am trying to get the number of rows affected by an <sql:update> but it returns an exception
I have the following code

 <sql:update  dataSource="${datasource}" var="updatereserved">
                    UPDATE  Books
                    SET Reserved = ?
                    WHERE ISBN  = ?
                    <sql:param value="Y"/>
                    <sql:param value="${param['ISBN']}"/>
                </sql:update>


                    <c:if test='${updatereserved.rowCount > 0}'>
                        <font color="green">
                            Book reserved

                        <br/>
                        You now have ${bookRes} reserved
                        </font>
                    </c:if>

Except it returns an exception saying

javax.el.PropertyNotFoundException: Property 'rowCount' not found on type java.lang.Integer

Any ideas? Thanks

[Muhammad Saifuddin]

<sql:update dataSource="${datasource}" var="updatereserved">

var = updatereserved variable is store the count of affected rows.

[Eman Adenola]

Hi, yeah but the problem is when i do
updatereserved.rowCount i get an exception, are you suggesting I use the updatereserved variable directly?

[Sean Clark]

Hey,

As the error says:

javax.el.PropertyNotFoundException: Property 'rowCount' not found on type java.lang.Integer 

The object is an integer, so therefore it doesn't have a method called getRowCount().

Sean

[Eman Adenola]

oh...yeah..I
I was thinking it returned an object like how a query does..will try it thanks.