CODEWITHSUNDEEP
javahibernate
Prashant Shilimkar
Prashant Shilimkar

Reputation: 8830

in OneTOMany mapping foreign key is inserted as null in Hibernate-MySQL

I am using Hibernate 4.3 and MySQL

There two tables 1. User and 2. Vehicle

I have inserted User's primary key in vehicle as a foreign key using hibernate annotation mapping shown in follwing code

User class

@Entity 
@Table(name = "USER_DETAILS")
public class UserDetails {

@Id
@Column (name="USER_ID")
private int userId;
@Column (name="USER_NAME")
private String userName;
@OneToMany(mappedBy="user")
private Collection<Vehicle> vehicle = new ArrayList<Vehicle>();

public int getUserId() {
    return userId;
}
public Collection<Vehicle> getVehicle() {
    return vehicle;
}
public void setVehicle(Collection<Vehicle> vehicle) {
    this.vehicle = vehicle;
}
public void setUserId(int userId) {
    this.userId = userId;
}
public String getUserName() {
    return userName;
}
public void setUserName(String userName) {
    this.userName = userName;
}

}

Vehicle class

@Entity
public class Vehicle {

@Id
private int vehicleId;
private String vehicleName;
@ManyToOne
@JoinColumn(name="USER_ID")
private UserDetails user;

public UserDetails getUser() {
    return user;
}
public void setUser(UserDetails user) {
    this.user = user;
}
public String getVehicleName() {
    return vehicleName;
}
public void setVehicleName(String vehicleName) {
    this.vehicleName = vehicleName;
}
public int getVehicleId() {
    return vehicleId;
}
public void setVehicleId(int vehicleId) {
    this.vehicleId = vehicleId;
}


}

Main class

public class HibernateMain {

public static void main(String[] args) {

    UserDetails user = new UserDetails();
    user.setUserId(1);
    user.setUserName("Second user");

    Vehicle vehicle = new Vehicle();
    vehicle.setVehicleId(1);
    vehicle.setVehicleName("car");

    Vehicle vehicle1 = new Vehicle();
    vehicle1.setVehicleId(2);
    vehicle1.setVehicleName("jeep");

    user.getVehicle().add(vehicle);
    user.getVehicle().add(vehicle1);

    Configuration cfg = new Configuration().configure("hibernate.cfg.xml");

    SessionFactory sf = cfg.buildSessionFactory(new ServiceRegistryBuilder()
                           .applySettings(cfg.getProperties()).build());

    Session session = sf.openSession();
    session.beginTransaction();
    session.save(user);
    session.save(vehicle);
    session.save(vehicle1);
    session.getTransaction().commit();
    session.close();
}
}

Output:

mysql> select * from user_details;

+---------+-------------+
| USER_ID | USER_NAME   |
+---------+-------------+
|       1 | Second user |
+---------+-------------+
mysql> select * from vehicle;
+-----------+-------------+---------+
| vehicleId | vehicleName | USER_ID |
+-----------+-------------+---------+
|         1 | car         |    NULL |
|         2 | jeep        |    NULL |
+-----------+-------------+---------+

Why User_ID in vehicle table is going null. It should be 1. Thanks for help.

Upvotes: 3

Views: 2102

Answers (2)

Prabhakaran Ramaswamy
Prabhakaran Ramaswamy

Reputation: 26084

change 

Session session = sf.openSession();
session.beginTransaction();
session.save(user);
session.save(vehicle);
session.save(vehicle1);
session.getTransaction().commit();
session.close();

to

Session session = sf.openSession();
session.beginTransaction();
session.save(vehicle);
session.save(vehicle1);
user.getVehicle().add(vehicle);
user.getVehicle().add(vehicle1);
session.save(user);
session.getTransaction().commit();
session.close();

And remove the association from here

vehicle1.setVehicleId(2);
vehicle1.setVehicleName("jeep");

user.getVehicle().add(vehicle);      <--- remove
user.getVehicle().add(vehicle1);     <--- remove

Upvotes: 1

smk
smk

Reputation: 5932

You need to explicitly say vehicle.setUser before you save vehicle object .

Upvotes: 4

Related Questions