Skip site navigation (1) Skip section navigation (2)

What Hibernate Object ID generator is recommanded for PG?

From: Vernon <vwu725(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: What Hibernate Object ID generator is recommanded for PG?
Date: 2005-04-21 21:13:49
Message-ID: 20050421211349.29702.qmail@web40529.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

Here is what I have:

Java class:

public class User {

	private Integer id;
...
}

Hibernate Mapping:

    <class name="com.ccc.domain.User" table="users">
        <id name="id" type="int" unsaved-value="null"
>
            <generator class="native"/>
        </id>
...
    </class>

DB Table:

create table USERS (
	id 			SERIAL UNIQUE primary key,	
...
)

When I call the save(object) method of Hibernate, I
get the following exception:

2005-04-21 13:52:13,859 ERROR
org.springframework.web.servlet.DispatcherServlet -
Could not complete request
org.springframework.jdbc.BadSqlGrammarException: Bad
SQL grammar [] in task 'Hibernate operation'; nested
exception is java.sql.SQLException: ERROR: relation
"hibernate_sequence" does not exist
java.sql.SQLException: ERROR: relation
"hibernate_sequence" does not exist
	at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1365)
	at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1160)
	at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:172)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:387)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:328)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:238)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
	at
net.sf.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:64)
	at
net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:774)
	at
net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:747)
	at
org.springframework.orm.hibernate.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:386)
	at
org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:243)
	at
org.springframework.orm.hibernate.HibernateTemplate.save(HibernateTemplate.java:383)
 
It seems the native ID generator doesn't work properly
in PG. After changing the generator to sequence. I get
the same exception. According to the Hibernate
documentation, that is the right way. Any suggestions
on the subject?

Thanks,

Vernon

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2005-04-21 21:37:44
Subject: Re: Array support
Previous:From: Ruediger HerrmannDate: 2005-04-21 21:10:09
Subject: isLast() and empty ResultSet

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group