Skip to Content
0

Removing namespace and prefix in each field

May 06, 2017 at 04:46 PM

200

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Stefan Grube May 07, 2017 at 02:14 PM
0

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi,

Target Structure was created as per JDBC format only.

Regards

Pavan

0

You need to create a structure for JDBC adapter.

Then you do a mapping.

0
Pavan Dogiparthy May 09, 2017 at 06:06 AM
0

Hi,

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

Regards

pavan

Share
10 |10000 characters needed characters left characters exceeded
Apu Das May 09, 2017 at 08:21 AM
0

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

Show 4 Share
10 |10000 characters needed characters left characters exceeded

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

map.jpg (115.7 kB)
0

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

0

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.

0

Yes, Sorry I missed it.

I have also doubt as Evgenity mentioned.

Thanks,
Apu

0
Evgeniy Kolmakov May 09, 2017 at 01:22 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded