we get "uFF06uFF03x0;" from sender JDBC adapter

[Former Member]

Thank you.

This is naoki kurihara.

We have a problem in sender JDBC adapter.

We use java mapping and sender JDBC adapter in PI7.1 on Windows.(DB is sqlserver)

and we test the interface and we found error.

the reason is to get "＆＃x0;" from JDBC adapter.

and our java mapping can't parse it. and we got error.

the column is not null.

how we can prevent "＆＃x0;",

(sorry I cant write "＆＃" 1byte word, so I wrote 2bytes word)

please give me your help!!

Thanks

[Former Member]

and this thread is finished!!

[Former Member]

To:Udo and Mark

Thank you for your helps!!

I try your sugestion and I notice I can replace the words.

but our team noticed the word is the noise data ....

when create our depelopment DB, our team mistook to create test data...

thanks for your helps

Naoki

[markangelo_dihiansan]

Hi,

Replace the & character with &amp ; in your java mapping. The same goes for these special characters:

< with &lt ;

> with &gt ;

" with &quot ;

' with &apos ;

Please remove the space between the escape character and the ; in your Java mapping. The spaces are typed here because the equivalent characters are not displaying correctly.

It should be able to handle the # though. Hope this helps

Regards,

Mark

[udo_martens]

Hi Naoki,

in a java mapping you have the control before parsing. You could replace that values before parsing.

Regards,

Udo