InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

markus

Do you do any garbage collection?
Have you tried running with more virtual memory allocated to the JVM?

Regards

Pete

--

Peter Hearty                         peter.hearty@lutris.com
Lutris Technologies (UK)        http://www.lutris.com
----- Original Message -----
From: "Markus Strickler" <mstrickler@gmx.de>
To: <instantdb@enhydra.org>
Sent: Wednesday, September 20, 2000 12:45 AM
Subject: InstantDB: Help on TEXT datatype


> Hi!
>
> I'm still struggling with getting large (> ~30K) chunks of character data
> into an InstantDB database.
>
> I'm compeltely at a loss on how to do so.
> I created a table with TEXT fields, inserting works quite fine as long as
> the data inserted is small (just below 34000 characters approx.). If it's
> larger than that, memory usage will peak, util the app quits with an
> OutOfMemory Exception:
>
> java.lang.OutOfMemoryError:
> at java.lang.StringBuffer.copy(StringBuffer.java:164)
> at java.lang.StringBuffer.setLength(StringBuffer.java:254)
> at org.enhydra.instantdb.db.tokenList.endOfToken(tokenList.java:173)
> at org.enhydra.instantdb.db.tokenList.parseTokens(tokenList.java:230)
> at org.enhydra.instantdb.db.tokenList.(tokenList.java:98)
> at org.enhydra.instantdb.db.matchedTokens.setParam(matchedTokens.java:324)
> at org.enhydra.instantdb.db.SQLProg.setParam(SQLProg.java:162)
> at
>
org.enhydra.instantdb.jdbc.idbPreparedStatement.set(idbPreparedStatement.jav
> a:249)
> at
>
org.enhydra.instantdb.jdbc.idbPreparedStatement.setObject(idbPreparedStateme
> nt.java:242)
> at
>
org.enhydra.instantdb.jdbc.idbPreparedStatement.setObject(idbPreparedStateme
> nt.java:227)
>
> I'm using a prepared statement and tried the setString, and the setObject
> methods (the latter with java.sql.types.VARCHAR as well as with
> java.sql.types.LONGVARCHAR) with just the same results.
>
> What am I doing wrong? What would be the correct way to store TEXT data?
>
> -markus
>
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.