Announcement

**alius** · 22 Apr 2013, 03:20

Hi,

Your suspicion is not correct: JPA DS generator does not generate relation fields for autoderived data sources.
Therefore you have to define it manualy. And you did it correctly (at least at first glance).

Can you post sources for JPA entities?

Alius

**echdskech** · 23 Apr 2013, 15:47

Hi Alius,

Here's the code for the Role and Action entities:

Code:

package com.nessotech.base.acl.jpa;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;

@Entity
@NamedQueries(value={
		@NamedQuery(name="actionCheck", query="select a from Action a where a.name in :names")
})
public class Action {

	Short id;
	
	String name;
	
	String description;

	
	
	public Action(String name) {
		setName(name);
	}
	
	public Action() {
	}
	
	@Id
	@GeneratedValue(strategy=GenerationType.SEQUENCE)
	public Short getId() {
		return id;
	}

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

	@Column(nullable=false, unique=true, updatable=false)
	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}
		
}

Code:

package com.nessotech.base.acl.jpa;

import java.util.Set;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;

/**
 * 
 * Custom Permission sets
 *
 */
@Entity
@NamedQueries(value={
		@NamedQuery(name="getSuperUser", query="select r from Role r where r.roleName = 'superuser' ")
})
public class Role {

	private Short id; 
	
	private String roleName;
	
	private Set<Action> actions;
	
	@Id
	@GeneratedValue(strategy=GenerationType.SEQUENCE)
	public Short getId() {
		return id;
	}

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

	@Column(nullable=false,unique=true)
	public String getRoleName() {
		return roleName;
	}

	public void setRoleName(String roleName) {
		this.roleName = roleName;
	}

	@ManyToMany(fetch=FetchType.EAGER)
	public Set<Action> getActions() {
		return actions;
	}

	public void setActions(Set<Action> actions) {
		this.actions = actions;
	}
	
}

As stated previously, the fetch operations seem to be working fine. That's what confuses me about the updates not working.

Thanks,

Ech

**alius** · 24 Apr 2013, 08:27

Hi,

Your DS definition is incorrect: you have missed <fields> tag. Should be:

Code:

<DataSource ID="roleDs" serverType="jpa"
	beanClassName="com.nessotech.base.acl.jpa.Role" schemaBean="com.nessotech.base.acl.jpa.Role"
	>
<fields> <!-- this line was missing in initial DS definition -->
	<field name="actions"
				hidden="true"
               canSave="true"
               canEdit="true"
               detail="true"
               type="actionDs"
               javaCollectionClass="com.nessotech.base.acl.jpa.Action"
               multiple="true"
               foreignKey="actionDs.id"/>
</fields> <!-- this line was missing in initial DS definition -->
</DataSource>

Regards,
Alius

**echdskech** · 29 Apr 2013, 17:57

That worked. Thanks!

Just a small follow up so I won't have to repost the same code and logs in another thread:

The selected records were being posted with extra fields in the request. The field seems to be a generated one with the format "_selection_#". This can be seen in the logs provided before:

Code:

_selection_7:true

The records still get updated anyway with the logs saying something like:

Code:

09:51:37,286 INFO  [stdout] (http--0.0.0.0-8443-11) === 2013-04-30 09:51:37,286 [3-11] INFO  DataTools - [builtinApplication.roleDs_update] setProperties: couldn't set:
09:51:37,287 INFO  [stdout] (http--0.0.0.0-8443-11) {
09:51:37,287 INFO  [stdout] (http--0.0.0.0-8443-11)     _selection_6:"No such property"
09:51:37,287 INFO  [stdout] (http--0.0.0.0-8443-11) }

I was just curious if this is an expected behavior or maybe I set something somewhere to cause this.

Thanks,

Ech

Announcement

JPA, ManyToMany update

Comment

Comment

Comment

Comment