Clob datatype update

I am having trouble with an insert statement. I am trying to
update an oracle db clob data type, my insert statement will work
fine if the form field is less than 8000 chararcters (which is the
varchar2 limit) anything after this will insert a blank field (no
data) into the clob column and the page throws the following error:



Io exception: Connection reset



Again this only happens if the field contains more than 8000
characters, less then this everything works as it should.



I double checked the db and it is indeed a clob field. I am
using cfqueryparam with cfsqltype set to cf_sql_clob. Any
ideas?Clob datatype update
Which driver are you using to connect to the Oracle DB and
which version of CF? There are known issues with the Oracle thin
drivers. It's been a while, but the fix may be switching to Merant
or some ODBC drivers, which of course have their own side effects
(ODBC is slower). I would look into your drivers for
starters.Clob datatype update
Take a look at your data source's advanced settings in the CF
administrator. Verify that CLOBs are enabled.
It is currently using the jdbc:oracle:thin driver and yes the
clobs are enabled.
What are the issues with the oracle thin drivers?
Honestly it's been a long time and the last time I ran into
this issue was CF5 so my information could be out of date. But I
know the fix was to switch drivers. You could probably Google and
find some information?



For your update statement, you should also make sure you use
''cf_sql_clob'' as the type like so:



%26lt;cfqueryparam cfsqltype=''cf_sql_clob''
value=''#Variables.myValue#'' /%26gt;
Yeah, I did a google search and will have to continue to dig
through the results, also my cfqueryparam is setup as you
mentioned.
I'm pretty sure it's a driver issue. If this is in a test
environment perhaps you could switch drivers real quick and see if
it makes a difference? That would be a solid indicator right
there.
Thanks Wiliam, I do have a a testing environment and db that
I can test this out on.