Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!news-lei1.dfn.de!news1.uni-leipzig.de!fu-berlin.de!uni-berlin.de!not-for-mail
From: "Cookie Monster" <cookie.monster@somewhere.com>
Newsgroups: comp.databases.oracle.misc
Subject: Writing Clobs with the thin driver
Date: Thu, 11 Nov 2004 13:16:03 +0100
Lines: 23
Message-ID: <2vh3g4F2kmf5sU1@uni-berlin.de>
X-Trace: news.uni-berlin.de PptS+h6Aqgv1IOyL0q2nQAjrYl8YMG9KXNqI9M6hfJ394xRvI=
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:114158

Hi,

I have a problem with the oracle thin driver writing clobs greater then 4000
chars.  Basically using the oci driver the following java code works fine:

PreparedStatement statement;
  Reader bodyReader = null;
  try {
   bodyReader = new StringReader(parameter.toString());
   statement.setCharacterStream(1,bodyReader,parameter.toString().length());
  } catch (Exception e) {
   e.printStackTrace();
   throw new SQLException("Failed to set text field.");
  }

But when using with the thin driver nothing gettings written to the clob.
Does anyone know a solution to this problem where I can use the thin driver
for writing clobs??

Thanks,
Steve.