Non latin characer crash on integrating with MS SQL

[Alan]

Hi,

I'm trying to integrate with MS SQL 2008.

Thanks to your tech documents, It was successful to retrieve data from MS SQL server.

English is shown well. But Korean character(non-latin) show as "???"

I used "useUnicode=true;characterEncoding=UTF-8" in jdbc url. It still remains.

I changed characterset in connector design from --Automa-- to another charset. It still remains.

Can you tell me things that I have to check point?

* SQL in Content field to post data (please refer to attached screenshot)
{
"protocol": "JDBC",
"data": {
"DBType": "SQLSERVER_2005",
"sqlUsername": "sa",
"sqlPassword": "xxxxxx",
"sqlStatement": "SELECT * FROM TESTDB.dbo.Customers"
}
}

* JDBC.config
#DBAgent Configuration
SQLSERVER_2005 = {"sqlDriver" : "com.microsoft.sqlserver.jdbc.SQLServerDriver", "sqlSource" :
"jdbc:sqlserver://localhost;databasename=TESTDB;useUnicode=true&characterEncoding=UTF-8","sqlDriverPath" : "C:/\SEC/\drives_jdbc/\sqljdbc_4.1/\enu/\sqljdbc4.jar"}

Regards,
Alan.

[Pankaj Kumar]

Hi Alan,

Can you share the result/screen-print what you are getting in the connector result also can you check this corrector to invoking by another web-service tool to check whether the character is not parsed correctly in RunMyProcess or at other layer and share the result with us in order to get more detail on the issue.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/ad312de8-d86c-4b18-a65c-58b6fbd1905c%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Lee, Woo-Seok]

Hi Pankaj,

Thanks for your reply. I attached screenshot of the result from connector.

Also please refer to result JSON data.

Red box is Korean character.

If you need other configuration, please let me know.

{

  "result": "success",

  "rows": 5,

  "data": [

    {

      "Country": "Norway    ",

      "CustomerName": "Cardinal  ",

      "CustomerID": "11        ",

      "CommonName": null,

      "City": "Stavanger ",

      "ContactName": "Erichsen  ",

      "Address": "Skagen 21 ",

      "PostalCode": "4006      "

    },

    {

      "Country": "Norway    ",

      "CustomerName": "Cardinal  ",

      "CustomerID": "11        ",

      "CommonName": null,

      "City": "Stavanger ",

      "ContactName": "Erichsen  ",

      "Address": "Skagen 21 ",

      "PostalCode": "4006      "

    },

    {

      "Country": "Norway    ",

      "CustomerName": "Top       ",

      "CustomerID": "22        ",

      "CommonName": null,

      "City": "Stavanger ",

      "ContactName": "Erichsen  ",

      "Address": "Skagen 21 ",

      "PostalCode": "4006      "

    },

    {

      "Country": "Norway    ",

      "CustomerName": "Cardinal  ",

      "CustomerID": "777       ",

      "CommonName": null,

      "City": "Stavanger ",

      "ContactName": "???    ",

      "Address": "Skagen 21 ",

      "PostalCode": "4006      "

    },

    {

      "Country": "Norway    ",

      "CustomerName": "Cardinal  ",

      "CustomerID": "44        ",

      "CommonName": "???",

      "City": "Stavanger ",

      "ContactName": "Tom33     ",

      "Address": "Skagen 21 ",

      "PostalCode": "4006      "

    }

  ]

}

You received this message because you are subscribed to a topic in the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/WGCxPiU1E6s/unsubscribe.
To unsubscribe from this group and all its topics, send an email to supportforum...@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CADHrCaxB8_xPf4Fc-aBv%2BQjPNY-fA2P6gQR75xFTsxgYuoMb7A%40mail.gmail.com.

[Richard Manga]

Good Morning SIR,

The issue you reported is a platform bug. We are aware of this issue and our R&D Team is currently working on it.

We will inform you when the issue is solved.

All our apologizes for the inconvenience.

If you have any other question, please don't hesitate to contact us.

Best Regards,

Richard Manga

Training & Support Team Leader

Fujitsu RunMyProcess

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAMt50%3DDgieE5dq%2BErpu--M%2BHwPYdHxJ15sT3e%2BtUJDUNwJr7iQ%40mail.gmail.com.

[al...@wedosoft.net]

Hi Richard,

Thanks for your checking. By this bug, Can it be fixed on next release?

Regards,
Alan.

On Monday, January 11, 2016 at 11:14:29 PM UTC+9, Richard Manga wrote:
> Good Morning SIR,
>
>
> The issue you reported is a platform bug. We are aware of this issue and our R&D Team is currently working on it.
> We will inform you when the issue is solved.
> All our apologizes for the inconvenience.
> If you have any other question, please don't hesitate to contact us.
>
>
> Best Regards,
>
>
> Richard Manga
> Training & Support Team Leader
> Fujitsu RunMyProcess
>
>
> On Mon, Jan 11, 2016 at 12:48 PM, Lee, Woo-Seok <al...@wedosoft.net> wrote:
>
> Hi Pankaj,
>
>
> Thanks for your reply. I attached screenshot of the result from connector.
>
> Also please refer to result JSON data.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Red box is Korean character.
>
>
> If you need other configuration, please let me know.
>
>
>
>
>
>
>
>
>

> {

[Richard Manga]

Good Morning Alan,

Our R&D Team confirm that the Bug will be fixed for next release (February).

All our apologizes for the inconvenience.

Regards,

Richard

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/42b3644f-0bbb-423a-a4e6-672c5ccdeab8%40runmyprocess.com.