Thread: BUG #3920: sequence not generated for postgres using toplink jpa
The following bug has been logged online: Bug reference: 3920 Logged by: Arun Email address: arun.viswanathanchandrika@ust-global.com PostgreSQL version: 8.2 Operating system: Win XP Description: sequence not generated for postgres using toplink jpa Details: sequence not generated for postgres using toplink jpa This sequence generator code is not working properly @SequenceGenerator(name="catalog_seq_gen", sequenceName="catalog_seq", allocationSize=1) @Id @GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "catalog_seq_gen") @Column(name ="catalog_id", nullable = false) private Long catalogId; @Column(name = "CATALOG_NAME", nullable = false) private String catalogName; @Column(name = "CATALOG_DESC") private String catalogDesc; I have 3 fields in the code and toplink is generating the query wrongly Exception in thread "main" javax.persistence.PersistenceException: javax.persistence.PersistenceException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build SNAPSHOT (06/04/2007))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: org.postgresql.util.PSQLException: ERROR: null value in column "catalog_id" violates not-null constraint Error Code: 0 Call: INSERT INTO CATALOG (CATALOG_NAME, CATALOG_DESC) VALUES (?, ?) bind => [Description, null] ideally it should generate INSERT INTO CATALOG (CATALOG_ID, CATALOG_NAME, CATALOG_DESC) VALUES (?,?, ?) bind => [1, Description, null] I am using Oracle TopLink 11g: Technical Preview 3 what could be the reason?
Re: BUG #3920: sequence not generated for postgres using toplink jpa
From
"Arun ViswanathanChandrika"
Date:
Hi=20 Solution is available at http://forums.oracle.com/forums/thread.jspa?messageID=3D2325330� -----Original Message----- From: Arun ViswanathanChandrika=20 Sent: Friday, February 01, 2008 8:22 PM To: pgsql-bugs@postgresql.org Subject: BUG #3920: sequence not generated for postgres using toplink jpa The following bug has been logged online: Bug reference: 3920 Logged by: Arun Email address: arun.viswanathanchandrika@ust-global.com PostgreSQL version: 8.2 Operating system: Win XP Description: sequence not generated for postgres using toplink jpa Details:=20 sequence not generated for postgres using toplink jpa This sequence generator code is not working properly @SequenceGenerator(name=3D"catalog_seq_gen", sequenceName=3D"catalog_seq", allocationSize=3D1) @Id @GeneratedValue(strategy =3D GenerationType.SEQUENCE,generator =3D "catalog_seq_gen") @Column(name =3D"catalog_id", nullable =3D false) private Long catalogId; @Column(name =3D "CATALOG_NAME", nullable =3D false) private String catalogName; @Column(name =3D "CATALOG_DESC") private String catalogDesc;=20 I have 3 fields in the code and toplink is generating the query wrongly Exception in thread "main" javax.persistence.PersistenceException: javax.persistence.PersistenceException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build SNAPSHOT (06/04/2007))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: org.postgresql.util.PSQLException: ERROR: null value in column "catalog_id" violates not-null constraint Error Code: 0 Call: INSERT INTO CATALOG (CATALOG_NAME, CATALOG_DESC) VALUES (?, ?) bind =3D> [Description, null] ideally it should generate=20 INSERT INTO CATALOG (CATALOG_ID, CATALOG_NAME, CATALOG_DESC) VALUES (?,?, ?) bind =3D> [1, Description, null] I am using Oracle TopLink 11g: Technical Preview 3=20 what could be the reason?