textarea to CLOB/BLOB (not an obvious question at all)

I am currently working on a problem whereby a form on the clientside (HTML page) POSTs the contents of a textarea to my servlet. The servlet then stores the content of the textarea into a BLOB. Quite simple sounding at first ... it seems that one would be required to directly process the ServletInputStream and parse the data.

I have been churning over previous posts in these forums for about 2days now, over the last few years the question has been posted at least five times with no satisfactory answer.

(using getParameter() string cause practical problems as they would need to be huge and servers often raise exceptions at a certain length/heap usage). How would one process incredibly long textarea contents into a BLOB via JDBC?

Bamkin

please see:

http://forum.java.sun.com/thread.jspa?threadID=5145362&messageID=9540826

http://forum.java.sun.com/thread.jspa?threadID=575684&messageID=2878235

http://forum.java.sun.com/thread.jspa?threadID=556900&messageID=2732246

http://forum.java.sun.com/thread.jspa?threadID=5145694

http://forum.java.sun.com/thread.jspa?threadID=575684 (oracle specific)

[1173 byte] By [bamkin-ov-lestaa] at [2007-11-27 9:54:33]
# 1

from my little knowledge i think that when u r dealing with blob and clob data type u r usually limited by the maximum size the database provides for the data type eg 2GB etc and not by the text u r receiving. So u should look at d limit for d database u r using then if u r using US-ASCII encoding u can get the byte size of the text using getBytes("US-ASCII")

malino01a at 2007-7-13 0:24:29 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
The question regarded how to implement this; not what the limitations are
bamkin-ov-lestaa at 2007-7-13 0:24:29 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...