joist | a Java orm based on code generation | Object-Relational Mapping library

I am trying to develop a system to handle data from a third party site. I will enter their data in my MySQL DB. Part of their data is a JSON string. I am new to JSON in MySQL. I have read and watched a tutorial on how to query JSON. I have done so successfully with JSON strings that I have entered. The problem is I cannot get their string to insert into my table. I get an error that says,"#3140 - Invalid JSON text: "The document root must not follow by other values." at position 11 in value for column 'ordered_shed.items'. Below is the JSON I received from the company. I have looked at it and cannot figure out what the problem is. I am using PHPMyAdmin to insert the code. The structure is.

id int(11) AUTO_INCREMENT items JSON

"lineItems":[ { "description": "details-item-size", "productKey": "size", "quantity": 1 }, { "description": "details-item-style", "model": "", "price": 2229, "productKey": "style", "quantity": 1, "value": "" }, { "description": "details-item-flooring", "price": 0, "productCategory": "flooring-interior", "quantity": 1 }, { "description": "details-item-floor-joist", "productCategory": "flooring-interior", "quantity": 1 }, { "description": "details-item-roof-overhang", "productKey": "RoofOverhang", "quantity": 1 }, { "description": "details-item-sidewall-height", "productKey": "wall-height", "quantity": 1 }, { "description": "standard", "productCategory": "structure", "quantity": 1 }, { "description": "Pressure Treated Skids", "productCategory": "structure", "quantity": 1 }, { "description": "details-item-loft", "productCategory": "flooring-interior", "quantity": 1 }, { "description": "details-item-roof-material", "productKey": "roof-material", "quantity": 1 }, { "description": "details-item-siding-color", "quantity": 1, "productKey": "siding-color" }, { "description": "details-item-siding", "productKey": "siding", "quantity": 1 }, { "description": "details-item-roof-color", "quantity": 1, "productKey": "roof-color" }, { "description": "details-item-trim-color", "quantity": 1, "productKey": "trim-color" }]

Any help would be greatly appreciated.

I have a json array from a form saved in the database. I am generating a report from the array.The form has a section for "Do you require the section?" If the user selected "No" to section, I need to skip the section until the end of the section.

In the json array, section starts at

'{"type":"section","label":"Do you require this section?","req":0,"Element_Values":"No"}'

and the end of the section is at

'{"type":"section-end","label":"","req":0,"Element_Values":""}'

If the Element_Values=No then skip the data until the type section-end, otherwise do not do anything.

For that I did the do{}while loop and it's still not working:

I have a table named dbo.XMLData and one column in the table named XMLValue, a sample row in the table is below( basically its a XML value)