Writing large amounts of data into a field of an Oracle database seems to raise some difficulties. The VARCHAR2 datatype is limited to 2K (or 4K) bytes, so you get into LOB (or CLOB or BLOB) datatypes. Then you run into problems with how to uses these datatypes from jdbc as well as more mysterious problems with speed and size limits.
Writing LOB fields in JDBC
Two-phase write
Consists of a
- 1 write of the row without the LOB field 1 a select for update 1 getting the stream of the LOB field 1 writing to that stream 1 performing an update.
Further explanation ToBeWritten
One-phase write
Speed Issues
Size Issues
Random notes:
A [http://www.theserverside.com/discussions/thread.tss?thread_id=30048 thread on The Server Side] mentions that
- Oracle thin drivers prior to version 10 seem to have a size-limit problem.
- You can use the Oracle 10.1.0.4 JDBC thin driver against the Oracle 9i database.
- Oracle OCI drivers don't seem to have the same problem.
Philip Greenspun on [http://www.eveandersson.com/arsdigita/books/sql/limits.html Oracle limits] (mostly 8i)