Skip to Content

Removing namespace and prefix in each field

Hi,

I am working on SOAP(AXIS) to JDBC sync scenario

client has provided a wsdl where we have imported in external defintion and done cdata mapping

But we are facing issue in namespace

when we have imported the wsdl in soap ui we can see there are two namespaces in the soap envelope

and if i initiate the request to PI the request is coming as second namespace is appending for each field and prefix is different for each field. Please see below

As it is cdata mapping and prefix also changing in each field the request which going to DB is throwing the error at backend

DB guys has suggested it is not possible handle at backend as the prefix has different in each field

At PI need to handle this case to remove namespace and prefix of each field.

Please suggest

Regards

Pavan Kumar D

nsp2.jpg (61.2 kB)
namesp1.jpg (70.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    May 07, 2017 at 02:14 PM

    when you want to work with JDBC adapter, you need to create a special structure for this.

    Check online help for details of the structure.

    Create that structure and do a mapping from your SOAP to JDBC.

    You cannot use this SOAP structure for working with JDBC adapter.

    Add comment
    10|10000 characters needed characters exceeded

  • May 09, 2017 at 06:06 AM

    Hi,

    Any idea on how to remove namespace in each field. Pleas suggest

    Regards

    pavan

    Add comment
    10|10000 characters needed characters exceeded

  • May 09, 2017 at 08:21 AM

    Pavan,

    You can handle this in JAVA mapping easily. But, I am quite doubtful how these prefixes are getting added in your receiver structure. Check your mapping properly.

    Is there any intermediary structure that you are populating before pushing the same into JDBC XML SQL Format.

    Thanks,

    Apu

    Add comment
    10|10000 characters needed characters exceeded

  • May 09, 2017 at 01:22 PM

    Hi Pavan!

    I see source messages on both of your screenshots. But if the first one is the request from SOAP UI, what is the second? It's in the same form even with SOAP UI's comments, but with different prefixes. Where did it come from?

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded