Forum Discussion

wwilbur's avatar
wwilbur
Occasional Contributor
3 years ago
Solved

java.sql.DataTruncation: Data truncation error

I am able to update and insert into a DB2 schema and table using DBeaver but when I try to do these in ReadyAPI I get the error message java.sql.DataTruncation: Data truncation error   Here is the ...
  • richie's avatar
    richie
    3 years ago

    Hey wwilbur 

     

    In that case there's some problem with the propertyexpansion I'm guessing.

     

    Only thing I can suggest to diagnose is try doing the simplest INSERT and repeatedly swap out expanded values across the different table attributes to identify the problematic attribute value (I'm assuming here that the problem isn't EVERY single attribute).

     

    So - I'd do the following:

    Step1: hardcode all the values excepting 1 attribute (where you expand), run the steps and check the results

    Step2: move to the next attribute value and repeat Step1 process

    Step3: continue until you've covered off all the attributes

     

    Cheers,

     

    Rich 

wwilbur's avatar
wwilbur
Occasional Contributor
3 years ago

If I hard code the values I am able to update and insert into the table but if I try to use parameters it gives me the data truncation error. I verified the data in the parameters was the correct length or shorter.

  • richie's avatar
    richie
    Community Hero
    3 years ago

    Hey wwilbur 

     

    In that case there's some problem with the propertyexpansion I'm guessing.

     

    Only thing I can suggest to diagnose is try doing the simplest INSERT and repeatedly swap out expanded values across the different table attributes to identify the problematic attribute value (I'm assuming here that the problem isn't EVERY single attribute).

     

    So - I'd do the following:

    Step1: hardcode all the values excepting 1 attribute (where you expand), run the steps and check the results

    Step2: move to the next attribute value and repeat Step1 process

    Step3: continue until you've covered off all the attributes

     

    Cheers,

     

    Rich