[jboss-user] [EJB 3.0] - Jpa with Parent/Child Relationship in Same Object

[cfrostrun]

Does anybody have an idea where I'm going wrong...

here's my table structure for Comment

 id            | integer                     | not null
 website_id    | integer                     | not null
 event_id      | integer                     | not null
 parent_id     | integer                     | 
 title         | character varying(150)      | 
 post_date     | timestamp without time zone | 
 user_id       | integer                     | not null
 ip_address    | character varying(100)      | 
 comment_name  | character varying(100)      | 
 comment_email | character varying(100)      | 
 hyperlink     | character varying(200)      | 
 comment       | text                        | 
 score         | integer                     | not null
 active_flag   | character(1)                | 


Parent Id is referencing Comment.Id ..

Here's my JPA Domain Object

@Entity
@Table(name="comments", schema="eventservices")
public class Comment implements IDomainObject{

	@Id
	@GeneratedValue(generator="SequenceComments")
	@SequenceGenerator(name="SequenceComments", sequenceName="eventservices.seq_comments")
	private long id = 0;
	
	@Column(name="website_id")
	private long websiteId = 0;
	
	@OneToMany(targetEntity=Comment.class, mappedBy="parent", fetch=FetchType.LAZY)
	private Collection comments = null;
	
	@ManyToOne
	@JoinColumn(name="event_id")
	private Event event = null;
	
	@ManyToOne
	@JoinColumn(name="parent_id")
	private Comment parent = null;

	@Column(name="title")
	private String title = null;
	
	@Temporal(TemporalType.TIMESTAMP)
	@Column(name="post_date")
	private Date postDate = null;
	
	@Column(name="user_id")
	private long userId = 0;

	@Column(name="comment_name")
	private String commentName = null;

	@Column(name="comment_email")
	private String commentEmail = null;
	
	@Column(name="hyperlink")
	private String hyperlink = null;
	
	@Column(name="comment")
	private String note = null;

	@Column(name="score")
	private long score = 0;	
	
	@Column(name="active_flag")
	private String activeFlag = null;

	@Column(name="ip_address")
	private String ipAddress = null;
	
	public String getIpAddress() {
		return ipAddress;
	}

	public void setIpAddress(String ipAddress) {
		this.ipAddress = ipAddress;
	}

	public String getActiveFlag() {
		return activeFlag;
	}

	public void setActiveFlag(String activeFlag) {
		this.activeFlag = activeFlag;
	}

	public Event getEvent() {
		return event;
	}

	public void setEvent(Event event) {
		this.event = event;
	}

	public String getHyperlink() {
		return hyperlink;
	}

	public void setHyperlink(String hyperlink) {
		this.hyperlink = hyperlink;
	}

	public long getId() {
		return id;
	}

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

	public String getNote() {
		return note;
	}

	public void setNote(String note) {
		this.note = note;
	}

	public Comment getParent() {
		return parent;
	}

	public void setParent(Comment parent) {
		this.parent = parent;
	}

	public Date getPostDate() {
		return postDate;
	}

	public void setPostDate(Date postDate) {
		this.postDate = postDate;
	}


	public String getCommentEmail() {
		return commentEmail;
	}

	public void setCommentEmail(String commentEmail) {
		this.commentEmail = commentEmail;
	}

	public String getCommentName() {
		return commentName;
	}

	public void setCommentName(String commentName) {
		this.commentName = commentName;
	}

	public String getTitle() {
		return title;
	}

	public void setTitle(String title) {
		this.title = title;
	}

	public long getUserId() {
		return userId;
	}

	public void setUserId(long userId) {
		this.userId = userId;
	}

	public long getWebsiteId() {
		return websiteId;
	}

	public void setWebsiteId(long websiteId) {
		this.websiteId = websiteId;
	}

	public long getScore() {
		return score;
	}

	public void setScore(long score) {
		this.score = score;
	}

	public Collection getComments() {
		return comments;
	}

	public void setComments(Collection comments) {
		this.comments = comments;
	}
	
	public void addComment(Comment comment){
		if(this.comments==null){
			this.comments = new java.util.HashSet();
		}
		this.comments.add(comment);
	}
}


Here's the exception in the logs:

22:12:23,367 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
22:12:23,367 ERROR [JDBCExceptionReporter] Batch entry 0 insert into eventservices.comments (website_id, event_id, parent_id, title, post_date, user_id, comment_name, comment_email, hyperlink, comment, score, active_flag, ip_address, id) values ( was aborted. Call getNextException() to see the cause.
22:12:23,367 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 22003
22:12:23,368 ERROR [JDBCExceptionReporter] ERROR: integer out of range


Parent Id will be null if it's a top level comment, and in the junit i'm running this is the case...   So I don't understand why this isn't working?

Thanks In Advance,

Chris

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4015588#4015588

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4015588