hibernate hello world

[naveen yadav]

hi ranchers,

i am creating a java project in eclipse using the hibernate 3.0


i do not know where to put the mapping configuration file (applabsuser.hbm.xml)
and
hibernate configuration file (hibernate.cfg.xml)



i have my POJO class in src\org.applabs.quickstart\AppLabsUser.java

[Madhavi Subramaniam]

Hi naveen,

you can have your all mapping configuration file in same project but in different package.

But you've to configure the mapping correctly.

For eg, you moving hbm file in src\org.applabs.quickstart.hbm\applabsuser.hbm.xml

you've to configure mapping in hibernate.cfg.xml as follows

<mapping resource="org\applabs\quickstart\hbm\applabsuser.hbm.xml " />


you can put hibernate.cfg.xml file where ever you want. But while reading this file for creating session factory, you should give exact file location.




Thanks.

[naveen yadav]

there is how i palce various file in Hibernate 3 hello application


mapping file in src\org.applabs.quickstart\hbm\applabsuser.hbm.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC 
 "-//Hibernate/Hibernate Mapping DTD//EN"
 "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"> 
 
<hibernate-mapping>
 	<class name="org.applabs.hibernate.quickstart.AppLabsUser" table="applabsuser">

 	 	<id column="USER_ID" name="id" type="java.lang.Integer">
 	 	 	<generator class="sequence"/>
 	 	</id>
 	 	
<property column="USER_NAME"         name="userName" />
<property column="USER_PASSWORD"     name="userPassword" />
<property column="USER_FIRST_NAME"   name="userFirstName" />
<property column="USER_LAST_NAME"    name="userLastName" />
<property column="USER_EMAIL"         name="userEmail" />
<property column="USER_CREATION_DATE   name="userCreationDate" />
<property column="USER_MODIFICATION_DATE"    name="userModificationDate" />

 	</class>
</hibernate-mapping> 

and

hibernate cong file in \src\hibernate.cfg.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration SYSTEM 
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
 	<session-factory>
<property name="show_sql">true</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/university</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">111</property>
<mapping resource="org/applabs/hibernate/quickstart/hbm/Applabsuser.hbm.xml"/>
</session-factory>
</hibernate-configuration> 

here is my main class

package org.applabs.quickstart;

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


public class FirstExample{
  public static void main(String[] args) {
  Session session = null;

  try{
[b]
 SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();[/b]


AppLabsUser user = new AppLabsUser();
Transaction tx = session.beginTransaction();
user.setUserCreationDate(new Date());
user.setUserEmail("[e-mail]");
user.setUserFirstName("userFirstName");
user.setUserLastName("userLastName");
user.setUserName("nav");
user.setUserPassword("ppp");
session.saveOrUpdate(user);
tx.commit();
session.close();
  }catch(Exception e){
  System.out.println(e.getMessage());
  }finally{
  // Actual stu insertion will happen at this step
  session.flush();
  session.close();

  }
  
  }
}

and on running above file i am getting
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "main" java.lang.NullPointerException
at org.applabs.quickstart.FirstExample.main(FirstExample.java:39)
Resource: applabsuser.hbm.xml not found


it seems that session object has not been instantiated. but why ?

[naveen yadav]

Please note that i have included only hibernate3.jar in build-path Do i have to add other jar files ?

[Madhavi Subramaniam]

Hi,

Have you created session factory for your database connection?

[naveen yadav]

here it is

hibernate.cfg.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration SYSTEM 
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>
<property name="show_sql">true</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/university</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">111</property>
</session-factory>
<mapping resource="org/applabs/hibernate/quickstart/hbm/applabsuser.hbm.xml"/>

</hibernate-configuration> 

and

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
problem parsing configuration/hibernate.cfg.xml
Exception in thread "main" java.lang.NullPointerException
at org.applabs.quickstart.FirstExample.main(FirstExample.java:35)


what is problem in above xml file ?

[naveen yadav]

Madhavi Subramaniam wrote:Hi,

Have you created session factory for your database connection?

how do i do that ?

[Madhavi Subramaniam]

Hi,

Have you added sqljdbc.jar in your build path?

[naveen yadav]

i have added mysql-connector-java-5.1.6-bin.jar in build-path

and i have added all jar files which comes with hibernate3 distribution.

[Prasad Krishnegowda]

Post the full exception stack trace. It should have the details on what is wrong in the XML file.

[Madhavi Subramaniam]

Hi,

I think,your connnection url value in wrong format.

If your DB name is university,It should be like

<property name="hibernate.connection.url">jdbc:sqlserver://localhost:3306;databaseName=university</property>

3306 is your sql server running port number rite?

[naveen yadav]

here is hibernate.cfg.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration SYSTEM 
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>
<property name="show_sql">true</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost/university</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">111</property>
<mapping resource="org/applabs/quickstart/applabsuser.hbm.xml"/>
</session-factory>
</hibernate-configuration> 

irrespective of <property name="hibernate.connection.url">jdbc:sqlserver://localhost:3306;databaseName=university</property> still throws exception

and full stack trace of exception.

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
org.hibernate.HibernateException: problem parsing configuration/hibernate.cfg.xml
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1222)
at org.hibernate.cfg.Configuration.configure(Configuration.java:1161)
at org.hibernate.cfg.Configuration.configure(Configuration.java:1147)
at org.applabs.quickstart.FirstExample.main(FirstExample.java:18)
Caused by: org.dom4j.DocumentException: Error on line 2 of document : The processing instruction target matching "[xX][mM][lL]" is not allowed. Nested [/b]exception: The processing instruction target matching "[xX][mM][lL]" is not allowed.
at org.dom4j.io.SAXReader.read(SAXReader.java:350)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1217)
... 3 more
Exception in thread "main" java.lang.NullPointerException
at org.applabs.quickstart.FirstExample.main(FirstExample.java:38)

[Prasad Krishnegowda]

This means there are some white spaces before the XML declaration..

[Prasad Krishnegowda]

Madhavi Subramaniam wrote:Hi,

I think,your connnection url value in wrong format.

If your DB name is university,It should be like

<property name="hibernate.connection.url">jdbc:sqlserver://localhost:3306;databaseName=university</property>

URL is in correct format, it should work with what the OP is having.

[naveen yadav]

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>
<property name="show_sql">true</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:sqlserver://localhost:3306;databaseName=university</property> 
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">111</property>
<mapping resource="org/applabs/quickstart/applabsuser.hbm.xml" />
</session-factory>


</hibernate-configuration> 

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
org.hibernate.MappingException: Error reading resource: org/applabs/quickstart/applabsuser.hbm.xml
at org.hibernate.cfg.Configuration.addResource(Configuration.java:448)
at org.hibernate.cfg.Configuration.parseMappingElement(Configuration.java:1312)
at org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1284)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1266)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1233)
at org.hibernate.cfg.Configuration.configure(Configuration.java:1161)
at org.hibernate.cfg.Configuration.configure(Configuration.java:1147)
at org.applabs.quickstart.FirstExample.main(FirstExample.java:15)
Caused by: org.hibernate.MappingException: class org.applabs.hibernate.quickstart.AppLabsUser not found while looking for property: userName
at org.hibernate.util.ReflectHelper.reflectedPropertyClass(ReflectHelper.java:81)
at org.hibernate.mapping.SimpleValue.setTypeUsingReflection(SimpleValue.java:254)
at org.hibernate.cfg.HbmBinder.createProperty(HbmBinder.java:1753)
at org.hibernate.cfg.HbmBinder.createClassProperties(HbmBinder.java:1742)
at org.hibernate.cfg.HbmBinder.bindRootPersistentClassCommonValues(HbmBinder.java:317)
at org.hibernate.cfg.HbmBinder.bindRootClass(HbmBinder.java:235)
at org.hibernate.cfg.HbmBinder.bindRoot(HbmBinder.java:151)
at org.hibernate.cfg.Configuration.add(Configuration.java:359)
at org.hibernate.cfg.Configuration.addInputStream(Configuration.java:396)
at org.hibernate.cfg.Configuration.addResource(Configuration.java:445)
... 7 more
Caused by: java.lang.ClassNotFoundException: org.applabs.hibernate.quickstart.AppLabsUser
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:108)
at org.hibernate.util.ReflectHelper.reflectedPropertyClass(ReflectHelper.java:77)
... 16 more
Exception in thread "main" java.lang.NullPointerException
at org.applabs.quickstart.FirstExample.main(FirstExample.java:32)


i have AppLabsUser.java in org.applabs.quickstart but there is not a AppLabsUser.class file.why it is not been created ?

[Prasad Krishnegowda]

naveen yadav wrote:
Caused by: java.lang.ClassNotFoundException: org.applabs.hibernate.quickstart.AppLabsUser

This is the root cause. It cannot find the specified class.
Post your hbm file and the AppLabsUser.java file.

[naveen yadav]

applabsuser.hbm.xml in org.applabs.quickstart

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC 
 "-//Hibernate/Hibernate Mapping DTD//EN"
 "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"> 
 
<hibernate-mapping>
 	<class name="org.applabs.hibernate.quickstart.AppLabsUser" table="applabsuser">

 	 	<id column="USER_ID" name="id" type="java.lang.Long">
 	 	 	<generator class="sequence"/>
 	 	</id>
 	 	
<property column="USER_NAME"         name="userName" />
<property column="USER_PASSWORD"     name="userPassword" />
<property column="USER_FIRST_NAME"   name="userFirstName" />
<property column="USER_LAST_NAME"    name="userLastName" />
<property column="USER_EMAIL"         name="userEmail" />


 	</class>
</hibernate-mapping> 

and here is AppLabsUser.java in org.applabs.quickstart

package org.applabs.quickstart;

import java.util.Date;

public class AppLabsUser {
	
	
	private Long id;

	/** persistent field */
	private String userName;

	/** persistent field */
	private String userPassword;

	/** persistent field */
	private String userFirstName;

	/** persistent field */
	private String userLastName;

	/** persistent field */
	private String userEmail;

	/** persistent field */
	private Date userCreationDate;

	/** persistent field */
	private Date userModificationDate;

	
	/** default constructor */
	public AppLabsUser() {
	}

	public Long getId() {
	return this.id;
	}

	public void setId(Long id) {
	this.id = id;
	}

	public String getUserName() {
	return this.userName;
	}

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

	public String getUserPassword() {
	return this.userPassword;
	}

	public void setUserPassword(String userPassword) {
	this.userPassword = userPassword;
	}

	public String getUserFirstName() {
	return this.userFirstName;
	}

	public void setUserFirstName(String userFirstName) {
	this.userFirstName = userFirstName;
	}

	public String getUserLastName() {
	return this.userLastName;
	}

	public void setUserLastName(String userLastName) {
	this.userLastName = userLastName;
	}

	public String getUserEmail() {
	return this.userEmail;
	}

	public void setUserEmail(String userEmail) {
	this.userEmail = userEmail;
	}



}

[naveen yadav]

in applabsuser.hbm.xml

replace
<hibernate-mapping>
<class name="org.applabs.hibernate.quickstart.AppLabsUser" table="applabsuser">

with
<hibernate-mapping>
<class name="org.applabs.quickstart.AppLabsUser" table="applabsuser">

and now

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
org.hibernate.MappingException: could not instantiate id generator
at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:94)
at org.hibernate.mapping.SimpleValue.createIdentifierGenerator(SimpleValue.java:135)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:166)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1054)
at org.applabs.quickstart.FirstExample.main(FirstExample.java:15)
Caused by: org.hibernate.MappingException: Dialect does not support sequences
at org.hibernate.dialect.Dialect.getSequenceNextValString(Dialect.java:413)
at org.hibernate.id.SequenceGenerator.configure(SequenceGenerator.java:65)
at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:90)
... 4 more
Exception in thread "main" java.lang.NullPointerException
at org.applabs.quickstart.FirstExample.main(FirstExample.java:32)

[Prasad Krishnegowda]

naveen yadav wrote:
and here is AppLabsUser.java in org.applabs.quickstart

But, what you give in hbm file, is org.applabs.hibernate.quickstart.AppLabsUser.
Change it to org.applabs.quickstart.AppLabsUser.

[naveen yadav]

now after change applabsuser.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC 
 "-//Hibernate/Hibernate Mapping DTD//EN"
 "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"> 
 
<hibernate-mapping>
 	<class name="org.applabs.quickstart.AppLabsUser" table="applabsuser">

 	 	<id column="USER_ID" name="id" type="java.lang.Long">
 	 	 	<generator class="sequence"/>
 	 	</id>
 	 	
<property column="USER_NAME"         name="userName" />
<property column="USER_PASSWORD"     name="userPassword" />
<property column="USER_FIRST_NAME"   name="userFirstName" />
<property column="USER_LAST_NAME"    name="userLastName" />
<property column="USER_EMAIL"         name="userEmail" />


 	</class>
</hibernate-mapping> 

and now

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
org.hibernate.MappingException: could not instantiate id generator
at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:94)
at org.hibernate.mapping.SimpleValue.createIdentifierGenerator(SimpleValue.java:135)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:166)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1054)
at org.applabs.quickstart.FirstExample.main(FirstExample.java:15)
Caused by: org.hibernate.MappingException: Dialect does not support sequences
at org.hibernate.dialect.Dialect.getSequenceNextValString(Dialect.java:413)
at org.hibernate.id.SequenceGenerator.configure(SequenceGenerator.java:65)
at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:90)
... 4 more
Exception in thread "main" java.lang.NullPointerException
at org.applabs.quickstart.FirstExample.main(FirstExample.java:32)

[Prasad Krishnegowda]

It tells, the database does not support sequences. You can try with generator class="increment" to have it incremented automatically or "assigned" to assign the value yourself.

[naveen yadav]

once again i have changed applabsuser.hbm.xml

from	<generator class="[b]sequence[/b]"/> 
to 
<generator class="[b]native[/b]"/>

Caused by: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:3306;databaseName=university
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.jdbc.AbstractBatcher.openConnection(AbstractBatcher.java:410)
... 7 more


but i have another simple application using same database is running fine

[Prasad Krishnegowda]

naveen yadav wrote:
Caused by: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:3306;databaseName=university

Change the driver to one, you had earlier in hibernate.cfg.xml.

[naveen yadav]

after doing chnges


log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
org.hibernate.PropertyNotFoundException: Could not find a getter for id in class org.applabs.quickstart.AppLabsUser
at org.hibernate.property.BasicPropertyAccessor.createGetter(BasicPropertyAccessor.java:213)
at org.hibernate.property.BasicPropertyAccessor.getGetter(BasicPropertyAccessor.java:207)
at org.hibernate.tuple.PropertyFactory.getGetter(PropertyFactory.java:148)
at org.hibernate.tuple.PropertyFactory.buildIdentifierProperty(PropertyFactory.java:41)
at org.hibernate.tuple.EntityMetamodel.<init>(EntityMetamodel.java:105)
at org.hibernate.persister.entity.BasicEntityPersister.<init>(BasicEntityPersister.java:400)
at org.hibernate.persister.entity.SingleTableEntityPersister.<init>(SingleTableEntityPersister.java:104)
at org.hibernate.persister.PersisterFactory.createClassPersister(PersisterFactory.java:55)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:199)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1054)
at org.applabs.quickstart.FirstExample.main(FirstExample.java:15)
Exception in thread "main" java.lang.NullPointerException
at org.applabs.quickstart.FirstExample.main(FirstExample.java:34)


in AppLabsUser.java

[code=java
int id;
public int getUserId() {
return this.id;
}

public void setUserId(int id) {
this.id = id;
}[/code]


in university database
id is represented by USER_ID --type is int

and here is how i insert user id from FirstExample.java(main class)

int ii=88;
user.setUserId(ii);

[Prasad Krishnegowda]

You need to have setters/getters in the standard format. My suggestion is use your IDE, to generate them.

[naveen yadav]

i have creted setter and getter method using IDE.

applabsuser table in database

CREATE TABLE `applabsuser` (
  `USER_ID` int(10) NOT NULL,
  `USER_NAME` varchar(20) NOT NULL,
  `USER_FIRST_NAME` varchar(20) default 'NULL',
  `USER_LAST_NAME` varchar(20) default 'NULL',
  `USER_EMAIL` varchar(20) default 'NULL',
  `USER_PASSWORD` varchar(20) NOT NULL,
  PRIMARY KEY  (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

main class

	Transaction tx = session.beginTransaction();
		AppLabsUser user = new AppLabsUser();
		Integer lg =88;
		user.setUserId(lg);
		user.setUserEmail("[e-mail]");
		user.setUserFirstName("userFirstName");
		user.setUserLastName("userLastName");
		user.setUserName("nav");
		user.setUserPassword("ppp");
		session.saveOrUpdate(user);
		tx.commit();

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: update applabsuser set USER_NAME=?, USER_PASSWORD=?, USER_FIRST_NAME=?, USER_LAST_NAME=?, USER_EMAIL=? where USER_ID=?
org.hibernate.StaleStateException: Batch update returned unexpected row count from update: 0 actual row count: 0 expected: 1
at org.hibernate.jdbc.BatchingBatcher.checkRowCount(BatchingBatcher.java:88)
at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:74)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:172)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:137)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:675)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:293)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at org.applabs.quickstart.FirstExample.main(FirstExample.java:28)


org.hibernate.StaleStateException
Thrown when a version number or timestamp check failed, indicating that the Session contained stale data (when using long transactions with versioning).

[Prasad Krishnegowda]

Ideally, it should have been insert query, don't know, why its become update query. Can you check by making it session.save(user) instead of session.saveOrUpdate(user)

[naveen yadav]

Prasad Krishnegowda wrote: Can you check by making it session.save(user) instead of session.saveOrUpdate(user)

with that it is like


log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: insert into applabsuser (USER_NAME, USER_PASSWORD, USER_FIRST_NAME, USER_LAST_NAME, USER_EMAIL) values (?, ?, ?, ?, ?)
org.hibernate.exception.GenericJDBCException: could not insert: [org.applabs.quickstart.AppLabsUser]
at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1790)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2192)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:238)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:158)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:104)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:429)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:424)
at org.applabs.quickstart.FirstExample.main(FirstExample.java:29)
Caused by: java.sql.SQLException: Field 'USER_ID' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1772)
... 14 more
Exception in thread "main" org.hibernate.AssertionFailure: null id in entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:49)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:82)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:190)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:70)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:675)
at org.applabs.quickstart.FirstExample.main(FirstExample.java:37)

[Prasad Krishnegowda]

have you mapped user_id column, how is the value set to this field?

[naveen yadav]

userId is a primary key in a table

  `USER_ID` int(10) NOT NULL,

USER_ID does not have default value since it is a primary key
i could not understand why there is Caused by: java.sql.SQLException: Field 'USER_ID' doesn't have a default value .Should i assign default value to it.

this is how i mapped user_id in applasuser.hbm.xml

<id column="USER_ID" name="userId" type="java.lang.Integer">
 	 	 	<generator class="native"/>
 	 	</id>

and in FirstExample.java(main) trying to set a user_id.

Integer lg =new Integer(88);
		user.setUserId(lg);

[Prasad Krishnegowda]

Hibernate: insert into applabsuser (USER_NAME, USER_PASSWORD, USER_FIRST_NAME, USER_LAST_NAME, USER_EMAIL) values (?, ?, ?, ?, ?)

This statement doesn't show the userid, it means there is some mistake in mapping the column of the table.

[naveen yadav]

USER_ID is a primary key and have been mapped to POJP property userId in applabsuser.xml

<hibernate-mapping>
 	<class name="org.applabs.quickstart.AppLabsUser" table="applabsuser">

 	 	<id column="USER_ID" name="userId" type="java.lang.Integer">
 	 	 	<generator class="native"/>
 	 	</id>
 	 	
<property column="USER_NAME"         name="userName" />
<property column="USER_PASSWORD"     name="userPassword" />
<property column="USER_FIRST_NAME"   name="userFirstName" />
<property column="USER_LAST_NAME"    name="userLastName" />
<property column="USER_EMAIL"         name="userEmail" />


 	</class>
</hibernate-mapping> 

[Prasad Krishnegowda]

can you change that class from native to assigned.. in the java code, you are assigning that. Native means, the underlying database only decides its value.

[naveen yadav]

Prasad Krishnegowda wrote:can you change that class from native to assigned.. in the java code, you are assigning that. Native means, the underlying database only decides its value.

after doing suggested changes.

Hibernate: insert into applabsuser (USER_NAME, USER_PASSWORD, USER_FIRST_NAME, USER_LAST_NAME, USER_EMAIL, USER_ID) values (?, ?, ?, ?, ?, ?)

Now there is a new row is inserted into the a database table.finally Hibernate Hello World is working.


Thank you very much Prasad Krishnegowda. I appreciates your effort. you help it right through the code. You kindly help at every single error
thanks.

[Prasad Krishnegowda]

Great.. Nice to hear, you finally made it work..
Welcome brother