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?
**this is the publish data that i have hardcoded in the pipeline
**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.