Re: clobs and blobs

From: Carl Smotricz (carl.smotricz_at_t-online.de)
Date: 07/27/04


Date: Tue, 27 Jul 2004 18:56:22 +0200

You may not need to. I think many databases will let you write CLOBs by
using PreparedStatement.setString() with strings of any size you care to
use, or setCharacterStream(); and BLOBs perhaps can be filled with
setBinaryStream().

No guarantees, but worth a try, I think.

-Carl-

MichaƂ wrote:

> Hi everyone!
>
> I want write new clobs and blobs to database. The problem is I don't
> know how to create Clob or Blob object. ResultSet.getClob(column)
> returns null, because db is empty.
>
> best regards
>
> - Michal -
>



Relevant Pages

  • Re: sdf
    ... I do load MDL's format for storing chemical compounds into Oracle ... databases. ... I use CLOBs to store them. ...
    (comp.databases.oracle.server)
  • Re: Tuning for CLOB usage
    ... CLOBs and BLOBs are deadly on performance ... Pretty sure there was no char set conversion going on. ... 4- do not even THINK of updating the LOB: ...
    (comp.databases.oracle.server)
  • Re: ER checksum routines - CLOB support?
    ... developerworks) you did implement smart blob checksums. ... with (NOT VARIANT, HANDLESNULLS, PARALLELIZABLE) ... Blobs and clobs can use the same checksum routine because internally they ...
    (comp.databases.informix)
  • =?iso-8859-1?q?Re:_Abfragen,_was_es_darau=DF_gemacht_hat=3F?=
    ... Die Idee ist garnicht so schlecht;) ... Außer Du updatest Datenbanken mit BLOBs oder CLOBs. ...
    (de.comp.lang.java)
  • Re: Delphi, Oracle 9i and CLOB
    ... doesn't handle CLOBs / BLOBs. ... The Oracle Provider for OLE DB does but ...
    (borland.public.delphi.database.ado)