Updating clob how to start speed dating

Posted by / 15-Feb-2020 16:50

Updating clob

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.

updating clob-85updating clob-10updating clob-77

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.