Clovertech
› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › XML Insert to SQL Database
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
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.
.
