Hibernate @GeneratedValue problem

[subhanair girish]

I am using mysql,hibernate ,spring

@Entity
@Table(name="login")
public class LoginForm extends ActionForm implements Serializable{
 

@Id
@GeneratedValue
@Column(name="userid")
    private String userid;

@Column(name="username")
private String username;
 
public String getusername(){
 
return username;
}
public void setusername(String username){
 
this.username=username;
}
public String getUserid() {
return userid;
}
public void setUserid(String userid) {
this.userid = userid;
}

Executing above code doesnot work.
Exception listing are

type Exception report
 
message 
 
description The server encountered an internal error () that prevented it from fulfilling this request.
 
exception 
 
javax.servlet.ServletException: could not insert: [com.palnar.library.form.LoginForm]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.palnar.library.form.LoginForm]
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 

root cause 
 
org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: [com.palnar.library.form.LoginForm]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.palnar.library.form.LoginForm]
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:613)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:377)
org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:686)
com.palnar.library.DAO.LoginDAOImpl.saveUser(LoginDAOImpl.java:13)
com.palnar.library.action.LoginAction.execute(LoginAction.java:22)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 

root cause 
 
org.hibernate.exception.SQLGrammarException: could not insert: [com.palnar.library.form.LoginForm]
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2163)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2643)
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:51)
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495)
org.springframework.orm.hibernate3.HibernateTemplate$16.doInHibernate(HibernateTemplate.java:689)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:686)
com.palnar.library.DAO.LoginDAOImpl.saveUser(LoginDAOImpl.java:13)
com.palnar.library.action.LoginAction.execute(LoginAction.java:22)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 

root cause 
 
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'library.login' doesn't exist
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2163)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2643)
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:51)
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495)
org.springframework.orm.hibernate3.HibernateTemplate$16.doInHibernate(HibernateTemplate.java:689)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:686)
com.palnar.library.DAO.LoginDAOImpl.saveUser(LoginDAOImpl.java:13)
com.palnar.library.action.LoginAction.execute(LoginAction.java:22)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.23 logs.
 

please help me in this, the problem is with generation_type, but I cannot correct it.
please..it's urgent

[Kuladip Yadav]

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'library.login' doesn't exist

Your table 'login' is not created in database
and you are trying to save in it !!!

[subhanair girish]

The table 'login' gets created if I am not writing @GeneratedValue in the @id field.

I am using mysql database that can take only GenerationType=IDENTITY to start the autoincrement feature.

[Kuladip Yadav]

  @Entity
@Table(name="login")
public class LoginForm extends ActionForm implements Serializable{
 

@Id
@GeneratedValue
@Column(name="userid")
         private Long userid;

use userid as Long or Interger it will work.
May be For String GeneratedValue will not work
Tannking you

[subhanair girish]

Thanks a lot . Its working perfectly now...
Thanks thanks

I do have one more issue.Its about setting foreign key in the table. I tried many ways, but it's not working.
I have two table

partner( idno(pk) , verifno)
user(userid(pk), idno(fk),username)

How to set foreignkey relation in the user table.

@Entity
@Table(name="SF_T_PARTNER")
 
public class PartnerForm extends ActionForm{
 
@Id
       // What should I write here........
@Column(name="IDENTIFICATION_NO")
private String identification_no;

@Column(name="VERIFICATION_NO")
private String verification_no ;

public String getIdentification_no() {
return identification_no;
}
 
public void setIdentification_no(String identification_no) {
this.identification_no = identification_no;
}

public String getVerification_no() {
return verification_no;
}
 
public void setVerification_no(String verification_no) {
this.verification_no = verification_no;
}
 

 
}
 

@Entity
@Table(name="SF_T_USER_LOGIN")
public class UserLoginForm extends ActionForm{
 
@Id
@Column(name="USERNAME")
private String username ;
 
@Column(name="PASSWORD")
private String password ;
   // What should i write here.........
@Column(name="IDENTIFICATION_NO")
private String identification_no;
 

 
public String getIdentification_no() {
return identification_no;
}
 
public void setIdentification_no(String identification_no) {
this.identification_no = identification_no;
}
 
public String getUsername() {
return username;
}
 
public void setUsername(String username) {
this.username = username;
}
 
public String getPassword() {
return password;
}
 
public void setPassword(String password) {
this.password = password;
}
 
}
 

Please help me in this.......

[Bogdan Nechyporenko]

You should make your @Id field with Long type or remove @GeneratedValue. Because GeneratedValue you could write only in Long type fields