About Question enthuware.ocpjp.v7.2.1200 :

[Ambiorix]

Why would you go to the bother of creating a filter class when you could just include something like 'and GPA > 4.0' in the original select statement?

To illustrate an approach, of course

I was thinking more generally. What's the point of the FilterRowSet? Is it not always easier just to get the select statement to pick the rows that meet the criteria you want?

[admin]

You might want to apply a filter on an existing rowset. It is just a facility/feature. It might not be useful very often but it could be useful when the opportunity to fire query is not present or the way you want to filter is not possible to code in the query.

[telston]

Section 9 of the exam guide at docs.oracle.com/javase/tutorial/extra/certification/javase-7-programmer2.html#jdbc does not cover the section about FilteredRowSet. It covers only RowSet as a general interface and JdbcRowSet. Does the actual exam cover detailed use of CachedRowSet, WebRowSet, FilteredRowSet, and JoinRowSet?

[admin]

Yes, we have seen candidates getting question on these RowSets.

See this: http://www.coderanch.com/t/657283/java- ... -Enthuware
HTH,
Paul.

[lunars]

If there is anyone else who, like me, was at first confused about the purpose of there being three evaluate methods, read the javadoc again more carefully!

http://stackoverflow.com/questions/5619 ... ate-method

Basically, the non-RowSet overloads are called by FilteredRowSet when you insert rows, the RowSet one is for queries... Do I have that right?

So in the code from the present Enthuware question, the two non-RowSet overloads would have affected the studentRS if we had moved to the insert row, updated its columns, and ran insertRow(). I suppose, since they returned false in ALL cases, any attempt to insert rows at all would have been blocked?

Thanks for any info in advance!