unable to insert a record into database using hibernate:

Here is the code:

javabean:

package hibernate_example;

public class User {

String First_Name;
String Last_Name;
int age;
int User_id;
String Email;


public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getEmail() {
return Email;
}
public void setEmail(String email) {
Email = email;
}
public String getFirst_Name() {
return First_Name;
}
public void setFirst_Name(String first_Name) {
First_Name = first_Name;
}
public String getLast_Name() {
return Last_Name;
}
public void setLast_Name(String last_Name) {
Last_Name = last_Name;
}
public int getUser_id() {
return User_id;
}
public void setUser_id(int user_id) {
User_id = user_id;
}



}




Actual accessing database

package hibernate_example;

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

public class TestClient
{


public static void main(String[] args)
{
try{

SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();

System.out.println("Inserting Record");
User _user=new User();
_user.setFirst_Name("pankaj");
_user.setLast_Name("jain");
_user.setAge(25);
_user.setEmail("[email protected]");

session.save(_user);
System.out.println("Done");
}catch(Exception e)
{
System.out.println(e.getMessage());

}

}
}

User.hbm file is

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<hibernate-mapping>

<class name="hibernate_example.User" table="user_1" >
<id name="User_id" type="java.lang.Integer" column="userid" >
<generator class="sequence">
<param name="sequence">userid_seq</param>
</generator>
</id>
<property name="First_Name" type="java.lang.String" column="fname" length="20" />
<property name="Last_Name" type="java.lang.String" column="lname" length="20" />
<property name="age" type="java.lang.Integer" column="age" length="-1" />
<property name="Email" type="java.lang.String" column="email" length="20" />
</class>

</hibernate-mapping>





It showing me following output
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Inserting Record
Hibernate: select max(userid) from user_1
Done


wel it is executing prperly but when i look into database, none record is get inserted

after the line



you must begin transaction, this for insert, update or delete rows.



and after the line



commit the transaction

as per u said i hv added those lines
but it showing me following output

[b]log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: insert into user_1 (fname, lname, age, email, userid) values (?, ?, ?, ?, ?)
Could not execute JDBC batch update[/b]

mmmmm...

the first and second line mean that you are not configured the Log4j( is a log system).

the third line mean that Hibernate try to insert the new row to the db.

the fourth line mean that the engine db no could execute the query .

review your code for populate the bean, I view that the property "email" has 22 characters when the definition of the column for this property is 20

thanks it is running
plz keep in touch if i need help

But is it compulsory to add

session.beginTransaction();
session.getTransaction().commit();

coz i hv go through a lot tutorial , but it is not mentioned any where.

Also i referred a book, but not mentioned........