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

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.