Java Server Faces ---> Persistance ---> MYSQL Database

CommitChanges() appears to work but in fact does not write any data to the database or produce any error if you change 
the SQL command to filter data on the CachedDataProvider.

To recreate

1. Create a small MYSQL table - add a few rows - Have an ID field that is autonumbering.
2. Create a Java Enterprise Application
3. Create a Java Server Faces Page and drop a grid on it
4. Drop the database on to the grid
5. Change the fields to be text editing fields instead of static display
6. Create two buttons - add new record and save changes

Add new record 
--------------
        cachedDataProvider1().appendRow();

Save Changes
------------
        
        polinesDataProvider.commitChanges();
        polinesDataProvider.refresh();
        return null;


Run the project, it will work fine you can add rows and change data.

Here's the problem, the real world problem I have is putting in a purchase order where there is header and detail 
information, so you need to change the SQL for the table to filter out anything that is not on "this" purchase order.

In the INIT phase I change the SQL witht he following code:-


                try {
            String sSQL="SELECT ALL polines.id, polines.poid, polines.description, polines.qty, polines.price, 
polines.total  FROM polines WHERE poid=" + cachedRowSetDataProvider1.getValue("id");
            polinesDataProvider.getCachedRowSet().setCommand(sSQL);
            polinesDataProvider.getCachedRowSet().execute();
            polinesDataProvider.refresh();
              } catch (Exception e) {
                  
              }

Now the records will not save, commitChanges appears to work and raises no error, but because I have a WHERE in the 
SQL string it does not write to the dataase.