Examples with PropertyVetoException java.beans.PropertyVetoException used on opensource projects

Example 6 with PropertyVetoException

use of java.beans.PropertyVetoException in project adempiere by adempiere.

the class VFile method actionPerformed.

//  getDisplay
/**
	 *	ActionListener - Button - Start Dialog
	 *  @param e ActionEvent
	 */
public void actionPerformed(ActionEvent e) {
    String m_value = m_text.getText();
    //
    log.config(m_value);
    //
    String fieldName = null;
    if (m_field != null)
        fieldName = m_field.getHeader();
    else
        fieldName = Msg.getElement(Env.getCtx(), m_columnName);
    //
    JFileChooser chooser = new JFileChooser(m_value);
    chooser.setMultiSelectionEnabled(false);
    chooser.setFileSelectionMode(m_selectionMode);
    chooser.setDialogTitle(fieldName);
    chooser.setDialogType(m_dialogType);
    //	
    int returnVal = -1;
    if (m_dialogType == JFileChooser.SAVE_DIALOG)
        returnVal = chooser.showSaveDialog(this);
    else if (m_dialogType == JFileChooser.OPEN_DIALOG)
        returnVal = chooser.showOpenDialog(this);
    else
        //	if (m_dialogType == JFileChooser.CUSTOM_DIALOG)
        returnVal = chooser.showDialog(this, fieldName);
    if (returnVal != JFileChooser.APPROVE_OPTION)
        return;
    File selectedFile = chooser.getSelectedFile();
    m_text.setText(selectedFile.getAbsolutePath());
    //  Data Binding
    try {
        fireVetoableChange(m_columnName, m_oldText, m_text.getText());
    } catch (PropertyVetoException pve) {
    }
}

Example 7 with PropertyVetoException

use of java.beans.PropertyVetoException in project adempiere by adempiere.

the class Graph method loadData.

private void loadData() {
    list = builder.loadData();
    JFreeChart chart = builder.createChart(builder.getMGoal().getChartType());
    if (chartPanel != null)
        remove(chartPanel);
    chartPanel = new ChartPanel(chart);
    chartPanel.setSize(getSize());
    chartPanel.addChartMouseListener(this);
    add(chartPanel, BorderLayout.CENTER);
    if (m_userSelection) {
        int AD_Reference_Value_ID = DB.getSQLValue(null, "SELECT AD_Reference_ID FROM AD_Reference WHERE Name = ?", "PA_Goal ChartType");
        MLookupInfo info = MLookupFactory.getLookup_List(Env.getLanguage(Env.getCtx()), AD_Reference_Value_ID);
        MLookup mLookup = new MLookup(info, 0);
        VLookup lookup = new VLookup("ChartType", false, false, true, mLookup);
        lookup.addVetoableChangeListener(new VetoableChangeListener() {

            public void vetoableChange(PropertyChangeEvent evt) throws PropertyVetoException {
                Object value = evt.getNewValue();
                if (value == null)
                    return;
                JFreeChart chart = null;
                chart = builder.createChart(value.toString());
                if (chart != null) {
                    if (chartPanel != null)
                        remove(chartPanel);
                    chartPanel = new ChartPanel(chart);
                    chartPanel.setSize(getSize());
                    chartPanel.addChartMouseListener(Graph.this);
                    add(chartPanel, BorderLayout.CENTER);
                    getParent().validate();
                }
            }
        });
        add(lookup, BorderLayout.NORTH);
    }
    this.setMinimumSize(paneldimension);
}

Example 8 with PropertyVetoException

use of java.beans.PropertyVetoException in project adempiere by adempiere.

the class GridController method vetoableChange.

/**************************************************************************
	 *  Vetoable Change Listener.
	 * 	Called from VEditor
	 *  <pre>
	 *  - for Save Confirmation dialog
	 *  - for Single Row from VEditor: Update MTable
	 *  </pre>
	 *  @param e event
	 *  @throws PropertyVetoException
	 */
public void vetoableChange(PropertyChangeEvent e) throws PropertyVetoException {
    if (//	only active records
    m_mTab.isProcessed() || !m_mTab.isActive()) {
        Object source = e.getSource();
        if (source instanceof VEditor) {
            if (!((VEditor) source).isReadWrite()) {
                log.config("(" + m_mTab.toString() + ") " + e.getPropertyName());
                return;
            }
        } else {
            log.config("(" + m_mTab.toString() + ") " + e.getPropertyName());
            return;
        }
    }
    //	processed
    log.config("(" + m_mTab.toString() + ") " + e.getPropertyName() + "=" + e.getNewValue() + " (" + e.getOldValue() + ") " + (e.getOldValue() == null ? "" : e.getOldValue().getClass().getName()));
    //  Save Confirmation dialog    MTable-RowSave
    if (e.getPropertyName().equals(GridTable.PROPERTY)) {
        //  throw new PropertyVetoException will call this listener again to revert to old value
        if (m_vetoActive) {
            //ignore
            m_vetoActive = false;
            return;
        }
        if (!Env.isAutoCommit(Env.getCtx(), m_WindowNo) || m_mTab.getCommitWarning().length() > 0) {
            if (!ADialog.ask(m_WindowNo, this, "SaveChanges?", m_mTab.getCommitWarning())) {
                m_vetoActive = true;
                throw new PropertyVetoException("UserDeniedSave", e);
            }
        }
        return;
    }
    //  saveConfirmation
    //  Get Row/Col Info
    GridTable mTable = m_mTab.getTableModel();
    int row = m_mTab.getCurrentRow();
    int col = mTable.findColumn(e.getPropertyName());
    //
    if ((e.getNewValue() == null || e.getNewValue().toString().isEmpty()) && e.getOldValue() != null && //	some editors return "" instead of null
    e.getOldValue().toString().length() > 0) {
        //  #283 Set value to null
        GridField gridField = m_mTab.getField(col);
        if (!gridField.getVO().IsMandatory)
            //	-> dataStatusChanged -> dynamicDisplay
            mTable.setValueAt(null, row, col);
        mTable.setChanged(true);
    } else {
        //	mTable.setValueAt (e.getNewValue(), row, col, true);
        /*
         	 * Changes: Added the logic below to handle multiple values for a single field
         	 *          due to multiple selection in Lookup (Info).
         	 * @author ashley
         	 */
        Object newValue = e.getNewValue();
        Integer[] newValues = null;
        if (newValue instanceof Integer[]) {
            newValues = ((Integer[]) newValue);
            newValue = newValues[0];
            if (newValues.length > 1) {
                Integer[] valuesCopy = new Integer[newValues.length - 1];
                System.arraycopy(newValues, 1, valuesCopy, 0, valuesCopy.length);
                newValues = valuesCopy;
            } else {
                newValues = null;
            }
        } else if (newValue instanceof Object[]) {
            log.severe("Multiple values can only be processed for IDs (Integer)");
            throw new PropertyVetoException("Multiple Selection values not available for this field", e);
        }
        //	-> dataStatusChanged -> dynamicDisplay
        mTable.setValueAt(newValue, row, col);
        //	Force Callout
        if (e.getPropertyName().equals("S_ResourceAssignment_ID")) {
            GridField mField = m_mTab.getField(col);
            if (mField != null && mField.getCallout().length() > 0)
                //  Dependencies & Callout
                m_mTab.processFieldChange(mField);
        }
        if (newValues != null && newValues.length > 0) {
            // Save data, since record need to be used for generating clones.
            if (!m_mTab.dataSave(false)) {
                throw new PropertyVetoException("SaveError", e);
            }
            // Retrieve the current record ID
            int recordId = m_mTab.getKeyID(m_mTab.getCurrentRow());
            Trx trx = Trx.get(Trx.createTrxName(), true);
            trx.start();
            try {
                saveMultipleRecords(Env.getCtx(), mTable.getTableName(), e.getPropertyName(), recordId, newValues, trx.getTrxName());
                trx.commit();
                m_mTab.dataRefreshAll();
            } catch (Exception ex) {
                trx.rollback();
                log.severe(ex.getMessage());
                throw new PropertyVetoException("SaveError", e);
            } finally {
                trx.close();
            }
        }
    }
//	log.config( "GridController.vetoableChange (" + m_mTab.toString() + ") - fini", e.getPropertyName() + "=" + e.getNewValue());
}

Example 9 with PropertyVetoException

use of java.beans.PropertyVetoException in project adempiere by adempiere.

the class GridTable method dataSave.

//  dataSave
/**
	 *	Save unconditional.
	 *  @param manualCmd if true, no vetoable PropertyChange will be fired for save confirmation
	 *	@return OK Or Error condition
	 *  Error info (Access*, FillMandatory, SaveErrorNotUnique,
	 *  SaveErrorRowNotFound, SaveErrorDataChanged) is saved in the log
	 */
public char dataSave(boolean manualCmd) {
    //	cannot save
    if (!m_open) {
        log.warning("Error - Open=" + m_open);
        return SAVE_ERROR;
    }
    //	no need - not changed - row not positioned - no Value changed
    if (m_rowChanged == -1) {
        log.config("NoNeed - Changed=" + m_changed + ", Row=" + m_rowChanged);
        //	return SAVE_ERROR;
        if (!manualCmd)
            return SAVE_OK;
    }
    //  Value not changed
    if (m_rowData == null) {
        //reset out of sync variable
        m_rowChanged = -1;
        log.fine("No Changes");
        return SAVE_ERROR;
    }
    if (m_readOnly) //	If Processed - not editable (Find always editable)  -> ok for changing payment terms, etc.
    {
        log.warning("IsReadOnly - ignored");
        dataIgnore();
        return SAVE_ACCESS;
    }
    //	row not positioned - no Value changed
    if (m_rowChanged == -1) {
        if (//  new row and nothing changed - might be OK
        m_newRow != -1)
            m_rowChanged = m_newRow;
        else {
            fireDataStatusEEvent("SaveErrorNoChange", "", true);
            return SAVE_ERROR;
        }
    }
    //	Can we change?
    int[] co = getClientOrg(m_rowChanged);
    int AD_Client_ID = co[0];
    int AD_Org_ID = co[1];
    if (!MRole.getDefault(m_ctx, false).canUpdate(AD_Client_ID, AD_Org_ID, m_AD_Table_ID, 0, true)) {
        fireDataStatusEEvent(CLogger.retrieveError());
        dataIgnore();
        return SAVE_ACCESS;
    }
    log.info("Row=" + m_rowChanged);
    //  inform about data save action, if not manually initiated
    try {
        if (!manualCmd)
            m_vetoableChangeSupport.fireVetoableChange(PROPERTY, -1, m_rowChanged);
    } catch (PropertyVetoException pve) {
        log.warning(pve.getMessage());
        //dataIgnore();
        return SAVE_ABORT;
    }
    //	get updated row data
    Object[] rowData = getDataAtRow(m_rowChanged);
    // CarlosRuiz - globalqss - fix [1722226] - Usability - Record_ID = 0 on 9 tables can't be modified
    boolean specialZeroUpdate = false;
    if (// not inserting, updating a record 
    !m_inserting && // in a manual way (pushing the save button)
    manualCmd && // user must know what is doing -> just allowed to System or SuperUser (Hardcoded)
    (Env.getAD_User_ID(m_ctx) == 0 || Env.getAD_User_ID(m_ctx) == 100) && getKeyID(m_rowChanged) == 0) {
        // the record being changed has ID = 0
        // just the allowed tables (HardCoded)
        String tablename = getTableName();
        if (tablename.equals("AD_Org") || tablename.equals("AD_ReportView") || tablename.equals("AD_Role") || tablename.equals("AD_System") || tablename.equals("AD_User") || tablename.equals("C_DocType") || tablename.equals("GL_Category") || tablename.equals("M_AttributeSet") || tablename.equals("M_AttributeSetInstance")) {
            specialZeroUpdate = true;
        }
    }
    //	Check Mandatory
    String missingColumns = getMandatory(rowData);
    if (missingColumns.length() != 0) {
        //	Trace.printStack(false, false);
        fireDataStatusEEvent("FillMandatory", missingColumns + "\n", true);
        return SAVE_MANDATORY;
    }
    /**
		 *	Update row *****
		 */
    int Record_ID = 0;
    if (!m_inserting)
        Record_ID = getKeyID(m_rowChanged);
    try {
        //	FR [ 392 ]
        if (//	translation tables have no model
        !specialZeroUpdate)
            return dataSavePO(Record_ID);
    } catch (Throwable e) {
        if (e instanceof ClassNotFoundException)
            log.warning(m_tableName + " - " + e.getLocalizedMessage());
        else {
            log.log(Level.SEVERE, "Persistency Issue - " + m_tableName + ": " + e.getLocalizedMessage(), e);
            return SAVE_ERROR;
        }
    }
    /**	Manual Update of Row (i.e. not via PO class)	**/
    log.info("NonPO");
    boolean error = false;
    lobReset();
    //
    String is = null;
    final String ERROR = "ERROR: ";
    final String INFO = "Info: ";
    //	Update SQL with specific where clause
    StringBuffer select = new StringBuffer("SELECT ");
    for (int i = 0, addedColumns = 0; i < m_fields.size(); i++) {
        GridField field = (GridField) m_fields.get(i);
        if (m_inserting && field.isVirtualColumn())
            continue;
        // Add "," if it is not the first added column - teo_sarca [ 1735618 ]
        if (addedColumns++ > 0)
            select.append(",");
        //	ColumnName or Virtual Column
        select.append(field.getColumnSQL(true));
    }
    //
    select.append(" FROM ").append(m_tableName);
    StringBuffer singleRowWHERE = new StringBuffer();
    StringBuffer multiRowWHERE = new StringBuffer();
    //	Create SQL	& RowID
    if (m_inserting)
        select.append(" WHERE 1=2");
    else
        //  FOR UPDATE causes  -  ORA-01002 fetch out of sequence
        select.append(" WHERE ").append(getWhereClause(rowData));
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try {
        pstmt = DB.prepareStatement(select.toString(), ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE, null);
        rs = pstmt.executeQuery();
        //	only one row
        if (!(m_inserting || rs.next())) {
            fireDataStatusEEvent("SaveErrorRowNotFound", "", true);
            dataRefresh(m_rowChanged);
            return SAVE_ERROR;
        }
        Object[] rowDataDB = null;
        //	Prepare
        boolean manualUpdate = ResultSet.CONCUR_READ_ONLY == rs.getConcurrency();
        // Manual update if log migration scripts is enabled - teo_sarca BF [ 1901192 ]
        if (!manualUpdate && Ini.isPropertyBool(Ini.P_LOGMIGRATIONSCRIPT))
            manualUpdate = true;
        if (manualUpdate)
            createUpdateSqlReset();
        if (m_inserting) {
            if (manualUpdate)
                log.fine("Prepare inserting ... manual");
            else {
                log.fine("Prepare inserting ... RowSet");
                rs.moveToInsertRow();
            }
        } else {
            log.fine("Prepare updating ... manual=" + manualUpdate);
            //	get current Data in DB
            rowDataDB = readData(rs);
        }
        /**	Data:
			 *		m_rowData	= original Data
			 *		rowData 	= updated Data
			 *		rowDataDB	= current Data in DB
			 *	1) Difference between original & updated Data?	N:next
			 *	2) Difference between original & current Data?	Y:don't update
			 *	3) Update current Data
			 *	4) Refresh to get last Data (changed by trigger, ...)
			 */
        //	Constants for Created/Updated(By)
        Timestamp now = new Timestamp(System.currentTimeMillis());
        int user = Env.getContextAsInt(m_ctx, "#AD_User_ID");
        /**
			 *	for every column
			 */
        int size = m_fields.size();
        int colRs = 1;
        for (int col = 0; col < size; col++) {
            GridField field = (GridField) m_fields.get(col);
            if (field.isVirtualColumn()) {
                if (!m_inserting)
                    colRs++;
                continue;
            }
            String columnName = field.getColumnName();
            //	RowID, Virtual Column
            if (field.getDisplayType() == DisplayType.RowID || field.isVirtualColumn())
                //	ignore
                ;
            else //	New Key
            if (field.isKey() && m_inserting) {
                if (columnName.endsWith("_ID") || columnName.toUpperCase().endsWith("_ID")) {
                    //	no trx
                    int insertID = DB.getNextID(m_ctx, m_tableName, null);
                    if (manualUpdate)
                        createUpdateSql(columnName, String.valueOf(insertID));
                    else
                        // ***
                        rs.updateInt(colRs, insertID);
                    singleRowWHERE.append(columnName).append("=").append(insertID);
                    //
                    is = INFO + columnName + " -> " + insertID + " (Key)";
                } else //	Key with String value
                {
                    String str = rowData[col].toString();
                    if (manualUpdate)
                        createUpdateSql(columnName, DB.TO_STRING(str));
                    else
                        // ***
                        rs.updateString(colRs, str);
                    //	overwrite
                    singleRowWHERE = new StringBuffer();
                    singleRowWHERE.append(columnName).append("=").append(DB.TO_STRING(str));
                    //
                    is = INFO + columnName + " -> " + str + " (StringKey)";
                }
                log.fine(is);
            } else //	New DocumentNo
            if (columnName.equals("DocumentNo")) {
                boolean newDocNo = false;
                String docNo = (String) rowData[col];
                //  we need to have a doc number
                if (docNo == null || docNo.length() == 0)
                    newDocNo = true;
                else //  Preliminary ID from CalloutSystem
                if (docNo.startsWith("<") && docNo.endsWith(">"))
                    newDocNo = true;
                if (newDocNo || m_inserting) {
                    String insertDoc = null;
                    //  always overwrite if insering with mandatory DocType DocNo
                    if (m_inserting)
                        insertDoc = DB.getDocumentNo(m_ctx, m_WindowNo, m_tableName, true, //	only doc type - no trx
                        null);
                    log.fine("DocumentNo entered=" + docNo + ", DocTypeInsert=" + insertDoc + ", newDocNo=" + newDocNo);
                    // can we use entered DocNo?
                    if (insertDoc == null || insertDoc.length() == 0) {
                        if (!newDocNo && docNo != null && docNo.length() > 0)
                            insertDoc = docNo;
                        else
                            //  get a number from DocType or Table
                            insertDoc = DB.getDocumentNo(m_ctx, m_WindowNo, m_tableName, false, //	no trx
                            null);
                    }
                    //	There might not be an automatic document no for this document
                    if (insertDoc == null || insertDoc.length() == 0) {
                        //  in case DB function did not return a value
                        if (docNo != null && docNo.length() != 0)
                            insertDoc = (String) rowData[col];
                        else {
                            error = true;
                            is = ERROR + field.getColumnName() + "= " + rowData[col] + " NO DocumentNo";
                            log.fine(is);
                            break;
                        }
                    }
                    //
                    if (manualUpdate)
                        createUpdateSql(columnName, DB.TO_STRING(insertDoc));
                    else
                        //	***
                        rs.updateString(colRs, insertDoc);
                    //
                    is = INFO + columnName + " -> " + insertDoc + " (DocNo)";
                    log.fine(is);
                }
            } else //  New Value(key)
            if (columnName.equals("Value") && m_inserting) {
                String value = (String) rowData[col];
                //  Get from Sequence, if not entered
                if (value == null || value.length() == 0) {
                    value = DB.getDocumentNo(m_ctx, m_WindowNo, m_tableName, false, null);
                    //  No Value
                    if (value == null || value.length() == 0) {
                        error = true;
                        is = ERROR + field.getColumnName() + "= " + rowData[col] + " No Value";
                        log.fine(is);
                        break;
                    }
                }
                if (manualUpdate)
                    createUpdateSql(columnName, DB.TO_STRING(value));
                else
                    //	***
                    rs.updateString(colRs, value);
                //
                is = INFO + columnName + " -> " + value + " (Value)";
                log.fine(is);
            } else //	Updated		- check database
            if (columnName.equals("Updated")) {
                if (//	changed
                m_compareDB && !m_inserting && !m_rowData[col].equals(rowDataDB[col])) {
                    error = true;
                    is = ERROR + field.getColumnName() + "= " + m_rowData[col] + " != DB: " + rowDataDB[col];
                    log.fine(is);
                    break;
                }
                if (manualUpdate)
                    createUpdateSql(columnName, DB.TO_DATE(now, false));
                else
                    //	***
                    rs.updateTimestamp(colRs, now);
                //
                is = INFO + "Updated/By -> " + now + " - " + user;
                log.fine(is);
            } else //	UpdatedBy	- update
            if (columnName.equals("UpdatedBy")) {
                if (manualUpdate)
                    createUpdateSql(columnName, String.valueOf(user));
                else
                    //	***
                    rs.updateInt(colRs, user);
            } else //	Created
            if (m_inserting && columnName.equals("Created")) {
                if (manualUpdate)
                    createUpdateSql(columnName, DB.TO_DATE(now, false));
                else
                    //	***
                    rs.updateTimestamp(colRs, now);
            } else //	CreatedBy
            if (m_inserting && columnName.equals("CreatedBy")) {
                if (manualUpdate)
                    createUpdateSql(columnName, String.valueOf(user));
                else
                    //	***
                    rs.updateInt(colRs, user);
            } else //	Nothing changed & null
            if (m_rowData[col] == null && rowData[col] == null) {
                if (m_inserting) {
                    if (manualUpdate)
                        createUpdateSql(columnName, "NULL");
                    else
                        //	***
                        rs.updateNull(colRs);
                    is = INFO + columnName + "= NULL";
                    log.fine(is);
                }
            } else //	***	Data changed ***
            if (m_inserting || (m_rowData[col] == null && rowData[col] != null) || (m_rowData[col] != null && rowData[col] == null) || //	changed
            !m_rowData[col].equals(rowData[col])) {
                //	Original == DB
                if (m_inserting || !m_compareDB || (m_rowData[col] == null && rowDataDB[col] == null) || (m_rowData[col] != null && m_rowData[col].equals(rowDataDB[col]))) {
                    if (CLogMgt.isLevelFinest())
                        log.fine(columnName + "=" + rowData[col] + " " + (rowData[col] == null ? "" : rowData[col].getClass().getName()));
                    //
                    boolean encrypted = field.isEncryptedColumn();
                    //
                    String type = "String";
                    if (rowData[col] == null) {
                        if (manualUpdate)
                            createUpdateSql(columnName, "NULL");
                        else
                            //	***
                            rs.updateNull(colRs);
                    } else //	ID - int
                    if (DisplayType.isID(field.getDisplayType()) || field.getDisplayType() == DisplayType.Integer) {
                        try {
                            Object dd = rowData[col];
                            Integer iii = null;
                            if (dd instanceof Integer)
                                iii = (Integer) dd;
                            else
                                iii = new Integer(dd.toString());
                            if (encrypted)
                                iii = (Integer) encrypt(iii);
                            if (manualUpdate)
                                createUpdateSql(columnName, String.valueOf(iii));
                            else
                                // 	***
                                rs.updateInt(colRs, iii.intValue());
                        } catch (//  could also be a String (AD_Language, AD_Message)
                        Exception e) {
                            if (manualUpdate)
                                createUpdateSql(columnName, DB.TO_STRING(rowData[col].toString()));
                            else
                                //	***
                                rs.updateString(colRs, rowData[col].toString());
                        }
                        type = "Int";
                    } else //	Numeric - BigDecimal
                    if (DisplayType.isNumeric(field.getDisplayType())) {
                        BigDecimal bd = (BigDecimal) rowData[col];
                        if (encrypted)
                            bd = (BigDecimal) encrypt(bd);
                        if (manualUpdate)
                            createUpdateSql(columnName, bd.toString());
                        else
                            //	***
                            rs.updateBigDecimal(colRs, bd);
                        type = "Number";
                    } else //	Date - Timestamp
                    if (DisplayType.isDate(field.getDisplayType())) {
                        Timestamp ts = (Timestamp) rowData[col];
                        if (encrypted)
                            ts = (Timestamp) encrypt(ts);
                        if (manualUpdate)
                            createUpdateSql(columnName, DB.TO_DATE(ts, false));
                        else
                            //	***
                            rs.updateTimestamp(colRs, ts);
                        type = "Date";
                    } else //	LOB
                    if (field.getDisplayType() == DisplayType.TextLong) {
                        PO_LOB lob = new PO_LOB(getTableName(), columnName, null, field.getDisplayType(), rowData[col]);
                        lobAdd(lob);
                        type = "CLOB";
                    } else //	Boolean
                    if (field.getDisplayType() == DisplayType.YesNo) {
                        String yn = null;
                        if (rowData[col] instanceof Boolean) {
                            Boolean bb = (Boolean) rowData[col];
                            yn = bb.booleanValue() ? "Y" : "N";
                        } else
                            yn = "Y".equals(rowData[col]) ? "Y" : "N";
                        if (encrypted)
                            yn = (String) yn;
                        if (manualUpdate)
                            createUpdateSql(columnName, DB.TO_STRING(yn));
                        else
                            //	***
                            rs.updateString(colRs, yn);
                    } else //	String and others
                    {
                        String str = rowData[col].toString();
                        if (encrypted)
                            str = (String) encrypt(str);
                        if (manualUpdate)
                            createUpdateSql(columnName, DB.TO_STRING(str));
                        else
                            //	***
                            rs.updateString(colRs, str);
                    }
                    //
                    is = INFO + columnName + "= " + m_rowData[col] + " -> " + rowData[col] + " (" + type + ")";
                    if (encrypted)
                        is += " encrypted";
                    log.fine(is);
                } else //	Original != DB
                {
                    error = true;
                    is = ERROR + field.getColumnName() + "= " + m_rowData[col] + " != DB: " + rowDataDB[col] + " -> " + rowData[col];
                    log.fine(is);
                }
            }
            //	Single Key - retrieval sql
            if (field.isKey() && !m_inserting) {
                if (rowData[col] == null)
                    throw new RuntimeException("Key is NULL - " + columnName);
                if (columnName.endsWith("_ID"))
                    singleRowWHERE.append(columnName).append("=").append(rowData[col]);
                else {
                    //	overwrite
                    singleRowWHERE = new StringBuffer();
                    singleRowWHERE.append(columnName).append("=").append(DB.TO_STRING(rowData[col].toString()));
                }
            }
            //	MultiKey Inserting - retrieval sql
            if (field.isParentColumn()) {
                if (rowData[col] == null)
                    throw new RuntimeException("MultiKey Parent is NULL - " + columnName);
                if (multiRowWHERE.length() != 0)
                    multiRowWHERE.append(" AND ");
                if (columnName.endsWith("_ID"))
                    multiRowWHERE.append(columnName).append("=").append(rowData[col]);
                else
                    multiRowWHERE.append(columnName).append("=").append(DB.TO_STRING(rowData[col].toString()));
            }
            //
            colRs++;
        }
        if (error) {
            if (manualUpdate)
                createUpdateSqlReset();
            else
                rs.cancelRowUpdates();
            fireDataStatusEEvent("SaveErrorDataChanged", "", true);
            dataRefresh(m_rowChanged);
            return SAVE_ERROR;
        }
        /**
			 *	Save to Database
			 */
        //
        String whereClause = singleRowWHERE.toString();
        if (whereClause.length() == 0)
            whereClause = multiRowWHERE.toString();
        if (m_inserting) {
            log.fine("Inserting ...");
            if (manualUpdate) {
                String sql = createUpdateSql(true, null);
                //	no Trx
                int no = DB.executeUpdateEx(sql, null);
                if (no != 1)
                    log.log(Level.SEVERE, "Insert #=" + no + " - " + sql);
            } else
                rs.insertRow();
        } else {
            log.fine("Updating ... " + whereClause);
            if (manualUpdate) {
                String sql = createUpdateSql(false, whereClause);
                //	no Trx
                int no = DB.executeUpdateEx(sql, null);
                if (no != 1)
                    log.log(Level.SEVERE, "Update #=" + no + " - " + sql);
            } else
                rs.updateRow();
        }
        log.fine("Committing ...");
        //	no Trx
        DB.commit(true, null);
        DB.close(rs, pstmt);
        rs = null;
        pstmt = null;
        //
        lobSave(whereClause);
        //	Need to re-read row to get ROWID, Key, DocumentNo, Trigger, virtual columns
        log.fine("Reading ... " + whereClause);
        StringBuffer refreshSQL = new StringBuffer(m_SQL_Select).append(" WHERE ").append(whereClause);
        pstmt = DB.prepareStatement(refreshSQL.toString(), null);
        rs = pstmt.executeQuery();
        if (rs.next()) {
            rowDataDB = readData(rs);
            //	update buffer
            setDataAtRow(m_rowChanged, rowDataDB);
            if (m_virtual) {
                MSort sort = m_sort.get(m_rowChanged);
                int oldId = sort.index;
                int newId = getKeyID(m_rowChanged);
                if (newId != oldId) {
                    sort.index = newId;
                    Object[] data = m_virtualBuffer.remove(oldId);
                    m_virtualBuffer.put(newId, data);
                }
            }
            fireTableRowsUpdated(m_rowChanged, m_rowChanged);
        } else
            log.log(Level.SEVERE, "Inserted row not found");
    //
    } catch (Exception e) {
        String msg = "SaveError";
        if (//	Unique Constraint
        DBException.isUniqueContraintError(e)) {
            log.log(Level.SEVERE, "Key Not Unique", e);
            msg = "SaveErrorNotUnique";
        } else
            log.log(Level.SEVERE, select.toString(), e);
        fireDataStatusEEvent(msg, e.getLocalizedMessage(), true);
        return SAVE_ERROR;
    } finally {
        DB.close(rs, pstmt);
        rs = null;
        pstmt = null;
    }
    //	everything ok
    m_rowData = null;
    m_changed = false;
    m_compareDB = true;
    m_rowChanged = -1;
    m_newRow = -1;
    m_inserting = false;
    fireDataStatusIEvent("Saved", "");
    //
    log.info("fini");
    return SAVE_OK;
}

Example 10 with PropertyVetoException

use of java.beans.PropertyVetoException in project intellij-community by JetBrains.

the class DateFilterComponent method setAfter.

public void setAfter(final long afterTs) {
    myUseDateAfterFilter.setSelected(true);
    try {
        myDateAfter.setDate(new Date(afterTs));
        myDateAfter.setEnabled(true);
    } catch (PropertyVetoException e) {
    //
    }
}