Removing namespace and prefix in each field

[PavanKumar]

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

[former_member190293]

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.

[apu_das2]

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

[PavanKumar]

Hi ApuDas,

Thanks for your reply can you please share sample java code to achieve this, the request data which i attached is source xml in receiver also these prefixes are generating in PI if the prefix unique means it can be able to handle at backend or through java as it is different in each field facing diffucultly.

There is no intermediate mapping it's a simple cdata mapping

Regards

Pavan kumar D

[apu_das2]

Your target structure of stored procedure is not valid. where is the access root node.

[former_member190293]

Hi Apu!

When calling stored procedure, no "access" element is required. Action type "EXECUTE", "Table" element with stored procedure name and list of parameters should be provided.

Regards, Evgeniy.

[apu_das2]

Yes, Sorry I missed it.

I have also doubt as Evgenity mentioned.

Thanks,
Apu

[PavanKumar]

Hi,

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

Regards

pavan

[stefan_grube]

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.

[PavanKumar]

Hi,

Target Structure was created as per JDBC format only.

Regards

Pavan

[stefan_grube]

You need to create a structure for JDBC adapter.

Then you do a mapping.