facebook
  1. MyEclipse Archived
    2.  > 
  2. Database Tools (DB Explorer, Hibernate, etc.)

MyEclipse 5.0 (M2 & GA) and db explorer :"Edit Data

  1. MyEclipse Archived
    2.  > 
  2. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 15 posts - 1 through 15 (of 19 total)
1 2
  • Author
    Posts
  • August 22, 2006 at 11:04 am #257377 Reply

    jayjaybee
    Member

    Hello,

    I use MyEclipse 5.0 + Eclipse 3.2 + Oracle 9i for database (classes12.jar for jdbc).

    When i try “Edit Data” of a table in MyEclipse Database Explorer perspective, it doesn’t work.

    More precisely, it opens a view named Edit table “SCHEMA_NAME”.”TABLE_NAME”. Though, at the bottom of it, an error message is written : Error: Cannot edit: null. This message always appears whatever the where condition i give (even it is left empty).

    In “Write your where condition” textfield, i then try to type a wrong syntax, the error message is different (Not Valid sql statement, of course).

    Last but not least, here is the stack trace associated to this problem :

    !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-08-22 18:02:27.984
    !MESSAGE Error opening edit view
    !STACK 0
    java.lang.NullPointerException
    at java.io.Reader.<init>(Reader.java:61)
    at java.io.InputStreamReader.<init>(InputStreamReader.java:80)
    at java.util.Properties.load(Properties.java:269)
    at java.util.PropertyResourceBundle.<init>(PropertyResourceBundle.java:96)
    at com.sun.rowset.JdbcRowSetResourceBundle.<init>()V(Unknown Source)
    at com.sun.rowset.JdbcRowSetResourceBundle.getJdbcRowSetResourceBundle()Lcom.sun.rowset.JdbcRowSetResourceBundle;(Unknown Source)
    at com.sun.rowset.JdbcRowSetImpl.<init>(Ljava.sql.ResultSet;)V(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.views.EditDataView.getRowSet(EditDataView.java:260)
    at com.genuitec.eclipse.sqlexplorer.views.EditDataView$1.run(EditDataView.java:114)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
    at com.genuitec.eclipse.sqlexplorer.views.EditDataView.createEditArea(EditDataView.java:110)
    at com.genuitec.eclipse.sqlexplorer.actions.TableDirectEditInView.run(TableDirectEditInView.java:72)
    at org.eclipse.jface.action.Action.runWithEvent(Action.java:499)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:539)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)
    at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:400)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
    at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1914)
    at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:419)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
    at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95)
    at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
    at jrockit.reflect.InitialMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)

    Any Ideas ? 🙂

    Thanks

    August 23, 2006 at 1:36 pm #257442 Reply

    Haris Peco
    Member

    jayjaybee,

    You have bad driver.You can try download jdbc for oracle9 (or oracle10 – it will work with oracle9 ) from
    http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

    choose ojdbc14.jar and add to your driver profile

    Best
    Peco

    September 4, 2006 at 7:52 am #258072 Reply

    jayjaybee
    Member

    Hello,

    I replaced classes12.jar by ojdbc14.jar. Then, i restarted eclipse and tried again.

    I Still have the same error message and edit data does not work.

    Any other idea ?

    Thank by in advance.

    JJB

    September 4, 2006 at 9:59 am #258075 Reply

    Haris Peco
    Member

    JJB,

    It is strange – I suppose that you have drivers or permissions problems

    Please, send me (if it is possible)
    – ddl for your table (right click on table and call Generate-DDL)

    Have you downloaded ojdbc14.jar from oracle site or use one from your distribution ?

    Please, check double if you have old jar included (it is better for test that you make new connection with ojdbc14.jar)

    Thanks
    Peco

    September 14, 2006 at 6:01 pm #258586 Reply

    Tony Herstell
    Participant

    I get this now.
    Was there a solution you found for this.
    I have removed and reattached the oracle driver file.

    September 18, 2006 at 7:12 pm #258724 Reply

    Tony Herstell
    Participant

    Anyone?
    Was there a solution found for this?

    September 18, 2006 at 7:21 pm #258725 Reply

    Tony Herstell
    Participant

    It happens with all the tables…

    September 19, 2006 at 3:14 am #258734 Reply

    Haris Peco
    Member

    Hello,

    Please send your jdbc version and ddl scipt for table

    Thanks

    October 3, 2006 at 3:52 pm #259792 Reply

    Tony Herstell
    Participant

    create table “X”.”CMR_UNIT”(
    “CMR_UNIT_ID” NUMBER not null,
    “CMR_UNIT_NAME” VARCHAR2(20) not null,
    constraint “SYS_C008923” primary key (“CMR_UNIT_ID”)
    );

    create unique index “X”.”SYS_C008923″ on “X”.”CMR_UNIT”(“CMR_UNIT_ID”);

    Oracle JDBC Driver
    9.2.0.3.0
    jdbc:oracle:thin:@ etc.

    Database is Oracle 9i Enterprise Edition Release 9.2.0.6.0

    October 3, 2006 at 3:53 pm #259793 Reply

    Tony Herstell
    Participant

    hope this helps

    October 3, 2006 at 5:05 pm #259796 Reply

    Haris Peco
    Member

    balanceofpower ,

    I can edit this table.Please, can you send error log (Windows-Show View-Other-PDE Runtime-Error Log view)

    Note : oracle jdbc driver (all versions) have bug for blob column , but this table work fine.
    You can’t insert new row with MyEclipse (for now) – you can only change/edit existing row.

    Best
    Peco

    October 3, 2006 at 5:40 pm #259802 Reply

    Tony Herstell
    Participant

    java.lang.NullPointerException
    at java.io.Reader.<init>(Unknown Source)
    at java.io.InputStreamReader.<init>(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.getRowSet(EditDataView.java:260)
    at com.genuitec.eclipse.sqlexplorer.views.EditDataView$1.run(EditDataView.java:114)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
    at com.genuitec.eclipse.sqlexplorer.views.EditDataView.createEditArea(EditDataView.java:110)
    at com.genuitec.eclipse.sqlexplorer.actions.TableDirectEditInView.run(TableDirectEditInView.java:72)
    at org.eclipse.jface.action.Action.runWithEvent(Action.java:499)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:539)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)
    at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:400)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
    at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1914)
    at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:419)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
    at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95)
    at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
    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.core.launcher.Main.invokeFramework(Main.java:336)
    at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
    at org.eclipse.core.launcher.Main.run(Main.java:977)
    at org.eclipse.core.launcher.Main.main(Main.java:952)

    eclipse.buildId=M20060629-1905
    java.version=1.4.2_03
    java.vendor=Sun Microsystems Inc.
    BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_NZ
    Framework arguments: -product com.genuitec.myeclipse.product.ide
    Command-line arguments: -os win32 -ws win32 -arch x86 -product com.genuitec.myeclipse.product.ide
    This is a continuation of log file C:\X\workspace\.metadata\.bak_0.log
    Created Time: 2006-09-19 18:35:50.981

    October 3, 2006 at 6:09 pm #259804 Reply

    Haris Peco
    Member

    I have tested with oracle jdbc 9.2.0.5 and 10.2.0.2 (latest oracle 10 driver) and your table work fine.

    However, based on your log, it looks like oracle jdbc bug.Oracle jdbc drivers have bug with DatabaseMetadata#getPrecision and DatabaseMetadata#getAutoIncrement (sometime oracle return wrong type for this methods, sometime throw exception …)
    You can try latest oracle driver ( http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html ) .It works better (for some tables), but
    have bugs, too.

    There is our PR about this problem and we will try make workaround for next release.

    Sorry for your inconvenience caused

    Best
    Peco

    October 3, 2006 at 8:32 pm #259806 Reply

    Tony Herstell
    Participant

    Driver : Oracle Database 10g Release 2 (10.2.0.2) JDBC Drivers is the most up to date I found…
    ojdbc14.jar (1,540,457 bytes) – classes for use with JDK 1.4 and 1.5
    Thanks for helping anyhow.

    Error
    Wed Oct 04 14:31:23 NZDT 2006
    Error opening edit view

    java.lang.NullPointerException
    at java.io.Reader.<init>(Unknown Source)
    at java.io.InputStreamReader.<init>(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.getRowSet(EditDataView.java:260)
    at com.genuitec.eclipse.sqlexplorer.views.EditDataView$1.run(EditDataView.java:114)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
    at com.genuitec.eclipse.sqlexplorer.views.EditDataView.createEditArea(EditDataView.java:110)
    at com.genuitec.eclipse.sqlexplorer.actions.TableDirectEditInView.run(TableDirectEditInView.java:72)
    at org.eclipse.jface.action.Action.runWithEvent(Action.java:499)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:539)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)
    at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:400)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
    at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1914)
    at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:419)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
    at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95)
    at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
    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.core.launcher.Main.invokeFramework(Main.java:336)
    at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
    at org.eclipse.core.launcher.Main.run(Main.java:977)
    at org.eclipse.core.launcher.Main.main(Main.java:952)

    October 3, 2006 at 9:00 pm #259807 Reply

    Haris Peco
    Member

    It is strange that it work for me.I know this jdbc bug and I can reproduce it with table which content blob column.
    Please, can you send me output from ‘Advanced ddl’ action and try to create same table (with other name) and call ‘edit data’.

    Best

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 19 total)
1 2
Reply To: MyEclipse 5.0 (M2 & GA) and db explorer :"Edit Data

You must be logged in to post in the forum log in