Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue while trying to update using ATP adapter using the option "Run Sql Statement"

in Integration 1 comment

Summary:

Unable to use update query in Run Sql Statement option under ATP adapter

Content (please ensure you mask any confidential information):

I selected the Run Sql Statement option and added the below update query

update XXSOL_ORD_CKPIT_HDR_STG set REQUESTED_SHIP_DATE= #pdate where record_id= #p_rec_id
Though values get assigned, It causes below error.

Pure SQL Exception.\nPure SQL Execute of update XXSOL_ORD_CKPIT_HDR_STG set REQUESTED_SHIP_DATE= ? where record_id= ? failed.\nCaused by Exception [EclipseLink-3001] (Eclipse Persistence Services - 2.6.7.v20230512-ce26847): org.eclipse.persistence.exceptions.ConversionException\nException Description: The object [18-APR-24], of class [class java.lang.String], could not be converted to [class java.sql.Timestamp].\nInternal Exception: BINDING.JCA-11635\nCould Not Convert Date Exception.\nUnable to convert a string value in the xml to a java.sql.Date.\nEven though databases accept strings representing dates in a variety of formats, the adapter only accepts strings representing dates in xml ISO date format.\nThe input value must be in the iso 8601 date format YYYY-MM-DD.\n.\nCheck to ensure that the database object(table,view) exists and all

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!