- This topic has 16 replies, 3 voices, and was last updated 17 years, 1 month ago by
.
-
Posts
-
I am having a similar problem as is described in this thread:
https://www.genuitec.com/forums/topic/myeclipse-5-0-m2-amp-ga-and-db-explorer-quot-edit-data/
When I try to do “Edit data” for any table in PostgreSQL databases the following error is displayed: “Error: Cannot edit: null”. If I enter a valid WHERE condition to the edit tab, the error is: “Error: not valid sql statement: null”. If the WHERE condition is invalid the error is: “Error: not valid sql statement: ERROR: syntax error at end of input”.
The database is PostgreSQL 8.04 and the driver is postgresql-8.1-407.jdbc3.jar. I tried to fix the problem by reinstalling Eclipse, MyEclipse and creating the database connections from scratch but this had no effect. Older MyEclipse 5.0+Eclipse 3.2 works fine with the same connections.
The following exception log appears in the logfile when I try to do “Edit data”:
!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2007-07-27 12:54:23.059 !MESSAGE Error opening edit view !STACK 0 java.lang.NullPointerException at java.util.Properties$LineReader.readLine(Unknown Source) at java.util.Properties.load(Unknown Source) at java.util.PropertyResourceBundle.<init>(Unknown Source) at com.sun.rowset.JdbcRowSetResourceBundle.<init>(Unknown Source) at com.sun.rowset.JdbcRowSetResourceBundle.getJdbcRowSetResourceBundle(Unknown Source) at com.sun.rowset.JdbcRowSetImpl.<init>(Unknown Source) at com.genuitec.eclipse.sqlexplorer.views.EditDataView$3.<init>(EditDataView.java:278) at com.genuitec.eclipse.sqlexplorer.views.EditDataView.getRowSet(EditDataView.java:278) at com.genuitec.eclipse.sqlexplorer.views.EditDataView$1.run(EditDataView.java:121) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67) at com.genuitec.eclipse.sqlexplorer.views.EditDataView.createEditArea(EditDataView.java:117) at com.genuitec.eclipse.sqlexplorer.actions.TableDirectEditInView.run(TableDirectEditInView.java:72) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:153) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:504) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:443) at org.eclipse.equinox.launcher.Main.run(Main.java:1169)A valid WHERE condition results in the following exception log:
!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2007-07-27 13:04:02.255 !MESSAGE Error in where condition !STACK 0 java.lang.NullPointerException at java.util.Properties$LineReader.readLine(Unknown Source) at java.util.Properties.load(Unknown Source) at java.util.PropertyResourceBundle.<init>(Unknown Source) at com.sun.rowset.JdbcRowSetResourceBundle.<init>(Unknown Source) at com.sun.rowset.JdbcRowSetResourceBundle.getJdbcRowSetResourceBundle(Unknown Source) at com.sun.rowset.JdbcRowSetImpl.<init>(Unknown Source) at com.genuitec.eclipse.sqlexplorer.views.EditDataView$3.<init>(EditDataView.java:278) at com.genuitec.eclipse.sqlexplorer.views.EditDataView.getRowSet(EditDataView.java:278) at com.genuitec.eclipse.sqlexplorer.views.EditDataView$5.run(EditDataView.java:468) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67) at com.genuitec.eclipse.sqlexplorer.views.EditDataView.updateWhereCondition(EditDataView.java:465) at com.genuitec.eclipse.sqlexplorer.actions.directedit.SQLCompositeView$2.widgetSelected(SQLCompositeView.java:96) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:153) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:504) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:443) at org.eclipse.equinox.launcher.Main.run(Main.java:1169)Also, when I start the MyEclipse the following error appears in the log file. I don’t know if this is related to my problem:
!SESSION 2007-07-27 11:53:51.697 ----------------------------------------------- eclipse.buildId=I20070625-1500 java.version=1.5.0_11 java.vendor=Sun Microsystems Inc. BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_FI Framework arguments: -product com.genuitec.myeclipse.product.ide Command-line arguments: -os win32 -ws win32 -arch x86 -product com.genuitec.myeclipse.product.ide !ENTRY org.eclipse.ui.workbench 2 0 2007-07-27 11:54:01.072 !MESSAGE A handler conflict occurred. This may disable some commands. !SUBENTRY 1 org.eclipse.ui.workbench 2 0 2007-07-27 11:54:01.072 !MESSAGE Conflict for 'AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.procedureTypeNodeContribution/com.genuitec.eclipse.sqlexplorer.actions.RefreshTypeNodeAction': HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.procedureTypeNodeContribution/com.genuitec.eclipse.sqlexplorer.actions.RefreshTypeNodeAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.actions.RefreshTypeNodeAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.procedureTypeNodeContribution/com.genuitec.eclipse.sqlexplorer.actions.RefreshTypeNodeAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.actions.RefreshTypeNodeAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) !SUBENTRY 1 org.eclipse.ui.workbench 2 0 2007-07-27 11:54:01.072 !MESSAGE Conflict for 'AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mysql.procedureNodeActions/com.genuitec.eclipse.sqlexplorer.mysql.actions.editNodeAction': HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mysql.procedureNodeActions/com.genuitec.eclipse.sqlexplorer.mysql.actions.editNodeAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.mysql.actions.EditNodeAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mysql.procedureNodeActions/com.genuitec.eclipse.sqlexplorer.mysql.actions.editNodeAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.mysql.actions.EditNodeAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) !SUBENTRY 1 org.eclipse.ui.workbench 2 0 2007-07-27 11:54:01.072 !MESSAGE Conflict for 'AUTOGEN:::ValidationMenuAction/ValidationAction': HandlerActivation(commandId=AUTOGEN:::ValidationMenuAction/ValidationAction, handler=ActionDelegateHandlerProxy(null,org.eclipse.wst.validation.internal.ui.ValidationMenuAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) HandlerActivation(commandId=AUTOGEN:::ValidationMenuAction/ValidationAction, handler=ActionDelegateHandlerProxy(null,org.eclipse.wst.validation.internal.ui.ValidationMenuAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) !SUBENTRY 1 org.eclipse.ui.workbench 2 0 2007-07-27 11:54:01.072 !MESSAGE Conflict for 'AUTOGEN:::org.eclipse.jst.ws.internal.consumption.ui.wizard.client.genwsil/org.eclipse.jst.ws.consumption.ui.wsilimport': HandlerActivation(commandId=AUTOGEN:::org.eclipse.jst.ws.internal.consumption.ui.wizard.client.genwsil/org.eclipse.jst.ws.consumption.ui.wsilimport, handler=ActionDelegateHandlerProxy(null,org.eclipse.wst.command.internal.env.ui.widgets.popup.DynamicPopupWizard), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) HandlerActivation(commandId=AUTOGEN:::org.eclipse.jst.ws.internal.consumption.ui.wizard.client.genwsil/org.eclipse.jst.ws.consumption.ui.wsilimport, handler=ActionDelegateHandlerProxy(null,org.eclipse.wst.command.internal.env.ui.widgets.popup.DynamicPopupWizard), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) !SUBENTRY 1 org.eclipse.ui.workbench 2 0 2007-07-27 11:54:01.072 !MESSAGE Conflict for 'AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.procedureNodeActions/com.genuitec.eclipse.sqlexplorer.mssql.runFunctionAction': HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.procedureNodeActions/com.genuitec.eclipse.sqlexplorer.mssql.runFunctionAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.mssql.actions.RunMssqlFunctionProcedureAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.procedureNodeActions/com.genuitec.eclipse.sqlexplorer.mssql.runFunctionAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.mssql.actions.RunSybaseFunctionProcedureAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) !SUBENTRY 1 org.eclipse.ui.workbench 2 0 2007-07-27 11:54:01.072 !MESSAGE Conflict for 'AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mysql.triggerNodeActions/com.genuitec.eclipse.sqlexplorer.mysql.openTriggerAction': HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mysql.triggerNodeActions/com.genuitec.eclipse.sqlexplorer.mysql.openTriggerAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.mysql.actions.OpenTriggerAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mysql.triggerNodeActions/com.genuitec.eclipse.sqlexplorer.mysql.openTriggerAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.mysql.actions.OpenTriggerAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) !SUBENTRY 1 org.eclipse.ui.workbench 2 0 2007-07-27 11:54:01.072 !MESSAGE Conflict for 'AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.triggerNodeActions/com.genuitec.eclipse.sqlexplorer.mssql.openTriggerAction': HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.triggerNodeActions/com.genuitec.eclipse.sqlexplorer.mssql.openTriggerAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.mssql.actions.OpenTriggerAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.triggerNodeActions/com.genuitec.eclipse.sqlexplorer.mssql.openTriggerAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.mssql.actions.OpenTriggerAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) !SUBENTRY 1 org.eclipse.ui.workbench 2 0 2007-07-27 11:54:01.072 !MESSAGE Conflict for 'AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.procedureNodeActions/com.genuitec.eclipse.sqlexplorer.mssql.editProcedureAction': HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.procedureNodeActions/com.genuitec.eclipse.sqlexplorer.mssql.editProcedureAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.mssql.actions.EditMssqlNodeAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.procedureNodeActions/com.genuitec.eclipse.sqlexplorer.mssql.editProcedureAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.mssql.actions.EditMssqlNodeAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) !SUBENTRY 1 org.eclipse.ui.workbench 2 0 2007-07-27 11:54:01.072 !MESSAGE Conflict for 'AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.procedureNodeActions/com.genuitec.eclipse.sqlexplorer.mssql.spHelpAction': HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.procedureNodeActions/com.genuitec.eclipse.sqlexplorer.mssql.spHelpAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.mssql.actions.MssqlSpHelpAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384) HandlerActivation(commandId=AUTOGEN:::com.genuitec.eclipse.sqlexplorer.mssql.procedureNodeActions/com.genuitec.eclipse.sqlexplorer.mssql.spHelpAction, handler=ActionDelegateHandlerProxy(null,com.genuitec.eclipse.sqlexplorer.mssql.actions.MssqlSpHelpAction), expression=WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow@bafdff),sourcePriority=16384)Hmm, because you are using 8.04, try using the 8.0 driver (8.0 Build 319) Link here: http://jdbc.postgresql.org/download/postgresql-8.0-319.jdbc3.jar
No effect, I get the same error with the 8.0 driver. I forgot to tell that the Preview-tab on the Table/Object Info window does show the table contents. Of course I can’t edit the data there.
Can you provide the DDL for the table you are trying to edit? in my own testing I am seeing some different problems as well.
Also do any of the fields that will be displayed during the Edit Data operation have null data in them? I noticed some problems with that in my own testing.
Sorry for the delay. Here is a DDL for one of the tables (the error is the same for any table):
create table "dev"."service"( "pk_service" int8 not null, "name" varchar(256) not null, "service" varchar(256) not null, constraint "service_pk" primary key ("pk_service") ); create unique index "service_pk" on "dev"."service"("pk_service");There are no nulls in this table data.
