Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Writing to CLOB with java

Re: Writing to CLOB with java

From: Patrick Joyal <please.reply_at_to.the.newsgroup>
Date: 2000/05/18
Message-ID: <3923eeef@news>#1/1

First of all, I don't know a thing about java. But what I can tell you is that we set a "Autocommit" property to false, you execute your SQL adding FOR UPDATE, and you create a stream object with GetCharacterStream.

hope that help

pat

US wrote in message <8fv07u$dmg_at_chronicle.concentric.net>...
>say, Patrick,
>Did you manage to find the solution for this problem? I"ve got *exactly*
 the
>same
>problem...
>
>US
>
>Patrick Joyal <please.reply_at_to.the.newsgroup> wrote in message
>news:3921a820_at_news...
>> Does someone have example of how to write
>> to CLOB fields in java, using streams?
>>
>> when opening the recordset using a ordinary SQL query, we got
>> a message saying "Row containing the LOB value is not locked".
>> if we use a FOR UPDATE query, we have a "fetch out of sequence" error.
>>
>> thanks
>>
>> Patrick
>>
>>
>>
>
>
Received on Thu May 18 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US