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]
