XML Insert to SQL Database

This topic has 1 reply, 2 voices, and was last updated 6 years, 7 months ago by Jim Kosloskey.

Creator

Topic
January 31, 2018 at 6:55 pm #55601

Jon Melin
Participant

Hello,

We are trying to use the Cloverleaf outbound database protocol (Built in JDBC connector in Cloverleaf 6.1 on Windows) to dump some XML to a field in a MS SQL server database. The problem is that the XML contains embedded special characters like
Creator

Topic

Viewing 0 reply threads

Author

Replies
- January 31, 2018 at 7:56 pm #85879
  
  Jim Kosloskey
  Participant
  
  I cannot offer anything but a potential workaround and an observation.
  
  The potential workaround involves base64 encoding the XML prior to insertion.
  
  The observation is there may have been updates to the JDBC protocol in later releases of Cloverleaf.
  
  Perhaps open a ticket with Infor.
  
  Maybe another user has better insight.
  
  email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
Author

Replies

Viewing 0 reply threads

The forum ‘Cloverleaf’ is closed to new topics and replies.