Here is the actually mapping file, java file and db structure
Although this is difft from what I posted in the begining, but I am working through this right now, if I can fix this, the same I need to apply to first one.
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping SYSTEM
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
<hibernate-mapping>
<!--
Nov 3, 2003 - Created
Suresh R
-->
<class name="insite.business.domain.services.PayTermsRequest"
table="pay_terms_request"
dynamic-insert="true"
dynamic-update="true" >
<id name="id" type="string" column="pay_terms_request_id" length="14" >
<generator class="assigned"/>
</id>
<property name="name" type="string" column="name" not-null="true" length="100"/>
<property name="description" type="string" column="description" length="2000"/>
<property name="ownerId" type="string" column="owner_id" not-null="true" length="24"/>
<property name="buyerCode" type="string" column="buyer_code" length="4"/>
<set name="commentSet" lazy="false" cascade="all">
<key column="object_ref"/>
<one-to-many class="insite.business.domain.services.Comments"/>
</set>
</class>
</hibernate-mapping>
Comments.hbm.xml
<hibernate-mapping>
<class name="insite.business.domain.services.Comments" table="comments">
<id name="commentId" type="string" column="comment_id">
<generator class="assigned"/>
</id>
<property name="createTime" type="timestamp" column="create_time" length="16"/>
<property name="creatorId" type="string" column="creator_id" not-null="true" length="24"/>
<property name="comments" type="string" column="comments" length="1000"/>
<property name="rejectedReasonId" type="string" column="rejected_reason_id" length="24"/>
<property name="internalComments" type="string" column="internal_comments" length="1000"/>
<many-to-one name="request" column="object_ref"
class="insite.business.domain.services.PayTermsRequest" />
</class>
</hibernate-mapping>
Java File
Comments.java
import java.sql.Timestamp;
import java.io.Serializable;
import net.sf.hibernate.Lifecycle;
import net.sf.hibernate.Session;
import net.sf.hibernate.CallbackException;
import fieldglass.util.IdUtil;
public class Comments implements Lifecycle {
private String objectRef;
private String creatorId;
private Timestamp createTime;
private String comments;
private String rejectedReasonId;
private String internalComments;
private String commentId;
private PayTermsRequest request;
public Comments() {
commentId = IdUtil.generateId();
}
public String getCommentId() {
return commentId;
}
public void setCommentId(String commentId) {
this.commentId = commentId;
}
public String getObjectRef() {
return objectRef;
}
public void setObjectRef(String objectRef) {
this.objectRef = objectRef;
}
public String getCreatorId() {
return creatorId;
}
public void setCreatorId(String creatorId) {
this.creatorId = creatorId;
}
public Timestamp getCreateTime() {
return createTime;
}
public void setCreateTime(Timestamp createTime) {
this.createTime = createTime;
}
public String getComments() {
return comments;
}
public void setComments(String comments) {
this.comments = comments;
}
public String getRejectedReasonId() {
return rejectedReasonId;
}
public void setRejectedReasonId(String rejectedReasonId) {
this.rejectedReasonId = rejectedReasonId;
}
public String getInternalComments() {
return internalComments;
}
public void setInternalComments(String internalComments) {
this.internalComments = internalComments;
}
public PayTermsRequest getRequest() {
return request;
}
public void setRequest(PayTermsRequest request) {
this.request = request;
}
public boolean onSave(Session s) throws CallbackException {
return false;
}
public boolean onUpdate(Session s) throws CallbackException {
return false;
}
public boolean onDelete(Session s) throws CallbackException {
return false;
}
public void onLoad(Session s, Serializable id) {
}
}
PayTermsRequest.java
import java.util.HashSet;
import java.util.Set;
public class PayTermsRequest {
private String id;
private String name;
private String description;
private String buyerCode;
private String ownerId;
private Set commentSet;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
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;
}
public String getBuyerCode() {
return buyerCode;
}
public void setBuyerCode(String buyerCode) {
this.buyerCode = buyerCode;
}
public String getOwnerId() {
return ownerId;
}
public void setOwnerId(String ownerId) {
this.ownerId = ownerId;
}
public Set getCommentSet() {
return commentSet;
}
public void setCommentSet(Set commentSet) {
this.commentSet = commentSet;
}
}
Tables
=====
CREATE TABLE [dbo].[comments] (
[comment_id] [varchar] (24) not null,
[object_ref] [varchar] (24) NOT NULL ,
[creator_id] [varchar] (24) NOT NULL ,
[create_time] [datetime] NOT NULL ,
[comments] [varchar] (2000) NULL ,
[rejected_reason_id] [varchar] (24) NULL ,
[internal_comments] [varchar] (2000) NULL,
)
go
alter table dbo.comments
add primary key (object_ref, comment_id)
go
drop table pay_terms_request
CREATE TABLE [dbo].[pay_terms_request] (
[pay_terms_request_id] [varchar] (14) NOT NULL ,
[name] [varchar] (100) NOT NULL ,
[description] [varchar] (2000) NULL ,
[buyer_code] [varchar] (4) NOT NULL ,
[owner_id] [varchar] (24) NOT NULL
)
go
alter table dbo.pay_terms_request
add primary key (pay_terms_request_id)
go
package fieldglass.persist;
import fieldglass.db.DBException;
import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Transaction;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;
import java.sql.Connection;
public class PersistSession {
private Connection connection = null;
private SessionFactory sessionFactory;
protected PersistSession(Connection connection){
this.connection = connection;
try {
this.sessionFactory = new Configuration().configure().buildSessionFactory();
} catch (Exception e) {
throw new DBException(e);
}
}
public void commit(Object o) {
Transaction transaction = null;
try {
Session session = sessionFactory.openSession(this.connection);
transaction = session.beginTransaction();
session.save(o);
transaction.commit();
} catch (HibernateException e) {
try {
transaction.rollback();
} catch (HibernateException e1) {
throw new DBException(e);
}
throw new DBException(e);
}
}
}
StackTrace........
Caused by: net.sf.hibernate.HibernateException: SQL update or deletion failed (row not found)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:25)
at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:633)
at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:602)
at net.sf.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:27)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2101)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2074)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2017)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:57)
at fieldglass.persist.PersistSession.commit(PersistSession.java:25)
Login
FAQ
Search
