Hi Bryan,
Forgive my ignorance but here are the 2 stack-traces that were in the
derby.log. I was not able to deduce anything from the stack trace and
the only reason I am posting the stack trace (as much as I hate it) is
to see if somebody else can deduce anything useful from it.
I am looking into the ij command line utility. Appreciate your help.
Thanks,
Kal
2008-01-08 17:28:27.478 GMT Thread[main,6,main] (XID = 4008637),
(SESSIONID = 0), (DATABASE = B:\SeedTrakDB), (DRDAID = null), Failed
Statement is: select * from productorder
java.lang.ArrayIndexOutOfBoundsException: -1
at
org.apache.derby.impl.store.raw.data.BasePage.getHeaderAtSlot(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.restorePortionLongColumn
(Unknown Source)
at
org.apache.derby.impl.store.raw.data.OverflowInputStream.fillByteHolder(
Unknown Source)
at
org.apache.derby.impl.store.raw.data.OverflowInputStream.<init>(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.readRecordFromArray(Unkn
own Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.restoreRecordFromSlot(Un
known Source)
at
org.apache.derby.impl.store.raw.data.BasePage.fetchFromSlot(Unknown
Source)
at
org.apache.derby.impl.store.access.conglomerate.GenericScanController.fe
tchRows(Unknown Source)
at
org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unk
nown Source)
at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(
Unknown Source)
at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unk
nown Source)
at
org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown
Source)
at
org.eclipse.wst.rdb.internal.outputview.ResultTableModel.<init>(ResultTa
bleModel.java:91)
at
org.eclipse.wst.rdb.internal.outputview.OutputViewModel$OutputObject.add
TableModel(OutputViewModel.java:542)
at
org.eclipse.wst.rdb.internal.outputview.OutputViewModel.addResultAndPara
meters(OutputViewModel.java:204)
at
org.eclipse.wst.rdb.internal.outputview.OutputViewModel.addResult(Output
ViewModel.java:180)
at
org.eclipse.wst.rdb.internal.outputview.OutputViewAPI.showOutputContent(
OutputViewAPI.java:365)
at
org.eclipse.wst.rdb.internal.outputview.OutputViewAPI.showOutputContent(
OutputViewAPI.java:351)
at
org.eclipse.wst.rdb.server.internal.ui.query.execute.QueryOutputHelper.r
unSQLScrapbookQuery(QueryOutputHelper.java:136)
at
org.eclipse.wst.rdb.sqleditor.internal.actions.SQLRunAction.run(SQLRunAc
tion.java:231)
at
com.ibm.datatools.cloudscapeworkbench.actions.RunSQLAction.run(RunSQLAct
ion.java:20)
at
org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:246)
at
org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(Ac
tionContributionItem.java:538)
at
org.eclipse.jface.action.ActionContributionItem.access$2(ActionContribut
ionItem.java:488)
at
org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionCont
ributionItem.java:441)
at
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
at
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
at
org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:3
67)
at
org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at
com.ibm.datatools.cloudscapeworkbench.CloudscapeWorkbench.run(Cloudscape
Workbench.java:16)
at
org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActiva
tor.java:226)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:
376)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:
163)
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:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)
2008-01-08 17:35:21.728 GMT Thread[main,6,main] (XID = 4008643),
(SESSIONID = 0), (DATABASE = B:\SeedTrakDB), (DRDAID = null), Failed
Statement is: select * from productorder where orderid = 1346
java.lang.ArrayIndexOutOfBoundsException: -1
at
org.apache.derby.impl.store.raw.data.BasePage.getHeaderAtSlot(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.restorePortionLongColumn
(Unknown Source)
at
org.apache.derby.impl.store.raw.data.OverflowInputStream.fillByteHolder(
Unknown Source)
at
org.apache.derby.impl.store.raw.data.OverflowInputStream.<init>(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.readRecordFromArray(Unkn
own Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.restoreRecordFromSlot(Un
known Source)
at
org.apache.derby.impl.store.raw.data.BasePage.fetchFromSlot(Unknown
Source)
at
org.apache.derby.impl.store.access.conglomerate.GenericConglomerateContr
oller.fetch(Unknown Source)
at
org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowC
ore(Unknown Source)
at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unk
nown Source)
at
org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown
Source)
at
org.eclipse.wst.rdb.internal.outputview.ResultTableModel.<init>(ResultTa
bleModel.java:91)
at
org.eclipse.wst.rdb.internal.outputview.OutputViewModel$OutputObject.add
TableModel(OutputViewModel.java:542)
at
org.eclipse.wst.rdb.internal.outputview.OutputViewModel.addResultAndPara
meters(OutputViewModel.java:204)
at
org.eclipse.wst.rdb.internal.outputview.OutputViewModel.addResult(Output
ViewModel.java:180)
at
org.eclipse.wst.rdb.internal.outputview.OutputViewAPI.showOutputContent(
OutputViewAPI.java:365)
at
org.eclipse.wst.rdb.internal.outputview.OutputViewAPI.showOutputContent(
OutputViewAPI.java:351)
at
org.eclipse.wst.rdb.server.internal.ui.query.execute.QueryOutputHelper.r
unSQLScrapbookQuery(QueryOutputHelper.java:136)
at
org.eclipse.wst.rdb.sqleditor.internal.actions.SQLRunAction.run(SQLRunAc
tion.java:231)
at
com.ibm.datatools.cloudscapeworkbench.actions.RunSQLAction.run(RunSQLAct
ion.java:20)
at
org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:246)
at
org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(Ac
tionContributionItem.java:538)
at
org.eclipse.jface.action.ActionContributionItem.access$2(ActionContribut
ionItem.java:488)
at
org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionCont
ributionItem.java:441)
at
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
at
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
at
org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:3
67)
at
org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at
com.ibm.datatools.cloudscapeworkbench.CloudscapeWorkbench.run(Cloudscape
Workbench.java:16)
at
org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActiva
tor.java:226)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:
376)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:
163)
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:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)
-----Original Message-----
From: Bryan Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 08, 2008 1:30 PM
To: Derby Discussion
Subject: Re: SQLException: Restore of a serializable or SQLData object
of class , attempted to read more data than was originally stored
INUGANTI, KALYAN [AG-Contractor/1000] wrote:
> If there is a way to directly
> query the underlying Derby DB (without using the workbench), please
let
> me know.
Derby comes with a simple command-line tool called "ij":
http://db.apache.org/derby/docs/10.3/tools/ctoolsij34525.html
Regarding the exceptions you are receiving: try looking for a file
named "derby.log" in or around your database directory on disk,
and see if there is more detailed information about the errors
in the derby.log file.
http://db.apache.org/derby/docs/10.3/devguide/cdevdvlp25889.html
thanks,
bryan
---------------------------------------------------------------------------------------------------------
This e-mail message may contain privileged and/or confidential information, and
is intended to be received only by persons entitled to receive such
information. If you have received this e-mail in error, please notify the
sender immediately. Please delete it and all attachments from any servers, hard
drives or any other media. Other use of this e-mail by you is strictly
prohibited.
All e-mails and attachments sent and received are subject to monitoring,
reading and archival by Monsanto, including its subsidiaries. The recipient of
this e-mail is solely responsible for checking for the presence of "Viruses" or
other "Malware". Monsanto, along with its subsidiaries, accepts no liability
for any damage caused by any such code transmitted by or accompanying this
e-mail or any attachment.
---------------------------------------------------------------------------------------------------------
