Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 354477 - Column of type LONGVARBINARY can't be edited but results in unsupported data type exception
Summary: Column of type LONGVARBINARY can't be edited but results in unsupported data ...
Status: NEW
Alias: None
Product: Data Tools
Classification: Tools
Component: Table Data Editor (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows 7
: P3 normal with 1 vote (vote)
Target Milestone: ---   Edit
Assignee: dtp.sqldevtools-inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-08-11 07:24 EDT by Oliver Soehnges CLA
Modified: 2013-03-15 19:41 EDT (History)
1 user (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Oliver Soehnges CLA 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"