On Fri, 2007-04-13 at 07:22 -0700, Bryan Pendleton wrote:
> > problems when *reading* from the CLOB.. When I call the
> > ResultSet.getString on the CLOB I get a IOException thrown, when the
> > String is large... Is this a known problem?
>
> Might be a resource exhaustion problem. Can you print out the
> entire exception stack trace, including all chained exceptions,
> and enclose that information? Also, are you running embedded or
> in the client/server configuration?
I'm running the embedded version. I'm running version 10.2.2.0.
Full StackTrace:
java.sql.SQLException: An IOException was thrown when reading a
'java.sql.String' from an InputStream.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.getString(Unknown Source)
at org.pt.um.di.gepl.model.DBFile.<init>(DBFile.java:44)
at
org.pt.um.di.gepl.gui.SVGNodeGraph.buildDepGraph(SVGNodeGraph.java:51)
at
org.pt.um.di.gepl.gui.listeners.FileClickListener.handleEvent(FileClickListener.java:57)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1097)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3238)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2905)
at org.pt.um.di.gepl.gui.Gui.loop(Gui.java:117)
at org.pt.um.di.gepl.gui.Gui.main(Gui.java:126)
Caused by: java.sql.SQLException: An IOException was thrown when reading a
'java.sql.String' from an InputStream.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 14 more
java.lang.NullPointerException
at java.io.StringReader.<init>(StringReader.java:33)
at
org.pt.um.di.gepl.gui.SVGNodeGraph.createSVGNode(SVGNodeGraph.java:118)
at
org.pt.um.di.gepl.gui.SVGNodeGraph.buildDepGraph(SVGNodeGraph.java:53)
at
org.pt.um.di.gepl.gui.listeners.FileClickListener.handleEvent(FileClickListener.java:57)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1097)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3238)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2905)
at org.pt.um.di.gepl.gui.Gui.loop(Gui.java:117)
at org.pt.um.di.gepl.gui.Gui.main(Gui.java:126)
>
> If the exception indicates that you're running out of memory, can
> you try specifying more memory for your JVM and see if that fixes it?
I'm running Linux 2.6.20 and Sun JDK 6 (build 1.6.0-b105) 32 bits.
>
> And how large do you mean by "the String is large"?
According to DbVisualizer, it occupies 65Kb on the DB.
>
> thanks,
If you need more information, please ask :)
Thank you
Ruben
>
> bryan
>
>
