Nicolas Arni-Bloch wrote:
I have try to deal with LOB and OJB but they are a of documentation.
The oracle LOB are pointer to the value, therefor with JDBC you can not
make a classic insert. The procedure to insert a LOB as 3 phases :
1) insert a record with empty_blob() or empty_clob()
2) make a select for update and call the getBlob() to obtain the
oracle.sql.BLOB
3) write or read with input/outputStream
Check out the Oracle9i platform implementation, which has got this stuff
incorporated. CLOB and BLOB objects of large sizes can be used with OCI or
THIN drivers for Oracle9i servers.
Batched mode only works with OCI (which unfortunately leaks memory beyond
usability on some Linux 2.4 kernels).
I have just caught up with this list after some weeks absence and have
seen some issues posted with the current Oracle9i platform driver:
* reflection lookups in managed environments fail
* possible issues with connection handling when concurrent thread access
to LOB-data occurs
* Oracle10 JDBC-driver compatibility not implemented
None of these issues should be huge development efforts, but I am personally
working on other projects and tight on time for free-time development.
(But I would like to get a stab at this as soon as possible.)
Unfortunately there doesn't seem to be a huge number of OJB developers
with an Oracle server installation at hand, so development can be a bit slow
at times - please contribute all you can.
Regards,
Martin
--
Martin Kal�n
Curalia AB Web: http://www.curalia.se
Orrspelsv�gen 2B Mail: [EMAIL PROTECTED]
SE-182 79 Stocksund Tel: +46-8-410 064 40
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
