Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 354477

Summary:	Column of type LONGVARBINARY can't be edited but results in unsupported data type exception
Product:	[Tools] Data Tools	Reporter:	Oliver Soehnges <Oliver.Soehnges>
Component:	Table Data Editor	Assignee:	dtp.sqldevtools-inbox <dtp.sqldevtools-inbox>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	P3	CC:	sslavic
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Windows 7
Whiteboard:

Description Oliver Soehnges

2011-08-11 07:24:58 EDT

Build Identifier: 20110615-0604 (Indigo)

We are using the table data editor for maintaining the records of a Fujitsu Symfoware database. Within one table there exists a column of type BLOB(1M) (:=binary data up to 1 megabyte) which will be mapped to the Java data type LONGVARBINARY. 

This data type seems not be supported by the DTP editor, because the "Data / Edit" operation results in the following error message:

"Cannot edit table. An unknown or unsupported data type encountered for column ..."

Unfortunately this problem stops the whole editor from working:
"Could not open the editor: An unexpected exception was thrown."

Stack trace (shortened):
java.lang.NullPointerException
	at org.eclipse.datatools.sqltools.data.internal.ui.editor.TableDataTableCursor.registerCellEditorsListener(TableDataTableCursor.java:110)
	at org.eclipse.datatools.sqltools.data.internal.ui.editor.TableDataTableCursor.<init>(TableDataTableCursor.java:41)
	at org.eclipse.datatools.sqltools.data.internal.ui.editor.TableDataTableCursorExternalEditingSupport.<init>(TableDataTableCursorExternalEditingSupport.java:46)
	at org.eclipse.datatools.sqltools.data.internal.ui.editor.TableDataEditor.createPartControl(TableDataEditor.java:124)
	at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:670)
	at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:465)
	at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:595)
	at org.eclipse.ui.internal.EditorReference.getEditor(EditorReference.java:289)
	at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditorBatched(WorkbenchPage.java:2945)
	at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:2850)
	at org.eclipse.ui.internal.WorkbenchPage.access$11(WorkbenchPage.java:2842)
	at org.eclipse.ui.internal.WorkbenchPage$10.run(WorkbenchPage.java:2793)
	at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
[...]

So my questions/requirements are as follows:

a. Is it as designed that LONGVARBINARY is not supported by the editor?
If yes: please support this data type as well...

b. In general if a data type is not supported it would be very helpful to open the editor with at least the remaining columns (instead of aborting with a NPE)

Reproducible: Always

Steps to Reproduce:
1. Create a Symfoware table with a column of type "BLOB(1M)"
   ALTER TABLE <Schema>.<Table> ADD <ColumnName> BLOB(1M);
2. Expand the table within the "Data Source Explorer"
3. Right click on table and invoke "Data / Edit"