Spring + Hibernate

[Aravind M Jay]

Hi,

This error is a combination of Spring + Hibernate. I have a FK in one of the tables which can accept null. But when this field is left blank the data is not saved in the DB.

This is the error message from the logs -

  
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.java.Department]; SQL [insert into Department (dep_user_id) values (?)]; The INSERT statement conflicted with the FOREIGN KEY constraint "FK_dep_user_id". The conflict occurred in database "x_Dev", table "x.Department", column 'dep_user_id'.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_dep_user_id". The conflict occurred in database "x_Dev", table "x.Department", column 'dep_user_id'.
  

Table Details -

  
 
UserDepartment
 
useriddept_id
namedep_user_id <FK>
 
  

Hibernate Mapping -

   
 
<class name="com.java.Department" table="Department">
        <id name="deptid" column="dept_id">
            <generator class="native"/>
        </id>       
        <property name="userid" column="dep_user_id" not-null="false"/>
</class>
 

 

POJO <excerpt> -

 
 
public class Department{
 
private User userid;
 
    public User getUserId() {
        return userid;
    }
 
    public void setUser(User userid) {
        this.userid = userid;
    }
 

   

Please let me know where am I going wrong.

Thanks,
MJ

[Arun Kumarr]

what is the data type of the column?

[Aravind M Jay]

Datatype is Integer.
Tried an alternative -
Replaced <column> with <formula> but this always saves NULL in the DB even though a value is entered.
Please let me know your inputs.

[Edvins Reisons]

Please post your DDL and data insertion code.

[Aravind M Jay]

   
 
DeapartmentHelper.java
 
userForm.set(userid,12345) // just hard-coded a value here for userid
 
Department bean = new Department();
 
BeanUtils.copyProperties(bean,userForm);// copying the form data into a bean
 
DepartmentDAO deptDAO = new DeapartmentDAO();
 
deptDAO.saveRequest(bean,bean.getUserId()); // here user id is populated - 12345
---------------------------------------------------------------------------
DepartmentDAO.java
 
saveRequest(DeapartmentBean bean,Integer userId)
{
try{
System.out.println("User Id" + bean.getUserId()); // prints 12345
getHibernateTemplate.save(bean); // throws error when this line is reached. If <formula> tag is user it saves as NULL instead of 12345


   }catch(Exception e){
 
e.printStackTrace();
}
 

 

}
 

 

 
 

[Edvins Reisons]

Aravind,

I would say that you need to IsolateTheProblem first; I am sure that this behavior can be reproduced without Spring, and without DAOs. The things that are needed, precise and complete, are the Java classes, hibernate mappings, and table definitions (the SQL "create table" statements).

[Arun Kumarr]

<property name="userid" column="dep_user_id" not-null="false"/>

Did you try adding an type column saying it is integer like this,

        <property name="userid" type="java.lang.Integer">
            <column name="dep_user_id" not-null="false" />
        </property>

Iam not sure. What Iam guessing is that, since you have not specified any type for the column mapping, may be it is trying to insert it as a String or something.

[Aravind M Jay]

I have tried even declaring the type but to no avail..