topic Re: XML encoding in Talend Studio

XML encoding

Anonymous — Sat, 16 Nov 2024 12:59:24 GMT

Hi,
I have created XML file which I am passing to SQL database as string.
Everything look ok unitl my string comming to the SQL database procedure as string where I am having error below.
Is anyone having an idea what can be. Also you can see an image of my work.
Thanks
Z
Exception in component tMSSqlSP_2
java.sql.SQLException: XML parsing: line 1, character 44, unable to switch the encoding
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:561)

Re: XML encoding

Anonymous — Mon, 11 Apr 2011 23:31:34 GMT

Hi,
From Microsoft - http://support.microsoft.com/kb/232580. For other related posts do search on 'SQL server encoding'.
HTH

Re: XML encoding

Anonymous — Thu, 30 Jul 2015 19:08:20 GMT

I have been banging my head against the wall with the same issue loading raw XML into a MS SQL Server 2014 XML datatype column.
Changing the encoding of or removing the XML declaration line from the input file did not work.
Adding the following value to the jtds connection string ("Additional Parameters" option) worked. The setting of source file encoding and the xml declaration are irrelevant.
"sendStringParametersAsUnicode=false"
jtds options:
https://www.qint.de/joria/doc/jdbc/jtds.html
Screenshot of Talend MS SQL Server jdbc Connection properties

Re: XML encoding

David_Beaty — Wed, 29 Mar 2017 14:12:04 GMT

FYI - I've also found using the AdditionalParams option of "sendStringParametersAsUnicode=false" useful when updating table data withe US default collation level of "SQL_Latin1_General_CP1_CI_AS".
Without this, it often ignores any indexes and performs a full table scan.