Assigning jsonobject to java class having one to many relationship

[YogendraK Singh]

Hi.. JavaRanch forum member I am having one problem in inserting data to my POJO having one to many relationship with each other.
I am using JPA persistence layer with spring and Ext JS 4.0.2a as a frontend technology

my Project pojo class is

private Integer id;
	private Date endDate;
	private String projectDesc;
	private String projectName;
	private String projectTitle;
	private Date startDate;
	private Set<Task> tasks = new HashSet<Task>(0);

	public Project() {
	}

	public Project(Date endDate, String projectDesc, String projectName,
			String projectTitle, Date startDate, Set<Task> tasks) {
		this.endDate = endDate;
		this.projectDesc = projectDesc;
		this.projectName = projectName;
		this.projectTitle = projectTitle;
		this.startDate = startDate;
		this.tasks = tasks;
	}

	@Id
	@GeneratedValue(strategy = IDENTITY)
	@Column(name = "id", unique = true, nullable = false)
	public Integer getId() {
		return this.id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name = "endDate", length = 19)
	public Date getEndDate() {
		return this.endDate;
	}

	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}

	@Column(name = "projectDesc")
	public String getProjectDesc() {
		return this.projectDesc;
	}

	public void setProjectDesc(String projectDesc) {
		this.projectDesc = projectDesc;
	}

	@Column(name = "projectName")
	public String getProjectName() {
		return this.projectName;
	}

	public void setProjectName(String projectName) {
		this.projectName = projectName;
	}

	@Column(name = "projectTitle")
	public String getProjectTitle() {
		return this.projectTitle;
	}

	public void setProjectTitle(String projectTitle) {
		this.projectTitle = projectTitle;
	}

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name = "startDate", length = 19)
	public Date getStartDate() {
		return this.startDate;
	}

	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}

	@OneToMany(fetch = FetchType.LAZY, mappedBy = "project")
	public Set<Task> getTasks() {
		return this.tasks;
	}

	public void setTasks(Set<Task> tasks) {
		this.tasks = tasks;
	}

my Task pojo class is

private int id;
    private Project project;
    private Integer depth;
    private Double duration;
    private String durationUnit;
    private Date endDate;
    private Integer taskIndex;
    private String taskName;
    private Integer parentId;
    private Integer percentDone;
    private Integer priority;
    private Date startDate;

    public Task() {
    }

    public Task(int id, Project project) {
        this.id = id;
        this.project = project;
    }

    public Task(int id, Project project, Integer depth, Double duration,
            String durationUnit, Date endDate, Integer taskIndex,
            String taskName, Integer parentId, Integer percentDone,
            Integer priority, Date startDate) {
        this.id = id;
        this.project = project;
        this.depth = depth;
        this.duration = duration;
        this.durationUnit = durationUnit;
        this.endDate = endDate;
        this.taskIndex = taskIndex;
        this.taskName = taskName;
        this.parentId = parentId;
        this.percentDone = percentDone;
        this.priority = priority;
        this.startDate = startDate;
    }

    @Id
    @Column(name = "id", unique = true, nullable = false)
    public int getId() {
        return this.id;
    }

    public void setId(int id) {
        this.id = id;
    }

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "projectId", nullable = false)
    public Project getProject() {
        return this.project;
    }

    public void setProject(Project project) {
        this.project = project;
    }

    @Column(name = "depth")
    public Integer getDepth() {
        return this.depth;
    }

    public void setDepth(Integer depth) {
        this.depth = depth;
    }

    @Column(name = "duration", precision = 22, scale = 0)
    public Double getDuration() {
        return this.duration;
    }

    public void setDuration(Double duration) {
        this.duration = duration;
    }

    @Column(name = "durationUnit")
    public String getDurationUnit() {
        return this.durationUnit;
    }

    public void setDurationUnit(String durationUnit) {
        this.durationUnit = durationUnit;
    }

    @Temporal(TemporalType.DATE)
    @Column(name = "endDate", length = 10)
    public Date getEndDate() {
        return this.endDate;
    }

    public void setEndDate(Date endDate) {
        this.endDate = endDate;
    }

    @Column(name = "taskIndex")
    public Integer getTaskIndex() {
        return this.taskIndex;
    }

    public void setTaskIndex(Integer taskIndex) {
        this.taskIndex = taskIndex;
    }

    @Column(name = "taskName")
    public String getTaskName() {
        return this.taskName;
    }

    public void setTaskName(String taskName) {
        this.taskName = taskName;
    }

    @Column(name = "parentId")
    public Integer getParentId() {
        return this.parentId;
    }

    public void setParentId(Integer parentId) {
        this.parentId = parentId;
    }

    @Column(name = "percentDone")
    public Integer getPercentDone() {
        return this.percentDone;
    }

    public void setPercentDone(Integer percentDone) {
        this.percentDone = percentDone;
    }

    @Column(name = "priority")
    public Integer getPriority() {
        return this.priority;
    }

    public void setPriority(Integer priority) {
        this.priority = priority;
    }

    @Temporal(TemporalType.DATE)
    @Column(name = "startDate", length = 10)
    public Date getStartDate() {
        return this.startDate;
    }

    public void setStartDate(Date startDate) {
        this.startDate = startDate;
    }
    public Project(int id, String projectTitle, String projectName,
            String projectDesc, Date startDate, Date endDate, Set<Task> tasks) {
        this.id = id;
        this.projectTitle = projectTitle;
        this.projectName = projectName;
        this.projectDesc = projectDesc;
        this.startDate = startDate;
        this.endDate = endDate;
        this.tasks = tasks;
    }

    @Id
    @Column(name = "id", unique = true, nullable = false)
    public int getId() {
        return this.id;
    }

    public void setId(int id) {
        this.id = id;
    }

    @Column(name = "projectTitle")
    public String getProjectTitle() {
        return this.projectTitle;
    }

    public void setProjectTitle(String projectTitle) {
        this.projectTitle = projectTitle;
    }

    @Column(name = "projectName")
    public String getProjectName() {
        return this.projectName;
    }

    public void setProjectName(String projectName) {
        this.projectName = projectName;
    }

    @Column(name = "projectDesc")
    public String getProjectDesc() {
        return this.projectDesc;
    }

    public void setProjectDesc(String projectDesc) {
        this.projectDesc = projectDesc;
    }

    @Temporal(TemporalType.TIMESTAMP)
    @Column(name = "startDate", length = 19)
    public Date getStartDate() {
        return this.startDate;
    }

    public void setStartDate(Date startDate) {
        this.startDate = startDate;
    }

    @Temporal(TemporalType.TIMESTAMP)
    @Column(name = "endDate", length = 19)
    public Date getEndDate() {
        return this.endDate;
    }

    public void setEndDate(Date endDate) {
        this.endDate = endDate;
    }

    @OneToMany(fetch = FetchType.LAZY, mappedBy = "project")
    public Set<Task> getTasks() {
        return this.tasks;
    }

    public void setTasks(Set<Task> tasks) {
        this.tasks = tasks;
    }

the relationship is like One project may have many Task.

the json data i am receiving on my server side is

{
    "projectTitle": "DEPENDENCY",
    "projectName": "DEPENDENCY",
    "projectDesc": "<b>DEPENDENCY<\/b>",
    "startDate": {
        "date": 25,
        "day": 3,
        "hours": 0,
        "minutes": 0,
        "month": 0,
        "seconds": 0,
        "time": 1327429800000,
        "timezoneOffset": -330,
        "year": 112
    },
    "endDate": {
        "date": 25,
        "day": 3,
        "hours": 0,
        "minutes": 0,
        "month": 0,
        "seconds": 0,
        "time": 1327429800000,
        "timezoneOffset": -330,
        "year": 112
    }
}

as my id is unique and autoincreement so no need to pass id. But i am having problem with the insertion of this JSON data i am receiving as the Project primary key is associated in relation with Task.
I tried to assign the values with the below method

JSONObject jsonObject = JSONObject.fromObject(data);
        JSONObject jsonTask = new JSONObject();


        String sDate = jsonObject.get("startdate").toString();
        String eDate = jsonObject.get("enddate").toString();


        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); 
        Date startD = sdf.parse(sDate);
        Date endD = sdf.parse(eDate);       

        jsonTask.put("endDate", endD);
        jsonTask.put("startDate", startD);
        jsonTask.put("depth", null);
        jsonTask.put("duration", null);
        jsonTask.put("durationUnit", null);
        jsonTask.put("taskIndex", null);
        jsonTask.put("taskName", null);
        jsonTask.put("parentId", null);
        jsonTask.put("percentDone", null);
        jsonTask.put("priority", null);

        jsonObject.put("tasks", jsonTask);
        jsonObject.put("projectTitle", jsonObject.getString("title"));
        jsonObject.put("projectName", jsonObject.getString("name"));
        jsonObject.put("projectDesc", jsonObject.getString("description").replace("\u200b", ""));
        jsonObject.put("startDate", startD);
        jsonObject.put("endDate", endD);


        jsonObject.remove("id");
        jsonObject.remove("title");
        jsonObject.remove("name");
        jsonObject.remove("description");
        jsonObject.remove("startdate");
        jsonObject.remove("enddate");       

        Project project = (Project) JSONObject.toBean(jsonObject, Project.class);

I tried to insert the Task with jsonTask but not able to assign task to POJO Task. When i removed the jsonTask all data in assigned to Project POJO.

So is there any way i can insert data to Project table of my database and Project's startDate, endDate,projectId will also be inserted to my Task table

Yogendra Singh
Sr. Programmer
Kintudesigns.com

[James Sutherland]

Why not just create the Project and Task directly and assign the values instead of using toBean, especially since your data does not match anyway.
Ensure that you set both sides of the task relationships (set the task's project).

You may also try using EclipseLink Moxy which now support mappings objects to/from JSON data.

[YogendraK Singh]

hi.. james thanks for your quick response

I am using Hibernate JPA as my ORM. I just want to know that first I have to insert all the data to my Project Table and then I have to select the Data available inside Project table and pass them to my Task Table.

My project table id will be the foreign key of the Task table projectId.

[YogendraK Singh]

still no one to help me to come out of this problem.
I am not able to get how to solve this one to many relationship problem. I am able to insert the data in both of the table but the problem is that How do I insert the primary key of both tables to the third one



Yogendra Singh
Sr. Programmer
Kintudesigns.com

[Vijitha Kumara]

I am able to insert the data in both of the table but the problem is that How do I insert the primary key of both tables to the third one

What "third" table are you talking about? You seems to have many @OneToMany relationships defined here, which one exactly you refer here?

[YogendraK Singh]

yes Vijitha Kumara, I am having one to many relationship between PROJECT 1------* TASK currently i am able to insert the records in both tables.

My Project table has fields id, name, title, startDate, endDate and Task table has fields id, depth, duration, durationUnit, startDate, endDate, parentId, percentDone, priority, taskIndex, taskName.

Now I want to establish one To many relation between Project and Task.

I take the input as project name, title, startDate, endDate. As soon as the project detail is entered I am also inserting the startDate and endDate to my Task table. And I am one to many relationship due to which third table is generated as project_task. But the problem is that project_task not able to hold the primary key's of project ID and task ID.

In my project pojo i am maintaining relationship with task with

private Set<Task> tasks = new HashSet<Task>(0);
@OneToMany(cascade = CascadeType.ALL)
@JoinTable(name = "project_task", joinColumns = { @JoinColumn(name = "project_id") }, inverseJoinColumns = { @JoinColumn(name = "task_id") })
public Set<Task> getTasks() {
return this.tasks;
}

for the task insertion i am also passing the set but doesn't seems to be work. I am getting error

35802 [http-8085-4] ERROR org.hibernate.property.BasicPropertyAccessor - IllegalArgumentException in class: com.kintu.projectmgt.model.Task, getter method of property: taskId


Yogendra Singh
Sr. Programmer
Kintudesigns.com

[Vijitha Kumara]

Before look at your solution why you need a third table to manage a One-to-Many relationship? Can't you have the "Many" side (Task table in this case) keep the foreign key to hold the relationship as that is the normal way of handling this?