Java Development Tools

Dear experts.

I created EO from mySQL database then simple VO (SELECT Sounds.idresources,  Sounds.resourceaccess FROM  resources Sounds). On jspx site I attached VO as a table and created a button to INSERT a new row to mySQL table directly via preparedStatement command.

At the end of a method I executed:

        DCBindingContainer DCB = (DCBindingContainer) BindingContext.getCurrent().getCurrentBindingsEntry();

        DCIteratorBinding iter = DCB.findIteratorBinding("VO_SOUNDS1Iterator");

        iter.getViewObject().clearCache();

        iter.executeQuery();

        iter.clearForRecreate();

        AdfFacesContext.getCurrentInstance().addPartialTarget(this.getT1());

to refresh table and see new inserted row. Unfortunately any changes are not visible. I have to navigate between other pages to see a correct result.

Any help would be appreciated.

Regards.