Hi all,
i am getting this error. but i don't know where did i do wrong, could anybody help?
Caused by: org.hibernate.exception.GenericJDBCException: could not get next sequence value
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:98)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at src.ejb.HibernateBean.createPerson(HibernateBean.java:163)
my sequence in mapping file:
<class name="src.hibernate.Person" table="TMP_PERSON">
<id name="id" column="PERSONID">
<generator class="sequence"/>
my java class:
public class Person {
private Long id;
getter and setter;
.....
}

method :
public Long createPerson(
String surname,
String firstname,
String tel,
String email) {
Session session = null;
Transaction tx = null;

try {
session = HibernateSessionFactory.openSession();
tx = session.beginTransaction();
Person aPerson = new Person();
aPerson.setSurname(surname);
aPerson.setFirstname(firstname);
aPerson.setTelNr(tel);
aPerson.setEmail(email);
Long personId = (Long)session.save(aPerson);
tx.commit();
return personId;
} catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw new HibernateException(e);
} finally {
HibernateSessionFactory.closeSession(session);
}
}

First of all, I'm using Oracle sequence. With the following configuration you should get to the right place.

Create sequence in Oracle:



then config id property in hbm.xml file:



make sure the type of id property in your java file is long, short or integer ;)

I had the same problem with postgres. Check whether the log in role of your DB and the password is true
in your hibernate config file.