One to Many Mapping : Table not found

[Rashmee Kulkarni]

Hi All,

I am trying to get hands on on @OneToMany relationship. But I am getting following error :

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Hibernate: insert into UserDetailsDTO (userId, desc, joiningDate, userName) values (null, ?, ?, ?)
Hibernate: insert into vehicle (vehicleId, vehicleName) values (null, ?)
Hibernate: insert into vehicle (vehicleId, vehicleName) values (null, ?)
Hibernate: insert into USER_ADDRESS (USER_ID, city_name, pincode_no, state_name, street_name) values (?, ?, ?, ?, ?)
Hibernate: insert into USER_ADDRESS (USER_ID, city_name, pincode_no, state_name, street_name) values (?, ?, ?, ?, ?)
Hibernate: insert into UserDetailsDTO_vehicle (UserDetailsDTO_userId, vehicle_vehicleId) values (?, ?)
Hibernate: insert into UserDetailsDTO_vehicle (UserDetailsDTO_userId, vehicle_vehicleId) values (?, ?)
Exception in thread "main" org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:188)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
	at com.hibernate.HibernateTest.main(HibernateTest.java:58)
Caused by: java.sql.BatchUpdateException: java.sql.SQLException: Failed to find table UserDetailsDTO_vehicle in database hibernate
	at com.hxtt.sql.dy.executeBatch(Unknown Source)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
	... 8 more

Here is my code :

UserDetailsDTO.java

package com.hibernate.dto;

import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.HashSet;
import java.util.List;
import java.util.Set;

import javax.persistence.ElementCollection;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.OneToMany;
import javax.persistence.OneToOne;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

@Entity
public class UserDetailsDTO {
	
	@Id 
	@GeneratedValue
	private int userId;
	
	private String userName;
	
	@ElementCollection
	@JoinTable(name="USER_ADDRESS",					// table name for collection
	joinColumns=@JoinColumn(name="USER_ID")		//configure join column name in collection
	)
	
	private Set<Address> listOfAddresses = new HashSet<Address>();
	
	@Temporal(TemporalType.DATE)
	private Date joiningDate;
	
	private String desc;
	
	@OneToMany
	private Collection<Vehicle> vehicle=new ArrayList<Vehicle>();
	
	public Collection<Vehicle> getVehicle() {
		return vehicle;
	}

	public void setVehicle(Collection<Vehicle> vehicle) {
		this.vehicle = vehicle;
	}

	public int getUserId() {
		return userId;
	}

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

	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName;
	}

	public Set<Address> getListOfAddresses() {
		return listOfAddresses;
	}

	public void setListOfAddresses(Set<Address> listOfAddress) {
		this.listOfAddresses = listOfAddress;
	}

	public Date getJoiningDate() {
		return joiningDate;
	}

	public void setJoiningDate(Date joiningDate) {
		this.joiningDate = joiningDate;
	}

	public String getDesc() {
		return desc;
	}

	public void setDesc(String desc) {
		this.desc = desc;
	}	
	
}

Vehicle.java

package com.hibernate.dto;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

@Entity
@Table(name="vehicle")
public class Vehicle {
	
	@Id 
	@GeneratedValue
	private int vehicleId;
	
	private String vehicleName;	

	public int getVehicleId() {
		return vehicleId;
	}

	public void setVehicleId(int vehicleId) {
		this.vehicleId = vehicleId;
	}

	public String getVehicleName() {
		return vehicleName;
	}

	public void setVehicleName(String vehicleName) {
		this.vehicleName = vehicleName;
	}
	
	
}

Address.java

	package com.hibernate.dto;

	import javax.persistence.Column;
	import javax.persistence.Embeddable;

	@Embeddable
	public class Address {
		
			@Column(name="street_name")
			private String street;
			@Column(name="city_name")
			private String city;
			@Column(name="state_name")
			private String state;
			@Column(name="pincode_no")
			private String pincode;
			
			public String getStreet() {
				return street;
			}
			public void setStreet(String street) {
				this.street = street;
			}
			public String getCity() {
				return city;
			}
			public void setCity(String city) {
				this.city = city;
			}
			public String getState() {
				return state;
			}
			public void setState(String state) {
				this.state = state;
			}
			public String getPincode() {
				return pincode;
			}
			public void setPincode(String pincode) {
				this.pincode = pincode;
			}
}

Following is Test code:

               UserDetailsDTO user = new UserDetailsDTO();
		user.setUserName("Rashmi");
		user.setJoiningDate(new Date());
		user.setDesc("First User");
		
		Address address = new Address();
		address.setCity("Pune");
		address.setPincode("411052");
		address.setState("Maharashtra");
		address.setStreet("B.T. Road");
		
		
		Address address2 = new Address();
		address2.setCity("Nashik");
		address2.setPincode("411051");
		address2.setState("Maharashtra");
		address2.setStreet("Gangapur Road");
		
		user.getListOfAddresses().add(address);
		user.getListOfAddresses().add(address2);
		
		
		Vehicle vehicle = new Vehicle();
		vehicle.setVehicleName("Activa");
		
		Vehicle vehicle2 = new Vehicle();
		vehicle2.setVehicleName("Jeep");
		
		user.getVehicle().add(vehicle);
		user.getVehicle().add(vehicle2);
		
		SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
		
		Session session = sessionFactory.openSession();
		
		session.beginTransaction();
		
		session.save(user);
		session.save(vehicle);
		session.save(vehicle2);
		
		session.getTransaction().commit();
		
		session.close();

I am using Access database. OneToOne and ManyToOne relationships are working fine.


Can anyone please throw light on whats going wrong here?

[Mohammed Sardar.]

But why @ElementCollection is not working but @OneToMany working. Is EC replaced by @OneToMany ?
@OneToMany(targetEntity=Address.class, mappedBy="", fetch=FetchType.EAGER)
private Set<Address> listOfAddresses = new HashSet<Address>();
Actually mappedBy column should be empty or else it's not working !