Hibernate Many-to-One mapping

[Deepaks Deshpande]

Dear All,
I am having trouble implementing Many-to-one mapping in hibernate. I have the done the following:
I have a table called Users and another table called Rank. The relationship between the two is that many users can have the same rank. So it is Many-to-One mapping. The Users and Rank tables are as follows:

CREATE TABLE users
(
  serviceno character varying(20) NOT NULL,
  userid character varying(30),
  password character varying(30),
  name character varying(30),
  emailid character varying(50),
  typeofuser character varying(40),
  rankid integer NOT NULL,
CONSTRAINT pk_users PRIMARY KEY (serviceno ),
CONSTRAINT "FK_Rank" FOREIGN KEY (rankid)
      REFERENCES rank (rankid) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)

CREATE TABLE rank
(
  rankid integer NOT NULL,
  rankname character varying(50),
  rankdescription character varying(100),
  CONSTRAINT pk_rank PRIMARY KEY (rankid )
)

The mapping files are as follows:

Users.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>
	<class name="ms.spring.hibernate.dto.Users" schema="public" table="users">
		<id name="serviceNo" type="java.lang.String">
			<column name="serviceno" length="20" />
			<generator class="assigned" />
		</id>
		
		<property name="userId" type="java.lang.String">
			<column name="userid" length="30" />
		</property>
		
		<property name="password" type="java.lang.String">
			<column name="password" length="30" />
		</property>
		
		<property name="name" type="java.lang.String">
			<column name="name" length="30" />
		</property>
		
		<property name="emailId" type="java.lang.String">
			<column name="emailid" length="30" />
		</property>
		
		<property name="typeOfUser" type="java.lang.String">
			<column name="typeofuser" length="30" />
		</property>
		
		<many-to-one name="rank" column="rankid" class="ms.spring.hibernate.dto.Rank" cascade="all" />
     <class>
<hibernate-mapping>

The Rank.hbm.xml file is :

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>
	<class name="ms.spring.hibernate.dto.Rank" schema="public" table="rank">
		<id name="rankId" type="java.lang.Integer">
			<column name="rankid" length="20" />
			<generator class="assigned" />
		</id>
		
		<property name="rankName" type="java.lang.String">
			<column name="rankname" length="30" />
		</property>
		
		<property name="rankDescription" type="java.lang.String">
			<column name="rankdescription" length="100" />
		</property>
	</class>
</hibernate-mapping>     

I am using hibernate template to insert the values in the Users table. The rank is a combobox item in the registration form. Each rank has an ID associated with it which has to be inserted in the users table's 'rankid' column.
The code for this is as follows:

public class UserServiceImpl implements UserService {

	private HibernateTemplate hibernateTemplate;
	
	/**
	 * @return the hibernateTemplate
	 */
	public HibernateTemplate getHibernateTemplate() {
		return hibernateTemplate;
	}

	/**
	 * @param hibernateTemplate the hibernateTemplate to set
	 */
	public void setHibernateTemplate(HibernateTemplate hibernateTemplate) {
		this.hibernateTemplate = hibernateTemplate;
	}

	/* (non-Javadoc)
	 * @see ilms.spring.hibernate.dao.UserService#saveUser(ilms.spring.hibernate.dto.Users)
	 */
	@Override
	public void saveUser(Users users) {
		// TODO Auto-generated method stub
		Session session = hibernateTemplate.getSessionFactory().openSession();
		Transaction transaction = session.beginTransaction();
		
		Rank rank = new Rank();
		rank.setRankId(rank.getRankId());
		rank.setRankName(rank.getRankName());
		
		users.setServiceNo(users.getServiceNo());
		users.setUserId(users.getUserId());
		users.setPassword(users.getPassword());
		users.setName(users.getName());
		users.setEmailId(users.getEmailId());
		users.setTypeOfUser(users.getTypeOfUser());
		
		users.setRank(rank);
		
		session.save(users);
		transaction.commit();
		session.close();
	}
}

My Form Controller is as follows:

public class RegistrationFormController extends SimpleFormController {
	
	static final Logger logger = Logger.getLogger(RegistrationFormController.class);
	
	ApplicationContext ctx = new ClassPathXmlApplicationContext("spring-hibernate-config.xml");
	
	public ModelAndView onSubmit(HttpServletRequest request, 
			HttpServletResponse response, Object command,
			BindException exception) {
		HttpSession session = request.getSession();
		Users users = (Users) command;
			Rank rank = new Rank();
		
		UserService userService = (UserService) ctx.getBean("userService");
		
		users.setServiceNo(users.getServiceNo());
		logger.info("::::: Entered service number is :::::: "+users.getServiceNo());
		
		users.setUserId(users.getEmailId());
		logger.info("::::: Entered user id is :::::: "+users.getUserId());
		
		users.setName(users.getName());
		logger.info("::::: Entered password is :::::: "+users.getPassword());
		
		users.setName(users.getName());
		logger.info("::::: Entered name is :::::: "+users.getName());
		
		users.setEmailId(users.getEmailId());
		logger.info("::::: Entered email id is :::::: "+users.getEmailId());
		
		users.setTypeOfUser(users.getTypeOfUser());
		logger.info("::::: Entered type of user is ::::: "+users.getTypeOfUser());
		
		rank.setRankId(rank.getRankId());
		users.setRank(rank);
		logger.info("::::: Entered rank is :::::" +users.getRank().getRankName());
		
		logger.info(":::: Registering the new user ::::");
		userService.saveUser(users);
		session.setAttribute("newUser", users.getUserId());
		logger.info(":::: User Registered Successfully ::::");
		
		return new ModelAndView("register/registersuccess", "newUser", users);
	}
}

When ever i try to register a new user, it is not calling the form controller. Am I doing something wrong?
Please help.
Thank you.

[Bill Gorder]

At this point it is not an ORM problem it is a Spring / JSP problem. You have a form and when you submit that form you are not getting inside your controller.

Here are my suggestions:

1. Forget about hibernate altogether you are not even getting far enough to have issues with that yet. When you do get to it do not use HIbernateTemplate. The use of this is deprecated, and is no longer needed. See the Spring reference manual for the modern way using the standard API's rather than a template.
2. Do not use SimpleFormController this also is old and deprecated. Use the modern controller style and the newest version of Spring.

Start with updating your Spring (if needed) and your controllers and get that piece working. If you need more help with that then post in our Spring forum. This link will get you started if you need an example:

http://blog.springsource.org/2010/07/22/spring-mvc-3-showcase/
https://github.com/SpringSource/spring-mvc-showcase (source code)