db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ruben Fonseca <rubenfons...@di.uminho.pt>
Subject Re: Store very large Strings
Date Fri, 13 Apr 2007 14:28:27 GMT
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
> 
> 


Mime
View raw message