Spring MVC can not fetch JSON value

Question

In Spring mvc I have a mytable.json file.

I want to fetch that json file data and then want to add to model.addAttribute().

mytable.json

{"name1":["place1.1","place1.2"],
  "name2":["place2.1","place1.2"] 
...........
.........}

I want to fetch the names with their corresponding citylist.

Ex:

name1=place1.1,place1.2

so,I have done:--

     try {           

            JSONParser parser = new JSONParser();

             ClassLoader classLoader = getClass().getClassLoader();
            File file = new File(classLoader.getResource("file/mytable.json").getFile());
JSONObject obj = (JSONObject) parser.parse(new FileReader(file));

            Iterator<String> keys = obj.values().iterator();

            while( keys.hasNext() ) 
            {
                String key = (String)keys.next();
                if ( obj.get(key) instanceof JSONObject )
                {
                    model.addAttribute("key", key);


                }

            }           


        } catch (Exception e) {
            e.printStackTrace();
        }

But I am getting error:

Unexpected character (�) at position 0.

in this line :

JSONObject obj = (JSONObject) parser.parse(new FileReader(file));

why??Where is the problem?

Can you check whether servletContext.getRealPath("/WEB-INF/mytable.json") get you the right path? — sag
– sag, Commented Dec 15, 2015 at 7:00
What JSON Parser are you using? I am able to parse with org.json.simple.parser.JSONParser — sag
– sag, Commented Dec 15, 2015 at 7:59
Can you just try recreating the file file/mytable.json? File encoding may have an issue here. — sag
– sag, Commented Dec 15, 2015 at 9:03

JGCW · Accepted Answer · 2015-12-15 09:12:00Z

1

The JSONParser parser = new JSONParser(); is expecting a JSON String, not a .json file. hence the Unexpected character.... error.

You can InputStreamReader:

jsonObject = (JSONObject) parser.parse(new InputStreamReader(new FileInputStream("file/mytable.json")));

answered Dec 15, 2015 at 9:12

JGCW

1,5291 gold badge13 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring MVC can not fetch JSON value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related