This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
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


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?
 
GeeCON Prague 2014
 
subject: Understanding FilteredRowSet and Predicate