Hello,
I have a problem with importing xml file(UTF-8 encoding) to MS SQL Database to table column as Data Type “XML”
I use “XML reader” and “Database Writer” (Database connector)
ERROR Database Writer 0:48 Execute failed: java.lang.Exception: Error while adding row #2 (Row0), reason: XML parsing: line 1, character 38, unable to switch the encoding
Where is the problem ? Could you help me?
Database Connector settings
jdbc:sqlserver://;Database=;integratedSecurity=true
Thanks
Martin