junable
03-29-2006, 06:45
Hello all,
I'm using Oracle database (Oracle8i, v8.1.7.4.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.
Thanks,
JM
I'm using Oracle database (Oracle8i, v8.1.7.4.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.
Thanks,
JM