openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bruce Beaumont <>
Subject OpenJPA and postgresql
Date Fri, 17 Aug 2007 06:26:10 GMT

I have a table defined as followes

CREATE TABLE log_profile_request
  lpr_id serial NOT NULL,

  CONSTRAINT "lpr-pk" PRIMARY KEY (lpr_id),
  CONSTRAINT p_unique UNIQUE (lpr_id)
ALTER TABLE log_profile_request OWNER TO bruce;

The generated sequence number is as followes
ALTER TABLE log_profile_request ALTER COLUMN lpr_id SET DEFAULT 

And a bean with the ID field set as followes
//@Column(name="lpr_id", nullable=false)
private Long id ;

When I try and insert a row I get the following error

Caused by: <openjpa-1.0.0-SNAPSHOT-r420667:564688 nonfatal general error> 
org.apache.openjpa.persistence.PersistenceException: ERROR: 
relation "log_profile_request_id_seq" does not exist {prepstmnt 33153822 
SELECT CURRVAL('log_profile_request_id_SEQ')} [code=0, state=42P01]

View raw message