I’m using Oracle database (Oracle8i, v126.96.36.199.0).
I have a JDBC Adapter set up to add record into a table (with a CLOB field).
For the CLOB field in the adapter service, I set input type as String.
The JDBC adapter happily converts this string to CLOB when the record is added.
However, when the string gets very large, I consistently get error
[ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service …
[ADA.1.316] Cannot execute the SQL statement
“(17410) No more data to read from socket”
No more data to read from socket.
I’m using JDK is 1.4.2 and I use classes12.zip (provided by Oracle).
Any one has encountered this error before when trying to add into a CLOB field?
What are the possible workarounds?
I read that some people have to write a custom Java service to manually write the CLOB field.
But the problem is I don’t know how to get the DB connection to start with.
What is your issue ? R u trying to connect to oracle database ?
It seems that some key words are preventing me from adding a thread so I have revised my original post.
In your JDBC adapter connection what is your driverType set to? thin or oci?
ex: Other Properties driverType=thin
You should try OCI conncetion for CLOB and BLOB objects as Jgray says.
It’s driverType=thin. I’ll use oci. Thanks.