Hey Great :)
On Fri, Sep 17, 2021 at 4:38 PM Daniel Langevin <[email protected]>
wrote:
> Hi Alexandrfe,
>
> you are right it's work with camel-xj
>
> whith those lines:
> <setBody><simple>${body[jsonString]}</simple></setBody>
> <to uri="xj:identity?transformDirection=JSON2XML" />
> <to uri="xj:identity?transformDirection=XML2JSON" />
>
>
>
> Thank's
>
>
> Daniel
>
> On 2021/09/15 08:54:25, Alexandre Gallice <[email protected]> wrote:
> > Never tested, but maybe camel-xj
> > https://camel.apache.org/components/3.7.x/xj-component.html ?
> >
> > On Wed, Sep 15, 2021 at 10:39 AM Daniel Langevin <[email protected]>
> > wrote:
> >
> > > Hi all,
> > >
> > > Here is my case,
> > > i have a body containing some Unicode characters, this body is the
> > > RESPONSE of a JDBC connection Query.
> > >
> > > In camel 2.x i was using xmljson to convert Unicode data into UTF-8
> > > encoding.
> > >
> > > i try to convert this service to camel 3.X but xmljson is deprecated
> and
> > > don,t find another way.
> > >
> > > Someone as a clue to achieve this by another way.
> > >
> > > Thank's
> > >
> > >
> > > Daniel
> > >
> > >
> > >
> ==========================================================================
> > > Here how i achieved this in camel 2.x to convert Special Unicode
> Character
> > > to UTF-8 encoding.
> > >
> > > <to
> uri="XXXoracleSqlStored:XXX_pkb_apx_service_ords.p_verif_ident(VARCHAR
> > > ${header.XXXCodepgm}, VARCHAR ${headers.XXXid}, OUT VARCHAR
> jsonString)" />
> > > <setBody><simple>${body[jsonString]}</simple></setBody>
> > > <!-- convert UTF-8 XML -->
> > > <unmarshal><xmljson encoding="UTF-8"/><unmarshal>
> > > <!-- goback to JSON converted -->
> > > <marshal><xmljson encoding="UTF-8"/><marshal>
> > >
> > >
> > > Explanation:
> > >
> > > <to
> uri="XXXoracleSqlStored:XXX_pkb_apx_service_ords.p_verif_ident(VARCHAR
> > > ${header.XXXCodepgm}, VARCHAR ${headers.XXXid}, OUT VARCHAR
> jsonString)" />
> > >
> > > BODY CONTENT (type : java.util.LinkedHashMap ) {jsonString={
> > > "codeRetour":200
> > > ,"msgRetour":"succes"
> > > ,"msgCourt":"L\u0027identification a r\u00E9ussi."
> > > ,"msgLong":"L\u0027identification du dossier du client a r\u00E9ussi."
> > > }
> > > }
> > >
> > >
> > > Retrieving jsonString content in the Body
> > > <setBody><simple>${body[jsonString]}</simple></setBody>
> > >
> > > BODY CONTENT (type : java.lang.String)
> > > {
> > > "codeRetour":200
> > > ,"msgRetour":"succes"
> > > ,"msgCourt":"L\u0027identification a r\u00E9ussi."
> > > ,"msgLong":"L\u0027identification du dossier du client a r\u00E9ussi."
> > > }
> > >
> > >
> > > Unmarshal to XML with jsonxml to convert unicode character with UTF-8
> > >
> > > <unmarshal><xmljson encoding="UTF-8"/><unmarshal> BODY CONTENT:
> > > <?xml version="1.0" encoding="UTF-8"?>
> > > <o><codeRetour>200</codeRetour><msgCourt>L'identification du dossier du
> > > client a réussi.</msgCourt> <msgLong>L'identification du dossier du
> client
> > > a réussi.</msgLong><msgRetour>succes</msgRetour></o>
> > >
> > > Marshal to JSON again with jsonxml.
> > > <marshal><xmljson encoding="UTF-8"/><marshal> BODY CONTENT:
> > > {"codeRetour":"200","msgCourt":"L'identification du dossier du client a
> > > réussi.", "msgLong":"L'identification du dossier du client a
> > > réussi.","msgRetour":"succes"}
> > >
> > >
> > >
> > >
> > > Daniel Langevin
> > >
> > >
> >
>
