hibernate table creation

[Kavitha hebbar]

I have two beans namely employee and department.This is one-to-many relationship where in one department many employees are working.department_id is the primary key.


This is Runner class which has main method

package Manytoone;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

public class Runner {

static void main(String[] args) {
SessionFactory factory=FactoryOneInstance.getInstance();
Session session=factory.openSession();
Transaction trans=session.beginTransaction();
Employee employee=new Employee();
Department dept=new Department();
employee.setName("Kavitha");
dept.setName("Software");
dept.setEmployee(employee);

try
{
trans.begin();
session.save("dept",dept);
trans.commit();
}
catch(HibernateException e)
{
e.printStackTrace();
trans.rollback();
}

}

}

This is employee.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="Manytoone">
<class name="Employee" table="employee" entity-name="emp">
<id name="empid" column="Id">
<generator class="increment"></generator>
</id>
<property name="name"></property>
</class>
</hibernate-mapping>
This is department.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="Manytoone.Department" table="department" entity-name="dept">
<id name="department_id" column="deptid">
<generator class="increment"></generator>
</id>
<property name="name"></property>
<many-to-one name="employee" class="Manytoone.Employee" cascade="all" >
<column name="empid"></column>
</many-to-one>
</class>

</hibernate-mapping>

[Bill Gorder]

Please edit your post and UseCodeTags. Also is there a question here? Did you mean to post this in this thread?

[Kavitha hebbar]

I have two beans namely employee and department.This is one-to-many relationship where in one department many employees are working.department_id is the primary key.
when i run this it asks "select a java application" giving some options like SchemaUpdate,DBdialect....If i choice any one it shows so many exceptions.Wher i have gone wrong?One difference is in configuration file i have given <property name="hbm2ddl.auto">create</property>

This is Runner class which has main method

package Manytoone;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

public class Runner {

	static void main(String[] args) {
		SessionFactory factory=FactoryOneInstance.getInstance();
		Session session=factory.openSession();
		Transaction trans=session.beginTransaction();
		Employee employee=new Employee();
		Department dept=new Department();
		employee.setName("Kavitha");
		dept.setName("Software");
		dept.setEmployee(employee);
		
		try
		{
			trans.begin();
			session.save("dept",dept);
			trans.commit();
		}
		catch(HibernateException e)
		{
			e.printStackTrace();
			trans.rollback();
		}

	}

}

This is employee.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="Manytoone">
	<class name="Employee" table="employee" entity-name="emp">
		<id name="empid" column="Id">
			<generator class="increment"></generator>
		</id>
		<property name="name"></property>
	</class>
</hibernate-mapping>
This is department.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="Manytoone.Department" table="department" entity-name="dept">
    <id name="department_id" column="deptid">
    <generator class="increment"></generator>
     </id>
     <property name="name"></property>
    <many-to-one name="employee" class="Manytoone.Employee" cascade="all" >
       <column name="empid"></column>
    </many-to-one>
  </class>

</hibernate-mapping>
Configuration file is this:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
	<session-factory>
		<property name="hibernate.connection.driver_class">
			com.mysql.jdbc.Driver
		</property>
		<property name="hibernate.connection.username">root</property>
		<property name="hibernate.connection.password">
			Kavitha
		</property>
		<property name="hibernate.connection.url">
			jdbc:mysql://localhost:3306/test
		</property>
		<property name="hibernate.connection.dialect">
			org.hibernate.dialect.MySQL5Dialect
		</property>
		<property name="show_sql">true</property>
        <property name="hbm2ddl.auto">create</property> 
        <mapping resource="Department.hbm.xml"/>
         <mapping resource="employee.hbm.xml"/>
        
	</session-factory>


</hibernate-configuration>
FactoryInstance class which is asigleton class to create only one object of factory:
package Manytoone;

import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class FactoryOneInstance {
	public static SessionFactory factory;
	 private FactoryOneInstance()
	 {		 
	 }
	public static SessionFactory getInstance(){
		return factory;
		
	}
	static
	{
		Configuration configuration=new Configuration();
		configuration.configure("config/configuration.xml");
		factory=configuration.buildSessionFactory();
	}

}

I'm right clicking on runner class and run as java application only.still it is coming like that.
Please help me.
Thanks

[Bill Gorder]

What does your hibernate.cfg.xml look like? How about your FactoryOneInstance class? Are you right clicking the runner class and saying run as java application? Why are you beginning a transaction twice and never committing it or closing the session?

Try checking out the tutorials
http://docs.jboss.org/hibernate/orm/4.1/quickstart/en-US/html_single/files/hibernate-tutorials.zip

and have a look at the getting started guide
http://docs.jboss.org/hibernate/orm/4.1/quickstart/en-US/html_single/

[Kavitha hebbar]

Hi,
I finally got it.In the employee.hbm.xml,I removed entity name.Then i got it.
Thank you.