cancel
Showing results for 
Search instead for 
Did you mean: 

Why do ReadyAPI and SoapUI convert database result into XML ?

SOLVED
Highlighted
Occasional Contributor

Why do ReadyAPI and SoapUI convert database result into XML ?

I see that ReadyAPI and SoapUI convert relational database result into XML. Why do they do that? If it is possible to convert it into JSON instead, then why do they don't do it?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Hero

Re: Why do ReadyAPI and SoapUI convert database result into XML ?

Hey @rajs2020,

This is a complete guess on my part, but id suggest the reason is historic.

Xml has been around a lot longer. I think json was only standardized quite recently (within the last decade) where xml's been knocking about for years.

Im guessing Eviware (owners of SoapUI before Smartbear grabbed it) when they first added jdbc support to SoapUI, json wasnt standardized so the risk of making chsnges to its handling by altering it from xml to json just werent worth the risk of json never been stndardized and slipping into obscurity.

Json advantages over xml just dont really add much incentive to switch from xml to json (e.g. a bit more lightweight, cos attribute names arent duplicated like they are in xml elements and datatypes are somewhat preserved in json where theyre not in xml...e.g. think numeric and text types. These are reflected by wrapping values in double quotes in json...this isnt done in xml).

Personally i still struggle when im editing very complex json (i struggle with complex jsonpath), whereas i can spot malformed xml from a mile off.

Ok. Thats just my guess/opinion and isnt necessarily true at all, but its the best guess i got!

Cheers,

Rich
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta

View solution in original post

3 REPLIES 3
Highlighted
Community Hero

Re: Why do ReadyAPI and SoapUI convert database result into XML ?

Hey @rajs2020,

This is a complete guess on my part, but id suggest the reason is historic.

Xml has been around a lot longer. I think json was only standardized quite recently (within the last decade) where xml's been knocking about for years.

Im guessing Eviware (owners of SoapUI before Smartbear grabbed it) when they first added jdbc support to SoapUI, json wasnt standardized so the risk of making chsnges to its handling by altering it from xml to json just werent worth the risk of json never been stndardized and slipping into obscurity.

Json advantages over xml just dont really add much incentive to switch from xml to json (e.g. a bit more lightweight, cos attribute names arent duplicated like they are in xml elements and datatypes are somewhat preserved in json where theyre not in xml...e.g. think numeric and text types. These are reflected by wrapping values in double quotes in json...this isnt done in xml).

Personally i still struggle when im editing very complex json (i struggle with complex jsonpath), whereas i can spot malformed xml from a mile off.

Ok. Thats just my guess/opinion and isnt necessarily true at all, but its the best guess i got!

Cheers,

Rich
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta

View solution in original post

Highlighted
Occasional Contributor

Re: Why do ReadyAPI and SoapUI convert database result into XML ?

@sonya_m - I see that you liked the reply. Wondering if you had any additional comments. thanks.

Highlighted
Community Manager

Re: Why do ReadyAPI and SoapUI convert database result into XML ?

Hi @rajs2020! I think that Richie provided a well-rounded response to your query.

Do you have anymore specific questions in mind for the Community to answer? Let us know and the Community will try to help more.


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
New Here?
Join us and watch the welcome video:
Announcements