Hi,

I am new to hibernate and this is my second post here. I need help for using generator class "sequence" in primary key identifier mapping of my table. My confusion is, do I have to create the sequence I mention for parameter name manually in the database? As I was not sure, I have created my sequence manually. I think I am doing every thing as it is mentioned in the hibernate documentation but still I get following exception when I try to insert data in the table:

org.hibernate.exception.SQLGrammarException: could not get next sequence value
..
Caused by: org.postgresql.util.PSQLException: ERROR: relation "hibernate_sequenc
e" does not exist
..

I have create following hibernate java bean:
public class Query implements Serializable {
private int queryId;
private String queryName;
...
}
Its hibernate mapping file Query.hbm.xml is as follows:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping package="com.akazaresearch.phenonet.server.main.persist.hiber">
<class name="Query" table="runtime_build_query" >
<id name="queryId" column="id" >
<generator class="sequence">
<param name="sequence">runtime_build_query_queryid_seq</param>
</generator>
</id>
<property name="queryName" column="name" type="string"></property>
...
</hibernate-mapping>

Table script for postgres database is:
CREATE TABLE runtime_build_query
(
id integer NOT NULL,
userid integer NOT NULL,
name character varying(100) NOT NULL,
description character varying(200),
summary character varying(300),
approved boolean DEFAULT false,
complete boolean DEFAULT false,
finalized boolean DEFAULT false,
activated boolean DEFAULT true,
last_update_timestamp timestamp with time zone,
result_download_approved boolean DEFAULT false,
CONSTRAINT runtime_build_query_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;
ALTER TABLE runtime_build_query OWNER TO chin;

I have created a sequence using following sql statement:
CREATE SEQUENCE runtime_build_query_queryid_seq INCREMENT BY 1 MINVALUE 1 NO MAXVALUE;

I don't know where I am going wrong. Please suggest. Thanks in advance.

Hi,

The problem I mentioned is solved. Actually earlier I had tried with "native" generator type which did not work because I had not created any sequence in my database. After changing it to "sequence" and creating the sequence manually, still I got the same error which I mentioned in last post. But it was probably a cache problem. When I re-deployed the application to tomcat server and started it from fresh again it did work. thanks.

Indeed, with this sequence created, everything should have been working. Cached code problems can indeed be frustrating!