Hi,
> PS: The @Column(name="lpr_id", nullable=false) is commented out because
> otherwise OpenJPA throws an exception about already having a value in the
> field.
Can you post that exception, and also the full class definition?
Thanks,
-Patrick
On 8/16/07, Bruce Beaumont <[EMAIL PROTECTED]> wrote:
> Hi
>
> I have a table with a serial key defined as followes
>
> CREATE TABLE log_profile_request
> (
> lpr_id serial NOT NULL,
> lpr_number varchar(12) NOT NULL,
> lpr_make varchar(20),
> lpr_model varchar(20),
> lpr_imei varchar(20),
> lpr_software_version varchar(10),
> lpr_profiles varchar(20),
> lpr_received_dt timestamp,
> lpr_response_dt timestamp,
> 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 no is as followes
> ALTER TABLE log_profile_request ALTER COLUMN lpr_id SET DEFAULT
> nextval('log_profile_request_lpr_id_seq'::regclass);
>
>
> My declaration for the field is as followes
> @Id
> @GeneratedValue(strategy=GenerationType.IDENTITY)
> //@Column(name="lpr_id", nullable=false)
> private Long id ;
>
> Then I try and insert a row I get the following exception
> 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]
>
> The SQL is as followes
> 552 MSWITCH-DEV TRACE [<ClientThread-Pool#1-ID:25>] openjpa.jdbc.SQL - <t
> 25935701, conn 29263633> executing prepstmnt 3238031 INSERT INTO
> log_profile_request (lpr_imei, lpr_make, lpr_model, lpr_number,
> lpr_software_version, lpr_profiles, lpr_received_dt, lpr_response_dt) VALUES
> (?, ?, ?, ?, ?, ?, ?, ?) [params=(String) 123456789012345678, (String)
> CyberGroup, (String) Test Program, (String) 27828246844, (String) 123456,
> (String) , (Timestamp) 2007-08-16 19:16:29.04, (Timestamp) 2007-08-16
> 19:16:29.3]
>
> 554 MSWITCH-DEV TRACE [<ClientThread-Pool#1-ID:25>] openjpa.jdbc.SQL - <t
> 25935701, conn 29263633> [2 ms] spent
> 555 MSWITCH-DEV TRACE [<ClientThread-Pool#1-ID:25>] openjpa.jdbc.SQL - <t
> 25935701, conn 29263633> executing prepstmnt 33153822 SELECT
> CURRVAL('log_profile_request_id_SEQ')
>
> I cannot seem to get the mapping right for this serial number field as was
> wondering if someone had a few hints
>
> PS: The @Column(name="lpr_id", nullable=false) is commented out because
> otherwise OpenJPA throws an exception about already having a value in the
> field.
>
> PPS: This is a new database so if there is some alternative to this sql
> mapping that works I can easily try that.
>
>
--
Patrick Linskey
202 669 5907
