Updating clob how to start speed dating
One thing I don't under stand is the error log says "Error looking up row in database" but this is a Insert/Update.
I even tried setting "Don't perform and updates" since I am only trying to insert now.
We are using Oracle Native (JDBC) connections and insert quite a bit into CLOB fields without any issues.
This might not help a bit, but just to start simple, are you using the latest JDBC (ojdbc14orai18n.jar)?
Hi desperado, you need to indicate to kettle that you want to use a clob instead of a normal string.
The way is to set the field lenght to 9999999 (for example in Excel Input step) :-) and kettle will consider this field to a clob when targeting database.
The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning.
So now my transform uses a table input selecting a CLOB and inserting into the same table in another database with same schema but empty and I still get this error. This might not help a bit, but just to start simple, are you using the latest JDBC (ojdbc14orai18n.jar)?
Your dynamic SQL is trying to concatenate the CLOB as part of the SQL statement, turning it into a string literal.
If dynamic SQL were required, you'd need to use bind variables.
One field in EO and three in the Community Characterization tables (COMM_CAG, COMM_CAN, COMM_CAS, and COMM_CAL) were lengthened from 4000 characters to unlimited data in Biotics 5.5, which means the Oracle datatype changed from VARCHAR2 to CLOB.
They are: EO: DIRECTIONS COMM_CAx: L_/G_/N_/S_ENVIRONMENTAL_SUM L_/G_/N_/S_VEGETATION_SUM L_G_/N_/S_DYNAMIC_PROCESSES_SUM Your data in these fields was not affected, however, any Crystal Reports which reference these fields will need to be updated.
We are using Oracle Native (JDBC) connections and insert quite a bit into CLOB fields without any issues. I see ojdbc14as well as orai18in my Kettle install path .../data-integration/libext/JDBC along with many other jars.