JSF DataProvider problem with updating, inserting or deleting from PostgreSQL 8.2 db

[Davor Poldrugo]

Hi there,

I'm trying to update, insert or delete from PostgreSQL 8.2 in my JSF web app. A table is bind to a DataProvider (upisani_kolegijDataProvider).

Here's what am doing:

public class SessionBean1 extends AbstractSessionBean {
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">
 
    /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {
        upisani_kolegijRowSet.setDataSourceName("java:comp/env/jdbc/studomat_PostgreSQL");
        upisani_kolegijRowSet.setCommand("SELECT * FROM studomat.upisani_kolegij");
        upisani_kolegijRowSet.setTableName("upisani_kolegij");
    .
    .
    .
    }
.
.
.
}
 
public class Page1 extends AbstractPageBean {
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">
    /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {
        upisani_kolegijDataProvider.setCachedRowSet((javax.sql.rowset.CachedRowSet) getValue("#{SessionBean1.upisani_kolegijRowSet}"));
    .
    .
    .
    }
.
.
.
    // This is the button for update
    // it raises this exception: Cannot update with row key CachedRowSetRowKey[3]java.lang.RuntimeException: Number of conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 3 ERROR: relation "upisani_kolegij" does not exist
    // when I add the schema in the upisani_kolegijRowSet.setTableName("upisani_kolegij") in the SessionBean1   -->   upisani_kolegijRowSet.setTableName("studomat.upisani_kolegij")
    // it raises: Cannot update with row key CachedRowSetRowKey[3]java.lang.RuntimeException
    // In both situations in the log of GlassFish V2 server it stands: No columns in table: upisani_kolegij at com.sun.sql.rowset.internal.CachedRowSetXWriter.initSQLStatements(CachedRowSetXWriter.java:1268) ...
    // or No columns in table: studomat.upisani_kolegij at com.sun.sql.rowset.internal.CachedRowSetXWriter.initSQLStatements(CachedRowSetXWriter.java:1268) ...
    public String button1_action() {
 
        RowKey rowKey = tableRowGroup1.getRowKey();
 
        try {
            upisani_kolegijDataProvider.setCursorRow(rowKey);
            upisani_kolegijDataProvider.setValue("ocjena", tekst1.getText());
            upisani_kolegijDataProvider.setValue("odslusan", checkbox1.getValue());
            try {
                upisani_kolegijDataProvider.commitChanges();
                upisani_kolegijDataProvider.refresh();
 
            } catch (DataProviderException dataProviderException) {
                error("Commit error: " + rowKey + dataProviderException);
            }
 
        } catch (Exception e) {
            error("Cannot update with row key " + rowKey + e);
        }
        return null;
    }   
    //Button for delete
    // raises the same exceptions as the update button
    public String button2_action() {
        RowKey rowKey = tableRowGroup1.getRowKey();
 
        try {
            upisani_kolegijDataProvider.removeRow(rowKey);
            upisani_kolegijDataProvider.commitChanges();
        } catch (Exception e) {
            error("Error while deleting: " + e);
        }
        return null;
    }        
        
    //"Manual" update button 
    // This works with no problems!!!!
    public String button4_action() {        
            
        try {    
            Class.forName("org.postgresql.Driver").newInstance();
            Connection conn = DriverManager.getConnection("jdbc :-P	 ostgresql://localhost:5432/database", "user", "pass");
 
            RowKey rowKey = tableRowGroup1.getRowKey();
            java.sql.Statement stmt = conn.createStatement();
            stmt.executeUpdate("update studomat.upisani_kolegij set ocjena=" + (String) tekst1.getText() + "where id=" + upisani_kolegijDataProvider.getValue("id", rowKey));
            conn.commit();
            table_nameDataProvider.refresh();
        } catch (ClassNotFoundException ex) {
            error("Error: " + ex);
        } catch (InstantiationException ex) {
            error("Error: " + ex);
        } catch (IllegalAccessException ex) {
            error("Error: " + ex);
        } catch (SQLException ex) {
            error("Error: " + ex);
        }
    }
    
}

Does anybody have any idea why this happends?
I forgot to tell you that update and delete with "DataProvider method" works just fine when I use Derby database.

I found one similar problem, but has no answer:
http://www.coderanch.com/t/217868/ORM/java/org-postgresql-util-PSQLException-ERROR


Thank you very much,
Davor