writing clobs using oracle thin driver

[Cookie Monster]

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.

 

[Sudsy]

Cookie Monster wrote:

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??

Such a common problem that I wrote an article about it. You can find it here:
<http://www.sudsy.net/technology/clobs.html>

 

[steve]

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.

don't be lazy.
1.go look at the ask tom, section on the oracle website.
2. download the sample code from oracle website.
both are free.