[redbend]

Hello

I work with myeclipse 5 and i tried to use the DB browser

database:oracle 10 g with ojdbc14.jar

I have some problems in view the tables data (not all the tables)

i get this errors (from the log):

!SESSION 2006-09-25 10:53:17.909 ———————————————–
eclipse.buildId=M20060629-1905
java.version=1.4.2_11
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Framework arguments: -product com.genuitec.myeclipse.product.ide
Command-line arguments: -os win32 -ws win32 -arch x86 -product com.genuitec.myeclipse.product.ide

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-09-25 11:25:22.246
!MESSAGE Error opening edit view
!STACK 0
java.lang.NumberFormatException: For input string: “4294967295”
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:480)
at java.lang.Integer.parseInt(Integer.java:518)
at oracle.jdbc.driver.OracleResultSetMetaData.getPrecision(OracleResultSetMetaData.java:303)
at com.sun.rowset.JdbcRowSetImpl.initMetaData(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(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
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)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-09-25 11:30:26.766
!MESSAGE Error opening edit view
!STACK 0
java.lang.NumberFormatException: For input string: “4294967295”
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:480)
at java.lang.Integer.parseInt(Integer.java:518)
at oracle.jdbc.driver.OracleResultSetMetaData.getPrecision(OracleResultSetMetaData.java:303)
at com.sun.rowset.JdbcRowSetImpl.initMetaData(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(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
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)

the problematic tables are:

create table DP_CACHE_TBL (
ID number(10,0) not null,
USED_TIME timestamp not null,
CRCS varchar2(256 char) not null,
COUNTER number(10,0) not null,
MANUFACTURER varchar2(32 char) not null,
MODEL varchar2(16 char) not null,
SIGNED_DP_FILE blob not null,
primary key (ID)
);

and :
create table COMPONENT_VERSION_TBL (
ID number(10,0) not null,
UUID varchar2(256 char),
VERSION varchar2(64 char) not null,
CONFIGURATION varchar2(256 char) not null,
DESCRIPTION varchar2(500 char),
RELEASE_NOTES_FILE blob,
RELEASE_NOTES_URL varchar2(256 char),
PLACE_HOLDER number(1,0) not null,
TARGET_TYPE varchar2(255 char),
COMPONENT_ID number(10,0),
MODEL_ID number(10,0),
primary key (ID)
);

The view in this table works fine:

create table COMPONENT_TBL (
ID number(10,0) not null,
NAME varchar2(64 char) not null,
VENDOR varchar2(64 char),
DESCRIPTION varchar2(256 char),
IS_PRIMARY number(1,0) not null,
PLACE_HOLDER number(1,0) not null,
primary key (ID)
);

Any Idea?

[Riyad Kalla]

Can you explain in more detail the problem? I’m not clear if you are just getting an exception in the log file, or if you are unable to view that table information, does it show up garbled? Do you get a popup? etc… please explain what you see from a user perspcetive that is wrong.

[Haris Peco]

redbend ,

This is bug in oracle jdbc driver – when client ask for precision on blob column oracle driver throw exception (NumberFormatException)
We will explore if it possible that make workaround for futures releases.

Best
Peco

[Author]

Posts