Need to insert .json file to MongoDB through java code

Question

I am beginner. I have MongoDB running. My task is to insert Student.json file on to MongoDB through java code and not through mongoimport.

Student.java

public class Student {

@Id
private ObjectId Id;

private long studentId;
private String studentName;
private String qualification;

public Student(){

}

public Student(long studentId, String studentName, String qualification) {
    this.studentId = studentId;
    this.studentName = studentName;
    this.qualification = qualification;
}

public long getStudentId() {
    return studentId;
}

public void setStudentId(long studentId) {
    this.studentId = studentId;
}

public String getStudentName() {
    return studentName;
}

public void setStudentName(String studentName) {
    this.studentName = studentName;
}

public String getQualification() {
    return qualification;
}

public void setQualification(String qualification) {
    this.qualification = qualification;
}
}

Student.json

[{
     "studentId": 1,
     "studentName": "Shreyas",
     "qualification": "B.E"
},
{
     "studentId": 2,
     "studentName": "Yashas",
     "qualification": "B.Tech"
}]

UpdateSudentModel.java

public class UpdateStudentModel {

private static UpdateStudentModel USM;
private StudentRepo sr;


public static void main(String[] args) {
    // TODO Auto-generated method stub

    try{

        File file = new File("/home/bshreyasrao/Student.json");


        Injector injector = Guice.createInjector(new BindingModules());
        StudentRepo sr = injector.getInstance(StudentRepo.class);

        USM = new UpdateStudentModel(sr);
        USM.importFromJsonToMongoDB(file);
        } catch (Exception e) {
        e.printStackTrace();
        System.out.println("Error while injecting/File is not present");
        }       
}

public UpdateStudentModel(StudentRepo sr)
{
    this.sr = sr;
}

public void importFromJsonToMongoDB(File file){

    try{
        JsonParser parser = new JsonFactory().createParser(file);
        ObjectMapper mapper = new ObjectMapper();
        Iterator<Student> iterator = mapper.readValues(parser, Student.class);

         while(iterator.hasNext()) {
             sr.save(iterator.next());
            }
    }catch (Exception e) {
        e.printStackTrace();
        System.out.println("Error While parsing data");
    }
}
}

Error

com.fasterxml.jackson.databind.RuntimeJsonMappingException: Can not deserialize instance of com.shreyas.student.model.Student out of START_ARRAY token
 at [Source: /home/bshreyasrao/Student.json; line: 1, column: 1]
    at com.fasterxml.jackson.databind.MappingIterator.next(MappingIterator.java:194)
    at com.shreyas.student.UpdateStudentModel.importFromJsonToMongoDB(UpdateStudentModel.java:55)
    at com.shreyas.student.UpdateStudentModel.main(UpdateStudentModel.java:34)
Caused by: com.fasterxml.jackson.databind.JsonMappingException: Can not deserialize instance of com.shreyas.student.model.Student out of START_ARRAY token
 at [Source: /home/bshreyasrao/Student.json; line: 1, column: 1]
    at com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:216)
    at com.fasterxml.jackson.databind.DeserializationContext.mappingException(DeserializationContext.java:873)
    at com.fasterxml.jackson.databind.DeserializationContext.mappingException(DeserializationContext.java:869)
    at com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromArray(BeanDeserializerBase.java:1293)
    at com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:159)
    at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:135)
    at com.fasterxml.jackson.databind.MappingIterator.nextValue(MappingIterator.java:277)
    at com.fasterxml.jackson.databind.MappingIterator.next(MappingIterator.java:192)
    ... 2 more
Error While parsing data

Things I tried

• In Student.json if i remove "[" , "]" and "," which separates 2 json objects then my above code UpdateStudentModel.java works fine.

{"studentId": 1,"studentName": "Shreyas","qualification": "B.E"} {"studentId": 2,"studentName": "Yashas","qualification": "B.Tech"}

I know this is not valid JSON format.

• So in order to be successful with valid JSON file how should i handle these "[" , "]" and "," ?

• What changes i should do in the code?....pls pls help me in this regards..

Answer 1

In your code you're expecting a Student object. But your JSON is a Student array. Can you try to change your code as expecting JSON array?

Change this line:

Iterator<Student> iterator = mapper.readValues(parser, Student.class);

as following:

Student[] iterator = mapper.readValues(parser, Student[].class);

OR

List<Student> iterator = mapper.readValues(parser, new TypeReference<List<Student>>.class);