Question

1
Replies
194
Views
Artsiom_Sukhanau Member since 2014 17 posts
Belvnesheconombank
Posted: 1 year ago
Last activity: 1 year 8 months ago
Closed
Solved

Unknown type JDBC Type 2004

Hi all!

Tell me please what I need to configure in my own external table to save BLOB?

Table columns is

ID (Autoincrement), DEALID, MESSAGECODE, PZPVSTREAM, CREATEDDATETIME (Current timestamp), PZINSKEY

Steps of my activity is

1) Page-New create page of class that map to table

2) Property-Set

a. .DealID = "AA-123" (This field is exposed)

b. .MessageCode = "121" (This field is exposed)

c. .MessageBody = "My test message" (This field is not exposed)

3) Obj-Save with Write now option

And on the third step I get an error "Database column MessageBody in database pegadata, table PRPC.TEMPTABLE has an unknown type: JDBC Type 2004".

I think that all exposed properties saved separately and all of other properties goes to BLOB column named PZPVSTREAM, but I was wrong...

Also can you tell me how I can read data from this field?

Thanks in advance!

Low-Code App Development Data Integration
Moderation Team has archived post
Share this page LinkedIn