Two Laptop Bag
The moose likes JDBC and Relational Databases and the fly likes Understanding FilteredRowSet and Predicate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Understanding FilteredRowSet and Predicate" Watch "Understanding FilteredRowSet and Predicate" New topic

Understanding FilteredRowSet and Predicate

Claus Reimer

Joined: May 01, 2013
Posts: 1
I have been playing around with a FilteredRowSet for a while, and found some very strange behavior that puzzles me a lot.

I have a small predicate that only allows names starting with "c" and when I try to insert eg. "klaus" I get a SQLException saying "value is not allowed by the filter" which is what would expect.

However when I try to update a name from "claus" to "Klaus" I'll get nothing , even updateRow() and acceptChanges() does not raise any error even though the value is never written to the db. Is this how it’s supposed to work or?
I agree. Here's the link:
subject: Understanding FilteredRowSet and Predicate
jQuery in Action, 3rd edition