Unable to use Obj-Save with date data type to External database
An error is encountered when trying to write to external DB2 table from Pega 7.1.7 using Obj-Save. Pega is running on Oracle 11g.
The DB2 table has a column defined as Date and Pega 7.1.7 has corresponding Date property.
Problem saving instance of class PEGA-FW-CLASS: code: -4474 SQLState: <none> Message: [jcc][4.19.26] Illegal conversion: can not convert from "java.lang.int" to "java.sql.Date" ERRORCODE=-4474, SQLSTATE=null
Steps to Reproduce
1. Create a data class and have it mapped to an external DB2 table.
2. Create an activity that uses Obj-Save to write to the DB2 table.
3. Run the activity.
A defect in Pegasystems’ code or rules. The issue occurs when a class is mapped to a table in external database which is not same as the database hosting Pega. External database is DB2 and table has a Date column.
Apply HFix-23317 to resolve this issue.
Published August 27, 2015 - Updated October 8, 2020
Was this useful?
0% found this useful
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.