Product/components used and version/fix level:

pub.jms:send, pub.jms:JMSMessage, Software AG 10.15

Detailed explanation of the problem:

My project is to consume data from a queue and ingest into database. I have tried pub.jms:send and pub.jms:JMSMessage in the input of my jdbc adapter service, it only able to consume the string column in the JMSMessage->body->string(string). When i use for JMSMessage->body->data(document list)

Error messages / full error message screenshot / log file:

inserted empty into db

Question related to a free trial, or to a production (customer) instance?

free trial

Picture references

image304×739 11.6 KB

**this is the input for my jdbc adapter service

**this is the string that i able to consume and ingest into db

**this is the document list that not able to consume and ingest empty into db

Are pub.jms:send and pub.jms:JMSMessage part of your requirement? If all you need to do is publish a document and then push the published documents to db using a trigger, then you can convert your document to publishable document and let integration server do the rest. pub.jms:send, pub.jms:JMSMessage services can also be used for the same purpose but they require higher level of understanding of the services and pub-sub pattern. Most of the times using a publishable document is enough and much easier to implement. Check this document for more information.

Link to the section about publishing a document.

You should use either “string” (-> JmsTextMessage) or “data” (JmsObjectMessage), not both.