File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
It's not a secret anymore!