Help for assertion failed error in handling editable TableViewer column data from and to database?

Greenhorn

Posts: 8

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi all,
In my project I would use the tableviewer to apply the capability to edit the data from database and update them back to the database through hibernate 3.2, and H2 database server mode , but assertion failed occors as below:

and the simple code is:

import java.text.SimpleDateFormat;
import java.util.List;

import org.eclipse.jface.viewers.CellEditor;
import org.eclipse.jface.viewers.ICellModifier;
import org.eclipse.jface.viewers.ILabelProviderListener;
import org.eclipse.jface.viewers.IStructuredContentProvider;
import org.eclipse.jface.viewers.ITableLabelProvider;
import org.eclipse.jface.viewers.TableViewer;
import org.eclipse.jface.viewers.TextCellEditor;
import org.eclipse.jface.viewers.Viewer;
import org.eclipse.swt.SWT;
import org.eclipse.swt.graphics.Image;
import org.eclipse.swt.layout.FillLayout;
import org.eclipse.swt.widgets.Display;
import org.eclipse.swt.widgets.Shell;
import org.eclipse.swt.widgets.Table;
import org.eclipse.swt.widgets.TableColumn;

import com.micromms.dao.hibernate.RepaymentDao;
import com.micromms.model.Repayment;

public class Demo {

private Table table;
	protected Shell shell;

public static void main(String[] args) {
		try {
			Demo window = new Demo();
			window.open();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

public void open() {
		final Display display = Display.getDefault();
		createContents();
		shell.open();
		shell.layout();
		while (!shell.isDisposed()) {
			if (!display.readAndDispatch())
				display.sleep();
		}
	}

protected void createContents() {
		shell = new Shell();
		shell.setLayout(new FillLayout());
		shell.setSize(500, 375);
		shell.setText("SWT Application");

final TableViewer tableViewer = new TableViewer(shell, SWT.BORDER|SWT.FULL_SELECTION);
		table = tableViewer.getTable();
		table.setLinesVisible(true);
		table.setHeaderVisible(true);

final TableColumn newColumnTableColumn = new TableColumn(table, SWT.NONE);
		newColumnTableColumn.setWidth(100);
		newColumnTableColumn.setText("ID");

final TableColumn rAccraul = new TableColumn(table, SWT.NONE);
		rAccraul.setWidth(100);
		rAccraul.setText("Returnable Accrual");

final TableColumn rPrinciple = new TableColumn(table, SWT.NONE);
		rPrinciple.setWidth(100);
		rPrinciple.setText("Returnable Priciple");

final TableColumn rDate = new TableColumn(table, SWT.NONE);
		rDate.setWidth(100);
		rDate.setText("Date");
		
		
		tableViewer.setContentProvider(new IStructuredContentProvider(){
			public void dispose() {}
			public void inputChanged(Viewer viewer, Object oldInput, Object newInput) {}
			public Object[] getElements(Object inputElement) {
				if (inputElement instanceof List) {
					return ((List<Repayment>)inputElement).toArray();
				}
				return null;
			}
		});
		
		tableViewer.setLabelProvider(new ITableLabelProvider(){

public Image getColumnImage(Object element, int columnIndex) {
				return null;
			}

public String getColumnText(Object element, int columnIndex) {
				Repayment repayment = null;
				SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
				if (element instanceof Repayment) {
					repayment = (Repayment)element;
				}
				if (columnIndex == 0) {
					return repayment.getId().toString();
				}else if (columnIndex == 1) {
					return repayment.getReturnableAmountAccrual().toString();
				}else if (columnIndex == 2) {
					return repayment.getReturnableAmountPrincipal().toString();
				}else if (columnIndex == 3) {
					return simpleDateFormat.format(repayment.getReturnableDate());
				}
				return null;
			}

public void addListener(ILabelProviderListener listener) {
			}
			public void dispose() {
			}
			public boolean isLabelProperty(Object element, String property) {
				return false;
			}
			public void removeListener(ILabelProviderListener listener) {
			}
			
		});
		
		tableViewer.setInput(new RepaymentDao().findByLoan(38));
		tableViewer.setCellEditors(new CellEditor[]{null, new TextCellEditor(table),new TextCellEditor(table),new TextCellEditor(table)});
		tableViewer.setColumnProperties(new String[]{"A","B","C","D"});
		tableViewer.setCellModifier(new ICellModifier(){

public boolean canModify(Object element, String property) {
				return true;
			}

public Object getValue(Object element, String property) {
				
				Repayment repay = (Repayment)element;
				
				if ("B".equals(property)) {
					return repay.getReturnableAmountAccrual();
				}else if ("C".equals(property)) {
					return repay.getReturnableAmountPrincipal();
				}else if ("D".equals(property)) {
					return repay.getReturnableDate();
				}
				return "";
			}

public void modify(Object element, String property, Object value) {
				TableItem item = (TableItem) element;
				Repayment repayment = (Repayment)item.getData();
				
				
				
				if ("B".equals(property)) {
					repayment.setReturnableAmountAccrual(Double.parseDouble(value.toString()));
				}else if ("C".equals(property)) {
					repayment.setReturnableAmountPrincipal(Double.parseDouble(value.toString()));
				}else if ("D".equals(property)) {
					repayment.setReturnableDate(repayment.getReturnableDate());
				}
				tableViewer.refresh();
			}
			
		});
	}

}

and the table structure is as below:

create table "FMS"."PUBLIC"."REPAYMENT"(
        "ID" INTEGER default '(NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_7D8F94F6_FC15_4DA9_9F67_6EF7682F7EB2)' not null,
       "LOANID" INTEGER,
       "RETURNABLE_AMOUNT_ACCRUAL" DOUBLE(17),
       "RETURNABLE_AMOUNT_PRINCIPAL" DOUBLE(17),
       "RETURNABLE_DATE" TIMESTAMP,
       "REAL_AMOUNT" DOUBLE(17) default '0',
       "REAL_DATE" TIMESTAMP,
       "MEMO" VARCHAR(3000),
       "ACTIVE" INTEGER,
       "CREATE_DATE" TIMESTAMP,
        constraint "CONSTRAINT_79" primary key ("ID")
    );

alter table "FMS"."PUBLIC"."REPAYMENT"  
        add constraint "CONSTRAINT_798" 
        foreign key ("LOANID") 
        references "FMS"."PUBLIC"."LOAN"("ID") 
        on delete restrict  
        on update restrict ;
    alter table "FMS"."PUBLIC"."REPAYMENT"  
        add constraint "CONSTRAINT_7984" 
        foreign key ("LOANID") 
        references "FMS"."PUBLIC"."LOAN"("ID") 
        on delete restrict  
        on update restrict ;
    create unique index "FMS"."PRIMARY_KEY_79" on "FMS"."PUBLIC"."REPAYMENT"("ID");
    create index "FMS"."CONSTRAINT_INDEX_7" on "FMS"."PUBLIC"."REPAYMENT"("LOANID");