openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bruce Beaumont <bruce.beaum...@ucs-solutions.co.za>
Subject OpenJPA and postgresql
Date Fri, 17 Aug 2007 06:26:10 GMT
Hi

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)
) 
WITHOUT OIDS;
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 
nextval('log_profile_request_lpr_id_seq'::regclass);

And a bean with the ID field set as followes
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
//@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]

Mime
View raw message