aspose file tools*
The moose likes JDBC and the fly likes Understanding FilteredRowSet and Predicate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Understanding FilteredRowSet and Predicate" Watch "Understanding FilteredRowSet and Predicate" New topic
Author

Understanding FilteredRowSet and Predicate

Claus Reimer
Greenhorn

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: http://aspose.com/file-tools
 
subject: Understanding FilteredRowSet and Predicate